Summary

When saving an invoice in SIMMS version 8.0.4 you may get the following error message if you have the General Ledger enabled: The insert statement conflicted with the FOREIGN KEY constraint "FK_AccJournals_AccChart". This issue has been resolved in the next version of SIMMS but if you wish to fix before the next service pack is released then run the script attached to this case.

Applies To

Symptoms

Solution

Download the zipped file attached to this article then unzip and run the sql file in the SIMMS SQL Query tool or in the SQL Manager, if you don't know how to do this then contact KCSI technical support 

Keywords

sp_save_invoicetransaction ,  FK_AccJournals_AccChart