The transactions on voucher XXXXXXX do not balance as per 2/11/2019. (accounting currency: -4,265.41 - reporting currency: 0.00)

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

We are getting the error as shown in the below screenshot.

8345.error.JPG

Below is the general journal which we are trying to post and for the second line, we have given the sales tax as shown in the below screenshot.

0815.Journal.JPG

line 1 is in SAR (Saudi Riyal)

line 2 is in USD

line 3 is in USD

line 4 is in USD

line 5 is in SAR

Exchange rate is 1 USD = 3.75 SAR

When we click on validate journal, there is no error and system is saying the journal is ok.

But when we try to post the journal, we are getting the issue.

We found the issue in sales tax, If we see the error, the sales tax amount is not converting into SAR from USD as shown in the below screenshot. Remaining all are converting into the SAR if the line is in USD.

8345.error.JPG

The marked line in the above screenshot is the transaction related to sales tax and it is calculated in USD. But when we see the error, the transaction currency amount and accounting currency amount is same.

When we click on sales tax in the ledger journal, the sales tax is calculated fine. Below is the screenshot for reference.

2134.salestax.JPG

The Journal which we are using is having "amount inclusive of tax" setup.

Please let us know what is the issue with this journal.

Thanks in advance.

*This post is locked for comments

All responses (16)

Answers (1)

Syed Tahseen Hussain 30 on at

Like (0)

Report

RE: The transactions on voucher XXXXXXX do not balance as per 2/11/2019. (accounting currency: -4,265.41 - reporting currency: 0.00)

I am having the same problem. The cause is when we applied Sales Tax with "amount inclusive of tax", it is ignoring sales tax amount and throwing the same error. if you figured out what is the fix for this bug please let me know.
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: The transactions on voucher XXXXXXX do not balance as per 2/11/2019. (accounting currency: -4,265.41 - reporting currency: 0.00)

Hello Anudeep,

I cannot tell you exactly because I do not have the exact system that you have and do not know how your tax is setup.

However, posting taxes related to a customer and vendor in a single voucher does not seem something that is useful and I would expect the system not to allow such a posting.

If you generate separate vouchers for the customer and vendor related transactions things might work.

Would be great if you could test this and let us know the outcome.

Many thanks,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: The transactions on voucher XXXXXXX do not balance as per 2/11/2019. (accounting currency: -4,265.41 - reporting currency: 0.00)

Hi Ludwig,

Good Morning! Thanks for trying the issue replication.

Yes we have already did the journal posting without sales tax and it went well without any issues. The problem comes when we give the sales tax.

Please let us know if it is system bug or not. So that we will convince our client to post the journal in two vouchers.

Regards,

Anudeep.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: The transactions on voucher XXXXXXX do not balance as per 2/11/2019. (accounting currency: -4,265.41 - reporting currency: 0.00)

Good Morning Anudeep,

I tried replicating the voucher but because I do not have a company with SAR as the accounting currency, I used a US company with the USD as the accounting currency. As a result, my currencies and lines are basically flipped from yours. Irrespective of that I was able to post the following voucher:

Please note that I did not include sales taxes because I do not know how you setup sales tax exactly but it seems that the journal lines and the way how the posting is made is not the problem, which seems possibly related to the taxes applied.

Can you do the following:

1. Test posting your voucher without sales tax in a demo/test system

2. Try posting it with sales tax in a demon/test system

I think 1.) should work for you but probably not 2.)

Would be great if you could verify that.

Many thanks,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: The transactions on voucher XXXXXXX do not balance as per 2/11/2019. (accounting currency: -4,265.41 - reporting currency: 0.00)

Hi Ludwig,

The exchange rate we are using is 1 USD = 3.75 SAR.

We have given the amounts entered in the system with the currency code. You can enter the amounts same like that.

The Purchase tax percentage we have used is 5 %.

Please check and let us know your result on this.

Please let us know if anything you need from our side.

Regards,

Anudeep.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: The transactions on voucher XXXXXXX do not balance as per 2/11/2019. (accounting currency: -4,265.41 - reporting currency: 0.00)

Hello Anudeep,

At the moment, I cannot replicate the issue because I do not know your exchange rates.

With the amounts entered, I cannot post because DR and CR do not balance...

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: The transactions on voucher XXXXXXX do not balance as per 2/11/2019. (accounting currency: -4,265.41 - reporting currency: 0.00)

Hi Ludwig,

We have some questions related to this issue.

1. Did you tried to replicate the issue from your side?

2. Do we have any update in the AX to resolve this issue?

3. Did you get the same error?

We will let you know in another reply why our client wants to create in single voucher rather than two vouchers.

Regards,

Anudeep.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: The transactions on voucher XXXXXXX do not balance as per 2/11/2019. (accounting currency: -4,265.41 - reporting currency: 0.00)

Hi Anudeep,

Thanks for this update.

The foreign currencies seem to be responsible then for what we see.

But what I still do not understand is why you cannot post line 2 and 3 in one voucher and the other lines in a separate one?

This voucher seems to post on the one hand side a kind of expense with a vendor relationship and a revenue (line 1, 4 and 5) with a customer relationship.

I think it is better separating those vouchers especially if this overcomes the error.

Probably talk to your accounting colleague once again and ask why this transaction has to be poste in a single voucher.

Many thanks and best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: The transactions on voucher XXXXXXX do not balance as per 2/11/2019. (accounting currency: -4,265.41 - reporting currency: 0.00)

Hi Magic,

We have given ledger account for Purchase Accruals as shown in the below screenshot.

We have posting profile defined in the AP parameters as shown below.

Regards,

Anudeep.
guk1964 10,877 on at

Like (0)

Report

RE: The transactions on voucher XXXXXXX do not balance as per 2/11/2019. (accounting currency: -4,265.41 - reporting currency: 0.00)

Check whether you have assigned an account to Purchase Accruals in Inventory & Warehouse > Setup > Posting > Profiles then Purchase Order.

Check posting profile in AP Parameter> Ledger & Sales Tax> Posting > (Posting - Posting Profile) Setup and if necessary Create summary account ,settlement Account,arrival and Offset Account

Check the exchange rates on each of the lines have the same date.