Skip to main content

Posts

Showing posts from March, 2012

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

Generate LotId or inventTransid by code in MSD axapta

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 MSD axapta by code

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

How to install Microsoft dynamics axapta 2009 on windows 7

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.

The reports get build up successfully but not getting deployed in MSD axapta

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 server. If you may not able t

TDS settlement tables and usable fields in MSD axapta

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