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

Amount on AR Aging does not match to GL

(3) Share

Report

Posted on by rcboiler

1,236

Base currency is USD. have an AR invoice processed with another currency. USD Amount (Amount $) and GL amounts match perfectly. However, when you run the Aged Accounts Receivable Report, the value showing in the open balance does not equal either the foreign currency or the USD amounts. Ever seen that before?

Revaluation journal did not produce any entries.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Alex A 3,003 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Have you run Adjust Cost Item Entries?

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,612 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Can you look at the Detailed Customer Ledger Entries and post the entries here along with the Aged report?

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 10,875 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

If A/R Aging shows a number that matches neither FCY nor LCY, it’s almost always because the report is pulling the wrong field, usually not Remaining Amt. (LCY).

Even when the invoice and G/L look perfect, the Customer Ledger Entry may have LCY rounding or detailed-entry differences that the aging report exposes.

Revaluation doing nothing just means BC thinks the LCY for that entry is already correct.

Check

Open the Customer Ledger Entry → compare:

Remaining Amt. (LCY)

Remaining Amt.

Whatever Aging shows = one of those fields (sometimes the wrong one due to layout/options).

If Remaining Amt. (LCY) ≠ Amount (LCY), the mismatch is coming from detailed entries rounding.

If you send the three numbers, I can tell you exactly which field the report is using.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,846 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Did you try Investigating some of those entries and see what they are actually holding and the reason?

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,935 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Yes, this is normal. When you run the Aged AR report without selecting Print Amounts in Customer’s Currency, the report converts the foreign-currency open balances into LCY using today’s exchange rate. If the invoice was not posted today, the LCY amount on the report will not match the LCY amount in the G/L. The report is designed to show what the LCY value would be if the invoice were settled today.

If you run the report with Print Amounts in Customer’s Currency set to Yes, the FCY amounts on the report will match the FCY amounts on the invoices.

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

Was this reply helpful? Yes No