webERP Forum
Larger Item Category Properties - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: Development Discussion & Specification (/forumdisplay.php?fid=10)
+--- Thread: Larger Item Category Properties (/showthread.php?tid=2296)



Larger Item Category Properties - agaluski - 09-06-2014 06:09 AM

I have a need for some items to print special receiving instructions on the GRN. For example. For some items I want a small sample of the product pulled for quality testing, labeled and delivered tot he quality lab. I may also want other "special Instructions" to print for FG on the W/O paperwork. I originally wanted to use the Item Category properties to do this however I have reached a limitation in that the field is only set for 100 characters and I will need more than this. So.... Should we increase the field length? Use a different data type? I don't want to invent a new screen or table to maintain this but I don't want to break anything already working.
What do the experts propose?


RE: Larger Item Category Properties - phil - 09-06-2014 01:10 PM

Well it is only 50 chars I think.
What about a number of different category properties fields. Or, if you are trying to write quite lot of info - perhaps we need to change it to a TEXT? Are you talking about

CREATE TABLE IF NOT EXISTS `stockitemproperties` (
`stockid` varchar(20) NOT NULL,
`stkcatpropid` int(11) NOT NULL,
`value` varchar(50) NOT NULL,
PRIMARY KEY (`stockid`,`stkcatpropid`),
KEY `stockid` (`stockid`),
KEY `value` (`value`),
KEY `stkcatpropid` (`stkcatpropid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

There looks to be a mismatch between the defaultvalue in the stockcatproperties definition table and the actual "value" stored in this table above. We should change the two to be the same!


RE: Larger Item Category Properties - agaluski - 09-07-2014 07:24 AM

Yes, Text is what I want. So I can enter enough instructions to explain to somebody what needs to happen after receipt. And during a W/O Build. Not talking pages of information. Just up to a half page probably


RE: Larger Item Category Properties - phil - 09-07-2014 07:59 AM

I wonder if you use a wiki - presenting a link to the wiki might be the best solution


RE: Larger Item Category Properties - agaluski - 09-08-2014 10:46 PM

While that may be a good idea for sharing information internally I am really looking to beef up the paperwork, Many people in the warehouse in this type of work spend little if any time in the system. They are on the floor, on a fork lift, moving materials. The paperwork is key in sharing important information between the office and them.They basically stop by the office 2-3 times per day and pick up paperwork, they follow the paperwork and then return the paperwork to somebody who keys in the data.