Microsoft Dynamics GP sync error: Invoice Number XXX, Cannot insert duplicate key row in object ‘dbo.PM10000’ with unique index ‘XXX. The duplicate key value is (XXX)

January 11, 2023 15:24
Updated

Why the sync error occurs

This issue occurs when a batch or transaction gets stuck when posting during a sync. To verify this is the cause, try to create a transaction in Microsoft Dynamics GP for the same voucher number to confirm the error.

How to fix the sync error

To resolve the error, Check to ensure there are no batches in batch recovery in GP. If not, contact the Microsoft Dynamics GP support team.