How to clear data for the Fixed Asset files in order to rerun an import in Fixed Assets in Microsoft Dynamics GP

Applies to: Dynamics GP 2013Microsoft Dynamics GP 2015Dynamics GP 2010

INTRODUCTION


This article describes how to clear data for the Fixed Asset files in order to rerun an import in Fixed Assets in Microsoft Dynamics GP.

More Information


Remove both the asset general information and the asset book information

If you want to remove both the asset general information and the asset book information, follow these steps.

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.
  1. In Microsoft Dynamics GP, point to  Tools on the Microsoft Dynamics GP menu, point to Utilities, point to Fixed Assets, and then click Clear Data.
  2. In the Series list, click Financial. (The Display option in the menubar should default to Logical.)
  3. To insert the following logical tables, click the tables, and then click Insert.
    • Fixed Assets Master
    • Fixed Assets Index Master
    • Fixed Assets Financial Master
  4. Click Process.

    Note If you receive any error messages for the Fixed Assets Financial Master Note tables, you must re-create the FA00902.* files. To do this, follow these steps:

    1. Exit Microsoft Dynamics GP.
    2. Open SQL Query Analyzer, and then select the company database.
    3. Enter the following query.
      Delete FA00902
      Delete FA00905
    4. To run the query, click the green arrow, or press F5.
    5. Start Microsoft Dynamics GP.

  5. Run the import again.

Remove only the book information

If you want to remove only the book information, follow these steps:
  1. Make a full backup copy to protect the data. 
  2. In Microsoft Dynamics GP, point to Tools on the Microsoft Dynamics GP menu, point to Utilities, point to Fixed Assets, and then click Clear Data.
  3. In the Series list, click Financial.
  4. In the top menubar, click Display and then click Physical
  5. To insert the following physical tables, click the table name, and then click Insert.

    • Asset Book Master (FA00200)
    • Asset Financial Detail Master (FA00902)
    • Asset Book ITC/Cost Adjustment Master (FA00300)
    • Fixed Assets General Ledger Interface WORK (FA00905)
  6. Click Process.

  7. Run the book import again.