Dynamics AX/D365FO Technical

https://organicax.com/2017/08/07/setting-up-and-environment-to-try-the-powerbi-report-models-part-1/ https://blogs.msdn.microsoft.com/dynamicsaxbi/2016/12/12/power-bi-content-from-microsoft-and-your-partners/

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/database/copy-database-from-azure-sql-to-sql-server

Useful link for Model Import and Export in D365 http://www.cloudfronts.com/model-importexport-in-dynamics-365-operations/ https://community.dynamics.com/enterprise/b/dynamics365enterprisecloudfronts/archive/2016/12/12/model-import-export-in-dynamics-365-operations

Hi Guys, We can browse table data in any browser if you know table name. Below is the example,provide parameters like cmp and tablename. Example: https://test-dev1aos.sandbox.ax.dynamics.com/Default.htm?mi=SysTableBrowser&tablename=CustTable&cmp=USMF Thanks

https://stoneridgesoftware.com/setting-up-continuous-integrations-in-dynamics-365-for-operations/

Hi guys, We can browse the table data in google chrome using the extension called D365 Table browser caller. Go to google chrome->more tools->extensions->search D365 browser caller. Will find the extension and add to chrome. It will showcase one Table Icon in the upper right corner of the browser.click on the icon and give the URL,legal entity details. It will provide the list of tables and Data Entities. Instead of browsing the data in table browser of VisualStudio,use this D365 browser caller extension and browse the data in Google chrome. Thanks

Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.    at Dynamics.Ax.Application.FormletterService.Run() in FormletterService.run.xpp:line 221    at Dynamics.Ax.Application.FormletterService.Postpurchaseorderconfirmation(PurchFormLetterPurchOrderContract _contract) in FormletterService.postPurchaseOrderConfirmation.xpp:line 14    at FormletterService::PostPurchaseOrderConfirmation(Object , Object[] )    at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters)    at Dynamics.Ax.Application.SysOperationServiceController.Runoperation(Boolean _async) in SysOperationServiceController.runOperation.xpp:line 93    at Dynamics.Ax.Application.SysOperationServiceController.runServiceOperation(Object[] parameters) in SysOperationServiceController.runServiceOperation.xpp:line 22    at SysOperationServ...

https://brianjparker.tech.blog/tag/vm/ https://dynamicsax708.wordpress.com/2017/03/16/virtual-machinevm-setup-to-access-dynamics-365-for-operation-instance/

All development work is carried out in conjunction with Visual Studio Team Services, or VSTS. It used to be optional, but the implementation process that is managed through Lifecycle services (LCS) requires that we have a VSTS project linked to it to function to its fullest. This is not just for source control and work management, but it is also used when performing code upgrades. When a solution is designed, it will be done by breaking the solution into packages of functionality. Package is a deployable unit that can becomes a distinct dll. Package that contain one model and one project. The  dependencies are defined against the project, not the model. When we create a project, the project is associated with a model. The Application Suite is a package that we normally always reference, as it contains the majority of the types that we usually need. Model is a subset of elements,such as classes, within package and can be used to move code from one development system ...

https://devserra.wordpress.com/tag/ax7/

static void customerContactInformation(Args _args) {     CustTable   custTable;     DirPartyTable dirPartyTable;     LogisticsElectronicAddress  logisticsElectronicAddress;             custTable = CustTable::find('‪‪‪13814');//give custAccount number     dirPartyTable = DirPartyTable::findRec(custTable.Party,false,DirPartyType::None);     logisticsElectronicAddress = LogisticsElectronicAddress::findRecId(dirPartyTable.PrimaryContactEmail);             info(strFmt("Name: %1,EmailAddress: %2 ",dirPartyTable.Name,logisticsElectronicAddress.Locator));             }

static void vendorPrimaryContactDetails(Args _args) {     VendTable       vendTable;     ContactPerson   contactPerson;     DirPartyTable   dirPartyTable;     LogisticsElectronicAddress  logisticsElectronicAddress;                 vendTable = VendTable::find('AP000000888');//Vendor Account Number     contactPerson = ContactPerson::find(vendTable.ContactPersonId);     dirPartyTable =DirPartyTable::findRec(contactPerson.Party,false,DirPartyType::Person);     logisticsElectronicAddress = LogisticsElectronicAddress::findRecId(dirPartyTable.PrimaryContactEmail);     info(strFmt("Name: %1,EmailAddress: %2 ",dirPartyTable.Name,logisticsElectronicAddress.Locator));           }

Script For  AOT Parallel Compile: @echo off title AX Compile Echo Started compiling AOS$01-LOCALVM D: cd "Program Files\Microsoft Dynamics AX\60\Server\ABC_AX_DEV\bin" axbuild.exe  xppcompileall /aos=01 /Workers=6 echo Finished pause

http://shafeaa.blogspot.in/p/di.html

static void vij_fulltextIndexJob(Args _args) {     //A full text index can improve the speed of queries that search for words that are embedded in string and memo fields on tables. [MS help]     Query   query;     QueryBuildDataSource  qbds;     QueryBuildRange   qbr;     CountryTable    ct;     QueryRun        qr;           query = new Query();     qbds =query.addDataSource(tableNum(CountryTable));     qbr = qbds.addRange(fieldNum(CountryTable,Country));     qbr.rangeType(QueryRangeType::FullText);     qbr.value('ind  usa  aus ');//space means OR  condition     //in x++ select statements we cant use fulltextindex     //we can only create fulltextindex for tablegroup main or group     //we can create maximum one full text index for table     ...

Some Times you cannot use the debugger in the all environments. But without using the debugger you can get call stack. The following x++ code will help you in this case. Add the example code to a method that is throwing an error. container callStackCon; int i; Str msg; callStackCon = xSession::xppCallStack(); for(i=1;i<=conlen(callStackCon);i++) { msg+ = conpeek(callStackCon,i); } info(msg);