Microsoft Dynamics Axapta Technical,Functional Coverage

MS Certification exam for D365 Finance and operations . You can schedule your exam online on below link Exam MB-300: Microsoft Dynamics 365: Core Finance and Operations Other exam as below Exam MB-310: Microsoft Dynamics 365 Finance Exam MB-320: Microsoft Dynamics 365 Supply Chain Management, Manufacturing Exam MB-330: Microsoft Dynamics 365 Supply Chain Management

Below is Code to delete attached document from forms in Axapta. If you want to delete all files from folder then this code sample can help you. Here word document considered as attachment for particular records. COM wordApplication; COM wordDocuments; COM wordDoc; DocuRef docuRef,docuRef2; DocuAction docuAction, createdDocuAction; str document,foldername,filename,fileinfo,newfilename; System.String[] filePath; int fileCount,currentFileCount,len; foldername =@"C:\DocsN\Document_Management\"; filePath =System.IO.Directory::GetFiles(foldername); //get listing of all files within the folder fileCount = filepath.get_Length(); //get how many files were found for(currentFileCount = 0; currentFileCount < fileCount ; ++currentFileCount) { fileinfo = filepath.GetValue(currentFileCount); len = strLen(fileinfo); filename = subStr(fileinfo,47,len); filename = fileinfo

Below is a Code to get current user Employee code in axapta. If employee relation exist for user then this code will work otherwise you need to attach employee for users form then add work using relation button. HcmWorker::find(DirPersonuser::findUserWorkerReference( curUserId())).PersonnelNumber;

Microsoft Dynamics 365 exam You can check below  Microsoft Dynamics 365 exam Certification code and description MB-200 Microsoft Dynamics 365 Customer Engagement Core MB-210 Microsoft Dynamics 365 for Sales MB-220 Microsoft Dynamics 365 for Marketing MB-230 Microsoft Dynamics 365 for Customer Service MB-240 Microsoft Dynamics 365 for Field Service MB-300 Microsoft Dynamics 365 Unified Operations Core MB-310 Microsoft Dynamics 365 for Finance and Operations, Financials MB-320 Microsoft Dynamics 365 for Finance and Operations, Manufacturing MB-330 Microsoft Dynamics 365 for Finance and Operations, Supply Chain Management MB-900 Microsoft Dynamics 365 Fundamentals

If you want to post Project Beginning balance for Estimation posting in Ax 2012 you can do that by using class and run method . What you need to do just you need to find posting class for Posting estimation of created stage records and pass via parameters. You need to review class ProjControlPostingPosted there are method run to post estimation. You can pass parameter then you need to write code to post it. Do not forget to initialize class via below code.  ProjControlPostingPosted1=new ProjControlPostingPosted(); after that you need to initialize query like this.            ProjControlPostingPosted1.initQuery();             ProjControlPostingPosted1.getQueryValues();             ProjControlPostingPosted1.queryRun(); Once you done that then you need to pass parameter simply in parm method and run the class by methods of run code. I hope you get the idea to post project estimation by code. I am not writing here whole code because you need to try your own way to get

Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole

If you are facing database or application performance issue then you can check these tables that may have large number of records. ECORESPRODUCTVARIANTDIMENSIONVALUE INVENTBATCH ECORESPRODUCTMASTERDIMENSIONVALUE ECORESPRODUCTMASTERDIMENSIONVALUE ECORESPRODUCT ECORESPRODUCTTRANSLATION ECORESPRODUCT ECORESPRODUCTVARIANTDIMENSIONVALUE INVENTDIMCOMBINATION ECORESRELEASESESSIONPRODUCT ECORESRELEASEPRODUCTLEGALENTITY INVENTSUMLOGTTS INVENTCOSTLISTPARM GENERALJOURNALACCOUNTENTRY GENERALJOURNALACCOUNTENTRYZAKAT_SA SMMTRANSLOG LEDGERENTRYJOURNALIZING DIMENSIONFOCUSBALANCE MARKUPTRANS INVENTTRANSPOSTING INVENTREPORTDIMHISTORY SALESPARMLINE SOURCEDOCUMENTLINE INVENTTRANS TRANSACTIONLOG INVENTTRANSORIGIN INVENTSETTLEMENT SALESPARMSUBTABLE SALESPARMTABLE SOURCEDOCUMENTHEADER SALESPARMUPDATE SQLSYNCINFO GENERALJOURNALENTRY SUBLEDGERVOUCHERGENERALJOURNALENTRY CUSTSETTLEMENT SMMACTIVITYPARENTLINKTABLE INVENTSUMDATETRANS LEDGERTRANSSTATEMENTTMP DIMENSIONFOCUSLE

Dynamics 365, version 9 Dynamics AX 2009 Dynamics AX 2009 License Dynamics AX 2012 Dynamics AX 2012 License Dynamics AX 2012 R2 Dynamics AX 2012 R3 Dynamics AX 4.0 Dynamics AX 4.0 Service Pack Dynamics Axapta 3.0 Dynamics Axapta 3.0 Service Pack

To find or add range in query method in axapta like if you want to write code in query init method then you can set range at runtime . Below is the sample to check with your code.  this.Query().dataSourceName("InventDim").findRange(fieldNum(InventDim,InventSiteId)).status(RangeStatus::Locked);

You can use below Code to close the form at run time in Axapta. Some time we need to close the form after any action so you can try this code on your applicable event to close the form.  element.close();

If you are getting below error ..on Sales Order Delivery Remainder Error during cancel quantity in Axapta. Error :The quantity cannot be reduced. The number of inventory transactions on order is too low because the quantity or part of it is referenced by an output order or a production order or is marked against other transactions. Then You can try this Steps  on Test application  then You can apply on production . 1- Find the Output order id  on which problem occurred. 2- Then open AOT ->Data Dictionary ->Tables -> WMSOrderTrans (Right click and open ) 3- In orderid field find the same inventory order number by search . 4- delete the record whose Expedition Status is Activated in WMSOrderTrans table. 5- You can then go to again the output order form on Sales Line on Sales Order form , refresh the screen, and select End Inventory order in function menu item form. 6- Then you can  go to the sales order screen and easily cancel the deliver render quantity I hope t

How to get Company address in Dynamics 365 ? You can try below code to check correctness of output. CompanyInfo companyInfo = CompanyInfo::find(); info(strFmt("%1",companyInfo.postalAddress().Address));

This is a sample Code to Convert Inventory to sales unit value for Item in Axapta . You can try this code in job to check the value. Item code you can use from your system data. I hope you will get idea and enjoy daxing. InventTableModule InventTableModule; int64 InvUnit, SalesUnit, EcoresproductRecid; UnitOfMeasureConversion UnitOfMeasureConversion; real d; select InventTableModule where InventTableModule.ItemId == '60068C' && InventTableModule.ModuleType == ModuleInventPurchSales::Invent; InvUnit = UnitOfMeasure::findBySymbol(InventTableModule.UnitId).RecId; SalesUnit = UnitOfMeasure::findBySymbol('BOX4').RecId; EcoresproductRecid = EcoResProduct::findByDisplayProductNumber('60068C').RecId; d = UnitOfMeasureConverter::convert(8.0,InvUnit,SalesUnit,NoYes::No,Ecoresproductrecid); info(strFmt("%1",d));

Problem :I need string-edit lookup display by default the code '00002' and not the '00001.How can i do this using axapta code? Solution  : Instead of asking 00002 as default in the lookup, you can set '00002' as the default value of the field on the form. Otherwise, if you don't like to have '00001' in the lookup then you need to write dynamic lookup on that field.

Upgrade yourself to Dynamics 365...!! Learn the most demanded ERP course by real time with hands on experienced consultants...!!

Following two line code can help you for Batch jobs log cleanup. If you delete from table manually then it will take longer time but by using delete_from command you can do it quickly. Delete cascade will also work using delete_from query. BatchJobHistory BatchJobHistory; delete_from BatchJobHistory ;

This is a sample Example of Code to create Free Text Invoice in Ax 2012. Variables you need to declare to complete code. ttsBegin; select custTable where custTable.AccountNum == '123'; custInvoiceTable.clear(); if (custTable.RecId != 0) { custInvoiceTable.OrderAccount = custTable.AccountNum; custInvoiceTable.modifiedField(fieldNum(CustInvoiceTable, OrderAccount)); custInvoiceTable.InvoiceId ='test04'; custInvoiceTable.insert(); lineNum = 0; } if (custInvoiceTable.RecId != 0) { custInvoiceLine.initFromCustInvoiceTable(custInvoiceTable); // LedgerDimension=Dimensionstorage::accountNum2LedgerDimension("30104000",LedgerJournalACType::Ledger); custInvoiceLine.LedgerDimension = LedgerDimension2;//5637146102; custInvoiceLine.Description = ''; custInvoiceLine.TaxGroup = '';

This Code Sample to Export Assets Master Table Value to CSV in Axapta. You can take many columns and value from table . This is just an example. Query q; QueryBuildDataSource qbds; QueryBuildRange qbr; QueryRun qr; CommaIO commaIO; FileName fileName; InventTable inventTable; AssetTable AssetTable; ; fileName = "C:\\TestSupport\\" + "ItemDetails1" + ".csv"; //Destination of the file commaIO = new CommaIO(fileName,'W'); q = new Query(); qbds = q.addDataSource(tablenum(AssetTable)); qbr = qbds.addRange(fieldnum(AssetTable,Assetid)); //Range qr = new QueryRun(q); commaIO.write("ItemId","Item Type"); //Header of the CSV File //Loop to insert values in the csv from the table while( qr.next() ) { AssetTable = qr.get(tablenum(AssetTable)); commaIO.write(AssetTable.AssetId,enum2str(AssetTable.AssetType)); break; } WINAPI::shellExecute(fileName);

I am sharing here good link which can help you to learn Dynamics 365 technical and functional for Finance and operation. Just visit this link to watch one by one video. Dynamics 365 learning collection   Ax 2012 Tutorial and tips are here Ax 2012 Tutorial and tips

Problem: Error on Event Log for Dynamics 365 database side. Clustered role 'D365AG' has exceeded its failover threshold.  It has exhausted the configured number of failover attempts within the failover period of time allotted to it and will be left in a failed state.  No additional attempts will be made to bring the role online or fail it over to another node in the cluster.  Please check the events associated with the failure.  After the issues causing the failure are resolved the role can be brought online manually or the cluster may attempt to bring it online again after the restart delay period. Solution: Following things you can try. 1. Restart all server and check admin user in tempdb databse right after restart if no permission then attach user to tempdb database. 2.Most of the problem resolve on restart of servers. 3. If still issue not solved then After some research, we traced it to the ‘Maximum failures in the specified period’ setting at the cluster g