JCIFQ Import Quisine Data

<< Click to Display Table of Contents >>

Navigation:  Welcome to Maxim Help Articles >

JCIFQ Import Quisine Data

Previous pageReturn to chapter overviewNext page

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.