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

Rounding balances in Customer accounts

(3) Share

Report

Posted on by NA-06031440-0

Hello, In the ageing report for this customer account the Currencies balances are 0.00 but the total LCY is showing 13.25, note that for these customers I did not apply entries as there are more than 30K entries to be applied manually which is too long. Now how do I get rid of this balance in the Total LCY?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Teagen Boll 1,200 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

This seems to be an FX difference at a glance. Have you ran the adjust exchange rates process for the customer ledger entries? That may fix the problem. I'd recommend running that in a copy of the company first.

You can see information on the update exchange rate here: Update currency exchange rates - Business Central | Microsoft Learn

Let me know if that works, there may be other issues though.

Teagen

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,769 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Is this amount found in Customer Ledger Entries? As Teagen mentioned, this looks like an FX difference, estimated to be -13.25 consisting of a large number of 0.01 and -0.01.

Hope the following can give you some hints as well.

https://community.dynamics.com/blogs/post/?postid=25fdd2b4-ff80-f011-b4cc-6045bdd8118b

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,372 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

This happens because your entries are not applied, so although each currency (GBP/EUR/USD) nets to 0.00, there are still small exchange/rounding differences in LCY, which is why you see the 13.25; the only way to fully clear it is to either apply the customer entries (best option) or post a small write-off/rounding journal and apply it, otherwise that LCY residual will always remain on ageing.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

AndrewThomas81 402 on at

Like (0)

Report
Copy link

Link copied!

Do you get the same result using the excel version of the report?

Can you run the report showing details? As already mentioned it is likely that you have un-resolved rounding differences due to allocations not performed

Kind Regards

Andrew Thomas
https://www.usebusinesscentral.com/
https://www.youtube.com/@usebusinesscentral

Was this reply helpful? Yes No
NA-06031440-0 11 on at

Like (0)

Report
Copy link

Link copied!

Hi all,

Thanks for your help, yes I did run the adjust exchange rate batch and I got this difference only after running it, the issue is that because we have more than 30 thousand lines it is very time consuming to apply entries. And if I post write off journal clearing the LCY total that is gonna leave a balance in the GBP Bucket in the ageing report.

Hi Andrew yes i get the same result running the excel version.

Could you kindly assist me with this? if there any other work arounds.

Was this reply helpful? Yes No
Suggested answer

AndrewThomas81 402 on at

Like (1)

Report
Copy link

Link copied!

It would be best practice to apply entries, as over time this report will take longer and longer to generate.

If manual application is an issue, you could consider switching to "Apply-to-Oldest" on the customers

Kind Regards

Andrew Thomas
https://www.usebusinesscentral.com/
https://www.youtube.com/@usebusinesscentral

Was this reply helpful? Yes No