Article Details
Id: | 11167 |
Product: | emPOWER |
Type: | FIX |
Version: | 5.03.15 |
Opened: | 23/05/2013 |
Closed: | 07/06/2013 |
Released: | 19/06/2013 |
Job: | J011645 |
Invoice Review; changing details on an invoice, including allocations, may result in message regarding EmployeeId column.
Reviewing an Invoice and changing any details including receipt allocations, (where the 'Sales Rep' field is blank), might result in one of the following messages when saving:
MS Access - You cannot add or change a record because a related record is required in table 'Employee'. (Microsoft JET Database Engine error -2147467259).
SQL Server - The UPDATE statement conflicted with the FOREIGN KEY constraint "Employee Transactions". The conflict occurred in database "emPOWER_5_03_database", table "dbo.Employee", column 'EmployeeId'. (Microsoft OLD DB Provider for SQL Server error -2147217873).