Applies to Product - Dynamics 365 Business Central
What’s happening?
Experiencing discrepancies in the Aged Accounts Payable report based on the selected 'Aging By' method. Specifically, an invoice does not appear when the report is run by document date, but it does appear when run by due date.
Reason:
This arises from the calculation logic in the report. If the "Document Date" is greater than the "Ending Date" (the field "Aged as of"), the calculation uses the "Posting Date," resulting in the invoice not being displayed. Conversely, when using the "Due Date," the report focuses on the "Due By" date, which does not filter out the invoice.
Resolution:
- Understand the differences between the 'Aging By' methods:
- Due Date: Calculates the age of payables based on the due date of the invoices, identifying overdue or approaching due invoices.
- Document Date: Calculates the age based on the date the document (invoice) was created, useful for tracking the age from the issuance date.
- Posting Date: Calculates the age based on the date the invoice was posted in the system, reflecting the age from the recording date.
- For the specific case where an invoice with a posting date of 01/01/2025, document date of 08/12/2024, and due date of 31/12/2024 does not appear when filtering by document date:
- Verify that the "Document Date" is not greater than the "Ending Date" in the report settings.
- If the "Document Date" is greater, the report will default to using the "Posting Date," which may lead to the invoice being excluded from the results.