Bertrand Desmarest articles

Bertrand Desmarest
Published 
1 min read

Warehouse Mobile Device Portal (WMDP) timeout 

Hello, If you see the following error message when using the Warehouse Mobile Device Portal: “Sorry, an error occurred while processing your request. Please retry your request or contact your system administrator”, you should first check the application log of the IIS server’s event viewer. If you are running into a timeout issue, you will
Published 
1 min read

Backup/restore the Model database or export/import the Model Store? 

In this post I would like to clarify the differences between doing a backup/restore of the Model database, and doing an export/import of the Model Store. Since version 2012 R2, and the separation of the application elements in a different database (the Model database), it is technically possible to restore this database separately. However, this
Published 
1 min read

Trial balance Opening balances are incorrect after Fiscal year close 

Hello, In some situations, if you check the opening balance amounts just after having executed the Fiscal year close Opening transactions process, you will see that the displayed values are incorrect. What you see may be only “temporarily” incorrect: if you check again after a few minutes, the balances may have changed to show the expected values. This is
Published 
1 min read

How to monitor Dynamics AX client versions 

Hello, If you see “version mismatch” warning messages in an AOS Server Event Viewer’s Application log, you have Dynamics AX clients with out-of-date versions: Object Server xxx: Internal version mismatch. Microsoft Dynamics AX Client from xxx The SYSUSERLOG table can help you to find the Dynamics AX clients that need to be updated. This table logs the login and logout events for each
Published 
2 min read

Creating and managing custom indexes in Dynamics AX 

Hello, An index is a database structure that is used to speed the retrieval of information from a table, or in some cases to ensure the uniqueness of records in a table. In Dynamics AX, each table comes out-of-the-box with a variety of indexes designed to provide the best results in most cases. As every Dynamics AX
Published 
2 min read

Hiding Open Bank Documents from the Bank Reconciliation Worksheet 

The Bank Reconciliation Worksheet is used to match transactions from a previously imported bank statement, with bank document transactions received or posted in Dynamics AX 2012. The documents that appear on this form cannot be modified and are available only for the purpose of reconciling. In the event of a bank error, there may be two bank statement lines listed
Published 
2 min read

Customizing the system-generated query of the Invoice journal form 

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 open the Invoice journal form
Published 
4 min read

Customizing the Bank reconciliation report to filter currency revaluation transactions 

Hello, When the Foreign currency revaluation process is run, Dynamics AX adjusts the amounts in the General Ledger accounts to recognize possible differences between the exchange rate for the original transaction currency, and the exchange rate that is used during the conversion to the accounting currency. As per the current design, Bank accounts are not
Published 
1 min read

Installing Reporting Services extensions on SQL Server 2014 

Hello, When installing Reporting Services extensions on SQL Server 2014 you may run into this error: “Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. An operation is not legal in the current state. (Exception from HRESULT: 0x80131509)”. To resolve this issue you should install the following components of SQL 2008 R2
Published 
<1 min read

How to select all the records from a grid 

In Microsoft Dynamics AX 2012 not all the records are loaded when a form is opened. If a user tries to select all the records using Control + A, going to File > Edit > Select all, or selecting the checkbox left to the grid header, they will actually select only the records that are already loaded.
Published 
1 min read

How to prevent copy/paste from grids 

In Microsoft Dynamics AX you can copy information from grids and paste that information into a Microsoft Excel worksheet. You can do this by selecting the lines you want to copy, going to File > Edit > Copy, and then pressing CTRL + V in Excel. You can also just press CTRL + C from the Dynamics