Import Vendors into
invoiceit!4
|
invoice it!4
allows import of clients, products, vendors and debtors. This is accessed
from Setup - Import/Export button at the bottom. |
^ click
on image to enlarge
|
How to
import vendors
this guide is as detailed as possible to enable novice users to follow the
steps.
Prepare the data:
1) from the 'Select Data Type' dropdown, select Spreadsheet
2) from the green dropdown, select 'Vendors'
3) double-click the large panel at the bottom to open the client import
template (it is located in your program folder ...\invoiceit\import).
Delete the sample entries (Line2 and below)
4) from File Menu, select 'Save as' and save a copy of this template in
another folder (as backup).
5) Right-click on the 'Supplier_List' tab at the bottom and select Insert.
Click on Worksheet, then click OK. A new worksheet is created named
'Sheet1'.
6) Right-click on the new worksheet tab and select 'Move or Copy'. Select
(move to end) and click OK.
7) From File Menu, select Open and locate your old vendor data spreadsheet and
double-click it.
8) Press Ctrl+A (to select all), then Ctrl+C (to copy all)
9) switch to the new worksheet 'Sheet1' on the import template, click on
cell A1 and press Ctrl+V (to paste all).
You now have both the import template and your old data in the same
spreadsheet.
Map the fields:
1) click on the 'Supplier_List' worksheet and select cell A2 (the first
empty cell at top left).
let's assume your old vendor ID is in column C of the worksheet 'Sheet1'
and the first row contains your field headers.
2) in cell A2 on the 'Supplier_List' worksheet, type =Sheet1!C2
and press Enter. You will see the old vendor ID displayed in cell A2 of
the template. Vendor IDs must be 50,000 or greater.
Repeat the same with other columns - Example: if your OLD vendor name is
on Sheet1, column A, type =Sheet1!A2 and
press Enter. Always use the row number of your old data worksheet which
contains the FIRST entry.
3) continue with other columns until all columns from worksheet 'Sheet1'
have found a corresponding column in worksheet 'Supplier_List' (see complete
column list and their expected content below).
4) when you have completed this, select Row 2, click on the black dot in the bottom right corner of Q2 and drag
this down as far as required. Example: if you have 50 vendors, drag as
far as Row 51.
All entries from the old data worksheet are now 'copied' to the template
worksheet.
5) from the File Menu, select 'Save' (or press Ctrl+S).
Close the spreadsheet and switch back to invoiceit. Click on the Import
button and it's done.
Vendor columns in detail - those in red are required entry
fields:
The lookup lists mentioned below can be found on Setup - List selector at
left.
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
|
VendorID
|
Date
|
Sort
|
VendorName
|
Address1
|
Address2
|
City
|
State
|
Zip
|
Country
|
must be a unique number 50,000 or greater
Required entry
|
the date vendor was first entered
|
for sorting vendor names
Max: 5
|
single field for First/Last Name or company name Max: 50
Required Entry
|
First postal address line Max: 50
|
Second postal address line Max: 50
|
postal address city/town Max: 50
|
State (US) Prov (CA) or County (UK)
use only abbreviations as per list #17
Max: 3
|
zip or postal code Max: 10
|
use only abbreviations as per list #16
Length: 2
Leave blank if in your own country
|
|
K
|
L
|
M
|
N
|
O
|
P
|
Q
|
|
Phone
|
Fax
|
Mobile
|
Email
|
ContactName
|
GroupID
|
Notes
|
|
Max. 50 characters
|
Max. 50 characters
|
Max. 50 characters
|
Max. 50 characters
|
Max. 50 characters
|
Vendor Group: use ID as per list #9
|
unlimited space
|
|
