Skip to main content

Posts

What are the classes involved in Journal in MSD axapta,

 What are the classes involved in Journal Posting, Sales Order Invoice Posting, Purchase Order Invoice posting, 1) Journal Posting : LedgerJournalCheckPost class ‎2). Sales Order Posting : SalesFormLetter Class and SalesFormLetter_Invoice class 3). Purchase Order Posting : involPurchFormLetter,Purch​FormLetter_PurchOrder,Purc​hFormLetter_Receiptlist,Pu​rchFormLetter_PackingSlip and PurchFormLetter_Invoice classes are involved.

How to return Name of d Day in string in MSD axapta x++ ?

dayofmth is method  to return Day and dayname is method to show name of day in string. strfmt is string method to show any type of  variable in string format. To return Name of d Day in string ( Monday,Tuesday,Wednesday etc​) by passing Date as my parameter Value you can try this method or code in axapta x++. info(strfmt("Name of the Day - %1",dayname(dayOfMth(today​()))));

Concatenate string to query in MSD axapta with external database connection

Concatenate string to query in axapta with external database connection Sql1 = "select * from TestTable WHERE Column1='"; sql1 = sql1 + Column1 + "'"; sql1 = sql1 + " and convert(datetime,DateColumn1) = ' "; sql1 = sql1 + date2str(DateColumn1,321,2,3,2,3,4) + "'" ; sql1 = sql1 + " and status=1 order by Column1,DateColumn1"; command1 = new CCADOCommand(); command1.activeConnection(connection); command1.commandText(sql1); recordSet1 = new CCADORecordSet(); recordSet1 = command1.execute(); Coms1 = recordSet1.recordSet(); while (!recordSet1.EOF()) { fields1 = recordSet1.fields(); info(strfmt("%1",fields1.itemname("Columnname").value())); }        

Set and update value of progress bar by code in MSD axapta x++

Set and update value of progress bar by code in axapta x++ lanugage SysOperationProgress progress1; //Initialize variable progress1= new SysOperationProgress(); // Progress1.setCaption('Progress'); Progress1.setText('Process is in Progress..Please Wait'); Progress1.setTotal(500); //Increment progress value and update to control progressexcel.update(true); Progress1.incCount();