INTRODUCTION

This article describes how to rebuild the Fixed Assets calendar in Microsoft Dynamics GP. Steps to rebuild the Fixed Assets calendar can be used as part of the troubleshooting steps for several problems in Fixed Assets. If the Fixed Assets calendar becomes damaged or the Fiscal Period calendar is rebuilt in General Ledger, the FA calendar has to be rebuilt.

Note Users can use a different fiscal calendar for Fixed Assets than is used for the Microsoft Dynamics GP calendar.

In Dynamics GP 2013 RTM, you can set up the FA calendar based on the Company fiscal period setup, a calendar year or an existing FA calendar setup, and also build short/long years. The FA calendar does not need to match the Company fiscal period calendar.  You can set up an unlimited number of FA Calendar ID's, but only one can be assigned to a Book and is locked down once it has been used.  If you need to change the FA calendar from a calendar year to fiscal year or vice versa, it is recommended to edit the existing calendar ID for periods going forward only.   You cannot change the periods for historical years or a 'reset life' will cause damaged data.  Therefore, only change the periods going forward, as outlined in the example in this blog: 

https://community.dynamics.com/gp/b/dynamicsgp/posts/guidelines-for-fiscal-period-year-changes-with-fixed-assets-in-dynamics-gp-10-and-2010

More Information

MICROSOFT DYNAMICS GP 2013 AND HIGHER VERSIONS:

The calendar does not need to match the Company Fiscal period calendar.  To rebuild the FA calendar, perform the following steps:

1. Make a current backup first, for reference if needed.

2. Go to Microsoft Dynamics GP | Tools | Setup | Fixed Assets | Calendar.

3. Pull up the Calendar ID being used.

4. Mark the Build Calendar checkbox.

5. If you normally build from the Fiscal Year Setup, make sure that option is marked, or choose the appropriate option. (Current company fiscal period setup, a calendar year, or an existing FA calendar setup)

6. Ensure the Years are set as 1901 to 2199.  Note:  You must rebuild all years.

7. Click Build Calendar.

8. Once complete, click Save.

---------------------------------------------------------------------

MICROSOFT DYNAMICS GP 2010 AND PRIOR VERSIONS:

To rebuild the Fixed Assets calendar when it differs from the Microsoft Dynamics GP calendar, follow these steps.

Note If the Fixed Assets calendar and the Microsoft Dynamics GP calendar are the same, complete only step 7 and step 8 in this section.

1. Make a complete backup copy of the database.
   
   Note It is important to back up the database because the Fiscal Period Setup table (SY40100) and the Fiscal Period Header table (SY40101) in this backup can be restored by using the Import and Export Utility in Microsoft SQL Server.

2. Make sure that all users log out of Microsoft Dynamics GP.

3. Delete the SY40100 table and the SY40101 table. This will remove the current fiscal periods that are set up for Microsoft Dynamics GP. To do this, follow these steps:

   1. Follow the appropriate step:

      • If you are using Microsoft SQL Server 2008, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.

      • If you are using Microsoft SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

      • If you are using Microsoft SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.

   2. Run the following statement against the company database.

      DELETE SY40100
      DELETE SY40101

4. Set up at least one fiscal year. To do this, follow the appropriate step:

   • In Microsoft Dynamics GP 10.0 or in Microsoft Dynamics GP 2010, point to Tools on the Microsoft Dynamics GP menu, point to Setup, point to Company, and then click Fiscal Periods.

   • In Microsoft Dynamics GP 9.0 or in earlier versions, point to Setup on the Tools menu, point to Company, and then click Fiscal Periods.
     
     Note If each year in Fixed Assets is the same, you have to set up only one year because the other years are modeled after this same year. If you want a stub year or a year that has a different period setup, you must set up those years in the Microsoft Dynamics GP calendar.

5. For the appropriate year, enter the First Day, enter the Last Day, enter the Number of Periods, and then click Calculate.

6. When you set up all the fiscal periods, click OK.

7. Build the Fixed Assets calendar. To do this, follow the appropriate step:

   • In Microsoft Dynamics GP 10.0 or in Microsoft Dynamics GP 2010, point to Tools on the Microsoft Dynamics GP menu, point to Utilities, point to Fixed Assets, and then click Build Calendar. Click to select the Build Fixed Assets Fiscal Calendar check box and the Replace check box.

   • In Microsoft Dynamics GP 9.0 or in earlier versions, point to Setup on the Tools menu, point to Utilities, point to Fixed Assets, and then click Build Calendar. Click to select the Build Fixed Assets Fiscal Calendar check box and the Replace check box.

   Note We recommended that you leave the default To and From year fields as 1901-2199. This will make sure that the years are set up so that there are no issues with projections or depreciation calculations.

8. Verify that the Fixed Assets calendar is built correctly. To do this, open the Build Fixed Assets Fiscal Calendar window, click Inquire, and then click Verify. Click OK when you are prompted to continue.

9. Print the FA Verify Fiscal Calendar report.
   
   Note Make sure that no periods have a status of "missing."

10. Restore the SY40100 table and the SY40101 table from a backup.
    
    For more information, click the following article number to view the article in the Microsoft Knowledge Base:
     

    874208 How to transfer setup information between company databases by using Microsoft SQL Server