The data file to import Suppliers must consist of seventeen (17) comma separated columns. The columns must be in the following order:
Column |
Field |
Required/Optional |
Description |
1 |
Supplier Name |
Required |
The supplier name must not exist in Pinnacle yet. |
2 |
Short Name |
Required |
The supplier short name must not exist in Pinnacle yet. |
3 |
Address |
Optional |
|
4 |
Post Code |
Optional |
|
5 |
Phone Number |
Optional |
|
6 |
Fax Number |
Optional |
|
7 |
E-mail Address |
Optional |
|
8 |
Contracts |
Optional |
|
9 |
Products |
Optional |
|
10 |
Comments |
Optional |
|
11 |
Tax Registered |
Optional |
The value for this field must be 'Y' for Yes, or 'N' for no. This will default to 'N' if no value is supplied. |
12 |
A.C.N. |
Optional |
|
13 |
A.B.N. |
Optional |
If the Tax Registered column is set to 'Y', this field must not be blank. |
14 |
Contact |
Optional |
|
15 |
Payee Name |
Optional |
|
16 |
Payee Address |
Optional |
|
17 |
Payee Post Code |
Optional |
|