VAT amount missing in TaxTrans table

(0) Share

Report

Posted on by Muthusamy

Hi All,

We are using AX2012 R2 CU7 Version.

VAT accounting system is configured for PO's, Project invoices and finance modules.

We have processed the Sales tax payment process for July month. Its done successfully. After that, we found some balances in VAT Receivables account. Then we have investigated the system.

When we post purchase order invoices, Sales tax account - Debited. I am able to see all voucher records in GeneralJournalAccountEntry table. But there is no record in TaxTrans table.

Sales tax account is posted and Sales tax ledger account value also updated. But didn't see record in Taxtrans table. What will be the problem....

Purchase Order and Invoice journal:

Vouchers:

Thanks,

All responses (9)

Answers (2)

Suggested answer

Muthusamy 4 on at

Like (0)

Report

RE: VAT amount missing in TaxTrans table

Hi Ludwig and Andre,

Yes, I have tried to replicate the issue. But no luck. Since its a time consuming task going without end.

Also, Its affected only for July month transactions. Informed customer that to replicate the issue.

I didn't create the support incident. As you said, MS will ask to replicate the issue in later version. Since we are in Ax2012 R2.

Thanks for the suggestion. I will close this issue here.

Thanks,
Verified answer

André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (1)

Report

RE: VAT amount missing in TaxTrans table

I do agree with Ludwig here. It could be caused by a bug, but then you need to be able to reproduce it. When you will create a support incident, Microsoft will ask you to replicate it in the latest available version on AX 2012 R3 as well.
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: VAT amount missing in TaxTrans table

Hello Muhutsamy,

If you cannot replicate the issue then things might be difficult, as the MS support will certainly ask you how to replicate the issue.

Do you have a developer around who can possibly have a look at those wrong or corrupted transactions?

I think that is the only chance what you have at the moment to identify the root cause of the problem.

Unless you know the underlying issue it does not make much sense to make some changes e.g. in the setup because the issue might arise again.

Best regards,

Ludwig
Muthusamy 4 on at

Like (0)

Report

RE: VAT amount missing in TaxTrans table

Good morning Ludwig,

Yes, I have checked the GL-Sales tax reconciliation report and I can see the difference in report.

Dynamics Version: AX2012 R2 CU7

I have checked the LCS and don't find any hotfixes related to this issue.

We tried to replicate the issue. but no luck. Because, we have posted 100's of invoices during the july month. Only few invoices having this issue.

Thanks,
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: VAT amount missing in TaxTrans table

Good Morning Muthusamy V,

Have you already run the GL-tax reconciliation report?

Do you see also some differences there?

What AX2012 version do you operate? Is this an older one? If so, have you already checked the available hotfixes on LCS?

Another question:

Can you replicate those tax issues in one of your demo systems?

Best regards,

Ludwig
Muthusamy 4 on at

Like (0)

Report

RE: VAT amount missing in TaxTrans table

Hi Andre,

Yes, In the Subledger shows two lines with Sales tax. But there is no data in the sales tax button on that form. Posted sales tax related transaction are stored in TaxTrans table. But record is missing for this voucher.

It'a Project PO, create with few stock items. Items are received through product receipt and invoicing done through Purchase order invoice. PO data's are dine.As usual, entries are there. let me know, If you want to check any details particularly.

I have found that 10 to 15 Purchase order invoices are in the same case. Sales tax ledger account is getting accounted with the posting type of 'Sales tax' and there is no record in taxTrans table. Also, all purchase order invoices are posted on the same day by one of the accounts payable clerk.

We come to know this issue, when doing sales tax payment for the settlement period. Because of this issue, there is some difference occurs in the sales tax ledger account.

Thanks,
André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (0)

Report

RE: VAT amount missing in TaxTrans table

Hi Muthusamy,

The screenshot with the subledger shows two lines with sales tax. There is also a Sales tax button on that form. Have you checked if you can find tax transactions using this button?

Can you also tell some details/procedures how the PO is created, goods are received and how you post the invoice?
Muthusamy 4 on at

Like (0)

Report

RE: VAT amount missing in TaxTrans table

Hi Ludwig,

Screenshot for the posted invoice.

Voucher ScreenShot:

Subledger:

:

Transaction Origin: I don't see sales tax made for subledger voucher..

Thanks,
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: VAT amount missing in TaxTrans table

Hello Muthusamy V,

Can you open the voucher button in your first screenprint for the invoice that you want to analyze?

Once you see the voucher button click the 'transaction origin' button and see if you can see a transaction that is made in the 'tax subledger'.

Would be great if you could share a screenprint of the transaction origin.

Many thanks,

Ludwig