Dynamics Community Forum Thread Details

AX 2012 India GST

Hello Experts,

Request you to please help for below issue related to India GST in AX2012.

In AX 2012, we need to set the tax rate based on slabs eg. 0 - 2500 = 5% and 2500 and above = 18%. In current AX Tax rate setup, in AX2012 Net amount column is not available to select the amounts. Version 179 in AX.

So I Create in D365 Electronic reporting > Tax configurations for Tax (India GST) i created a clone named "'GST India updated' and in designer added for (CGST, SGST, ISGT) Rate > Lookup > Column > Added Net Amount from line to column. Saved the designer and set status to completed. I have exported all 4 configurations. (Version 82.155.301)

These 4 exported xml files have loaded in AX. These are loaded successfully and 'GST India updated' showing in AX configurations.

But when I am synchronise the 'GST India updated' in AX it is giving below error:

"Exception has been thrown by the target of an invocation.

Generation failed:Data access error:Cannot insert duplicate key row in object 'dbo.TAXRUNTIMELOOKUPMEASURERESULT' with unique index 'I_104867KEY'. The duplicate key value is (5637144576, 5637366634, 104845, 5637145365).

The statement has been terminated."

Could you please suggest Am i following the correct steps or not and the solution to this issue.

Categories:

Microsoft Dynamics AX

Hi @Ankit Life,

Since the version 82.155.301 was brought by Microsoft for D365FO, it should not be used for AX2012, as in AX2012 maximum version was around 64. As you mentioned Version 179 in AX, it actually referring to version "Tax (India GST) V51.97.179", so you should use this version and do the extension, they try that file by importing back to AX2012 instead of higher versions..

Because with each version, MS also change the table and fields in the backend.. so it will not match with ER configurations if you try to use D365 related versions into AX2012.

I am sharing the AX2012 files as attachment.. if you need any assistance in extending the same, you can let me know. i can try to extend it for Net selling price based tax rate. You need to extend the taxable document (India) and Tax (India GST) files similar to that you have one for latest versions.

If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified

Regards,

Neeraj Kumar

Quick Links