Product Category Import Format

A

1

Line Type

3

Character

Yes

Enter CAT to specify a product category record.

B

2

Product Category

12

Character

Yes

Enter a product category.

C

3

Short Description

30

Character

Yes

Enter a brief description of the product category.

D

4

Supplier Code

15

Character

No

Enter a valid supplier code of the primary supplier for the product category. For more information, see Supplier Maintenance and Supplier Code and Name.

E

5

Review Days

4

9999

No

Enter the number of days products in the product category are reviewed for determining purchase levels. This field is used for the Demand Forecasting buying method.

F

6

Primary Buyer

60

Character

No

Enter a valid user ID of the buyer generally responsible for the replenishment of products in the product category. For information on setting up users, see User Profile Maintenance.

G

7

Secondary Buyer

60

Character

No

Enter a valid user ID of a secondary buyer responsible for replenishment of products in the product category. For information on setting up users, see User Profile Maintenance.

H

8

Special Product Code

2

Character

No

Enter a user-defined special product code for products in the category. You can track products defined with special product codes in Customer Special Product Analysis and Sales Representative Special Product Analysis. For more information, see Special Product Tracking.

I

9

Sales Tax Category

12

Character

No

Enter a valid sales tax category for products in the product category. You can use sales tax categories to group similar products for sales tax calculations. For more information, see Sales Tax Category Maintenance and Sales Tax Rate Maintenance.

NOTE This field is ignored when AvaTax interface is used.

J

10

Hazard Code

10

Character

No

Enter a valid hazard code if one is required for products in the product category. Hazard codes are identification codes for products that have special handling, selling, or purchasing requirements (such as products for the chemical materials industry). For information on setting up hazard codes, see Hazardous Material Maintenance.

K

11

Price Classes

Character

No

Enter valid price classes for products in the product category. Separate each price class with the following delimiter character: |

Example PriceClassA|PriceClassB|PriceClassC

You can use price classes to group similar products for pricing, and to create price matrices for price books (groups of customers) in Price Book Price Maintenance or for specific customers in Customer Price Maintenance.

The order of price classes in this field determines the hierarchy for the product category's price classes.

For information on setting up price classes, see Price Class Maintenance.

L

12

Stocking Unit of Measure

8

Character

No

Enter a valid stocking unit of measure for products in the product category.

M

13

Cost Class

10

Character

No

Enter a valid cost class for products in the product category. You can use cost classes to group similar products so that a single cost may be assigned by cost class in Purchase Cost Matrix Maintenance. Cost classes are defined and maintained in Purchase Cost Class Maintenance, and are then used to create cost matrix records.

N

14

Order Minimum

9

>>>,>>9.99

No

Enter the minimum order quantity allowed to be entered during sales order entry for products in the product category (in the stock, or lowest level unit of measure).

Note If there is an order multiple value entered for the Order Multiple field, the order minimum must be specified in that order multiple value. For example, if an order multiple is 4 each, then the order minimum must be one of the following: 4, 8, 12, etc.

O

15

Commission Class

12

Character

No

Enter a valid commission class for products in the product category. You can use commission classes to group similar products for sales representative commission calculations. For information on setting up commission classes, see Commission Class Maintenance.

P

16

Order Multiple

9

>>>,>>9.99

No

Enter the order quantity multiple users are allowed to enter during sales order entry for products in the product category (in the stock, or lowest level unit of measure).

When setting up order minimums and order multiples, be careful if a product has multiple units of measure defined so that expected results are achieved.

Example A product has a stock, or lowest unit of measure of each, an inner pack unit of measure equal to three eaches, and a master carton unit of measure equal to 30 eaches. The order minimum is set up as six eaches and the order multiple is set up as four eaches. If an order is entered for two inner packs, it has met the minimum requirement (six), but not the multiple (six is not evenly divisible by four). So, the software either warns the user or rounds down (for information on specifying how this situation is handled, see Customer Service Control Maintenance).

Q

17

Buying Method

20

Character

No

Enter the buying method for products in the product category. The buying method determines how a product is purchased. For information on setting up buying methods, see Buying Method Maintenance.

The following buying methods are available by default:

• Default - This is the default buying method.

• Min-Max - Use the min-max buying method. Products will be ordered for up to the maximum stocking level for the product. If you enter this option, you can use Min-Max Buying Recommendations to create purchase orders based on a single location and buying ID.

• Demand Forecasting - Enter this option if you will use third-party demand forecasting software for purchasing.

If this field is blank, it defaults to Default.

R

18

Product Code Mask

40

Character

No

Enter a valid product code mask for any product code element(s) you want to default for products in the product category.

S

19

Product Status

12

Character

No

Enter a valid current status for products in the product category. For information on setting up product statuses, see Product Status Maintenance.

T

20

Profit Category Code Sales (Customer)

12

Character

No

Enter a valid customer scorecard profit category code for sales for the product category. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

U

21

Profit Subcategory Code Sales (Customer)

12

Character

No

Enter a valid customer scorecard profit subcategory code for sales for the product category. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

V

22

Profit Category Code Cost (Customer)

12

Character

No

Enter a valid customer scorecard profit category code for costs for the product category. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

W

23

Profit Subcategory Code Cost (Customer)

12

Character

No

Enter a valid customer scorecard profit subcategory code for costs for the product category. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

X

24

Profit Category Code Sales (Supplier)

12

Character

No

Enter a valid supplier scorecard profit category code for sales for the product category. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

Y

25

Profit Subcategory Code Sales (Supplier)

12

Character

No

Enter a valid supplier scorecard profit subcategory code for sales for the product category. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

Z

26

Profit Category Code Cost (Supplier)

12

Character

No

Enter a valid supplier scorecard profit category code for costs for the product category. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

AA

27

Profit Subcategory Code Cost (Supplier)

12

Character

No

Enter a valid supplier scorecard profit subcategory code for costs for the product category. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

AB

28

Profit Category Code Sales (Product)

12

Character

No

Enter a valid product scorecard profit category code for sales for the product category. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

AC

29

Profit Subcategory Code Sales (Product)

12

Character

No

Enter a valid product scorecard profit subcategory code for sales for the product category. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

AD

30

Profit Category Code Cost (Product)

12

Character

No

Enter a valid product scorecard profit category code for costs for the product category. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

AE

31

Profit Subcategory Code Cost (Product)

12

Character

No

Enter a valid product scorecard profit subcategory code for costs for the product category. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

AF

32

Description

240

Character

No

Enter a detailed description of the product category.

AG

33

Accounting Cost

8

Character

No

Enter an accounting cost basis for the product category. The accounting cost basis controls general ledger entry amounts, and therefore, only the GAAP (generally accepted accounting principles) methods of Average, Standard, LIFO, and FIFO are available. Depending on your specific needs, enter one of the following:

• AVG Cost

• Std Cost

• LIFO

• FIFO

If this field is blank, it defaults to AVG Cost.

AH

34

Sales Reporting Cost

8

Character

No

Enter a sales cost basis for the product category. The sales cost basis is used in gross margin determination for sales reporting. Depending on your specific needs, enter one of the following:

• AVG Cost

• Std Cost

• LIFO

• FIFO

If this field is blank, it defaults to AVG Cost.

AI

35

Commission Cost

8

Character

No

Enter a commission cost basis for the product category. The commission cost basis is used for gross margin determination for commission reporting. Depending on your specific needs, enter one of the following:

• AVG Cost

• Std Cost

• LIFO

• FIFO

If this field is blank, it defaults to AVG Cost.

AJ

36

Perform Sanity Check on Product Cost

3

Yes/No

No

Enter Yes if you want the system to display a warning when a product cost is manually entered in Purchase Order Maintenance that varies from the most recent purchase order product cost from the same supplier by a given cost variance percentage. If you enter Yes, enter the cost variance percentage for the Cost Variance Percentage field.

AK

37

Cost Variance Percentage

9

>>>,>>9.99

No

Enter a cost variance percentage if you entered Yes for the Perform Sanity Check on Product Cost field. The cost variance percentage entered in this field is used in performing the sanity check for a cost assigned to a product.

AL

38

Sales Margin

6

Character

No

Enter a method for handling sales orders that are below the margin percentage entered for the Minimum Margin Percentage field or above the margin percentage entered for the Maximum Margin Percentage field. Enter one of the following:

• Ignore - Do not check margin percentages.

• Hold - Place an order on margin hold if the margin is above the maximum margin percentage or below the minimum margin percentage.

• Warn - Display a warning for an order if the margin is above the maximum margin percentage or below the minimum margin percentage.

For more information, see Gross Margin Testing FAQ.

AM

39

Minimum Margin Percentage

6

>>9.99

No

Enter the minimum sales margin percentage for a sales order. If the margin percentage for an order is below this value, the order is either placed on margin hold or a warning is displayed. For more information, see Gross Margin Testing FAQ. This field is only used if you enter Hold or Warn for the Sales Margin field.

AN

40

Maximum Margin Percentage

6

>>9.99

No

Enter the maximum sales margin percentage for a sales order. If the margin percentage for an order is above this value, the order is either placed on margin hold or a warning is displayed. For more information, see Gross Margin Testing FAQ. This field is only used if you enter Hold or Warn for the Sales Margin field.

AO

41

Allocate X Business Days Before Required Date

4

>>>9

No

Leave this field blank if you want to allocate regardless of an order’s required date.

Note If this value is blank and an order is entered with a required date six months in the future, the product will sit on the shelf reserved for that order for six months.

If you only want to reserve products in the product category for orders required within a certain number of business days, enter the number of business days. Business days are calculated based on how your business calendar is set up in Business Calendar Day Maintenance.

Example You allocate inventory 10 days before the required date for Product A. You create an order for this product with an order date of 01/05/2021 and a required date of 01/18/2021. If sufficient inventory exists, it is allocated for Product A on 01/05/2021 because there are nine business days between 01/05/2021 and 01/18/2021. The number of units allocated displays on the Items tab in Order Entry.

AP

42

Co-Op Product

3

Yes/No

No

Enter Yes if products in the product category are co-op products. If you enter Yes, you must select whether the co-op will be calculated based on an amount per unit or percent, and you must enter an amount for the Co-Op Amount field. For more information, see Co-Op Year Maintenance and Co-op Sales Process Flow.

AQ

43

Co-Op Type

7

Character

No

Enter Amount if the co-op is calculated based on an amount per unit or enter Percent if it is based on a percentage. This field is only used if you enter Yes for the Co-Op Product field.

AR

44

Co-Op Amount

11

>>>,>>9.9999

No

Enter the co-op amount for products in the product category. The amount entered represents a monetary amount if you enter Amount for the Co-Op Type field, or a percentage if you enter Percent for that field. This field is only used if you enter Yes for the Co-Op Product field.

AS

45

Track Quantity At Product

3

Yes/No

No

Enter Yes to indicate that quantities for products in the product category are tracked.

AT

46

Track Quantity At Location

3

Yes/No

No

Enter Yes to indicate quantities for products in the product category are tracked by location.

AU

47

Track Quantity At Bin

3

Yes/No

No

Enter Yes to indicate quantities for products in the product category are tracked by bin.

AV

48

Track Quantity At Lot

3

Yes/No

No

Enter Yes if you want quantities for products in the product category to be tracked by lot. You cannot enter Yes for both this field and the Track Quantity At Serial Number field. Lot or serial number information is required for inbound (receipts), internal (location transfers), and outbound (sales) procedures. For more information, see Serial and Lot Tracking FAQ.

AW

49

Track Quantity At Serial Number

3

Yes/No

No

Enter Yes if you want quantities for products in the product category to be tracked by serial number. You cannot enter Yes for both this field and the Track Quantity At Lot field. Lot or serial number information is required for inbound (receipts), internal (location transfers), and outbound (sales) procedures. For more information, see Serial and Lot Tracking FAQ.

AX

50

Hold Inventory for Backorders

3

Yes/No

No

Enter Yes to hold inventory for backorders before releasing inventory to new orders.

Example If a product has 0 available, 100 on backorder, and you receive 120, only 20 are available for new orders if you enter Yes in this field. If the enter No or leave the field blank, all 120 are immediately available for new orders and some backorders may not be released.

AY

51

Only Release Backorders Manually

3

Yes/No

No

Enter Yes to allow backorders to only be released in Product Backorder Allocate. If you enter Yes, batch and future inventory allocations cannot be used to release backorders for products in the product category.

AZ

52

Allow Reallocation

3

Yes/No

No

Enter Yes to permit products in the product category to be reallocated to other sales orders. This is useful for a product if demand exceeds supply and you need to ration the product to multiple customers until there is enough available supply. For more information, see Order Allocation Management.

BA

53

Allow Larger Unit of Measure Picking Recommendations

3

Yes/No

No

Enter Yes to permit a larger unit of measure to be broken down to fulfill a sales order allocation for a smaller unit of measure (upward picking). The alternative is to replenish the smaller unit of measure. Upward picking takes precedence over downward picking.

Note A product has three units of measure - each, case/10, and pallet/100. There are 3 each, 1 case/10, and 1 pallet/100 available. A new sales order is created for 2 case/10. If you allowed upward picking for the product, the pick demand for this sales order will have a line item for 1 case/10 and another line item to break down the pallet/100 to pick another case/10.

BB

54

Allow Smaller Unit of Measure Picking Recommendations

3

Yes/No

No

Enter Yes to permit a larger unit of measure to be assembled from smaller units of measure to fulfill a sales order allocation (downward picking).

Note A product has three units of measure - each, case/10, and pallet/100. There are 11 each, 0 case/10, and 1 pallet/100 available. A new sales order is created for 1 case/10. If you allowed downward picking for the product, the pick demand for this sales order will have a line item for 10 each to assemble to 1 case/10.

BC

55

Include On Order Quantity in Order Entry Discontinued Validation

3

Yes/No

No

Enter Yes to select the Include On Order Quantity in OE Discontinued Validation check box in Product Maintenance by default for products in the product category. This is useful if you want to include the on order quantity in the order validation that occurs for discontinued products during order entry. If the check box in Product Maintenance is cleared, the validation only allows users to order a discontinued product if the sum of the available quantity and any applicable inventory reservations is greater than the ordered quantity. If the check box in Product Maintenance is selected, the on order quantity is added to the sum of the available quantity and inventory reservations and may allow the discontinued product to be ordered.

BD

56

Sales Track At

6

Character

No

Enter a sales tracking level for products in the product category.

Enter one of the following:

• None - Do not track by lot or serial number.

• Lot - Track by lot.

• Serial - Track by serial number.

A product that is tracked at the sales level is assigned a tracking number (lot or serial number) only when the product is shipped. This is in contrast to the Track Quantity At option that requires lot or serial number information for inbound, intra-location, inter-location, and outbound procedures. Inquiries at sales-tracked levels are performed in Sales Tracking Inquiry. For more information, see Serial and Lot Tracking FAQ.

Note If a product is either serial or lot tracked at the inventory level and is sales tracked, the inventory information will default to the sales tracking information. If you only need customer outbound tracking by lot or serial number, use only the Sales Track At options. After a product is created, its tracking level can only be changed if there are no existing inventory records for the product; therefore, it is important to determine appropriate tracking levels for a product.

BE

57

Pick Method

20

Character

No

Enter a valid pick method for the product category.

BF

58

Pick Group

20

Character

No

Enter a valid product pick group for the product category. For information on setting up product pick groups, see Product Pick Group Maintenance.

If this field is blank, it defaults to Default.

BG

59

NMFC Number

16

Character

No

Enter a valid National Motor Freight Classification (NMFC) number used for bill of lading printing. For information on setting up NMFC numbers, see National Motor Freight Classification Maintenance.

BH

60

Catch Weight

3

Yes/No

No

Enter Yes if products in the product category are a random weight. If you enter Yes, the next four fields allow you to define a range for the catch weight.

BI

61

Sanity Over Amount

8

>>,>>9.99

No

Enter the acceptable maximum variance amount over the gross packaged weight for products in the product category. Only use this field if you entered Yes for the Catch Weight field.

BJ

62

Sanity Under Amount

8

>>,>>9.99

No

Enter the acceptable maximum variance amount under the gross packaged weight for products in the product category. Only use this field if you entered Yes for the Catch Weight field.

BK

63

Sanity Over Percent

6

>>9.99

No

Enter the acceptable maximum variance percentage over the gross packaged weight for products in the product category. Only use this field if you entered Yes for the Catch Weight field.

BL

64

Sanity Under Percent

6

>>9.99

No

Enter the acceptable maximum variance percentage under the gross packaged weight for products in the product category. Only use this field if you entered Yes for the Catch Weight field.

BM

65

Sales Account

29

Character

No

Enter all or part of the sales general ledger account to use when resolving the account from products in the product category. For more information on sales accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BN

66

Sales Discount Account

29

Character

No

Enter all or part of the sales discount general ledger account to use when resolving the account from products in the product category. For more information on sales discount accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BO

67

Sales Returns Account

29

Character

No

Enter all or part of the returns general ledger account to use when resolving the account from products in the product category. For more information on returns accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BP

68

Sales Returns Discount Account

29

Character

No

Enter all or part of the returns discount general ledger account to use when resolving the account from products in the product category. For more information on returns discount accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BQ

69

Drop Ship Sales Account

29

Character

No

Enter all or part of the drop-ship sales general ledger account to use when resolving the account from products in the product category. For more information on drop-ship sales accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BR

70

Inventory Account

29

Character

No

Enter all or part of the inventory general ledger account to use when resolving the account from products in the product category. For more information on inventory accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BS

71

Cost of Goods Sold Account

29

Character

No

Enter all or part of the cost of goods sold general ledger account to use when resolving the account from products in the product category. For more information on cost of goods sold accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BT

72

Cost of Goods Sold Returns Account

29

Character

No

Enter all or part of the cost of goods sold returns general ledger account to use when resolving the account from products in the product category. For more information on cost of goods sold returns accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BU

73

Returns Expense Account

29

Character

No

Enter all or part of the returns expense general ledger account to use when resolving the account from products in the product category. For more information on returns expense accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BV

74

Transfer Sale Account

29

Character

No

Enter all or part of the transfer sale general ledger account to use when resolving the account from products in the product category. For more information on transfer sale accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BW

75

In Transit Account

29

Character

No

Enter all or part of the in transit general ledger account to use when resolving the account from products in the product category. For more information on in transit accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BX

76

Stock Adjustment Expense Account

29

Character

No

Enter all or part of the adjustments expense general ledger account to use when resolving the account from products in the product category. For more information on adjustments expense accounts, see Warehouse Management Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BY

77

Transfer Buy Account

29

Character

No

Enter all or part of the transfer buy general ledger account to use when resolving the account from products in the product category. For more information on transfer buy accounts, see Purchasing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

BZ

78

Standard Cost Variance Account

29

Character

No

Enter all or part of the standard cost variance general ledger account to use when resolving the account from products in the product category. For more information on standard cost variance accounts, see Purchasing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CA

79

Transfer Expense Account

29

Character

No

Enter all or part of the transfer expense general ledger account to use when resolving the account from products in the product category. For more information on transfer expense accounts, see Purchasing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CB

80

Accounts Payable Inventory Reconciliation Account

29

Character

No

Enter all or part of the accounts payable inventory variance general ledger account to use when resolving the account from products in the product category. For more information on accounts payable inventory variance accounts, see Purchasing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CC

81

Drop Ship Cost of Goods Sold Account

29

Character

No

Enter all or part of the drop-ship cost of goods sold general ledger account to use when resolving the account from products in the product category. For more information on drop-ship cost of goods sold accounts, see Purchasing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CD

82

Catch Weight Variance Account

29

Character

No

Enter all or part of the catch weight variance general ledger account to use when resolving the account from products in the product category.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CE

83

Lot Expiration Account

29

Character

No

Enter all or part of the lot expiration general ledger account to use when resolving the account from products in the product category.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CF

84

Production Monitoring Class

20

Character

No

Enter a valid supplier production monitoring class for the product category. For information on setting up supplier production monitoring classes, see Monitoring Class Maintenance.

CG

85

Input VAT Clearing Account

29

Character

No

Enter all or part of the input VAT clearing general ledger account to use when resolving the account from products in the product category. For more information on input VAT clearing accounts, see VAT Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CH

86

Input VAT Account

29

Character

No

Enter all or part of the input VAT general ledger account to use when resolving the account from products in the product category. For more information on input VAT accounts, see VAT Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CI

87

Input VAT Write-off Account

29

Character

No

Enter all or part of the input VAT write-off general ledger account to use when resolving the account from the products in the product category. For more information on input VAT write-off accounts, see VAT Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CJ

88

Input VAT Pending Account

29

Character

No

Enter all or part of the input VAT pending general ledger account to use when resolving the account from products in the product category. For more information on input VAT pending accounts, see VAT Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CK

89

Output VAT Account

29

Character

No

Enter all or part of the output VAT general ledger account to use when resolving the account from products in the product category. For more information on output VAT accounts, see VAT Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CL

90

Output VAT Variance Account

29

Character

No

Enter all or part of the output VAT variance general ledger account to use when resolving the account from products in the product category. For more information on output VAT variance accounts, see VAT Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CM

91

Country 1

10

Character

Yes, only if you enter a VAT class code in the VAT Class Code 1 field or a VAT exempt reason code in the VAT Exempt Reason Code 1 field

Enter a valid country code for which you want to associate a VAT class or reason code for the product category. For information on setting up countries, see Country Maintenance.

Note You can set up VAT information for two countries in a single row in the import file.

CN

92

VAT Class Code 1

20

Character

No

Enter a valid VAT class code associated with the country entered for the Country 1 field. For information on setting up VAT class codes, see VAT Class Maintenance.

CO

93

VAT Exempt Reason Code 1

20

Character

No

Enter a valid VAT exempt reason code to explain why orders for the country entered for the Country 1 field are exempt from VAT. For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance.

CP

94

Country 2

10

Character

Yes, only if you enter a VAT class code in the VAT Class Code 2 field or a VAT exempt reason code in the VAT Exempt Reason Code 2 field

Enter a valid country code for which you want to associate a VAT class or reason code for the product category. For information on setting up countries, see Country Maintenance.

Note You can set up VAT information for two countries in a single row in the import file.

CQ

95

VAT Class Code 2

20

Character

No

Enter a valid VAT class code associated with the country entered for the Country 2 field. For information on setting up VAT class codes, see VAT Class Maintenance.

CR

96

VAT Exempt Reason Code 2

20

Character

No

Enter a valid VAT exempt reason code to explain why orders for the country entered for the Country 2 field are exempt from VAT. For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance.

CS

97

Product Scan

7

Character

No

Enter one of the following:

• Default - Require or do not require users to validate (scan) products in the product category for Wireless Warehouse picking based on whether the Product check box is selected for picking in Zone Task Options.

• Yes - Require users to scan products in the product category for Wireless Warehouse picking. If you select this option, it overrides the Product check box in Zone Task Options.

• No - Do not require users to scan products in the product category for Wireless Warehouse picking. If you select this option, it overrides the selected Product check box option in Zone Task Options.

CT

98

Quantity Scan

7

Character

No

Enter one of the following:

• Default - Require users to scan or enter product quantities for Wireless Warehouse picking based on the Quantity Scan option selected for picking in Zone Task Options.

• Each - Require users to scan every product, one at a time, and keep track of the count during Wireless Warehouse picking. If you select this option, it overrides the selected Quantity Scan option in Zone Task Options.

Example If you select this option and a user is picking 15 cases, the user must scan each case (15 scans).

• Qty - Require users to enter quantities manually during Wireless Warehouse picking. If you select this option, it overrides the selected Quantity Scan option in Zone Task Options.

CU

99

Cycle Class Code

12

Character

No

Enter a valid cycle class code for products in the product category. The cycle class code is used to group together similar products and locations for Wireless Warehouse cycle counting. For information on setting up cycle class codes, see Product Cycle Count Class Maintenance.

CV

100

VAT Exempt 1

3

Yes/No

No

Enter Yes if products in the product category are exempt from VAT for the country entered for the Country 1 field.

CW

101

VAT Exempt 2

3

Yes/No

No

Enter Yes if products in the product category are exempt from VAT for the country entered for the Country 2 field.

CX

102

Work in Process - Labor

29

Character

No

Enter all or part of the labor work in process general ledger account to use when resolving the account from products in the product category. For more information on labor work in process accounts, see Manufacturing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CY

103

Work in Process - Material

29

Character

No

Enter all or part of the material work in process general ledger account to use when resolving the account from products in the product category. For more information on material work in process accounts, see Manufacturing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

CZ

104

Work in Process - Outside Processing

29

Character

No

Enter all or part of the outside processing work in process general ledger account to use when resolving the account from products in the product category. For more information on outside processing work in process accounts, see Manufacturing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DA

105

Work in Process - Overhead

29

Character

No

Enter all or part of the overhead work in process general ledger account to use when resolving the account from products in the product category. For more information on overhead work in process accounts, see Manufacturing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DB

106

Scrap Expenses

29

Character

No

Enter all or part of the scrap expenses general ledger account to use when resolving the account from products in the product category. For more information on scrap expenses accounts, see Manufacturing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DC

107

Inventory (Manufacturing)

29

Character

No

Enter all or part of the inventory general ledger account to use when resolving the account from products in the product category. For more information on inventory accounts, see Manufacturing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DD

108

Variance - Labor

29

Character

No

Enter all or part of the variance labor general ledger account to use when resolving the account from products in the product category. For more information on variance labor accounts, see Manufacturing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DE

109

Variance - Outside Processing

29

Character

No

Enter all or part of the variance outside processing general ledger account to use when resolving the account from products in the product category. For more information on variance outside processing accounts, see Manufacturing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DF

110

Variance - Overhead

29

Character

No

Enter all or part of the variance overhead general ledger account to use when resolving the account from products in the product category. For more information on variance overhead accounts, see Manufacturing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DG

111

Absorbed - Labor

29

Character

No

Enter all or part of the absorbed labor general ledger account to use when resolving the account from products in the product category. For more information on absorbed labor accounts, see Manufacturing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DH

112

Absorbed - Outside Processing

29

Character

No

Enter all or part of the absorbed outside processing general ledger account to use when resolving the account from products in the product category. For more information on absorbed outside processing accounts, see Manufacturing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DI

113

Absorbed - Overhead

29

Character

No

Enter all or part of the absorbed overhead general ledger account to use when resolving the account from products in the product category. For more information on absorbed overhead accounts, see Manufacturing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DJ

114

Drop Ship In Transit

29

Character

No

Enter all or part of the drop-ship in transit general ledger account to use when resolving the account from products in the product category. For more information on drop-ship in transit accounts, see Purchasing Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DK

115

Restricted Allocation

3

Yes/No

No

Enter Yes to automatically put all sales order line items for products in the product category on backorder even if inventory is available. This ensures that allocation of the products are monitored.

DL

116

Ship and Debit

29

Character

No

Enter all or part of the ship and debit general ledger account to use when resolving the account from products in the product category. For more information on ship and debit accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DM

117

Ship and Debit Variance

29

Character

No

Enter all or part of the ship and debit variance general ledger account to use when resolving the account from products in the product category. For more information on ship and debit variance accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DN

118

Bill and Hold Clearing

29

Character

No

Enter all or part of the bill and hold clearing general ledger account to use when resolving the account from products in the product category. For more information on bill and hold clearing accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DO

119

Bill and Hold Variance

29

Character

No

Enter all or part of the bill and hold variance general ledger account to use when resolving the account from products in the product category. For more information on bill and hold variance accounts, see Customer Service Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from products in the product category. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

DP

120

Commission Cost Charge Type

12

Character

No

Enter a drop-ship commission additional charge type to use for products in the product category on drop-ship commission orders for which commissions are based on costs. For more information, see Drop-Ship Commission Orders FAQ. For information on setting up additional charge types, see Order Entry Additional Charge Maintenance.

A

1

Line Type

2

Character

Yes

Enter UM to specify a product category unit of measure record.

B

2

Product Category

8

Character

Yes

Enter a product category for which you want to specify a unit of measure.

C

3

Unit of Measure

8

Character

Yes

Enter a unit of measure for the product category entered for the Product Category field.

D

4

Sell

3

Yes/No

No

Enter Yes if products for the product category can be sold in the unit of measure entered for the Unit of Measure field.

Note Any unit of measure is allowed for return orders.

EXAMPLE You only want to sell a product by the case, but you allow cans in a case to be returned for credit. Enter No for this field for the cans unit of measure and enter Yes for this field for the case unit of measure.

E

5

Purchase

3

Yes/No

No

Enter Yes if products for the product category can be purchased in the unit of measure entered for the Unit of Measure field.

F

6

Pick

3

Yes/No

No

Enter Yes if products for the product category can be picked in the unit of measure entered for the Unit of Measure field.

G

7

Default Sell

3

Yes/No

No

Enter Yes if the unit of measure entered for the Unit of Measure field is the default unit of measure for sales and transfer orders of products in the product category. You can sell products in more than one unit of measure, but you can only define one default. The O/E Line Item Entry window uses this unit of measure.

Note The default selling unit of measure is also used for price matrix definitions.

H

8

Default Purchase

3

Yes/No

No

Enter Yes if the unit of measure entered for the Unit of Measure field is the default purchasing unit of measure for products in the product category. You can purchase in more than one unit of measure, but you can only define one default. Demand forecasting, Min-Max Buying Recommendations, and Purchase Order Maintenance use this unit of measure.

I

9

Default Display

3

Yes/No

No

Enter Yes if the unit of measure entered for the Unit of Measure field is the default unit of measure to use for displaying products in the product category in inquiries and reports.

J

10

Default Receipt

3

Yes/No

No

Enter Yes if the unit of measure entered for the Unit of Measure field is the default unit of measure for receiving products in the product category, regardless of the purchasing unit of measure.

Note The software keeps track of inventory by unit of measure. Inventory by unit of measure is used during pick demand creation. For example, if your supplier requires your purchase order for a product to be in a master case unit of measure, but you want to put it away as eaches, you would set the default receipt unit of measure to each.

K

11

Web

3

Yes/No

No

Enter Yes if products for the product category can be sold on the customer portal site in the unit of measure entered for the Unit of Measure field.

L

12

Break-to Unit of Measure

8

Character

No

If the unit of measure entered for the Unit of Measure field can be broken down into a smaller unit of measure (or assembled up to a larger unit of measure), enter the unit of measure. If nothing is entered, it is assumed that the unit of measure cannot be broken down (or assembled up).

M

13

Pick Sequence Group

12

Character

No

Enter a valid pick sequence group for the unit of measure entered for the Unit of Measure field. For information on setting up pick sequence groups, see Pick Sequence Group Maintenance.

N

14

Can be Packaged

3

Yes/No

No

Enter Yes if the unit of measure can be packaged into other larger packages for picking cartonization. If you enter No, this unit of measure is a package and cannot be put into a larger package.