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

Maximum penny difference

(2) Share

Report

Posted on by Marco_1000

Hi there,

In Business Central you have sometimes an imbalances in the reporting currency for a small amount such as 0.01 when the total in the foreign currency evens out perfectly. For this reason there is a function to avoid getting this error and record the pennies to a separate account.

https://learn.microsoft.com/en-us/dynamics365/finance/general-ledger/posting-fail-imbalance

There are blog post about NAV where you can set up the maximum penny difference for i.e. EUR:

https://cloudblogs.microsoft.com/dynamics365/it/2017/04/26/what-does-the-maximum-penny-difference-parameter-do/

The questions is where is the function /Maximum penny difference/ located in Business Central?

Thanks a lot.

Best,

Marco

Categories:

Dynamics 365 Business Central

All responses (5)

Answers (0)

Sort by

Gerardo Rentería Ga... 27,623 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi

The documentation is from F&O which is another solution, not BC.

This product is not NAV, it is AX.

If I understand correctly, you are looking for this.

https://learn.microsoft.com/en-us/training/modules/foreign-currencies-dynamics-365-business-central/2-analyze

BR

GR
Marco_1000 51 on at

Like (1)

Report
Copy link

Link copied!

No it is more about if you have a collective booking. Sometimes you have to add 0.01 in the reporting currency that it matches in the reporting and the foreign currency:

and I think to avoid to always to book these 0.01 you can use the maximum penny difference. The question is only where to activate it.
Suggested answer

YUN ZHU 103,712 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, have you run Adjust Exchange Rates batch?

Generally, the balance of exchange rate adjustments is accounted for in the following accounts.

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-set-up-currencies?wt.mc_id=DX-MVP-5004336

Hopefully other experts can give you better advice.

Thanks.

ZHU
Suggested answer

Jun Wang 8,222 Moderator on at

Like (0)

Report
Copy link

Link copied!

I believe you need to visit this page for a specific currency. the other place is general ledger setup page
Marco_1000 51 on at

Like (0)

Report
Copy link

Link copied!

The problem is that each line is multiplied by the exchange rate and the decimals lead to that some rounding takes place, which then gives us an imbalance of 0.02 in the reporting currency. To not manually correct the 0.02 in the reporting currency, I thought the maximum penny difference could help. However, I do not find this option in Business Central.

Is there a function that could cancel out such penny imbalances automatically?