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

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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×