Skip to main content
Avalara Help Center

How do I resolve error 'Cannot insert duplicate key in object' in Dynamics GP?

Overview

You are attempting to process a invoice but receive "[Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PKSOP10105'. Cannot insert duplicate key in object 'dbo.SOP10105'. The duplicate key value is (4, RTN00004959 , 32768, AVA-USWA ).*/"

Environment

Dynamics GP

Resolution

  • Restart workstation
  • If AvaTax is installed on a second workstation/server, recalculate invoice from another workstation/server