General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint FK_AP7INVOICES_AP7SALESTAXITEMSID". The conflict occurred in database "KCSFEDB", table "dbo.AP7SALESTAXITEMS", column 'AP7S

When attempting to save an invoice in a Canadian database where the GST tax was removed from the Invoice tab an Error occurs:
General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_AP7INVOICES_AP7SALESTAXITEMSID". The conflict occurred in database "KCSFEDB", table "dbo.AP7SALESTAXITEMS", column 'AP7SALESTAXITEMSID'.
Native error:547
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
Native error:362
The Vendor has a default distribution set that utilizes GST.  As an alternative solution, we can remove the default GST to save the invoice:

1. Vendor > Distribution > remove the GST TAX ID to BLANK.
2. Save the changes.
3. Re-create the Invoice.

Environment

 7.82.104, patch 35

Was this article helpful?