-

How to update funding Source for Project Contract in Ax 2012

If you want to  update funding Source for Project Contract in Ax 2012 by code then you can get idea from below code.  These all standard table.

 ProjFundingSource      projFundingSource;  
   ProjInvoiceTable      projInvoiceTable;  
   LogisticsLocation      logisticsLocation,logisticsLocationNew;  
   ;  
   ttsBegin;  
   while select projInvoiceTable order by ProjInvoiceProjId desc  
   {  
     if(projInvoiceTable.ProjInvoiceProjId != "ProjID")  
     {  
       if(projInvoiceTable.fundingSourceName() != "")  
       {  
         while select forUpdate projFundingSource where projFundingSource.ContractId == projInvoiceTable.ProjInvoiceProjId  
         {  
           projFundingSource.FundingSourceId = projInvoiceTable.fundingSourceName();  
           projFundingSource.InvoiceLocation = 0;  
           projFundingSource.update();  
         }  
       }  
     }  
     else  
       break;  
   }  
   ttsCommit;

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