• From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,094

Topic: Common Units of Measure

FA comes with Each and Hours as Units of Measure.
The following will add common Units of Measure:

INSERT INTO `0_item_units` (`abbr`,`name`,`decimals`,`inactive`) VALUES
('pc','Pieces',0,0),
('lb','Pounds',0,0),
('kg','Kgs',0,0),
('cwt','CentWt',0,0),
('gm','Grams',0,0),
('ltr','Litres',0,0),
('gal','Gallons',1,0),
('km','Kilometres',0,0),
('mtr','Metres',0,0),
('cm','Centimetres',0,0),
('ctn','Cartons',0,0),
('box','Boxes',0,0),
('ctr','Containers',0,0),
('brl','Barrels',0,0),
('drm','Drums',0,0),
('ton','Tons',2,0);

Replace the Company prefix for the table in the above statement to suit your install or append it to your CoA sql file before company creation.

apmuthu's Website

  • Registered: 12/13/2014
  • Posts: 8

Re: Common Units of Measure

Usefully