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

Code to Convert Inventory to sales unit value for Item in Axapta

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

How to Set default value in Ax form Lookup

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.