How to generate Commodity Trading Reports?
In the Reports module, click on the Commodity Trading Reports drop-down list.
Here, click on either Sales Loss Report or Purchase Loss Report to generate an Excel file that corresponds to your needs.
Purchase Loss Report
Tracks differences between the quantity a supplier was supposed to deliver vs. what was actually received.
Highlights shortages, allowable (natural) loss, and actual loss at the purchase stage.
Breaks down by Purchase Order, item lines, and related Receive Notes.
Ensures you know if actual losses are within acceptable limits or if they exceed (abnormal losses).
In which:
Qty After Warehouse Loss Rate = Received Qty x Warehouse Loss Rate
Shortage = Expected qty - Received Qty
Allowable Loss = Expected qty x Product detail’s Acceptable Loss Rate
Actual Loss = If Shortage < Allowable Loss → 0; If not, show Shortage - Allowable Loss
Note: For products like oil or chemical liquids, it’s normal to lose a small amount during storage or delivery (e.g. leakage or evaporation).
In EMERGE, you can set up the warehouse loss rate and acceptable product loss rate to detect the acceptable loss rate during storage and delivery.
Sales Loss Report
Compares what was sold and shipped to customers vs. what customers actually received.
Shows total loss, acceptable (natural) loss, and abnormal loss.
Breaks down by Sales Order, shipment batches, and invoices.
Ensures losses beyond acceptable limits are highlighted for action.
In which:
Natural Loss = SO’s qty x Product’s Acceptable Loss Rate
Total Loss = SO’s qty - Customer Received Qty
If this number > Natural Loss → Number = Red to 3 columns Total Loss, Actual Loss, Abnormal Loss (to show that it exceeds the Acceptable Loss)
Actual Loss = Delivered Qty - Customer Received Qty
Abnormal Loss = Total Loss - Natural Loss
Relate content: