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)

Marco_1000 23 on at

Like (0)

Report

Maximum penny difference

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?
Suggested answer

Jun Wang 7,440 Super User 2024 Season 2 on at

Like (0)

Report

Maximum penny difference

I believe you need to visit this page for a specific currency. the other place is general ledger setup page
Suggested answer

YUN ZHU 75,848 Super User 2024 Season 2 on at

Like (0)

Report

Maximum penny difference

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
Marco_1000 23 on at

Like (1)

Report

Maximum penny difference

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.
gdrenteria 13,057 Most Valuable Professional on at

Like (1)

Report

Maximum penny difference

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