How to calculate CGST, SGST & IGST through X++

There is a method on sales side SalesInvoiceDP.insertIntoGSTTaxAmount_IN, see if you can use the similar logic on purchase side.

Hello Techies,

I want to know how it is calculating item wise CGST & SGST ?
And also getting company GST Number & Vendor GST Number

Kindly share me the lines of code to my mail Id "thirumal.siddhavatam@gmail.com"

Hi thirumal,

  // Company GSTINNumber
   select companyInfo where companyInfo.DataArea == curext()
           join dirpartytable where dirpartytable.PartyNumber == companyInfo.PartyNumber
               join dirPartyLocation where dirPartyLocation.Party == dirpartytable.RecId
                   join logisticsLocation where logisticsLocation.RecId == dirPartyLocation.Location
                      join taxInformation_IN where taxInformation_IN.RegistrationLocation == logisticsLocation.RecId
                                                              && taxInformation_IN.IsPrimary == NoYes::Yes;

  tmp.comapanyGSTINNumber = TaxRegistrationNumbers_IN::find(taxInformation_IN.GSTIN).RegistrationNumber;

 //Vendor GSTINNumber
  select vendtable1 where vendtable1.AccountNum==vendtable.AccountNum
          join dirPartyLocation where dirPartyLocation.Party == vendtable1.Party
              join logisticsLocation where logisticsLocation.RecId == dirPartyLocation.Location
                   join taxInformation_IN where taxInformation_IN.RegistrationLocation == logisticsLocation.RecId
                                                          && taxInformation_IN.IsPrimary == NoYes::Yes;

     tmp.vendorGSTINNumber = TaxRegistrationNumbers_IN::find(taxInformation_IN.GSTIN).RegistrationNumber;

  // CGST , SGST & IGST numbers with rates.
  select firstOnly HSNCode, SAC from taxDocumentRowTransaction_IN
          join RecId, DiscountAmount from taxDocumentRowTransaction
               where taxDocumentRowTransaction.RecId == taxDocumentRowTransaction_IN.TaxDocumentRowTransactionRecId
               && taxDocumentRowTransaction.TransactionHeaderTableId == vendInvoiceinfotable.TableId
               && taxDocumentRowTransaction.TransactionHeaderRecId == vendInvoiceinfotable.RecId
               && taxDocumentRowTransaction.TransactionLineTableId == vendInvoiceinfoline.TableId
               && taxDocumentRowTransaction.TransactionLineRecId == vendInvoiceinfoline.RecId;

      if(taxDocumentRowTransaction.RecId)
     {
           while select taxDocumentComponentTransaction

            where taxDocumentComponentTransaction.TaxDocumentRowTransactionRecId == taxDocumentRowTransaction.RecId
         {
               if(taxDocumentComponentTransaction.TaxCode =="CGST")
               {
                     tmp.CGST_TaxRate = taxDocumentComponentTransaction.TaxRate*100;
                     tmp.CGST = taxDocumentComponentTransaction.TaxAmountCur;
               }
              if(taxDocumentComponentTransaction.TaxCode == "SGST")
              {
                    tmp.SGST_Taxrate = taxDocumentComponentTransaction.TaxRate*100;
                    tmp.SGST = taxDocumentComponentTransaction.TaxAmountCur;
              }
             if(taxDocumentComponentTransaction.TaxCode == "IGST")
             {
                   tmp.IGST_Taxrate = taxDocumentComponentTransaction.TaxRate*100;
                   tmp.IGST = taxDocumentComponentTransaction.TaxAmountCur;
             }
       }
   }

Thanks,
Siva Rama Krishna.

Better and Thanks Once
I want to get the TAX calculation details for the Purchase order after confirmation done and before of Invoicing the same purchase order.

Regards,
G.Rajkumar
gov.rajkumar@gmail.com

Thanks Arun,

I am asking the Tax calculation for Purchase Order not for Sales Order or Purchase Invoice.
But, you have given for Sales Order and I am thinking that you have given for AX 2012. I am requesting for Ax 2009.

Regards,
G.Rajkumar

I have given for both :) For Purchase Order, u replace the sales objects into purchase. and it will work for 2009 also. Regards,
Arun

Arun,

Thats right, u given the code for 2012, because the declarations are assigned in 2012. There is no tables in Ax 2009 as you mentioned. (TmpTaxDocument, ITaxableDocument etc.).

We found for Sales Invoice & also for Purchase Invoice. But for Purchase Order, the tax will not hit the tax tables, and not able to find where the tax are hitting and stored. for Tax Document, the details are arriving.

Regards,
G.Rajkumar

Hi Raj,

Both TmpTaxDocument, ITaxableDocument etc are available in AX2009. I think you must check and confirm whether your AX is up to date with GST Roll up. Please check again.

Arun,

Found them and got the tax details by changing some conditions in PurchTotals Class. According to INDIAN GST, made the changes and the tax details arrived.

Regards,
G.Rajkumar

Hello Raj,
Can you help me for Tax calculation item wise at the time of Purchase Order Confirmation itself?

Dear Arunachalam,

we using ax 2012 r3cu12, in this environment we didn't find[purchtotals1 = purchtotals::construct(purchtable::find('00136646_052'));)Construct method.

will u able to help us to before po invoice process we need to get the item wise gst percentage and value.

Thanks,
Hareesh

use purchTotals = PurchTotals::newPurchTable(purchTable);

for item wise, look into my previous comment.

Revert back if any issues

Guys sorry for the delay. This is used in Ax 2009.


void GSTItem_TaxCalculation()
{
TmpTaxDocument tmpTax;
PurchCalcTax PurchCalcTax;
SalesTotals salesTotals;
PurchTotals purchTotals;
ITaxableDocument taxableDocument;
ITaxDocumentComponentLineEnumerator lineEnumerator;
ITaxDocument taxDocumentObject;
real taxTotalGTE,taxtotal,SGST,CGST,IGST;
ITaxDocumentMeasure taxMeasure;
ITaxDocumentMeasureEnumerator taxMeasureEnumerator;
ITaxDocumentMeasureValue partyTaxMeasureValue;
int j,Line_loop;
;

// SGST_Value = 0; CGST_Value = 0; IGST_Value = 0;
purchTotals = PurchTotals::POconstruct(PurchTable::find(vendPurchOrderJour.PurchId));
taxableDocument = TaxableDocumentObject::construct(purchTotals.parmTaxableDocumentDescriptor());
taxDocumentObject = TaxBusinessService::calculateTax(taxableDocument);

if (taxDocumentObject)
{
taxTotalGTE = taxDocumentObject.getTotalTax().amountTransactionCurrency();

// Calculation of Tax amount for Tax type GST and Tax component SGST
Line_Loop = 0;
lineEnumerator = taxDocumentObject.componentLines("GST","SGST");
while (lineEnumerator.moveNext())
{
Line_Loop++;
taxMeasureEnumerator = lineEnumerator.current().measures();
while (taxMeasureEnumerator.moveNext())
{
j++;
if (j == 3)
{
partyTaxMeasureValue = taxMeasureEnumerator.current().value();
SGST_Arr[Line_Loop] = partyTaxMeasureValue.amountTransactionCurrency();
j=0;
break;
}
}
}

// Calculation of Tax amount for Tax type GST and Tax component CGST
Line_Loop = 0;
lineEnumerator = taxDocumentObject.componentLines("GST","CGST");
while (lineEnumerator.moveNext())
{
Line_Loop++;
taxMeasureEnumerator = lineEnumerator.current().measures();
while (taxMeasureEnumerator.moveNext())
{
j++;
if (j == 3)
{
partyTaxMeasureValue = taxMeasureEnumerator.current().value();
CGST_Arr[Line_Loop] = partyTaxMeasureValue.amountTransactionCurrency();
j=0;
break;
}
}
}

// Calculation of Tax amount for Tax type GST and Tax component IGST
Line_Loop = 0;
lineEnumerator = taxDocumentObject.componentLines("GST","IGST");
while (lineEnumerator.moveNext())
{
Line_Loop++;
taxMeasureEnumerator = lineEnumerator.current().measures();
while (taxMeasureEnumerator.moveNext())
{
j++;
if (j == 3)
{
partyTaxMeasureValue = taxMeasureEnumerator.current().value();
IGST_Arr[Line_Loop] = partyTaxMeasureValue.amountTransactionCurrency();
j=0;
break;
}
}
}
}
}
Array has to be declare in the classdeclaration itself.

You have to create the below method in the PurchTotals class.

static PurchTotals POconstruct(Common _purchTable,
PurchUpdate _specQty = PurchUpdate::All,
AccountOrder _sumBy = AccountOrder::None,
ParmId _parmId = '',
PurchId _sumPurchId = '',
DocumentStatus _documentStatus = DocumentStatus::None)
{
PurchTable purchTable;
;
if (_purchTable.TableId)
{
if (_purchTable.TableId == tablenum(PurchParmTable))
{
purchTable = _purchTable.purchTable();
}
else
{
purchTable = _purchTable;
}
if (_parmId == '')
return new PurchTotals_Trans(_purchTable, _specQty);
}
Else
{
return null;
}
}