The insert statement conflicted with the FOREIGN KEY constraint...

Expand / Collapse
 

The insert statement conflicted with the FOREIGN KEY constraint "FK_AccJournals_AccChart"


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

SIMMS Version 8.0.4

Symptoms

Can't save an invoice without getting a sp_save_invoicetransaction error: The insert statement conflicted with the FOREIGN KEY constraint "FK_AccJournals_AccChart"

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



Rate this Article:

Attachments


f4dd8415-3b7e-4edf-881c-f437.zip Case5396QuickFix.zip (1.85 KB, 444 views)

Add Your Comments


Name: *
Email Address:
Web Address:
   
  
 
 
   
Verification Code:
*
 

Details
Last Modified:July-22-11 4:14:53 PM

Last Modified By: Sheldonk

Type: INFO

Level: Intermediate

Article not rated yet.

Article has been viewed 27,311 times.

Options