Inconsistencies between sales tax transactions and voucher transactions are generated when you create invoices that contains sales taxes in Microsoft Dynamics AX 2012 R3

(0) Share

Report

Posted on by udaY-ch

5,082

Hi,

We are using ax 2012 R3 CU11, and facing an issue pertains to the difference between the sales tax transaction and voucher transactions. Has anyone faced the same ? The difference amount is 0.20 but the voucher transaction has the big difference and checked the table data and it seems to be correct and couldn't able to identify the big difference between the voucher and sales tax transactions. Also, not able to relate the tax transactions created for the voucher and original transaction.

Appreciate your help solving the issue.

Best

Uday.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

udaY-ch 5,082 on at

Like (1)

Report

RE: Inconsistencies between sales tax transactions and voucher transactions are generated when you create invoices that contains sales taxes in Microsoft Dynamics AX 2012 R3

Thanks for the response Ludwig and Crispin.

Sales tax setup are correct and I'm not seeing any difference if I run the report several times even after days.

I was able to see the difference when I'm comparing the transactions with vouchers and taxtrans. Also, I had found something that the differences are shown in the report if we hadn't ran the sales tax payment job. The differences aren't displayed when the sales tax payment job had been executed. That makes my job difficult to find the transaction which causes the error.

Best,

Uday.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Inconsistencies between sales tax transactions and voucher transactions are generated when you create invoices that contains sales taxes in Microsoft Dynamics AX 2012 R3

Hi,

Can you check the vouchers that cause that difference at least exemplarily?

Does this difference that you see remain stable or does it change e.g. if you run the report the next day?

If it changes then you might have a problem with your sales tax setup and/or the way how taxes are recorded.

Best regards,

Ludwig

Was this reply helpful? Yes No
udaY-ch 5,082 on at

Like (0)

Report

RE: Inconsistencies between sales tax transactions and voucher transactions are generated when you create invoices that contains sales taxes in Microsoft Dynamics AX 2012 R3

Hi Andre and Ludwing,

Sales tax report shows the difference as below when we ran for the specific tax account,

Tax trans for the voucher holds the same data as the report and general journal has the same balance. Both the tables holds the same data as we see in the report.

Having 10,000+ records in tax trans for the voucher. We are generating the report for the upcoming month before running the sales tax payment job to identify is there any difference for upcoming month as well for the same tax account.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Inconsistencies between sales tax transactions and voucher transactions are generated when you create invoices that contains sales taxes in Microsoft Dynamics AX 2012 R3

Hi,

Can you share the voucher that shows the 2500 ledger balance and the 2000 sales tax balance?

When doing that I would be interested in what you see in the transaction origin tab that is related to the voucher?

Have you already run the sales tax reconciliation reports? Especially the sales tax by ledger account report?

Best regards,

Ludwig

Was this reply helpful? Yes No
udaY-ch 5,082 on at

Like (0)

Report

RE: Inconsistencies between sales tax transactions and voucher transactions are generated when you create invoices that contains sales taxes in Microsoft Dynamics AX 2012 R3

HI Andre,

Thanks for your reply.

When running the sales tax report for certain period say for example, month of august. Sales tax report shows the list transaction with differences for the transaction created in the month of august. After running the sales tax payment periodic activity, I got a voucher transaction for the sales tax main account.

Period - 8/1/2018,,8/31/2018

Sales tax account -1001

Sales tax for the month of august - 2000 (purchase invoices)

Voucher has been created for the account for august as 2000 and also transactions created (TaxTrans) by running the sales tax payment job.

When I run the report (Sales tax report) for the month of august with selected account as 1001.

I can see, all the transactions and also the new voucher being created after running the sales tax payment job.

I'm finding the difference between the sales tax balance and ledger balance in the voucher record which created by the sales tax payment jobs.

Sales tax balance as 2500 ledger balance as 2000 Difference 500.

while debugging, ledger balance(2000) and tax balance(2500).Actual sales tax transaction is 2000 but for the voucher transaction, sales tax transactions are created for 2500. I couldn't find the relation between the actual sales tax transaction and voucher sales tax transaction.

Was this reply helpful? Yes No
André Arnaud de Cal... 297,200 Super User 2025 Season 2 on at

Like (0)

Report

RE: Inconsistencies between sales tax transactions and voucher transactions are generated when you create invoices that contains sales taxes in Microsoft Dynamics AX 2012 R3

Hi Uday,

It would help for our understanding if you provide information what you are doing here. What type of posting are you creating? What steps are you doing which could reproduce this issue? Possibly also provide some screenshots.

Was this reply helpful? Yes No