I am using the DMT to import suppliers from Vantage 8.03 to E10. I was able to import the Vendor table except for 18 records that have a value other than blank for the PurPoint field. I used the following fields:
Company VendorID Name VendorNum Address1 Address2 Address3 City State ZIP Country TaxPayerID PurPoint TermsCode Print1099 FaxNum PhoneNum Comment PrimPCon DefaultFOB Approved EMailAddress WebVendor VendURL Hazmat
When I try to DMT the VendorPP table, I get the following error:
ForeignKeyConstraint VendorVendorPP requires the child key values (RAPAT, 781) to exist in the parent table.
I am trying to use the following fields:
Company |
PurPoint |
Name |
Address1 |
Address2 |
Address3 |
City |
State |
Zip |
Country |
VendorNum |
PrimPCon |
EMailAddress |
VendorNumVendorID |
Any ideas?