Use
Stock Import, a product has multiple stock records, each record should have a unique rotation number.
Limitations
The following has to exist already
...
Optionally the following may be needed
Reserve Customer
Notes
This import originated from an older system so some of the fields are not relevant but remain as part of the standard import tables.
...
[Item only optional not mandatory]
Fields
Field Type | Explanantion |
|---|---|
int | integer fields |
bit | Yes or No fields 1 for Yes and 0 for No |
date | format dd/mm/yy or dd/mm/yyyy |
nvarchar (11) | text field with maximum length 11 |
decimal (8,2) | Decimal field must include the decimal and 00 e.g 42.00 17.00 18.43 26.40 |
...