AX Notes

Microsoft documentation for AX 2012 doesn’t provide clear steps on how to create new bank transaction based on the Marked new transaction in bank statement lines. These following steps can be followed to create the new bank transaction based on the bank statement line(s): During reconciliation process (under bank reconciliation worksheet), mark the statement line(s) that is indicated as a new transaction in the bank document. Or this step can be automated by using matching rules. Once marked as new transaction, open the related bank statement. Go to the line marked as new transaction and click ‘ Distribute amount ’ button. Put the ledger dimension string on Ledger account field. If you need to post into several accounts/dimensions you can utilise Split button. Close the Accounting distribution form and click post on the bank statement. This should help to create the new bank transaction automatically. Dynamics 365 Finance and Operations have the similar...

One of the improvement (or new feature) Microsoft made is the ability to export (and update) account structure. This can be done using office add-ins. This feature will be a big help for the users to be able to dump the data, perform analysis, and make changes directly in Excel format. Below are the steps to download and update account structure. Go to /General ledger/Chart of accounts/Structures/Configure account structures/ Click on “Open in Microsoft Office” icon at the top right-hand corner of the screen and choose “Account structure allowed values” template. Other template is to extract the list of the account structure available in the system not the value combination. Add-ins Template for Account Structure The account structure value combinations will be exported into excel format as follow (after successfully login to add-ins): If the account structure is in the draft mode, the records in Excel will be displayed in two different categorie...