In many industries, items can be produced, stored, sold, consumed and purchased in different unit of measure, or UoM to simplify. For example, an item can be stored by case, produced by piece, sold by Dozen, and packaged/shipped by Box. You can track all of these transactions in Beas by setting up UoM for sales, inventory, shipping and more.
For all these cases, we will need to define conversion rates within the units of measure. For example, if an item is stored as individual pieces, but purchased by dozens, then a conversion factor of 12 will be used on the purchase order. This will help the process flow according to the quantities per transaction.
To facilitate processing, Beas maintains conversion rates between the standard UoM and the various other UoMs. The standard unit of measure is the Inventory unit, so all conversions will be from any UoM to the Inventory unit.
The conversion formula allows mathematical operators or predefined functions. The values on the dimensions (Length, width, height and density) are not real. It is only to check the results. The true values come from the item master data.
Example 1: Need to convert from Kilogram to Gram, which is standard.
In the formula field, the value is 1000, which means it will multiply the value by 1000. Above, Beas displays the conversion result:
1 kg = 1000 Gr
In addition, the opposite direction is displayed, only to test the formula.
IMPORTANT: In case you need the conversion backwards (from Gr to Kg), another conversion formula must be created.
Example 2: Need to convert from Kilogram to Meter, which depends on a factor per item.
In the conversion formula, the variable “density” works as a conversion factor. This option is used when the conversion is not fixed as, for example, Kilogram to gram. In this case we use variables.
The correct way to use it is to calculate the formula and type the result in the field "Spec. Weight" on the item master data. To enable this field, you will have to check the parameter on the configuration wizard (Master Data > Item > Display > Item Master > Spec. Weight by item)
In the formula field, the value is "density", which means it will multiply the value by the value defined on the field "Spec. Weight". Above, Beas displays the conversion result:
1 kg = 7.10 m