The Receipts module allows you to upload PO receipt data and calculate On-Time Delivery performance for your suppliers.
The following columns are required:
"Vendor Code"
"Supplier" (ignored)
"Buyer"
"PO Number"
"PO Release"
"Receipt Number"
"Part Number" (optional, currently not tied to Part Master)
"Part Description" (optional)
"Receipt Date"
"Commit Date"
"Late Days" (ignored)
"Reason Code"
"Supplier" (ignored)
"Buyer"
"PO Number"
"PO Release"
"Receipt Number"
"Part Number" (optional, currently not tied to Part Master)
"Part Description" (optional)
"Receipt Date"
"Commit Date"
"Late Days" (ignored)
"Reason Code"
The following Reason Codes are available (Currently this is a fixed list. In the future, this will be user configurable under List Of Values).
"on Time" // green
"Early" // light green
"Delayed Receipt Transaction" // yellow
"Vendor Responsible" // red
"Buyer Data Maintenance" // orange
"Freight/Customs" // brown
"Data Correction" // grey
"Early" // light green
"Delayed Receipt Transaction" // yellow
"Vendor Responsible" // red
"Buyer Data Maintenance" // orange
"Freight/Customs" // brown
"Data Correction" // grey
Also we have a special logic (currently) to automatically set reason codes to "On Time" and "Early":
when( "Receipt Date" = "Commit Date" ) reason code = "On Time"
when( "Receipt Date" < "Commit Date" ) reason code = "Early"