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

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

I have the same question (0)

All responses (16)

Answers (1)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

What kind of transaction do you try to post here?

You have a customer and a vendor included in a single voucher?

In addition, you post incoming purchase tax.

Do you also post sales tax?

Why don't you create multiple vouchers rather than trying to combine all into one?!

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

We are posting the expense invoices to the vendor and customer.

Yes, we have included the customer and vendor in single voucher.

Yes we are posting the incoming purchase tax .

No we are not posting the sales tax.

Our client wants to post it in single voucher rather than multiple vouchers.

Regards,

Anudeep.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Anudeep,

Can you try separating this transaction into multiple vouchers to check if this issue persists if you use multiple vouchers?

Can you also let us know the exact AX2012 version that you operate?

Many thanks,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

When we use the multiple vouchers, these are posting fine.

The AX version we are using is AX 2012 R3 with CU13 update.

Regards,

Anudeep.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Did you filter out some lines that we cannot see?

I tried replicating your voucher but noticed that the totals of the journal do not match.

Your total debits and credits add up to 238k $.

If I reenter your voucher, debit and credit amounts are different from that amount and do not match.

Where are the other lines that make up the total of 238k $?

How was this journal created?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

We did not hide any lines. Please see below journal lines information for clear understanding.

Regards,

Anudeep.

Was this reply helpful? Yes No
guk1964 10,888 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No