-
Based On PurchId show HSN,SAC,GST,TAX number  ,Base Amount ,Tax Amnt,and Total

static void Job19(Args _args)
{
    PurchTable                          purchTable;
    VendTable                           vendTable;
    TaxDocumentComponentTransaction     taxDocumentComponentTransaction;
    TaxDocumentRowTransaction_IN        taxDocumentRowTransaction_IN;
    TaxDocumentRowTransaction           taxDocumentRowTransaction;
    VendInvoiceInfoLine                 vendInvoiceInfoLine;
    VendInvoiceInfoTable                vendinvoiceInfoTable;
    DirPartyTable                       dirPartyTable;
    DirPartyLocation                    dirPartyLocation;
    LogisticsLocation                   logisticsLocation;
    TaxInformation_IN                   taxInformation_IN;

    DLS_Test_VendorGSTInfo           DLS_Test;


      delete_from DLS_Test;
  while  select  HSNCode ,SAC from taxDocumentRowTransaction_IN
            join RecId, DiscountAmount from taxDocumentRowTransaction
            join  vendinvoiceInfoTable
            join vendTable where
            vendinvoiceInfoTable.OrderAccount == vendTable.AccountNum
            && taxDocumentRowTransaction.RecId == taxDocumentRowTransaction_IN.TaxDocumentRowTransactionRecId
            && vendinvoiceInfoTable.RecId == taxDocumentRowTransaction.TransactionHeaderRecId

              join dirPartyLocation where dirPartyLocation.Party  == vendtable.Party
                join logisticsLocation where logisticsLocation.RecId == dirPartyLocation.Location
                 join taxInformation_IN where taxInformation_IN.RegistrationLocation == logisticsLocation.RecId
                                           && taxInformation_IN.IsPrimary == NoYes::Yes

        if(taxDocumentRowTransaction.RecId )
         {
            while select *from taxDocumentComponentTransaction
                where taxDocumentRowTransaction.RecId == taxDocumentComponentTransaction.TaxDocumentRowTransactionRecId

               {
                  DLS_Test.OrderAccount = vendinvoiceInfoTable.OrderAccount;
                  DLS_Test.PurchName   = vendinvoiceInfoTable.PurchName;
                  DLS_Test.PurchId     = vendinvoiceInfoTable.PurchId;
                  DLS_Test.RegistrationNumber = TaxRegistrationNumbers_IN::find(taxInformation_IN.GSTIN).RegistrationNumber;

                  DLS_Test.HSNCode     = taxDocumentRowTransaction_IN.HSNCode;
                  DLS_Test.SAC         = taxDocumentRowTransaction_IN.SAC;
                if(taxDocumentComponentTransaction.TaxCode == "CGST")
                {
                    DLS_Test.TaxBaseAmount = taxDocumentComponentTransaction.TaxBaseAmount;
                    DLS_Test.CGST          = taxDocumentComponentTransaction.TaxAmountCur;
                }
                    else if(taxDocumentComponentTransaction.TaxCode == "SGST")
                {
                     DLS_Test.SGST       =  taxDocumentComponentTransaction.TaxAmountCur;
                }
                    else if(taxDocumentComponentTransaction.TaxCode == "IGST")
                {
                    DLS_Test.TaxBaseAmount = taxDocumentComponentTransaction.TaxBaseAmount;

                     DLS_Test.IGST       = taxDocumentComponentTransaction.TaxAmountCur;
                }
              DLS_Test.Total = DLS_Test.TaxBaseAmount + DLS_Test.CGST+DLS_Test.SGST+DLS_Test.IGST;
              DLS_Test.insert();
              DLS_Test.clear();

            }
     }
    info('Insert Record');
}


Note : The result will come based on line Level  ...so after this we should write anotther job group by 

Comments

Post a Comment

Popular posts from this blog

-
Image
Contract Class: Microsoft Dynamics AX 2012 introduces the concept of attributes. Attributes provide a way to specify metadata about classes and methods. Two of these attributes are used when creating data contracts: the DataContractAttribute and DataMemberAttribute attributes.  The DataContractAttribute attribute is used to define that a class is a data contract.  The DataMemberAttribute attribute is added to methods of data contracts that represent data members that have to be exposed. Contracts are used to define what can be communicated. A data contract are used for defining parameters to the SSRS report. We can define any number of parameters using X++ statements of any data type, which can be passed on to the RDP class. A data contract class is an X++ class which contains parm methods with the DataMemberAttribute defined at the beginning of the method. RDP Class: The RDP class is a data provider that allows you to add business logic for the data that is di...
Read more
-
How to get Company information and tax information using X++ code in Ax 2012 http://axatulblogs.blogspot.com/2017/09/get-vendors-gst-number-in-ax-2012-r3.html http://axgenius.blogspot.com/2016/08/how-to-get-company-information-using-x.html https://dhruvrthakar.blogspot.com/2017/07/get-vendor-gstin-from-purchase-order-in.html
Read more
-
Image
Insert Data into Custom Table  (Based On Given Condition Like itemNumber,WareHouse,LocationId,Site ):  static void ProjectManagment1016(Args _args) {     ItemId                          itemid;     InventTable                     inventTable;     InventTrans                     inventtrans;     InventSum                       inventSum;     InventDim                       inventDim;     EcoResProductTranslation        ecoResProductTranslation;     EcoResProduct                   ecoResProduct;     DLSProjectmanagment1016 ...
Read more