Sales Tracking Import Format

A

1

Customer Code

12

Character

Yes

Enter a valid customer code. For information on setting up customer codes, see Customer Maintenance.

B

2

Product Code

40

Character

Yes

Enter a valid product code. For information on setting up product codes, see Product Maintenance.

C

3

Pick Demand Number

12

Character

No

Enter the pick demand number associated with the sales data.

D

4

Source

7

Character

Yes

Enter the source of the sales data. Enter Sales or Returns.

E

5

Sales Order Number

12

Character

No

Enter the sales order number.

F

6

Shipment Number

25

Character

No

Enter the shipment number associated with the sales data.

G

7

Sales Tracking Number

30

Character

No

Enter the sales tracking number.

H

8

Quantity Shipped

18

>>>,>>>,>>>,>>9.99

No

Enter the quantity of the product shipped.

I

9

Sales Track Level

6

Character

Yes

Enter the sales tracking level for the sales data. Enter either Lot or Serial.