The transactions on voucher XXXX do not balance as per <date>. (accounting currency: $<some#> - reporting currency: $<same#>)

(0) Share

Report

Posted on by Community Member

Issue validating a Ledger Journal:

The Journal has 1 voucher with about 940 transactions, all in USD. I've gotten some Google results, but nothing to solve my problem. I've tried changing the USD Rounding Rules to 0.01, but it doesn't fix my issue. I've also tried setting the Maximum penny difference to 0.01 and Maximum penny-rounding in the reporting currency to 0.01 without any luck.

Ax2012
6.0.947.280

Thanks,

Joe

*This post is locked for comments

I have the same question (0)

All responses (38)

Answers (0)

Suggested answer

MazS 450 on at

Like (0)

Report

Hi Joe

AX has a habit of giving us errors mentioning currencies which lead people down the path of thinking it is something to do with Exchange Rates when often it isn't - it's simply that the journal doesn't balance.

I suspect you may have different dates on the journal and this will be why, for example if you had a voucher with two lines dated differently but techically balanced by value, you would get the error you have described i.e. 31/01/2012 DR 100.00 & 01/02/2012 CR 100.00

If you need all the transactions to be dated differently, then I would suggest using the Offset Account to balance off each line as a different voucher.

I hope that helps?

Thanks

Maz

Was this reply helpful? Yes No
Suggested answer

Lidia Ruiz 25 on at

Like (0)

Report

Hi Joe,

Maybe your problem can be solved with this post:

blogs.solidq.com/.../Post.aspx

Hope this helps!

Cheers!

Lidia

Was this reply helpful? Yes No
Umesh Raut 40 on at

Like (1)

Report

Hi,

I have faced the same issue in AX 2012. It has been resolved by creating new posting profile.

So i kindly request you to try this.

Account Payable --> Setup --> Account Payable Paramerts

Ledger and sales tax --> Posing Profile.

Cheers

Umesh

Was this reply helpful? Yes No
Andrew Xu 3,877 on at

Like (1)

Report

Thanks Umesh.

I had the same error when I was posting a free text invoice in AX 2012, and the error message is really confusing...

After setting the AR posting profile in parameter settings, it's ok!

Was this reply helpful? Yes No
ahmed abdel monem i... 450 on at

Like (0)

Report

Cannot Post Purchase order (The transactions on voucher do not balance as per date . (accounting currency: xxxx - reporting currency: xxxx)) .

- Uncheck box the post definition for accounting Rules .

GL -> parameter

Was this reply helpful? Yes No
AxConsultant 335 on at

Like (0)

Report

Dear All

I'm facing the same Issue but my transaction is related to INTERCOMPANY, i will explain the case ...

Suppose I have 2 companies one in KSA & other in USA my reporting currecy is SAR...

Now the issue is from USA ... someone transfer the amount through bank from USA company to KSA bank when i passed the entry sytem gave the below error messgae...

The Transaction on Voucher INT000001 do not balance as per DATE (acounting currency ...... & reporting currency 0.00)

Can you please help me about this..

Regards

Was this reply helpful? Yes No
Shehzad Younus 15 on at

Like (0)

Report

Thanks Umesh, Issue resolved.

Was this reply helpful? Yes No
soha mostafa 1,225 on at

Like (0)

Report

I tried all solution in this post but i am still have the same error appear when receive purchase order

the error is the following:

The transactions on voucher do not balance as per XXXXX. (accounting currency: ####- reporting currency: #####)

I am using ax 2012 R2

it's very urgent for me please any one have any idea??

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Two of our customers have had the same problem in AX 2012 regarding posting Project Invoices - one is in a Feature Pack and one in a R2 version - and this was a known bug.

Maybe this is the same thing - then you will need to get a hofix from Microsoft.

I hope Everything gets worked out // Anna

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report

Hi ANNA RAM ,

I am also working on AX 2012 R2 , so Could you share me the link of that hotfix regarding the above error ?

Thanks in advance

Was this reply helpful? Yes No