1. Vendor names on the CSV file must be entered the same way they appear on the Vendor field of the Transactions > Purchases/Vendors > Enter Bills page. If Auto-Generated Numbering is set to True (Setup > Company > Auto-Generated Numbers > Entities tab > Enable box is checked for Vendor), the format will be Vendor Id Vendor Name. For example 123 ABC Company.
2. Internal Id's of the Vendors can also be used. If the CSV file contains the Internal IDs, make sure that on the Field Mapping page of the CSV import, click the pencil icon besides Vendor field mapping and choose Internal Id under the Choose Reference Type dropdown.
3. If Vendor records are entered via CSV Import and External Id's are assigned to them, this can also be used. On the Field Mapping page of the CSV Import, just click the pencil icon besides the Vendor field and choose External Id under the Choose Reference Type dropdown.
4. Vendor records should also be Active at the time of Vendor Bills import. Navigate to Lists > Relationships > Vendors and check the Show Inactive box to see if there is a check mark besides the Vendor name.
No comments:
Post a Comment