Scenario
User needs to create a report that shows the total quantity and PO rate amount of all open sales orders in which items that have already been received on the associated PO but are still pending fulfillment.
User tried to customize the Sales Orders Pending Fulfillment Report but noted the following:
- The amount on the report is showing the sales order amount and not the PO rate amount. The report needs to show the total PO rate amount which reflects the cost.
- The quantity received line is inaccurate. This column is not showing the correct quantity for the associated PO.
Solution
1. Go to Lists > Search > Saved Searches > New
2. Select Transaction
3. Under the Criteria tab, add the following fields:
Note: You may add or remove fields if needed.
4. Under the Results tab, add the following:
Note: You may add or remove fields if needed.
Formula used:
- Qty Received Not Yet Fulfilled: {purchaseorder.quantityshiprecv}-{quantityshiprecv}
- $ Amount Received Not Yet Fulfilled: ({purchaseorder.quantityshiprecv}-{quantityshiprecv})*{purchaseorder.rate}
5. Enter a Search Title
6. Click Save & Run
This search compares the Quantity Fulfilled on the Sales Order with the Quantity Received from the Purchase Order, then multiplies that quantity with the unit cost from the PO to get the value of the items.
-----
If you find this information useful, let us know by reacting or commenting on this post!