You’re offline. This is a read only version of the page.
4,624
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
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.
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
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.
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
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (