This example demonstrates how to set up a user-defined quantity formula to automatically convert Unit of Measurement (UOM) values (e.g. TIN to LITRE) and apply it during item maintenance.
Example:
UOM: 1 TIN = 500ML
UOM: 2 TIN = 500ML x 2 QTY = 1 LITRES
Go to Housekeeping [NEW], Run Setup, General Setup.
Select User Define - Formula
Insert the following formula for Qtye = (XQTY1 * XQTY2) / 1000
Insert Xqty1 = TIN
Insert Xqty2 = ML
Click Verify and OK
Go to Maintenance, Item Maintenance, Item File Maintenance.
Add in Item No and details
Unit Of Measurement, LITRE
Unit Cost Price, 8.50
Unit Selling Price, 17.50
Mark Quantity Formula
Click Save
When cursor reaches Quantity, hit the arrow down key on the keyboard to pull out the dialog box Determine Quantity.