Microsoft Dynamics 365 Blog

Customizing the system-generated query of the Invoice journal form 

2 min read

When creating a Sales order in Dynamics AX 2012, you can define both a “Customer account” and an “Invoice account”. The Customer account identifies the customer for which the Sales order is being created, and the Invoice account references the account number of the customer to invoice, in case it is different. If you want to modify this behavior, you…Read more


Visual Studio Dynamics AX report development how to associate X++ class with report dataSet 

1 min read

Some time ago I run into following question regarding reporting development in Visual Studio 2008 To add a query to AxQuery you pass in a Dictionary object, but our range needs to be equivalent to: select * from InventTrans where DatePhysical < _paramDate && (DateFinancial == datenull() || DateFinancial > _paramDate) The problem is on…Read more


About locking and blocking in Dynamics AX and how to prevent it 

6 min read

The locking of records is necessary to ensure transactions are processed accurately and with a high level of concurrency. Unfortunately the more records are locked the higher is the chance other transactoins are getting blocked resulting in peformance reductions on the one hand and end user frustration on the other hand. Dynamics AX and Microsoft…Read more


AOT Query Browser – same as Table Browser 

<1 min read

There is a really handy tool available from the axaptapedia site, it allows you to run a table browser type form against AOT query objects:If you’re creating queries in the AOT,it’s useful to be able to see the data they return before you go to the trouble of building the object that will use the…Read more