In Integration Manager for Microsoft Dynamics GP, you receive the following error message when you run a Fixed Assets integration, and there are multiple Suffix IDs for an Asset ID:

The Asset ID and Book ID already exist in the FA00200 table and updates are not supported on Asset Books at this time.


This problem or behavior occurs when query relationships are incorrect.


To resolve this error, add a query relationship on both the Asset ID and the Suffix ID. To do this, follow these steps:

  1. Open Integration Manager and the integration.

  2. Double-click the Query Relationships window to open the window.

  3. Click the Asset ID in the General source, and drag it to the Asset ID in the Book source.

  4. Click the Suffix ID in the General source, and drag it to the Suffix ID.

Need more help?

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

Was this information helpful?

What affected your experience?

Thank you for your feedback!