To report or analyse Customer Aging, there are 2 reports available in Business Central:
Vendor - Summary Aging
Aged Accounts Payables
Vendor - Summary Aging Report
Steps
Search for Vendor - Summary Aging Report (in the category Report and Analysis)
...
When you click on the link, following window opens
...
Category Options: First filters that can be used are Filters on: Starting Date, Period Length and you canalso swithch can also switch on/off the option to Show Amount in LCY (Local Currency)
...
You can use filter on Vendor No., Search Name, Vendor Posting Group and many more Vendor related fields from the list:
...
You can also filter totals by:
Currency Filter
Date Filter
Global Dimension 1 and 2 Code
...
You will run the report by clicking on:
Send to - you can choose from many options (PDF Document, XML Document,…)
Print
Preview
...
Document Appearance
...
Aged Accounts Payable Report
Shows a list of aged remaining balances for each vendor by period.
Steps
Search for Aged Accounts Payable Report (in the category Report and Analysis)
...
When you click on the link, following window opens:
...
In Category Options some set-up for the report can be done. User can filter on these values:
Aged As Of (choose a date)
Aging by: choose from options Due Date, Posting Date, Document Date
Period Length (use number and shortcut → D = day, M = month, y = year)
choose if you want to Print Amounts in LCY (Local Currency)
choose if you want to Print Details
Heading Type: choose from options Date Interval or Number of Days
choose if you want a New Page per Vendor
choose if you want to Use External Document No.
...
You can use filter on Vendor No. and many more fields from the list: which opens after clicking on:
...
You can also filter totals by:
Currency Filter
Date Filter
Global Dimension 1 and 2 Code
...
You will run the report by clicking on:
Send to - you can choose from many options (PDF Document, XML Document,…)
Print
Preview
...
Document Appearance
...