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:
- Open Integration Manager and the integration.
- Double-click the Query Relationships window to open the window.
- Click the Asset ID in the General source, and drag it to the Asset ID in the Book source.
- Click the Suffix ID in the General source, and drag it to the Suffix ID.