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, invoices 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.  



Navigation



To navigate to the AP Aging Report, click 'My Reports' in the Accounting Module and select 'Vendors' in the top header. Once opened, a listing of reports will be shown. 


Find 'AP Aging', as displayed in the image above, and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be set to pinpoint the exact report a User needs.



Report Parameters



1) Legal Entity - A listing of all Legal Entities that can be selected 

2) As Of - The date this report is ran as of

3) Vendor - A listing of all Vendors

4) Hide $0 Balances - This option will either hide or show $0 Balances

5) Detail Level - This option will show either show or hide the invoice numbers expanded from their Vendors initially

6) Sum By Location - This option will either include or exclude the Location before each listing of Vendors

7) Calculate Aging From - This option will either calculate the aging from the document date or the due date

8) Include Trx Based On - This option will allow the User to specify the date the transactions are based on

9) Show Unapproved - This option will either show or hide unapproved transactions

10) Vendor Group - A listing of all Vendor Groups for the Vendor

11) Run Button - Runs the report 



Report Columns




1) Trx # - The transaction numbers associated with the AP Invoices, AP Payments, and AP Credit Memos

2) Trx Type - The type of transaction associated with the transaction number

3) Doc Date - The date the AP Transaction was put into R365

4) GL Date - The date the AP Transaction posts to the General Ledger

5) Due Date - The date the AP Transaction is due

6) Current - Any invoice amounts that are currently due. If at $0, this AP transaction is past due 

7) 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 

8) 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 

9) 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  

10) 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 

11) Total Due - The total amount due to each Vendor