When receipting Purchase Orders, your receipted dollar amount may not equal your total Purchase Order (PO) amount. When these are closed, this will cause balances to remain in your Encumbrance accounts if amounts are not cancelled. To be able to compare Purchase Order total amount against the Total Receipt Amount, you must create an export.
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