You are currently offline, waiting for your internet to reconnect

How to rebuild the Fixed Assets calendar in Microsoft Dynamics GP

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
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.
More information
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 SY40100DELETE 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
More information
The Fixed Asset Management Fiscal calendar can supply all the calendar information instead of the Microsoft Dynamics GP calendar. This allows for differences that may exist between the two calendars. Users can use a different fiscal calendar for Fixed Assets.
Properties

Article ID: 874133 - Last Review: 01/23/2016 00:53:00 - Revision: 11.0

Microsoft Dynamics GP 2010, Microsoft Dynamics GP 10.0, Microsoft Dynamics GP 9.0, Microsoft Business Solutions–Great Plains 8.0

  • kbnosurvey kbinfo kbexpertisebeginner kbhowto kbexpertiseinter kbmbsmigrate KB874133
Feedback
/body>