Opening Periods in D365 for Data Management Imports
During an implementation, one of the most important steps is importing old GL data. Prior to uploading historical GL balances, you must open those historical periods. Without opening the historical periods, you will not be able to upload any historical balance. In this blog I will illustrate how to effectively and efficiently open and close GL periods and provide some useful tips and tricks to make your data import job, simple.
First, navigate to General Ledger > Calendars > Ledger Calendars.
Next, in the top right corner, click the box to the left of the paper clip and under Open In Excel, click Ledger Fiscal Calendar Period.
After clicking that, a new window will open. Click Download. After download the file, open the file and enable editing. Please make sure you are logged in with your proper credentials.
Next, an excel spreadsheet will open. Prior to editing, here are a few tips that make this job much, much easier.
- Periods 0 and 13 are called “Opening” and “Closing” periods respectively. These periods will always be Permanently Closed. When the excel sheet first opens, I recommend utilizing the filter feature to hide both Periods 0 and 13.
- If you have periods 2005-2030 in your system, but you only want to open periods between 2016-2017, filter based on those dates. Filtering out un-needed additional information will help reduce the chance for errors.
- Once a period is ‘Permanently Closed’ you cannot reopen this. Be very careful with permanently closing any periods.
Once you have your filters set up, you can easily open or put on hold all periods. Here is what a filtered workbook will look like. In the picture below you will see in columns C (Fiscal Year), D (Period Name), E (Period Status). We can see that our filters are in place because there isn’t a Period 0 or 13 and only showing periods between 2016-17.
To update the periods, simply type ‘Open’ in the Period Status column for the period you wish to open and copy that to all other periods you wish to open.
Additionally, once you have completed your Historical GL Import, you can follow this same method to put all prior years back to ‘On Hold’.
Lastly, once you’ve made your changes, remove your filters from the spreadsheet. You will not be able to publish the spreadsheet while the data is filtered. Once you’ve removed the filter, on the bottom right side of the screen, click Publish to publish your changes into your D365 environment.
Is your organization looking for a D365 upgrade, installation, implementation, or support? If so, contact Logan Consulting for more information now!
Logan Consulting is a professional services firm committed to helping businesses improve business processes to get the most from their ERP investments.
25 Brilliant Ideas to Outsmart Your Competition with Microsoft Dynamics
Top 10 Inventory & Operations Decisions Distributors Are Making Blind
2020 Nucleus Research Report on ERP Technology