PDA

View Full Version : INSERT statement...EXPIRE_ACT_SALE_DETAIL


David Stephen
01-04-2007, 09:43 AM
Error Message: "INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'EXPIRE_ACT_SALE_DETAIL'. the conflict occurred in database 'RWD' table "EXPIRE_ACT', column EXPIRE_ACT_ID'

Occurrence: Posting (ringing up) a sale.

Cause: Database conflict

Resolution: In Point Of Sale (POS) click the "setup" menu > "POS Setup" > "Posting Defaults" > set the "Expired Items" to "Always". Save and then exit the POS. Open the POS, and change it back to "Show Prompt" .


Key words: Expire, Insert statement conflicted, conflict, Point of Sale error.