Saturday, May 4, 2019

Purchase Order Report to Display Quantity Received and not yet Received

1. Navigate to Reports > Purchases > Open Purchases > Open Purchase Orders > Customize.

2. On the Edit Columns link, click on the Open Purchases folder. Scroll down and click on the Item folder. Click on the Name field. This will add a column for the items.

3. On the Edit Columns link, click on the Open Purchase Orders folder. Click on Quantity field.

4. On the Edit Columns link, click on the Open Purchase Orders folder. Click on Quantity Received field.

5. On your left hand side, click on the Add Formula Field button. A new formula column will be added.

6. On the Formula Type, choose Difference x-y.

7. Set x to Quantity.

8. Set y to Quantity Received.

9. Change the Column Label to "Quantity not yet Received".

10. On the Filters link, click on the Open Purchase Orders folder. Scroll down and click on Validated Status. Set the filter to Validated Status is equal to Partially Received, Pending Billing/Partially Received, Pending Receipt.

11. Rename the report and hit Save.

2 comments: