web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Changing Fiscal years for a company with Fixed Assets.

(0) ShareShare
ReportReport
Posted on by 75,854 Moderator

Client not only wants to change their fiscal year to calendar they also want the depreciation of their fixed assets to now reflect the change in fiscal year. Is this possible? If so, how do you accomplish this?

Categories:
  • Michael O'Donnell Profile Picture
    355 on at

    Depreciation of fixed assets is a bit fiddly, hence I recommend that you make a copy of your database and do this in the copy so you can test things out.

    Once you get the copy of the database ready Go to the Financial module > setup > Fixed assets > Calendar and setup your calendar year

    Next: Click Transactions, point to Fixed Assets, click Select Assets, and then click New Group.

    Name the group, and then click OK.

    Under Current Groups, click the newly created asset group, click to select the assets for which you want to reset the life, and then click OK.

    Click Transactions, point to Fixed Assets, and then click Mass Change.

    Select the newly created asset group ID, click the Book tab, select the book ID, select Reset Life, and then click Apply Changes.

    In the following message, click OK:

    Are you sure you want to apply changes to group (New_Group_Name)

    Do all this in test and see how it goes. This link might help: www.crestwood.com/.../

  • Richard Wheeler Profile Picture
    75,854 Moderator on at

    Thank you for this detailed explanation. This is my job for this weekend. I will provide an update.

  • Richard Wheeler Profile Picture
    75,854 Moderator on at

    OK, I have followed these instructions so now do I know if anything has changed? I am not a FA person and I am really not sure how changing the fiscal year will impact any fixed assets.

  • Michael O'Donnell Profile Picture
    355 on at

    The Dynamics GP Fixed Assets module can easily depreciate assets and send that information to the general ledger. If you want to see what future asset depreciation will be you can run a depreciation projection report. Running a projection is like 'try before you buy' it won't commit anything to the system. 

    There are two steps to running the depreciation projection report:

    1. Run the projection routine: Routines >> Fixed Assets >> Projection. Specify the date to which you want to run the projection.
    2. Run the projection report: Reports >> Fixed Assets >> Projection. You can run the report at a summary or detail level, and show either annual or periodic depreciation amounts.

    To do an actual depreciation:

    Depreciating the assets is simple. Just navigate to: Routines >> Fixed Assets >> Depreciate. Select the book(s) you want to run the depreciation for, and the “depreciate to” date. If you go back and look at an asset you will see the individual depreciation records created for each period.

    Show the projection results to the accountants and see what they say. If things are looking good then you are done. If not, then there will be work to do.  How do you know that the current FA setup is right? Is every single asset properly configured? Look at the Asset Book screen shot below, all the fields must be correct for the depreciation to work. Have the accountants validated everything is spot on? 

    Ask the accounting team to provide you a complete Excel file with all the fixed assets and all the relevant columns as seen below in the Asset Book screen shot. You need a column for the Placed in Service data, Depreciation to date, Begin Year Cost...etc. They need to fill in everything. Do not proceed until they furnish you with this. You can go to: Financial\Utilities\Fixed Assets\Asset Import/Export then click Help\About this window.  You'll get the following help screen.  From there click Field Mapping....  and it will give you the column layout needed.

    The accountants should also provide for the depreciation they are expecting to happen (so you can compare it to how GP is doing the depreciation). Basically, the accounting team needs to roll up their sleeves and get heavily involved in order to make FA work correctly. There are some good YouTube videos on FA, watch them to give yourself some familiarity. 

    pastedimage1636836470186v1.png

  • Richard Wheeler Profile Picture
    75,854 Moderator on at

    They have supplied the spreadsheet. There are 995 assets dating back to 1999. If I were to get involved with I could spend weeks if not months on this. The only person I have spoken to about this the owner. I do not know if he has pulled any accountants in on this. I will allow him to reviews the assets and see how he wants to proceed. This was all done in a test company so whatever I have done can easily be rolled back. Let me know if I am correct in this thought. Changing the calendar year really does nothing to what has already been depreciated. It will affect only the depreciations going forward. If he wants to get deep in the weeds with this and you want to assist send me a PM and we will connect and setup up a relationship.

  • Michael O'Donnell Profile Picture
    355 on at

    Doing this in a test company is always the best path to take. You are correct that changing the calendar year will not impact depreciation already taken and will only impact future depreciation. I recommend that you focus on one asset only and see if you can get it to depreciate the way the owner (or accountants) expects it to. Then once you nail it down, you can focus on the other assets. Unfortunately, my current workload won't allow me to take on anything new, but I am available on this forum to help.

  • Richard Wheeler Profile Picture
    75,854 Moderator on at

    Thanks for your invaluable help. This now in the owner's hands. If all looks good we move onto doing this in production. I will keep you posted.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 475 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 399 Super User 2026 Season 2

#3
CU10121822-0 Profile Picture

CU10121822-0 374

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans