How to Run Yearly Depreciation Projections in D365
Yearly, accounting will need depreciation projections run for them. You will get the data out of D365, then export it to Excel and use a PivotTable to build the report they’ll need. It is typically run for 5 years, but may be more or less depending on what’s requested. If different, adjust the years where referenced here.
First you will need to create any ledger calendars for future years that aren’t already created. Since we run this yearly, you will probably need to just c5eate one year, but that could also change depending on what’s requested by Accounting.
In D365, navigate to
General ledger >> Calendars >> Fiscal calendars
This will open the Fiscal calendars page.
In the “Calendar” dropdown box, choose “FA Cal”
Click the “New year” dropdown button at the top to add any more fiscal years that you’ll need.
Make sure the Start of the fiscal year date is October 1st, and the End of fiscal year date is September 30th of the following calendar year.
Enter a Fiscal year name (Use the 4-digit year).
Make sure “Copy from last fiscal year” is set to “Yes”
Click the “Create” button to continue.
This will create the new fiscal year.
Repeat this process for however many fiscal years are needed to run the projections into the future.
This process will create the fiscal calendars for every company, so you only need to do it once.
Close the window when you’re done.
Now we need to create the Fixed asset budget journal in D365.
Navigate to
Fixed assets >> Budget >> Fixed asset budget journal
This will open the Fixed asset budget journal page. You can ignore any existing entries here.
Click the “New” button at the top.
This will create a new Fixed asset budget journal.
Make sure “FABudget” is chosen for Name and type a brief Description.
Click the “Lines” button at the top to continue.
This will open the Fixed asset budget lines page.
At the top, click the “Proposals” dropdown box and choose “Depreciation proposal”
This will open the Depreciation proposal flyover pane on the right side.
Choose a Budget model. (This doesn’t matter too much, since we’re not going to post these journals, but look for NBMSBM or NLLCBM)
Choose a From date (1st day of the current month)
Choose a To date (September 30th of the last year to run through)
Make sure you’re not filtering to any particular assets.
Click the “OK” button to continue.
D365 will then begin populating the Depreciation proposal.
This part takes quite a while. (Typically around 10 minutes for NBMS, 30 for NLLC)
Once the processing is completed, you will be returned to the Fixed asset budget journal lines page. You should now see it populated with lines.
Now you will need to export this data to Excel.
Select all lines, click the “Open in Microsoft office” button in the top left corner of the page, and choose “Journal lines”
This will open the Export to Excel flyover pane on the right side.
Click the “Download” button.
The export generation step may take around 30 seconds to complete.
When it’s done your browser should open the Excel export in a separate tab.
Click the “Download file” button at the top to save the file to your computer.
Once the file has been saved, open it and choose “Enable Editing”
Now you will need to create a PivotTable.
Select Cell “A2”
In the Ribbon menu, on the Insert tab, choose “PivotTable”
Make sure “New Worksheet” is selected, and click the “OK” button.
This will open the PivotTable builder panel on the right side.
Drag and drop the “Date” field to the “Columns” area
This will add Years, Quarters, Months, and Date.
We only need the “Date” line in this area.
Click the Dropdown arrow next to the Years line and choose “Remove Field”
Repeat for the Quarters and Months lines.
Next, drag and drop the “Credit” field to the “Values” area.
Excel will automatically make it a sum of the Credit field.
Last, drag and drop “Offset account”, then “Account” fields to the “Rows” area.
The PivotTable is now built. You can close the PivotTable builder pane on the right side.
Now you need to do a little formatting before sending to Accounting.
In the Ribbon menu on the PivotTable Analyze tab, choose “Collapse Field”
This will collapse the PivotTable to the Offset account level.
Rename each sheet to something descriptive.
Make sure to save the workbook with a descriptive name.
You are now ready to send the workbook to Accounting for their use.
You will need to repeat the process for each company that the Depreciation projection is requested for (Usually NBMS and NLLC)