To report on total PO amount and total Receipt amount, follow the steps below:
1. In Accounts Payable, click Export
2. Click New and choose Purchase Order as the type of Export
3. Click Create now to reach the Export options
4. On the filters tab, you may choose to filter if you would like to limit your results
- Tip: You may apply a Purchase Order query with the criteria to pull only closed Purchase Orders to the filter if you want to report only on Closed Purchase Orders.
5. On the Output tab, expand Purchase order
6. Select which columns you would like in your export including "Purchase order number", "Total" and "Total amount receipted"
7. Click Export Now
8. Choose your file location and name
9. Click Save to begin Export
10. Open file in Excel