Vendor Balance created For Penny difference

(0) Share

Report

Posted on by Community Member

Hi Guys,

For the below Voucher's SubLedgerJournalEntries , the Vendor balance Reporting Currency Amount was additionally created as 0.01 as there is a difference between the Acc Currency & Rep Currency.

Currency Exchange Rate - PEN to ZAR - 4.015333725787

(3979.81 - 477.58 ) = 3502.23 * 4.015333725787 = 14062.62223446301

15980.27 - 1917.64 = 14062.63

So , here my problem is that for the 0.01 vendor balance record there are records inserted in SubLedgerJournalAccountEntryDistribution which causes the voucher to imbalance in respect of the SubLedgerJournalAccountEntryDistribution table.

How can i avoid this?

*This post is locked for comments

All responses (8)

Answers (0)

Community Member on at

Like (0)

Report

RE: Vendor Balance created For Penny difference

Hi Ludwig,

[quote user=""Ludwig"]I found a couple of them that deal with penny difference issues and believe that there must be one available that fixes your issue.[/quote]

Can you please list them or provide me links to it?
OsmanIstanbul 2,814 on at

Like (0)

Report

RE: Vendor Balance created For Penny difference

Hi!

Rarely number sequences cause this issue. Can you change your voucher number sequence and try again?

Best regards

Osman
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor Balance created For Penny difference

Good Morning Hello World,

In this case, I would like to ask you following Andre's recommendation.

Have a look at LCS and look out for hotfixes that apply to your system version.

I found a couple of them that deal with penny difference issues and believe that there must be one available that fixes your issue.

Best regards,

Ludwig
Community Member on at

Like (0)

Report

RE: Vendor Balance created For Penny difference

Hi Ludwig,

I have tried increasing the GL Parameters---->Maximum Penny rounding in the Reporting Currency to 0.02 to 0.50 , but the results are same as before.
André Arnaud de Cal... 292,863 Super User 2025 Season 1 on at

Like (0)

Report

RE: Vendor Balance created For Penny difference

Hi,

The error on the screen is not directly mentioning that there is an imbalance. It could be related to wrong customizations or a bug. Have you looked into LCS issue search for a possible known issue?
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor Balance created For Penny difference

Hi HelloWorld,

Have you tried increasing your acceptable penny difference configurations to 0.02 cents?

Can you do that in a demo/test system and replicate the transaction that you shared?

Best regards,

Ludwig
Community Member on at

Like (0)

Report

RE: Vendor Balance created For Penny difference

Hi Andre,

As vendor balance was created 0.01 and it also creating the amounts in SubLedgerJournalAccountEntryDistribution table which is not required in any cases and causing it to imbalance it and while we run Reporting Currency Conversion from GL , we are getting the error as,

the below error from LedgerCurrencyConversionProvider_FIM - > balanceSubLedgerJournalAccontEntryDist() method
André Arnaud de Cal... 292,863 Super User 2025 Season 1 on at

Like (0)

Report

RE: Vendor Balance created For Penny difference

Hi,

Can you tell if you get an error while posting a document? What exact error and what type of posting did you do? You provided a screenshot, but without any column labels. In some cases the 0.01 rounding line is correct.