Hello,
If you say VendorGroupID is the same (make sure spelling is identical, with same spacing and capital letters), then it is probably somethingf else.
Can you confirm a few things:
- Vendor number sequence is set to Manual for the import?
- Parties were imported first or created through a different process before the Vendor import, so Party ID used in the Excel table already exists in Global Address Book?
- Make sure the PartyID column data type is set to text.
- Another mandatory field is VendorPartyType (Person or Organisation), if you already have imported the party it is not required but if the party is created with the Vendor creation it will be required.
Suggestions:
-Pare down the import file to just one or two records and remove any unnecessary columns. Just keep Vendor Number, Party Number, and Vendor Group, remove the rest.
- Add reduced file to the import job, and make sure to select to stop at Staging (so you can see the result before final puch to target).
- Map entity form scratch and confirm that mapping is correct (you file's headers are matched with the correct fields in the entity)
- Import and check the staging table.
When successfull, add more columns and records.
Good luck! Its a learning experience.
Danny
