web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Tables called when Sales order is confirmed to Get GST Tax details

(0) ShareShare
ReportReport
Posted on by 325

Hi Everyone,

I am developing a Sales Confirmation report for Indian localization. I want to know which tables are called  to store GST tax details in AX 2012 R3

*This post is locked for comments

I have the same question (0)
  • Ravikumar Profile Picture
    325 on at

    Hi Crispin, thank your for your reply.  

    I referred SalesConfirmDP class, the code you mentioned is in "else" clause, In many scenarios  execution is not entering the "else" clause it is entering "if" clause. Here I didnt find Taxspec class, so I am bit confused how the tax has been calculated.

    if(_confirmTransOrTaxTrans == NoYes::Yes)

       {

           if (printLineHeader)

           {

               salesConfirmTmp.LineHeader          = custConfirmTrans.LineHeader;

           }

           else

           {

               salesConfirmTmp.LineHeader          = '';

           }

           salesConfirmTmp.ItemId                  = this.itemId();

           salesConfirmTmp.Name                    = custConfirmTrans.Name;

           salesConfirmTmp.Qty                     = custConfirmTrans.Qty;

           salesConfirmTmp.SalesUnitTxt            = custConfirmTrans.salesUnitTxt();

           salesConfirmTmp.SalesPrice              = custConfirmTrans.SalesPrice;

           salesConfirmTmp.DlvDate                 = custConfirmTrans.DlvDate;

           salesConfirmTmp.DiscPercent             = custConfirmTrans.DiscPercent;

           salesConfirmTmp.DiscAmount              = custConfirmTrans.DiscAmount;

           salesConfirmTmp.LineAmount              = custConfirmTrans.LineAmount;

           salesConfirmTmp.CurrencyCode            = custConfirmJour.CurrencyCode;

           salesConfirmTmp.PrintCode               = custConfirmTrans.TaxWriteCode;

           if (pdsCWEnabled)

           {

               salesConfirmTmp.PdsCWUnitId         = custConfirmTrans.pdsCWUnitId();

               salesConfirmTmp.PdsCWQty            = custConfirmTrans.PdsCWQty;

           }

           salesConfirmTmp.ExternalItemId          = FormLetter::journalExternalItemId(ModuleInventPurchSales::Sales, custConfirmTrans.ExternalItemId);

           if ((custFormletterDocument.DocuOnConfirm == DocuOnFormular::Line)

            || (custFormletterDocument.DocuOnConfirm == DocuOnFormular::All))

           {

               docuRefSearch = DocuRefSearch::newTypeIdAndRestriction(custConfirmTrans,

                                                                      custFormletterDocument.DocuTypeConfirm,

                                                                      DocuRestriction::External);

               salesConfirmTmp.Notes               = Docu::concatDocuRefNotes(docuRefSearch);

           }

           salesConfirmTmp.InventDimPrint          = this.printDimHistory();

           if (inventDim)

           {

               salesConfirmTmp.InventDimProduct    = FormLetter::inventDimReport(inventDim, inventDimProductSetup, custConfirmJour.LanguageId);

           }

       }

       else

       {

           salesConfirmTmp.PrintCode               = taxSpec.taxWriteCode();

           salesConfirmTmp.TaxCode                 = taxSpec.taxCode();

  • Verified answer
    Vilmos Kintera Profile Picture
    46,149 on at

    Microsoft has released a lot of materials and examples related to Indian taxation:

    mbs.microsoft.com/.../GST-India

    I assume you have the same installed, for which you are trying to add your own design of sales confirmation.

    The best starting point would be to read the published documentation.

    The next step would be to have a look at the model content in AX for the patch, which probably has some country-specific tables for taxation which might be relevant for your development, other than the standard tables.

    Finally, override the insert/aosValidateWrite methods on the Tax* tables, place a breakpoint on them using the Visual Studio debugger (to be able to see server-side code execution), do some postings and you will see what populates the tables and can identify where else is it writing data. Altneratively you could use the SQL Server Profiler to capture it from the database end to see which tables have insert/update operations during the posting.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans