The total integration with Excel for Dynamics 365 Finance is one is the powerful tools that as user, consultant or technical we can use. I think it's amazing but, are you really using all the possibilities that the system offers? I wasn't until I read this great article Make your own Open in Excel Designer.
Since I read about this, I'm using it as much as I can, maybe too much 😅 but I'm really impress. Let me show you the step by step with one example:
Vendor ledger accounts in Dynamics 365 Finance are based on the "Posting profiles" that determine the balance account where the transaction, based on the type of movement and vendor group, is posted.
How many times you experience, hear and read about "once you post a journal in Dynamics 365 Finance, it's not possible to change it or deleted, you need to post a voucher to reverse the entry"?? As a user this can generates a lot frustration and more when the data you need to change is internal, for example the voucher description.
In the previous post we saw how to obtain reports for general ledger directly in Excel from D365 Finance using the reports defined as Electronic Reports. In the Fixed Asset module, we have similar reports that can be used for the year end close or the auditors´ requirements. Obtain these reports can save a lot of manual preparation because the reports include all the key information about the fixed asset transactions and their status.
We can generate from D365 Finance some standard reports really useful, printed in Excel with the required format for using during the month closing and even generate it for the internal audits.
There are two key reports in General Ledger that I recommend you configure and use it for your month closing or daily validations, let's see the details about the required setup and how to generate it.
