PBI Fastclose Report in Month-end Closing Accruals

How can I use the Fastclose PowerBI report in conjunction with D365 Finance General Journals for month-end closing accruals?

Accurate and efficient processing of month-end closing accruals in D365 Finance is crucial for maintaining financial integrity. This guide provides step-by-step instructions on setting up D365 journal Excel templates, modifying journal lines, and ensuring proper data upload for seamless month-end closing. Dooap's PBI Fastclose Report can be utilized as a template in Month-end Closing Accruals.

Important: When setting up the D365 journal Excel templates, it is crucial to carefully follow the instructions for file naming and dimension setup in D365.

Processing Month-End Closing Accruals

To process month-end closing accruals, you can use any General Ledger journal type in D365 Finance.

1. Open D365.
2. Begin by creating a new journal.
   1. When using the journal for the first time, it's recommended to manually fill in one line to understand the format of each field when opening the journal in Excel.
3. To modify the journal, select it and click Open lines in Excel.
4. In the dialog box, choose the template you want to use.
   1. 1. You can select the Microsoft default "General journal line entry" template or a custom template like "Dooap Fastclose".
      2. New custom templates can be uploaded via Common > Office Integrations > Document templates.
      3. More information on adding custom templates can be found here. 
         
         
         
         
         
         
         
         
5. Open the downloaded Excel document.
6. In Excel, click Enable Content to activate the Add-In.
   1. If this is your first time using the Excel Add-In, you may need to enable it by clicking the Insert tab in the Excel ribbon, selecting "My Add-ins," and then choosing the Microsoft Dynamics Add-In.
      1. Click Add to open the side panel, which will indicate the connection to D365.
   2. If prompted, enter your D365 login credentials.
      
      
      
      
      
      
      
7. You can now modify the journal lines.
   1. Keep in mind that D365 is very strict about the coding format; you must ensure the correct number of values or delimiters are used.
      1. Do not manually change the "Line Number" field.
8. To upload the lines to the journal in D365, click Publish in the lower right corner of the D365 Add-In screen.
   1. Be aware that any lines with errors will be removed during the upload, so it's advisable to save a backup of the lines before publishing to avoid additional work.
      
      
      
      
      
      
      
      
9. Any upload errors can be viewed via the flag icon.
10. Once the publishing is completed, you can close the Excel file.
11. The lines are then visible inside the journal in D365.