Microsoft Dynamics Axapta Technical,Functional Coverage

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 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();

Generate new voucher by code NumberSeq _numberSeq; LedgerJournalTrans_LedgerJournalTrans; ; _NumberSeq=NumberSeq::newGetVoucherFromCode(LedgerJournalName::find( _LedgerJournalTable.JournalName).VoucherSeries); _LedgerJournalTrans.Voucher=_NumberSeq.voucher();

Some times we need to generate lot Id by code in axapta 4.0 or 2009. following are code you can set in your program too. NumberSeq _numberSeq; salesline salesline; ; _numberSeq=NumberSeq::newGetNumFromCode(NumberSequenceReference::find(TypeId2ExtendedTypeId(typeid(InventTransId))).NumberSequence); salesline.InventTransId=_numberSeq.num(); Just you need to pass Extended data type InventTransId to given function I hope this method or code will help you.

How to generate sales Order number in axapta by code NumberSeq           num;  SalesTable salesTable; ; num = NumberSeq::newGetNum(SalesParameters::numRefSalesId()); salesTable.SalesId = num.num();  if (salesTable::exist(salesTable.SalesId))    {           num.abort();          checkFailed("@LIQ1977");           checkFailed(strfmt("@LIQ1978", salesTable.SalesId));           throw error("@SYS23020");         }                            num.used();

So, many of us use VPC for AX demo and exploration because it has all the required components already in place. But it requires you to have enough memory to run your host OS and VPC at the same time, it also slows down your system. If you don’t have enough free memory then it will even refuse to load. This article is for those who want to install AX on their laptop, so that they don’t have to wait for VPC to start (or wake up from hibernation) and at the same time want to maintain the system performance at its best. Follow the steps given in the link below:- http://daynamicsaxaptaforum.blogspot.in/2012/02/how-to-install-microsoft-dynamics-ax.html and AX will be installed on your local system.

Error description: having an AOS server and a Database server. SQL reporting service have been configured and working fine. I've created a new Dynamics ax reporting project on AOS server.the reports get build up successfully bot not getting deployed. An error may occurred :   Error 32 Deployment failed unexpectedly with the message:  The following components have not been installed or are not configured correctly: Reporting Extensions  Please consult your administrator or the documentation.  See the log file for further details. C:\Program Files\MSBuild\Microsoft\DynamicsTools\Microsoft.Dynamics.Fra​mework.Design.Reporting.Modeli​ng.targets 374 8 Solution: Then login to aos server. Open Internet explorer. browse the report server and manager url. If you can see the dynamics ax folder just try to get inside the folder and browse a single report manually. If you may able to browse then there is no issue exit. Just restart the IIS on reporting serv...

TDS settlement tables in axapta If you are looking for tables used for tds tax in axapta then I am mentioning here some tables which you can fire query from backend or sql to make correction for tds settlement. 1.TAXWITHHOLDTRANS_IN 2.TAXWITHHOLDSETTLETRANS_IN Fields name  which usable to settlement of tds manually. 1.voucher 2. ORIGVOUCHER 3.TRANSDATE 4. DATAAREAID 5.TAXREPCOUNTER 6. TAXWITHHOLDGROUP 7.SETTLED