JCIFQ Import Quisine Data
<< Click to Display Table of Contents >> JCIFQ Import Quisine Data |
![]() ![]() ![]() |
Imports products from a CSV (Comma delimited) file.
The quote levels will be established automatically by the import to quote process.
The import will be aborted if there are invalid product codes or the product cost centre is invalid. An error report is printed.
File format:
A. |
Product Code |
U30 |
(Must be a valid Maxim product code) |
B. |
Quantity |
N6.2 |
|
C. |
ExStockQuantity |
N6.2 |
(If zero, assumes to be purchased) |
D. |
UOM |
U3 |
Not a mandatory field - Maxim will ignore if present |
E. |
BuyPrice |
N8.2 |
|
F. |
Margin% |
N3.2 |
|
G. |
Discount% |
N3.2 |
|
H. |
SellPrice |
N8.2 |
|
I. |
Supplier |
U8 |
If present, is the supplier for the PO and overrides any preferred supplier. |
J. |
ProductDescription |
A90 |
If present will override the product code's name - ie miscellaneous product. |
K. |
Comment |
A60 |
Line comments. |
L. |
StockLocation |
U3 |
If blank, the default location for the product group is used. |