Supplier Product Import Format

NOTE For general information on using imports, see Imports FAQ.

The following table lists the format for importing a record in Supplier Product Import.

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Supplier Code

15

Character

Yes

Enter a valid supplier code for the product. For information on creating supplier codes, see Supplier Maintenance.

B

2

Product Code

40

Character

Yes

Enter a valid product code for the product. For information on creating product codes, see Product Maintenance.

C

3

Supplier's Product Code

20  

Character

No

Enter the product code used by the supplier for the product.

Example The product code for a product is 123 in Product Maintenance. Supplier ABC identifies the product as A314-B6.

D

4

Supplier's Product Name

30

Character

No

Enter the name used by the supplier to identify the product.

E

5

Description

60

Character

No

Enter the description used by the supplier for the product.

F

6

Purchase Increment

16

>>>,>>>,>>9.99<<

No

Enter the purchase increment for the product that can be used on a purchase order. The increment is in the unit of measure entered for the Unit of Measure field.

Example The product can only be ordered in increments of 10 cases from this supplier.

Note If you enter a purchase increment, it is used in Purchase Order Maintenance.

G

7

Minimum Purchase Quantity

16

>>>,>>>,>>9.99<<

No

Enter the minimum quantity that can be ordered on a purchase order. The minimum quantity is in the unit of measure entered for the Unit of Measure field.

Example The product can only be ordered from this supplier if 25 cases or more are ordered.

Note If you enter a minimum purchase quantity, it is used in Purchase Order Maintenance.

H

8

Quality Rating

8

Character

No

Enter the quality rating for the supplier. This rating is only used for reporting.

I

9

Additional Duty Basis

17

 

->>>,>>>,>>9.99<<

No

Enter an amount that is added to the purchasing cost of the product for duty calculations.

J

10

Delivery Rating

8

Character

No

Enter the delivery rating for the supplier. This rating is only used for reporting.

K

11

Lead Time

8

>>>>>>>9

No

Enter the number of days between the purchase order date and the date the product is expected to be received (and available to be sold).

L

12

Tax Category

8

Character

No

Leave this field blank. This field is not used.

M

13

Active

3

Yes/No

No

Enter Yes if the supplier product is currently active or No if it is not. If this field is blank, it defaults to Yes.

N

14

Under Contract

3

Yes/No

No

Enter Yes if your company has a contract with the supplier for the product. If this field is blank, it defaults to No.

O

15

Unit of Measure

8

Character

Yes

Enter a valid purchasing unit of measure for the product. For information on creating units of measure, see Unit of Measure Maintenance.

P

16

Country of Origin

10

Character

No

Enter a valid country code for the product's country of origin. For information on creating country codes, see Country Maintenance.

Q

17

Goal Seek Unit Code

12

Character

No

Enter the goal seek unit code for the supplier product. For information on setting up goal seek unit codes, see Goal Seek Unit Maintenance.

R

18

Goal Seek Unit Count

14

>>>>>>>>9.99<<

No

Enter the goal seek unit count for the supplier product. This value is used to convert the goal seek unit to the default purchasing unit of measure for the supplier product. If this field is blank, it defaults to 1.

S

19

In Transit Lead Time

4

>>>9

No

Enter the in-transit lead time for the product, which is the number of days between when the product is shipped and received. This is used by DRP to calculate purchase order and blanket release ship dates.

Example If the in-transit lead time is 10 days, and the purchase order delivery date is 06/15/2020, the purchase order ship date is calculated as 06/05/2020.

Prerequisites

Before using this import, the following must be set up:

Import Format Notes