A/P Vendor Import

Navigate to the menu Vendors -> AP Vendor Import.

Click the box “Generate New Vendor ID” to change its value to “Yes” to generate new IDs for the vendors imported into Naviga Ad. Leave the value as "No" when the Vendor IDs are supplied in the import file will be used. This will overwrite existing vendors in the system with matching IDs.

Click the button “Download Template” and an excel sheet displays on your desktop. Fill out the column values according to the section below titled Template. Save the data to your desktop and then click the “Select” button on the Naviga Ad import screen. Browse for the file to upload. Click the “Test Import File” button and the system alerts you to any errors in the spreadsheet.

If there are errors, remove the sheet from the Naviga Ad screen by clicking the x red button. Resave the file and retest the import. Repeat until you get a successful test.

Click the button “Import File” and this uploads the template and vendor IDs into the system. You can view the new vendors when you search for them in the vendor maintenance screen.

Field Name	Example	Info	Mandatory/ Optional
Vendor ID	GGHJ	Alphanumeric ID	Optional
Vendor Name	Psychic Cleaners	Alphanumeric vendor name	Mandatory
Name Line 2	Professional	Alphanumeric vendor name	Optional
Address 1	1555 10th ST	Street address alphanumeric	Optional
Address 2	Suite 200	Second line Address alphanumeric	Optional
Address 3	2nd floor	Third line address alphanumeric	Optional
City	Santa Monica	City name of address;	Optional
State / Region	CA	State of vendor	Optional
Postal Code	90401	Zip Code	Optional
Country ID	US	Country ID; 2 or 3 letter code, depending upon your setup of countries in Address Setup.	Optional
Phone	9145453333	Phone of vendor; format is according to the phone setup in the systems table menu.	Optional
Phone Ext	333	Extension	Optional
Fax	9143454444	Fax number of vendor format is according to the phone setup in the systems table menu.	Optional
Website	www.vendor.com	Vendor web address
Vendor Type ID	XX	This is the value from the Setup menu -> Vendor Type Setup; must match Naviga Ad values.	Mandatory
Terms ID	N30	Terms Code ID and must match the Naviga Ad value in the Systems Tables	Mandatory
Tax Code	0	Tax Code ID and must match the Naviga Ad value in the Systems Tables	Mandatory
Withholding Tax Code	W2	This is the withholding tax code. If used, value must match Naviga Ad value	Optional
Tax ID	087654321	Tax ID of vendor	Optional
VAT Code	123	VAT code as it applies to European clients	Optional
Issue 1099	Y or N	Yes or No to issue 1099 or not.	Optional
Account Open Date	04/10/2019	Date format entry of the day when the vendor account was opened	Optional
Default GL Account	01*030*0033	GL account value which must match a GL account in Naviga Ad.	Optional
Vendor Note		Free alphanumeric entry of any vendor related note.	Optional
Payment Priority ID	H	Payment priority entry code (free format field, but best to use a set naming convention)	Optional
Payment Status ID	P	P, H or S must match one of these values for Pay, Hold or Stop Payment	Optional
Bank ID	BOA	Bank ID must match Naviga Ad value in Setup menu for Banks	Optional
Contact Name	Bob Jones	Name of Vendor contact; alphanumeric entry	Optional
Contact Role	Manager	Role of the vendor contact; alphanumeric entry	Optional
Contact Phone	9143435555	Vendor phone number according to phone format setup in Naviga Ad	Optional
Contact Email	[email protected]	Vendor Contact email address	Optional
1042 Country		Value must match the Naviga Ad code for 1042 Country ID	Optional
1042 Type		Value must match the Naviga Ad code for 1042 type code	Optional
1042 Type 3 Exemption Code		Value must match the Naviga Ad code for 1042 type 3 status code	Optional
1042 Type 3 Status		Value must match the Naviga Ad code for 1042 type 3 status code	Optional
1042 Type 4 Exemption Code		Value must match Naviga Ad value for the 1042 type 4 exemption code	Optional
1042 Type 4 Status		Value must match Naviga Ad value for the 1042 type 4 status	Optional
1099 Default Code		Value must match Naviga Ad 1099 code from the Setup menu	Optional
Our Account ID w/Vendor	879787	Alphanumeric account ID with vendor	Optional
Legacy ID	Coke, Pepsi	Alphanumeric entries for the Legacy ID of the vendor	Optional