Follow the steps below for the 2nd UOM Handling:

First Stage: Setup of 2nd UOM in the Item Card

1) Search "Items", go to the related item and find action button "Unit of Measure - 2nd UOM"

2) Set Code from the "Unit of Measure List" & the Qty Per Unit of Measure (Base Unit)

*Users need to enter the Base Unit Code, and Qty. per Unit of Measure = 1


Second Stage: Order Process handling

Case 1 - if the 2nd UOM only for Purchase Order.  For example, the order to customer is use 1000M2 but need to use TONNES for place order to Vendor.

(1) - In sales order, enter the Order Quantity and Sales Unit.  Leave blank for 2nd UOM

(2) - In related Purchase Order, enter the Direct Unit Cost and select the 2nd UOM.

    The system will calculate 2nd UOM Qty and 2nd UOM Price once the Order Qty, Unit, Unit Price and 2nd UOM is entered.

Calculation of 2nd UOM Qty and Price

  • 2nd UOM Qty = Order Quantity * Qty. per Unit of Measure, up to 4dp
  • 2nd UOM Price = Order Amount / 2nd UOM Qty, up to 2dp
  • User can change the value of the 2nd UOM Qty and 2nd UOM price after calculated by system.  However, system will not calculate the Order Qty and Direct Unit Cost
  • If user change the order quantity after 2nd UOM Qty and 2nd UOM Price is calculated, system will not re-calculate the value.  User can select the 2nd UOM again for allow system to re-calculate.


Case 2 - if the 2nd UOM need to show on Sales Order.  For example, the order to customer is 1000M2 but need to show how much TONNES on the sales order.

2nd UOM

  • If the 2nd UOM is entered in Sales Order, the 2nd UOM and 2nd UOM quantity to be brought to the drop shipment purchase order when create the drop shipment PO. 
  • The 2nd UOM, 2nd UOM Quantity must be same for the Sales Order and Purchase Order.  Currently, system is no verification on SO 2nd UOM Qty and Unit and PO 2nd UOM Qty and Unit
  • If the Order Qty in SO is updated, system will update the order quantity to PO automatically.  However, the 2nd UOM Qty and Price will not re-calculate by system.

(1) - In sales order, enter the Order Quantity, Sales Unit, Unit Price and select 2nd UOM


(2) - When create drop shipment Purchase Order, the 2nd UOM Qty, 2nd UOM and 2nd UOM Price to be carried from the sales order line.  

User need to change the 2nd UOM Price manually or re-select the 2nd UOM for allow system re-calculate the 2nd UOM price.


Third Stage: Group Shipment handling

1) When create a Group Shipment, 2nd UOM Qty & Price will be populated according to the Purchase Order Line 

Assumption on Pick Line from Order

The logic for populate 2nd UOM, 2nd UOM Qty and 2nd UOM Price is base on the assumption below:

1) in Group Shipment, there are only one set of fields for 2nd UOM, 2nd UOM Qty and 2nd UOM Price.  the value is only able to carried from either SO or PO.

2) 2nd UOM, 2nd UOM Quantity must be the same for the drop shipment SO/PO

3) refer to the 2nd UOM we identified, Group Shipment will alwasys has the value from PO if 2nd UOM is entered for both SO/PO.

2) If the shipment is Partial Shipment, system will prompt the message for alert user to re-calculate the 2nd UOM Qty and 2nd UOM price.

 The calculation to be according to the Unit of Measure - 2nd UOM

User need to click the button "Recalculate 2nd UOM Qty & Price" for calculation the 2nd UOM Qty and Price for the Ship Qty..


Re-calculate 2nd UOM in Group Shipment

*After the group shipment line is created for the order, if change of 2nd UOM Qty and 2nd UOM price in the order line, it will not refresh to the related group shipment line.

*If user changed the UOM Qty / Price in the Group Shipment and post all document, information will not be updated in the Sales Order Line but will refresh the posted documents.