Error: General ODBC Error: [Microsoft][ODBC SQL Server][SQL Server]The UPDATE statement conflicted with the FOREIGN KEY constraint FK_PSTRECEIVABLEACCOUNT_GL7ACCOUNTS". The conflict occurred in database "DB_1", table"dbo.GL7ACCOUNTS", column 'GL7ACCOUNT

When editing Activity Types in an Canadian database an ODBC error occurs after clicking OK.
The error only occurs when the Fund is masked.  Activity Types are not intended to have masked Funds.  To use multiple funds without using asterisks to mask the Fund segment, leave the accounts blank on the activity type.  The rebates will then pull from the accounts set up in default accounts. 

Environment

 7.82.104, patch 11

Was this article helpful?