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.
]]>