What is this import?
The Stock Account Data import creates or updates stock accounts in Access Delta WMS. A stock account is the account against which stock is held in the system. It is usually the sender of the data files.
You will typically run this import once, as part of setting up the system for the first time. It is not a day-to-day operation.
Package name: DeltaWMS IE Customer Import V5 File format: CSV
Before you start
Make sure your file:
Includes all mandatory fields (marked M in the table below)
Uses the correct column order
Field specification
CSV Column | Field Name | Type | Max Characters | Required | Notes |
1 | Account Code | AN | 8 | M |
|
3 | Account Name | AN | 30 | M |
|
4 | Address 1 | AN | 30 | Optional |
|
5 | Address 2 | AN | 30 | Optional |
|
6 | Address 3 | AN | 30 | Optional |
|
7 | Address 4 | AN | 30 | Optional |
|
8 | Telephone | AN | 20 | Optional |
|
9 | Fax | AN | 20 | Optional |
|
10 | AN | 80 | Optional |
| |
11 | Answerback | AN | 20 | Optional |
|
12 | Sales Contact | AN | 30 | Optional |
|
13 | Accounts Contact | AN | 30 | Optional |
|
Type key: AN = alphanumeric, N = numeric, A = alphabetic, DT = date, TM = time
Troubleshooting
If your import fails, check:
Column 1 (Account Code) and Column 3 (Account Name) are present and not empty
The file is placed in the correct import directory (USERIMP)