How to Resolve This eConnect Error: 8087 Error Description = Account already exists in the Variable Allocation Master record – GL00104

In this video, we’ll explain how to resolve eConnect error 8087 when updating existing Variable Allocation detail accounts in Microsoft Dynamics GP. You'll learn why the "Update If Exists" option does not work as expected due to a known issue in the eConnect stored procedure and how this results in the "Account already exists in the Variable Allocation Master record" error.

We’ll walk through a practical workaround using a SQL Task in SmartConnect to remove existing allocation account records before eConnect processes the update. You'll also see why this task should be configured as a Before Document task and how this approach allows variable allocation records to be updated successfully.

For additional details, refer to the documentation that accompanies this video by clicking here.