Create a shipping performance report by customer / line item that shows the information for all plant customers
The shipping performance report must include:
1) Normal orders
2) Schedule agreements
3) Cross company PO
If the Order is on a Scheduling Agreement, we have to consider that we have a blanket order that does not have an Order Fixed qty, so the report should show
Date of shipment (according with the scheduling agreement).
Qty requested (according with the scheduling agreement fot that specific date)
Value of the scheduling agreement line (Value of the scheduling agreement line = Qty Requested * Material Unit price)
Total pieces shipped (for this specific schedule agreement line.)
Balance Left ( Balance Left = Qty requested - Total pieces shipped )
Value of the balance left Value of the balance left = Balance left * Unit price only if the Balance left is greater than cero,
if the balance left is lower than or equals cero, the value of the balance left show be cero.
% Delivery. (% Delivery = Total Pieces shipped / Qty requested)
How to find the fields