Bertrand Desmarest articles
Bertrand Desmarest
Published
1 min read
“Unable to find the digital certificate” error when posting an invoice using the Mexican localization
In this post I would like to mention a known issue related to the Mexican electronic invoice (CFDI) in Dynamics AX 2012. If you have followed all the configuration steps detailed here, have valid certificates, and still see the error message “unable to find the digital certificate” when posting an invoice, you should make sure
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