container cont = ["one", "two", "three"]; int no = 1; while (no <= conlen(cont)) { info(conPeek(cont, no)); no++; } // The output is "one", "two", "three".
Author: Marco Saad
AX – D365FO – DO…WHILE statement example
int FindPower(real realNumber) { int exponent = -1; real curVal; do { exponent++; curVal = power(10, exponent); } while (realNumber > curVal); return exponent; }
AX – D365FO – “FOR” Statement example
int integers[10]; for (int i = 0; i < 10; i++) { info(int2str(integers[i])); } // The output is a series of 0's.
AX – D365FO – Refresh database data from a production environment to a sandbox environment (UAT) in LCS
You can use Microsoft Dynamics Lifecycle Services (LCS) to perform a refresh of the database to a sandbox user acceptance testing (UAT) environment. A database refresh lets you copy the transactional and financial reporting databases of your production environment into the target, sandbox UAT environment. If you have another sandbox environment, you can also copy … Continue reading AX – D365FO – Refresh database data from a production environment to a sandbox environment (UAT) in LCS
AX – D365FO – “OR” conditions in a QueryBuildRange for a same field
I want to add a list of values in an "OR" Condition for a same field in a QueryBuildRange. The result must be something like that select * from CustGroup where custGroup.CustGroup == '50' || custGroup.Group =='90'; To do that Just add range and assign value on the same field multiple times as shown in code … Continue reading AX – D365FO – “OR” conditions in a QueryBuildRange for a same field
AX – D365FO – Add Menu item to Favourites in AX2012
To add a menu item to Favourites just right-click on menu item, click on "Add to favourites" and you'll find it in the Favourites Menu (like show below)
Visuali Studio – Enable / Disable Word Wrap
To set word wrap preferences On the Tools menu, select Options.In the Text Editor folder, choose the General options in the All Languages subfolder to set this option globally.— or —Choose the General options in the subfolder for the language in which you are programming.Under Settings, select or clear the Word wrap option.When the Word wrap option is selected, the Show visual glyphs for word wrap option is enabled.Select the Show visual glyphs for … Continue reading Visuali Studio – Enable / Disable Word Wrap
AX – D365FO – Select Statement with an Outer Join
static void OuterJoinSelectJob3(Args _args) { SalesOrder recSalesOrder; SalesOrderLine recSalesOrderLine; struct struct4; ; struct4 = new struct ("int SalesOrderID;" + "date DateAdded;" + "str SalesOrderLineID;" + "int Quantity" ); while SELECT from recSalesOrder OUTER JOIN recSalesOrderLine WHERE recSalesOrder.SalesOrderID == recSalesOrderLine.SalesOrderID && recSalesOrderLine.Quantity == 66 { struct4.value("SalesOrderID", recSalesOrder.SalesOrderID); struct4.value("DateAdded", recSalesOrder.DateAdded); struct4.value("SalesOrderLineID", recSalesOrderLine.SalesOrderLineID); struct4.value("Quantity", recSalesOrderLine.Quantity); info(struct4.toString()); } }
AX – D365FO – Making a Cross-Company Tables in AX
When using AX, there are a lot of times where you want data to go across companies. To set a Table to Cross company just set NO the "Save Data per Company" property
AX – D365FO – Customization Analysis Report (XppBp.exe)
The Customization Analysis Report is a tool that analyzes your customization and extension models, and runs a predefined set of best practice rules. The report is one of the requirements of the solution certification process. The report is in the form of a Microsoft Excel workbook. Click here to view some examples on how to … Continue reading AX – D365FO – Customization Analysis Report (XppBp.exe)
AX / Dynamics 365 For Finance and Operations blog 