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

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