1-866-278-6243
PK Constraint - Key Violation
Constraint...Foreign Key conflict...
All Orders 4.X
Constraint...Foreign Key conflict... while converting from Version 3
Description
During the conversion from version 3, you may receive a foreigh key constraint error in the Customer or ItemInventory tables as follows
Constraint...Foreign Key conflict...
Cause:
In All Orders 3 the FullName field was not a unique field whereas in All Orders 4 the FullName field is a unique field. Before All Orders 4, when you deleted an Item in QuickBooks it was not deleted in All Orders and may have been duplicated if it was re-introduced in QuickBooks.
Resolution:
-
Open your file in version 3 of All Orders and do a Full Sync. File --> Synchronize with QuickBooks - Full Sync
-
Close All Orders version 3.
-
Open All Orders version 4 and retry the conversion.
10/19/2006
More questions?
Call to speak with a NumberCruncher Solutions Consultant at:
