web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

AR (Excel) report get inacurate result

(1) ShareShare
ReportReport
Posted on by 61

Dear All,

I noticed a change when exporting the Aged Accounts Receivable (Excel) report in BC  after upgrading to version 28.4.

Previously, I used the following filters:

  • As of Date: 31/07/2026
  • Period Length: 1M
  • aging by : either posting date or due date
  • Period Count:  default ( so count is 5)

With these settings, the report periods were generated from February to July, and I obtained the correct AR balances as of the selected date.

The report included all relevant Customer Ledger Entries posted up to 31/07/2026, regardless of whether the original invoices were posted in 2025, 2024, 2023, or earlier. The report correctly grouped them into the aging periods.

However, after the upgrade to version 28.4, using the same filters does not produce the same result.

Only invoices posted within certain months (for example, March to April) are included, while invoices posted outside those months are excluded from the report, even though they remain open as of 31/07/2026. 

Could you all please advise whether there have been any changes to the report filter logic or report behavior in version 28.4, or whether this could be an issue?

 

 

Regards,

Dia

 

I have the same question (0)
  • Dia Lwin Profile Picture
    61 on at

    To be add on I've verified in the version 28.3 and there is no issue. 

  • Suggested answer
    AndrewThomas81 Profile Picture
    2,499 Super User 2026 Season 2 on at

    I'm not seeing any reconciliation issue with the report (provided it is run on posting date) and my data has entries from 2025 and they are showing correctly as 2025

     

    Kind Regards

     

    Andrew Thomas FCCA MCP

    YouTube - Use Business Central

    LinkedIn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 592 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 372 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 329 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans