How to Setup Alternative Unit of Measure in Business Central
Introduction:
Many Businesses supports buying and selling items with different unit of measures. How to configure this in Business Central without showcasing your inventory in decimals.
Let’s take an example:
We will be buying the goods always in dozen whereas we can sell the items in PCS or CARTONS.
Steps to achieve the goal:
- Go to Items choose base unit of measure in PCS. The reason is if you choose higher unit of measure (DOZEN or CARTONS) as base unit of measure and if you selling goods lower unit of measure(PCS) the inventory would be showcased in decimal value.
2. Once the base unit of measure is set to PCS. Go to the Item Unit of Measure page by click on Related-> Unit of Measure.
3. By default PCS line would be set to 1. Add new line enter DOZEN and next right 6 which means 1 dozen has 6 PCS.
4. Next line add CARTONS and enter the qty per unit of measure as 72. which means 1 Cartons has 72 PCS in it.
5. Once the above lines have been set. Let’s pass Item journal where will be increase the inventory by dozen and sell the items in PCS and CARTONS. Ideally the inventory would be shown without any decimal value.
6. Below is the explanation how system would calculate into PCS as when you buy and sell in different items.
7. Purchase 100 dozen which is 600 PCS. This would be converted by Business Central itself. As we have defined 1 dozen as 6 PCS.
8. Sales 7 Cartons which is 702 PCS. This would be calculated by Business Central itself as per the Item Unit of Measure configuration where 1 cartons is 72 PCS.
9.Once the above transaction is posted the inventory would be whole value without any decimal.
Conclusion:
Thus, we saw how we can use alternative Unit of measure in Business Central.
Thank you very much for reading my work. Hope you enjoyed the article!
