MB-300 Microsoft Dynamics 365: Core Finance and Operations | MS Certification exam online visit link for more details

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



Exam MB-300: Microsoft Dynamics 365: Core Finance and Operations

Code to delete attached document from forms in Axapta

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;  
       // Create instance of Word application  
       wordApplication = new COM("Word.Application");  
       // Get documents property  
       wordDocuments = wordApplication.Documents();  
       WinApi::Deletefile(filename);  
 }  

Code to get current user Employee code in axapta

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;

Find New Microsoft Dynamics 365 Certification Exam

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


Code help to Create and post Project Beginning balance for Estimation posting in Ax 2012 | post project estimate

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 final solution. I have provided only hints.

Code to get customer Primary Address in Ax 2012

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_P.LocationRole  
            // &&   logisticsLocationRole.Type == LogisticsLocationRoleType::Delivery/* YOUR ROLE - LogisticsLocationRoleType::Delivery*/  
       join logisticsLocation_P  
           where  logisticsLocation_P.RecId == dirPartyLocation_P.Location  
         join logisticsPostalAddress_P  
             where  logisticsPostalAddress_P.Location == logisticsLocation_P.RecId  
   {  
     info(strFmt("%1", logisticsPostalAddress_P.Address));  
   }  

Table lists which can have large number of records in Ax 2012

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
DIMENSIONFOCUSLEDGERDIMENSIONREFERENCE
SALESQUOTATIONPARMLINE
SALESLINE
INVENTTRANSORIGINSALESLINE
DIMENSIONFOCUSUNPROCESSEDTRANSACTIONS
CUSTCONFIRMTRANS
CUSTPACKINGSLIPTRANS
CUSTINVOICETRANS
DIMENSIONATTRIBUTELEVELVALUE
INVENTJOURNALTRANS
CUSTINVOICEPACKINGSLIPQUANTITYMATCH
CUSTTRANS
CUSTTRANSIDREF
SALESTABLE
WMSBILLOFLADINGCARRIER
INVENTTRANSORIGINJOURNALTRANS
SALESQUOTATIONPARMSUBTABLE
SALESQUOTATIONPARMTABLE
CUSTPACKINGSLIPVERSION
SALESPARMSUBLINE
CUSTPACKINGSLIPJOUR
CUSTPACKINGSLIPSALESLINK
CUSTCONFIRMJOUR
CUSTCONFIRMSALESLINK
CUSTINVOICEJOUR
CUSTINVOICESALESLINK
SALESSHIPPINGSTAT
WMSBILLOFLADING
INVENTSUM
WMSBILLOFLADINGORDER
LEDGERJOURNALTRANS
BATCHHISTORY
SALESQUOTATIONPARMUPDATE
SQLDICTIONARY
CUSTQUOTATIONTRANS
SALESQUOTATIONLINE
BATCHJOBHISTORY
CUSTACCOUNTSTATEMENTEXTTMP
DIMENSIONATTRIBUTEVALUEGROUPCOMBINATION
INVENTTRANSORIGINTRANSFER
SALESQUOTATIONTABLE
CUSTQUOTATIONCONFIRMTRANS
SMMOPPORTUNITYTABLE
SMMACTIVITIES
ECORESRELEASEPRODUCTLEGALENTITYLOG
SUBLEDGERJOURNALACCOUNTENTRYDISTRIBUTION
INVENTTRANSFERPARMLINE
CUSTQUOTATIONJOUR
CUSTQUOTATIONSALESLINK
DIMENSIONATTRIBUTEVALUEGROUP
DIMENSIONATTRIBUTEVALUECOMBINATION
INVENTJOURNALTABLE
SRSREPORTQUERY
LEDGERTRANSACTIONLISTTMP
INVENTTRANSFERJOURLINE
INVENTDIM
LEDGERENTRYJOURNAL
CUSTQUOTATIONCONFIRMJOUR
CUSTQUOTATIONCONFIRMSALESLINK
XREFTABLERELATION
EVENTINBOXDATA
EVENTINBOX
ACCOUNTINGDISTRIBUTION
DOCUREF
SYSEXCEPTIONTABLE
DOCUVALUE
INVENTTABLEMODULE
INVENTTRANSORIGINSALESQUOTATIONLINE
PRINTJOBHEADER
LEDGERJOURNALTRANSZAKAT_SA
INVENTTRANSFERLINE
INVENTTRANSORIGINTRANSFERRECEIVE
INVENTTRANSORIGINTRANSFERSHIP
INVENTTRANSORIGINTRANSFERTRANSITFROM
INVENTTRANSORIGINTRANSFERTRANSITTO
WORKCALENDARDATELINE
ASSETTRANS
SYSUSERLOG
LEDGERJOURNALTRANS_ASSET
WORKCALENDARDATE
P_PAYROLLPERIODICTRANS
LOGISTICSADDRESSCOUNTRYREGIONTRANSLATION
DMFINVENTJOURNALENTITY
INVENTCOUNTJOUR
INVENTTRANSFERPARMUPDATE
INVENTTRANSFERPARMTABLE
BANKACCOUNTTRANS
AIFDOCUMENTFIELD
SYSTRACETABLESQL
INVENTCOSTLIST
INVENTTRANSFERJOUR
CUSTPACKINGSLIPBACKORDERLINEHISTORY
SYSLASTVALUE
CUSTPACKINGSLIPBACKORDERLINE
DMFSALESLINEENTITY
INVENTTRANSORIGINJOURNALTRANSRECEIPT
PURCHLINEHISTORY
INVENTITEMINVENTSETUP
INVENTITEMPURCHSETUP
INVENTITEMSALESSETUP
INVENTITEMLOCATION
INVENTITEMSETUPSUPPLYTYPE
INVENTTABLE
ECORESSTORAGEDIMENSIONGROUPITEM
ECORESTRACKINGDIMENSIONGROUPITEM
INVENTMODELGROUPITEM
INVENTITEMGROUPITEM
ITEMCOST
DMFSTAGINGEXECUTIONERRORS
ITEMCOSTHISTORY
ECORESSIZE
DMFECORESSIZEENTITY
PURCHPARMLINE
PURCHPARMLINE_ASSET
DIMENSIONATTRIBUTEVALUEGROUPSTATUS
CUSTPACKINGSLIPTRANSHISTORY
INVENTITEMPRICE
DIMENSIONATTRIBUTEVALUECOMBINATIONSTATUS
UNITOFMEASURECONVERSION
SYSEXPIMPTABLE
DMFSALESTABLEENTITY
LEDGERTRIALBALANCETMP
P_EMPLDEDUCTIONTRANS
INVENTTRANSFERTABLE
DMFPRODUCTENTITY
DMFUNITOFMEASURECONVERSIONENTITY
XREFPATHS
SALESJOURNALAUTOSUMMARY
ACCOUNTINGEVENT
DMFLEDGERJOURNALENTITY
P_EOSPROVISIONPERIODLINES
XREFREFERENCES
SUBLEDGERJOURNALACCOUNTENTRY
DIRORGPERSONRELATIONS
INVENTITEMLOCATIONCOUNTINGSTATUS
P_LOANSDETAILS
DIMENSIONATTRIBUTEVALUESETITEM
PURCHLINE
ECORESPRODUCTMASTERDIMENSIONVALUE
ECORESPRODUCTIDENTIFIER
ECORESPRODUCTDIMENSIONGROUPPRODUCT
ECORESPRODUCTMASTERMODELINGPOLICY
ECORESPRODUCTMASTERDIMENSIONVALUE
ECORESPRODUCTMASTERDIMENSIONVALUE
VENDPACKINGSLIPTRANS
VENDPACKINGSLIPTRANS_INTRASTAT
P_VACATIONTRANS
INVENTTRANSORIGINPURCHLINE
LEDGERJOURNALTABLE
P_PAYROLLPERIODICHEADER
DMFTARGETXMLTOENTITYMAP
PDSVENDBATCHINFO
ECORESSTORAGEDIMENSIONGROUPPRODUCT
ECORESTRACKINGDIMENSIONGROUPPRODUCT
SOURCEDOCUMENTLINERELIEVINGAMOUNT
SOURCEDOCUMENTLINERELIEVING
VENDINVOICEPACKINGSLIPQUANTITYMATCH
VENDINVOICETRANS
INVENTITEMGROUPFORM
VENDSETTLEMENT
P_PAYROLLPERIODICPERIODSLICES
P_PAYROLLPERIODPAYMENTS
ITEMS_MISSED
TEMPINVENTTABLE
VENDINVOICEINFOLINE
VENDINVOICEINFOLINE_ASSET
VENDINVOICEMATCHINGLINE
VENDINVOICEINFOSUBLINE
P_PAYROLLPERIODPAYMENTSLINES
NUMBERSEQUENCEHISTORY
IMPORTITEMPRICES
DMFTARGETXML
VENDTRANS
DIMENSIONATTRIBUTEVALUE
CUSTTRANSOPEN
SRSREPORTPREPROCESSEDDETAILS
CUSTAGINGLINE
SALESSHIPPINGSTATHISTORY
ASSETTABLE
LOGISTICSELECTRONICADDRESS
PURCHPARMUPDATE
ASSETBOOK
ASSETBOOKMERGE
NUMBERSEQUENCETABLE
LEDGERPERIODMODULEACCESSCONTROL
PURCHPARMTABLE
PURCHPARMSUBTABLE
XREFNAMES
DIRPARTYRELATIONSHIP
INVENTCOSTBUNDLELIST
SRSTMPDATASTORE
LOGISTICSLOCATION
INVENTCLOSING
DIRPARTYLOCATION
LOGISTICSLOCATIONROLETRANSLATION
SUBLEDGERJOURNALENTRY
SYSUTILELEMENTSLOG
DIRPARTYTABLE
SYSTRACETABLESQLTABREF
P_EMPLALLOWANCETRANS
NUMBERSEQUENCEREFERENCE
VENDPURCHORDERJOUR
CUSTTABLE
DIMENSIONATTRIBUTEVALUESET
PURCHTABLEVERSION
LOGISTICSPOSTALADDRESS
SYSIMAGETABLE
SYSLABELLOG
DIRORGANIZATIONNAME
PURCHTABLEHISTORY
DIRPARTYLOCATIONROLE
DIRPARTYTABLE
JOURNALERROR
RETAILCUSTTABLE
SYSTEMSEQUENCES

Microsoft Dynamics Axapta version list

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

How to find range in query method in axapta

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

Code to close the form at run time in Axapta

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

Sales Order Delivery Remainder Error during cancel quantity in Axapta,The quantity cannot be reduced. The


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.

Ax error


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 this time it will work.

I hope you problem will resolve after all those steps then happy daxing.

How to get Company address in Dynamics 365

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