Wish you could project depreciation for the coming year for budget purposes? While AX doesn't have a formal depreciation projection function, with a little creativity, we can create one.
Step 1 - Create a new Fixed Asset Proposal journal. Give it a descriptive name and add 'DO NOT POST' to the description, just to be safe. The last thing we want to post a year or more of depreciation inadvertently.
Step 2 - Click the Lines button, then Proposals>>Depreciation. Set the 'To date' to the depreciation end date. You can also filter the proposal by Fixed asset group and/or Value model. Click OK and sit back and wait for the proposal to generate.
Step 3 - Once the Lines window is populated, press Ctrl-t to transfer the results to Excel. At this point, you can also enter a Release date way in the future to be extra safe about not posting this journal.
Step 4 - Filter or Pivot the results in Excel to limit the periods in your projection to the desired result set and group the results as desired.
Step 5 - DELETE THE DEPRECIATION PROPOSAL!
Voila - a depreciation projection for your enjoyment.
No comments:
Post a Comment