Aged Receivables

Is it possible to create Report- Aged Receivables based on Due Date, not only Invoice Date?

image
This report is already based on Due Date not Invoice date

1 Like

Wrong. Invoiced date not Due date


3 Likes

Sorry but @shahabb is right. If you think it still is wrong then illustrate with relevant screenshots similar to @shahabb

The problem arises when you create the report.
You have only two options: choose by invoice date, not due date, or choose today’s date. I need a report created based on the due date.

As @shahabb already explained in his first response and also with his screenshots it is based on Due date. The due date in hist screenshot was 26 July 2024 and days overdue as 23 days similar to the report date as of 18 August 2024 shows aged receivables as between 1-30 days (23 days is within that range).

The current date or custom date that you provide in the Aged Receivables report is the date until which all overdue items are listed per customer.

When you create report, which date you choose?

The date you choose is usually the default date which is the current date because you want to know which receivables are due by that date and as shown by which period overdue until more that 90+days.