Finance | Project Operations, Human Resources, ...

Error in Project invoice: transactions on voucher x do not balance as per xxx. (accounting currency: -xx - reporting currency: -xx)

(0) Share

Report

Posted on by JuleWergne

338

Hi all, i've read through related topics, but couldn't find an answer for my case..

When posting a project invoice proposal we get an error: "The transactions on voucher x do not balance as per xxx. (accounting currency: -0,05 - reporting currency: -0,05)" --> 5 cents.

The invoice proposal has 50 lines, transaction and accounting currency are different. In GL Parameters we have max. penny difference set as 2 cents.

Just for testing purpose I set the max. penny difference Parameter to 5 sent and AX posted it through (in the voucher the AR(customer balance) is then 5 Cent less than Invoiced revenues).

(it is AX 2012 R3 System)

How could we solve this problem? I see no chance to adjust something in the invoice proposal

or is changing the GL parameters the only solution? I was told, in this case it could have some Impact on old transactions(e.g.when reversing old transactions).

We have also seen a field "round off" in the invoice proposal mask: Totals-->Round off. But it is not editable. Does it have some purpose or how we could use it?

Thank you in advance!

Best regards, J.

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Error in Project invoice: transactions on voucher x do not balance as per xxx. (accounting currency: -xx - reporting currency: -xx)

Hi Jule,

I would expect that this is only a one time issue.

For that reason, I would temporarily change the rounding settings to 5 ct. , then post the invoice and then reset the rounding settings to where they have been.

Should the issue come up again in the future, have a chat with a developer and debug things in detail. I would expect that this won't be the case but to overcome your issue you can temporarily change your parameter settings.

Best regards,

Ludwig
JuleWergne 338 on at

Like (0)

Report

RE: Error in Project invoice: transactions on voucher x do not balance as per xxx. (accounting currency: -xx - reporting currency: -xx)

Hi Ludwig Reinhard

I have already tested if I set GL parameters from 2 Cent to 5. It works in this case, and the 5 Cent difference is posted to automatic account.

My questions would be:

1) should I set both GL parameters to 5 Cent?

2)should AR/AP parameters also be changed in this case?

3)If we change these parameters,does it have some impact on old Transactions? E.g. if some Transaction was posted a month ago with GL Parameter of 2 Cent, and now it has to be reversed (with GL Parameter of 5 Cent), would there be some complications?

Of course, I will talk to AX users about the exact amount of rounding difference in parameters.

Thank you!
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Error in Project invoice: transactions on voucher x do not balance as per xxx. (accounting currency: -xx - reporting currency: -xx)

Hi,

Your screenshots look ok.

Can you try a couple of things

- try to increase your rounding settings to 0.06

- if this does not fix the error, check in the GL automatic posting accounts that there are accounts for picking up and posting such rounding differences

- if also this does not help, check your AX2012 version. Might be that this system behavior is related to a bug. I found a couple of them for older AX2012 systems. Please see: fix.lcs.dynamics.com/.../Results

- if also this does not result in something, ask a developer for some help to debug.

Best regards,

Ludwig
JuleWergne 338 on at

Like (0)

Report

RE: Error in Project invoice: transactions on voucher x do not balance as per xxx. (accounting currency: -xx - reporting currency: -xx)

Hi André, hi Ludiwg,

accounting currency is not different from the reporting currency(it is EUR in this Case); Transaction currency is CHF.

I have checked the Parameters:

in GL we have 0,02 eur in Setup:

in AR/AP 0,01 eur:

With the current setup AX tries to post e.g. 100€ on customer balance account(debit) and 100,05€ on revenues account(credit)--> and it comes to the error.

As the invoice has about 50 lines, I tried to find out which line exactly causes probably this Problem, but couldn't find anything. No tax is calculated in this invoice.

Ludwig Reinhard what Setup did you mean here exactly?

"The smallest coin in Switzerland is 5 Rappen or 0.05 CHF.

Can you check in your currency setup that this is setup there?"

the setup in GL from my screenshots or is there separate Setup for CHF currency?

For CHF I have found this one:

Thank you!

Regards
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Error in Project invoice: transactions on voucher x do not balance as per xxx. (accounting currency: -xx - reporting currency: -xx)

Hello Jule,

The smallest coin in Switzerland is 5 Rappen or 0.05 CHF.

Can you check in your currency setup that this is setup there?

If so, talk to the users whether this can be changed in line with your other GL/AR/AP parameters rounding settings.

To me this would explain the imbalance mentioned.

Best regards,

Ludwig
André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (0)

Report

RE: Error in Project invoice: transactions on voucher x do not balance as per xxx. (accounting currency: -xx - reporting currency: -xx)

Hi Jule,

Is the accounting currency different from the reporting currency? Have you identified where the difference of 0.05 comes from? Is it related to Sales Tax or something different?