The AP Aging report shows all open AP Transactions, including Credit Memos that haven't been applied to an invoice yet, listed with day ranges to show what invoices are current and past due. Even further, transactions are hyperlinked to allow the user to see the specific details of each transaction. Finally, any imbalanced transactions will be tied to 'Unassigned Vendor', which pinpoints the invoices that need to be corrected.
Users who have access to this report can send, export, or print this report directly from the reporting window. Learn how to send, export, or print this report.
A GL Adjustment will appear on this report if one of the dates on the transaction (Doc Date or GL Date) has occurred but the other has not. Click here to read more into an AP Invoice's Document Date and GL Date.
Navigation
The My Reports search bar can be used to search R365's entire catalog of reports.
- Open the Reports app.
- Navigate to My Reports.
- Enter all or part of the report name in the search bar.
- The Results tab will open with the list of search results.
- From beneath the report name, click Run to run the report with the selected report view.
-OR-
Click Customize to adjust the report parameters and run the report.
Report Parameters
Field/Column | Description |
|---|---|
Legal Entity | A listing of all legal entities that can be selected. |
As Of | The date this report is run as of. |
Vendor | A listing of all vendors. |
Hide $0 Balances | This option will either hide or show $0 balances. |
Detail Level | This option will either show or hide the invoice numbers expanded from their vendors initially. |
Sum By Location | This option will either include or exclude the location before each listing of vendors. |
Calculate Aging From | This option will either calculate the aging from the document date or the due date. |
Include Trx Based On | This option will allow the user to specify the date the transactions are based on. |
Show Unapproved | This option will either show or hide unapproved transactions. |
Vendor Group | A listing of all vendor groups for the vendor. |
Run Button | Runs the report. |
Report Columns
Field/Column | Description |
|---|---|
Trx # | The transaction numbers associated with the AP invoices, AP payments, and AP credit memos. These are linked to their transactions. If a vendor is labeled “GL adjustment,” this simply notes the transactions that have a different document date and GL date. |
Trx Type | The type of transaction associated with the transaction number. |
Doc Date | The date the AP transaction was entered into R365. |
GL Date | The date the AP transaction posts to the general ledger. |
Due Date | The date the AP transaction is due. |
Current | Any invoice amounts that are currently due. If at $0, this AP transaction is past due. |
1-30 Past | The 1–30 day date range an AP transaction is past due. If at $0, this AP transaction is either currently due or even further past due. |
31-60 Past | The 31–60 day date range an AP transaction is past due. If at $0, this AP transaction is either currently due, more recently past due, or even further past due. |
61-90 Past | The 61–90 day date range an AP transaction is past due. If at $0, this AP transaction is either currently due, more recently past due, or even further past due. |
91+ Past | The 91+ day date range an AP transaction is past due. If at $0, this AP transaction is either currently due or more recently past due. |
Total Due | The total amount due to each vendor. |
Email, Export, or Print the Report
This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.
