Microsoft Dynamics Ax, Application Integration Framework, X++ programming, AX 2009 , 2012.Ax Rainier or version 7, Enterprise portal, SharePoint , BI Tools, OLAP, Performance Tuning, SSRS,SSIS,SSAS, Workflow.

Wednesday, June 19, 2013

Update Invoice date in salesTable in axapta

If you want to show invoice date in sales order form then you need to add field invoicedate in salestable and update date using following code.

CustInvoiceJour custinvoiceJour1;
SalesTable SalesTable1;
while select forupdate * from SalesTable1 where SalesTable1.InvoiceId=="" && SalesTable1.SalesStatus==SalesStatus::Invoiced
select custInvoiceJour1 order by invoicedate desc where custInvoiceJour1.SalesId == SalesTable1.SalesId && custInvoiceJour1.SalesId != "";