I am attempting to create a report to show the total quantity and PO rate amount of all open sales orders in which items have been received on the associated PO but are still pending item fulfillment. This would allow me to see the exact dollar amount of non-inventory items which are staged in our warehouse waiting to be fulfilled.
I have run into the following issues.
- The amount on the report is showing the sales order amount and not the PO rate amount. I need the report to show the total PO rate amount which is our cost.
- The quantity received line is inaccurate. This column is not showing the accurate reporting for the associated PO.
In this pictured example the associated PO is 2447. The top line on this example has an ordered quantity of 2 and a quantity received of 0. As you can see in the second picture, the 2 items have been received on the last line. With this information I would expect the quantity received column to represent the quantity of 2 having been received.
Ultimately I need a report to show the total quantity and $ amount of non-inventory items which have been received and are still pending fulfillment.