Change fixed assets from fiscal to calendar year end

After changing the GL year end from fiscal to calendar on GP10sp2 by reopening all the history years with Microsoft support we found that fixed assets would not depreciate correctly because it was in the middle of a fiscal year even after we rebuilt the FA calendar. We tried resetting the year and recalc remaining life from mass change but nothing worked. We opened a Microsoft support case and here are the steps we took to resolve it, all of this being done in a test company.

1. Delete the GL fiscal period setup tables (delete SY40100 delete SY40101) from management studio. This is only in a test company, we will create an FA calendar script from it later.
2. Recreate the GL fiscal period setup window (in GL) – enter one full year on the old fiscal periods, then enter an 18 month year ended 12/31, then one year on a calendar basis. This 18 period fiscal year will overlap the current “Depreciated to Date” for all the assets on the old fiscal year end. For example, the depreciated to date was 10/31/12 and the fiscal year end was 6/30 so we entered the following (GL not fixed assets) in the fiscal period setup window:
a. 2012: 07/01/2011 – 06/30/2012
b. 2013: 07/01/2012 – 12/31/2013 (long year)
c. 2014: 01/01/2014 – 12/31/2014
3. Rebuild the fixed assets calendar – MS Dynamics>>tools>>utilities>>fixed assets>>build calendar (and replace). This will look at the (GL) fiscal period setup window and rebuild all the FA calendar where 2012 and prior will be on a fiscal basis, 2013 will be 18 periods, and 2014 and above will be on a calendar basis.
4. Run the attached script called “Get FA calendar Inserts” provided by support and run it against your test company only. The results of this script is what you need to save as a new script which deletes the FA calendar table and inserts the new FA calendar as described above. This script is mainly used to copy the FA calendar to other company databases which you can use if you have other companies that use fixed assets.
5. You may want to test depreciation by running “depreciate one asset” then verify it’s consistent with prior depreciation amounts through inquiry>>fixed assets>>financial detail window.
6. Test your FA calendar script – Refresh your test company, then run the script you saved from above
7. In the test company, run depreciation and verify all your reports agree to the general ledger for cost and accumulated depreciation.
8. Backup your live company, then run the script you created above in your live company and run depreciation and verify your reports agree to the general ledger for cost and accumulated depreciation.
9. Remember, during the FA GL posting routine, be sure you enter an ending date up to 18 periods through 12/31/13, then in January 2014 it will go back to a standard calendar where 1/31/2014 ending period for the FA general ledger posting window will be 2014-001.

10. If all your assets are set to depreciation based on “original life”, I recommend changing it to depreciate based on “remaining life”, otherwise all your assets will be fully depreciate.

11. Also, when you refresh the test company be sure to run the test company script, see the link below:

Here are some links to other reference information that might help:

–Guidelines for fiscal period/year changes with Fixed Assets in Microsoft Dynamics GP 10 and 2010
http://community.dynamics.com/product/gp/gptechnical/b/dynamicsgp/archive/2012/10/09/guidelines-for-fiscal-period-year-changes-with-fixed-assets-in-dynamics-gp-10-and-2010.aspx

–How to reset the life of an asset or of a group of assets in Fixed Asset Management in Microsoft Dynamics GP
https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;861544

–Calendar Script
Get_FA_Calendar_Inserts.sql

This entry was posted in Dynamics GP. Bookmark the permalink.

4 Responses to Change fixed assets from fiscal to calendar year end

  1. Ann B says:

    Hi,
    Thanks for this…we are having this exact issue. You reference a script “Get FA calendar Inserts” provided by support..can you post that?
    Again, thanks so much!

  2. Steve says:

    Thanks, I updated my website so the script is downloadable now.

  3. Ann says:

    Thank you.

  4. Ann says:

    On more item. I did have to change the convention to ‘full period’ from 1st of month on assets added during changed year, if not added on first day. This is a ‘known issue’ on the last page of the document from MSFT.

Leave a Reply

Your email address will not be published. Required fields are marked *