Product Override Import Format

A

1

Product Code

40

Character

Yes

Enter a valid product code for a product you want to have replaced by another product. For information on setting up product codes, see Product Maintenance.

B

2

Override Type

8

Character

No

Enter one of the following:

• All - The override applies to all customers.

• Division - The override applies to only customers in a specific customer division.

• Customer - The override applies to only a specific customer.

If this field is blank, it defaults to All.

C

3

Customer Division ID

12

Character

Yes, only if Division is entered for the Override Type field

Enter a valid customer division ID for the product override. For information on setting up customer divisions, see Customer Division Maintenance.

D

4

Customer Code

12

Character

Yes, only if Customer is entered for the Override Type field

Enter a valid customer code for the product override. For information on setting up customers, see Customer Maintenance.

E

5

Override Product Code

40

Character

Yes

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

F

6

Start Date

10

99/99/9999

No

Enter the first date in a range of effective order dates for the product override. If this field is blank, it defaults to the current date.

G

7

End Date

10

99/99/9999

No

Enter the last date in a range of effective order dates for the product override. If this field is blank, it defaults to the current date.

H

8

Effect in Order Entry

15

Character

No

Enter one of the following options to control how the product override affects orders created in Order Entry:

• Display Warning - Display a warning message in Order Entry for the product override.

• Always Override - Do not display a warning message in Order Entry for the product override.

• No Effect - Do not use the product override in Order Entry. It is only used for DRP.

If this field is blank, it defaults to Display Warning.

I

9

Override Option

31

Character

Yes

Enter one of the following options for the product override:

• Always Override - Always replace the original product with the override product (regardless of inventory levels).

• Available Inventory / Ask - If there is available inventory for the override product, prompt the user whether or not to replace the original product during sales order entry. If there is no available inventory for the override product, leave the original product on the sales order.

NOTE For imported orders, this option functions the same as if you entered the Available Inventory / Don't Ask option.

• Available Inventory / Don't Ask - If there is available inventory for the override product, replace the original product automatically during sales order entry. If there is no available inventory for the override product, leave the original product on the sales order.

J

10

Permanent Replacement

3

Yes/No

No

Enter Yes if you entered All for the Override Type field and you want to permanently replace the product.

Enter No if you do not want to permanently replace the product.

If you enter Yes for this field, DRP forecast creation is calculated by adding the forecast sales for the override product and the product being overridden.

If this field is blank, it defaults to No.

K

11

Ignore Dates If No Inventory

3

Yes/No

No

Enter Yes to ignore the imported product override date range if the product that is being overridden has no inventory. If you enter Yes for this field, and the product that is being overridden has no available quantity and no on order quantity for a specific location, the override is used (regardless of the date range that is imported).

Enter No to not ignore the imported product override date range.

If this field is blank, it defaults to No.