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 != "";
ttsbegin;
SalesTable1.InvoiceDate=custInvoiceJour1.InvoiceDate;
SalesTable1.update();
ttscommit;

}
 

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Popular Posts

Active Search Results Technology Blogs