Purchases

The Dual Unit of Measure app allows you to purchase items with a variable relationship between weight/volume and units. For example, order cartons at an average weight and then receive the actual weight and number of cartons.

Create a Purchase Order with Dual Unit of Measure Items

In this example, we assume that you already know Business Central and have already set up Dual Unit or Measure Items.

Variable Ratio Dual Unit of Measure Item

Create a new Purchase Order and select the Vendor.
In the lines section, select Item for the type and then select the Beef Whole Eye Fillet item.
Specify 50 in the Units field.
Specify the Direct Unit Cost.

Fixed Ratio Dual Unit of Measure Item

Add a new line and select the Punnet of Strawberries item on the same purchase order.
Specify 40 in the Units field.
Release the purchase order.

note

You will notice that the Quantity field updated automatically for both lines using the ratio configured against the item.

tip

If you want to show the units on your purchase order document, you will need to update the layout of the Standard Purchase Order. You might need help from your implementation partner to do this. The app extends the standard documents and adds units to the dataset, so you only have to update your layout.

Receive and Invoice a Purchase Order with Dual Unit of Measure Items

We will now receive and invoice the order we created above.

Processing

Specify TEST1 for the Vendor Invoice No..
On the line for the Beef Whole Eye Fillet, change the Qty. to Receive to 53.25. In this scenario, the weight is slightly over the average, but well within the tolerance we specified in the setup (20%). Notice how updating the Qty. to Receive also updated the order quantity and amount without reopening the document.
Select the Post action and select Receive and Invoice.