Microsoft Dynamics Axapta Technical,Functional Coverage

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