Small and medium business | Business Central, N...

Aged accounts payable report

(1) Share

Report

Posted on by Imari

154

Hi. We are using the Aged Accounts Payable report however, there's one invoice that's not included in the report. This is both from report ID 322 and report id 10085. The only difference I can see is the invoice that's not in the report is a corrected invoice. We corrected the invoice because the amount is incorrect. Upon checking on the Aged AP report, it's not included. Could you please help on how to fix it?

Categories:

Dynamics 365 Business Central

All responses (6)

Answers (0)

Imari 154 on at

Like (0)

Report

Aged accounts payable report

Hello, All.

Good morning. We have tested the same scenario in our testing environment and we were able to capture the data on the report. The other difference of this specific transaction is the Net terms. This is set to Net45 compared to all that has Net30. Would this impact anything? What's the range for the Current or Balance Due field? Is it only within 30 days from the due date to be included in the report under the Balance Due field?
Imari 154 on at

Like (0)

Report

Aged accounts payable report

Hi, Valentin and Zhu. Here's the ss of the Vendor ledger entry for the PIN. The aged as of date is set to today's date.
Suggested answer

YUN ZHU 81,702 Super User 2025 Season 1 on at

Like (0)

Report

Aged accounts payable report

It seems to be a posting date issue.
As Valentin mentioned, it would be helpful if you could provide the screenshot below.

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Valentin Castravet 27,825 Super User 2025 Season 1 on at

Like (0)

Report

Aged accounts payable report

Oh ok got it. When you go to the Vendor Ledger Entries Page, does the invoice have a checkmark in the Open column? And when you run the report, is the Aged as of Date after the Posting Date of the invoice?
Imari 154 on at

Like (0)

Report

Aged accounts payable report

Hi, Valentin. We corrected it and created a new purchase invoice. The new purchase invoice is not showing in the report.
Suggested answer

Valentin Castravet 27,825 Super User 2025 Season 1 on at

Like (0)

Report

Aged accounts payable report

If you corrected it, that means a credit memo was created and applied to the invoice. The credit memo and invoice are applied to each other, so the invoice is not open anymore. The Aged AP report only displays open items. Why do you want to display it in the report if its corrected?

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/