Product Category Maintenance

Menu Path: Purchasing Images\bluerarw.gif Module Setup Images\bluerarw.gif Products Images\bluerarw.gif Product Category Maintenance

Alternate Menu Path: Warehouse Management Images\bluerarw.gif Module Setup Images\bluerarw.gif Products Images\bluerarw.gif Product Category Maintenance

Purpose

Define categories of products.

Overview

Use Product Category Maintenance to define product categories. This window has multiple tabs for storing default field values. When creating a new product in Product Maintenance, selecting a product category will use that category’s defaults.

Note After a product has been created with product category defaults, any subsequent changes or updates to that product category have no effect on the created product. The product category's changes only affect products created after the product category was updated. After a product record is created, any changes or updates to the product should be made at the product level in Product Maintenance. If the product record is assigned to locations, after changes are made to a product record, you are asked if you want to add changes to the locations. You should select the appropriate locations for which the changes have taken place. If this step is not performed, changes will not be associated with the product's locations.

You can also import product categories in Product Category Import.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Product Category Maintenance window.

New

Click this button to create a new product category.

Update

Click this button to edit the selected product category.

Delete

Click this button to delete the selected product category.

OK

Click this button to accept an action. This button is only available if you click the New, Update, or Delete button in the ribbon.

Cancel

Click this button to cancel an action. This button is only available if you click the New, Update, or Delete button in the ribbon.

First

Click this button to display the first product category.

Prev

Click this button to display the previous product category.

Next

Click this button to display the next product category.

Last

Click this button to display the last product category.

Fields and Buttons

Field or Button

Description

Category

Enter a product category, or click the Lookup button to select a previously created product category.

Short Description

Enter a brief description of the product category.

General Tab Fields and Buttons

Field or Button

Description

Supplier Code

Enter the supplier code of the primary supplier for the product category, or click the Lookup button to select the supplier code. For more information, see Supplier Maintenance and Supplier Code and Name.

Name

Enter the supplier name of the primary supplier for the product category, or click the Lookup button to select the supplier name. For more information, see Supplier Maintenance and Supplier Code and Name.

Primary Buyer

Enter the user ID of the buyer generally responsible for the replenishment of products in the product category, or click the Lookup button to select a user ID.

Secondary Buyer

Enter the user ID of a secondary buyer responsible for replenishment of products in the product category, or click the Lookup button to select a user ID.

Sales Tax Category

Enter the sales tax category for products in the product category, or click the Lookup button to select a sales tax category. Sales tax categories are used to group similar products for sales tax calculations. For more information, see Sales Tax Category Maintenance and Sales Tax Rate Maintenance. This field is only available when the internal tax functionality is used.

Hazard Code

Enter a hazard code if one is required for products in the product category, or click the Lookup button to select a hazard code. Hazard codes are identification codes for products that have special handling, selling, or purchasing requirements (such as products for the chemical materials industry). Hazard codes are defined and maintained in Hazardous Material Maintenance.

Cost Class

Enter a cost class for products in the product category, or click the Lookup button to select a cost class. 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.

Stocking U/M

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

Commission Class

Enter the commission class for products in the product category, or click the Lookup button to select a commission class. You can use commission classes to group together similar products for sales representative commission calculations. For more information, see Commission Class Maintenance.

Order Minimum

Enter the minimum order quantity users are allowed to enter 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 in 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.

Buying Method

Enter the buying method for products in the product category, or click the Lookup button to select a buying method. 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 - Select this option to use the default buying method.

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

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

Order Multiple

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).

Images\warning.gif When setting up order minimums and order multiples, be careful if the 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).

Product Code Mask

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

Example Your system is set up with product codes with four elements. The third element is used to indicate the product category. You would enter the third element for each specific category in this field (leaving the other elements blank in this field).

Review Days

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.

Product Status

Enter the current status for products in the product category, or click the Lookup button to select a status. For information on setting up product statuses, see Product Status Maintenance.

Special Product Code

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.

Production Monitoring Class

Enter a supplier production monitoring class for the product category, or click the Lookup button to select a supplier production monitoring class. For information on setting up supplier production monitoring classes, see Monitoring Class Maintenance.

Cycle Class Code

Enter a cycle class code for products in the product category, or click the Lookup button to select a cycle class code. 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.

Commission Cost Charge Type

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, or click the Lookup button to select a drop-ship commission additional charge type. For more information, see Drop-Ship Commission Orders FAQ. For information on setting up additional charge types, see Order Entry Additional Charge Maintenance.

Description

Enter a detailed description of the product category.

Selling Tab Fields and Buttons

Field or Button

Description

Price Class

Enter a price class to group similar products for pricing, or click the Lookup button to select a price class. You can use price classes to create price matrices for price books (groups of customers) in Price Book Price Maintenance or for specific customers in Customer Price Maintenance. For information on setting up price classes, see Price Class Maintenance.

Description

This field displays the description of the selected price class.

Add

Click this button to add the price class to the product category.

Remove

Click this to remove the price class selected in the Price Classes grid from the product category.

Price Classes

This grid displays the price classes for the product category. You can use the arrow buttons to the right of this grid to change the hierarchy of price classes for the product category.

Click this button to move the selected price class up in the price class hierarchy.

Click this button to move the selected price class down in the price class hierarchy.

Market Groups

Select the check box for each market segment and/or market group associated with products in the product category. You can click the plus or minus symbol to the left of a market group to show or hide the market segments in the market group. If you select a market group, all market segments in the market group are selected. For information on setting up market groups and market segments, see Market Group and Segment Maintenance.

Cost Tab Fields and Buttons

Field or Button

Description

Accounting Cost

Click the Lookup button to select an accounting cost basis. 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.

Sales Reporting Cost

Click the Lookup button to select a sales reporting cost basis. The sales reporting cost basis is used in gross margin determination for sales reporting. You can select Average, Standard, LIFO, FIFO, Burden, and Last Cost depending on your specific needs.

Commission Cost

Click the Lookup button to select a commission cost basis. The commission cost basis is used for gross margin determination for commission reporting. You can select Average, Standard, LIFO, FIFO, Burden, and Last Cost depending on your specific needs.

Sales Margin

Select a method for handling sales orders that are below the margin percentage entered in the Min Margin % field or above the margin percentage entered in the Max Margin % field. You can select one of the following:

  • Ignore Margins - Do not check margin percentages.

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

  • Give Warning - 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.

Min Margin %

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 enabled if you select the Place on Hold or Give Warning radio button.

Max Margin %

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 enabled if you select the Place on Hold or Give Warning radio button.

Perform Sanity Check on Product Cost

Select this check box 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 select this check box, enter the cost variance percentage in the Cost Variance % field.

Cost Variance %

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

Allocate X Business Days before Required Date

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

Note If this value is 0 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.

Co-Op Product

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

Amount Per Unit/Percent

Select whether the co-op is calculated based on an amount per unit or percentage. These radio buttons are only enabled if you select the Co-Op Product check box.

Co-Op Amount

Enter the co-op amount for products in the product category. The amount entered represents a monetary amount if the Amount Per Unit radio button is selected, or a percentage if the Percent radio button is selected. This field is only enabled if you select the Co-Op Product check box.

Warehouse Tab Fields and Buttons

Field or Button

Description

Product

This check box is selected to indicate that quantities for products in the product category are tracked.

Location

This check box is selected to indicate that quantities for products in the product category are tracked by location.

Bin

This check box is selected to indicate that quantities for products in the product category are tracked by bin.

Lot

Select this check box if quantities for products in the product category are tracked by lot. This check box is only enabled if you clear the Serial Number check box. 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.

Serial Number

Select this check box if quantities for products in the category are tracked by serial number. This check box is only enabled if you clear the Lot check box. Lot or serial information is required for inbound (receipts), internal (location transfers), and outbound (sales) procedures. For more information, see Serial and Lot Tracking FAQ.

Sales Track At

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

Select one of the following:

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

  • Lot - Track by lot.

  • Serial Number - 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 option. 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.

Hold Inventory for Backorders

Select this check box 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 this check box is selected. If the check box is cleared, all 120 are immediately available for new orders and some backorders may not be released.

Only Release Backorders Manually

Select this check box to allow backorders to only be released in Product Backorder Allocate. If this check box is selected, batch and future inventory allocations cannot be used to release backorders for products in the product category.

Allow Re-Allocation

Select this check box 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.

Allow Larger U/M Picking Recommendations

Select this check box 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 the Allow Larger U/M Picking Recommendations check box is selected, 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.

Allow Smaller U/M Picking Recommendations

Select this check box 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 the Allow Smaller U/M Picking Recommendations check box is selected, the pick demand for this sales order will have a line item for 10 each to assemble to 1 case/10.

Include On Order Quantity in OE Discontinued Validation

Select this check box 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.

Restricted Allocation

Select this check box 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.

Do Not Reclassify

Select this check box to not allow the automatic reclassification of the cycle class code when running product cycle count reclassification for products in the product category.

Pick Method

Enter a pick method for the product category, or click the Lookup button to select a pick method. This defaults to FIFO/UM/SEQ.

Pick Group

Enter a product pick group for the product category, or click the Lookup button to select a product pick group. For information on setting up product pick groups, see Product Pick Group Maintenance. This defaults to the DEFAULT pick group if it exists.

NMFC Number

Enter the National Motor Freight Classification (NMFC) number used for bill of lading printing, or click the Lookup button to select an NMFC number. For information on setting up NMFC numbers, see National Motor Freight Classification Maintenance.

Catch Weight

Select this check box if products in the product category are a random weight. If you select this check box, the fields below it allow you to define a range for the catch weight.

Sanity Over Amount

Enter the acceptable maximum variance amount over the gross packaged weight for products in the product category.

Sanity Under Amount

Enter the acceptable maximum variance amount under the gross packaged weight for products in the product category.

Sanity Over Percent

Enter the acceptable maximum variance percentage over the gross packaged weight for products in the product category.

Sanity Under Percent

Enter the acceptable maximum variance percentage under the gross packaged weight for products in the product category.

Backorder Release Priority

This grid displays the backorder release priority for products in the category. A product that is on backorder can be assigned a backorder release priority hierarchy based on the order date, order class, order priority, or the required date of the order. Use the up and down arrow buttons to rearrange the backorder release priority. If a product in the category is ordered and goes on backorder, its backorder release priority is used to determine the release of the backorder.

Up

Click this button to move the selected backorder release priority higher in the backorder release priority list.

Down

Click this button to move the selected backorder release priority lower in the backorder release priority list.

Product Scan

Select one of the following options:

  • 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.

Quantity Scan

Select one of the following options:

  • 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.

  • Scan Each Item - 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).

  • Enter Quantity - 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.

Accts 1 Tab Fields and Buttons

Field or Button

Description

Sales

Enter all or part of the sales general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Sales Discount

Enter all or part of the sales discount general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Sales Returns

Enter all or part of the returns general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Sales Returns Discount

Enter all or part of the returns discount general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Drop Ship Sales

Enter all or part of the drop-ship sales general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Inventory

Enter all or part of the inventory general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Cost of Goods Sold

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, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

COGS Returns

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, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Returns Expense

Enter all or part of the returns expense general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Transfer Sale

Enter all or part of the transfer sale general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

In Transit

Enter all or part of the in transit general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Ship and Debit

Enter all or part of the ship and debit general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Ship and Debit Variance

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, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Bill and Hold Clearing

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, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Bill and Hold Variance

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, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Manufacturing Accts Tab Fields and Buttons

Field or Button

Description

Inventory

Enter all or part of the inventory general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Work in Process - Material

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, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Work in Process - Labor

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, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Work in Process - Overhead

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, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Work in Process - Outside Processing

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, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Absorbed - Labor

Enter all or part of the absorbed labor general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Absorbed - Overhead

Enter all or part of the absorbed overhead general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Absorbed - Outside Processing

Enter all or part of the absorbed outside processing general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Variance - Labor

Enter all or part of the variance labor general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Variance - Overhead

Enter all or part of the variance overhead general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Variance - Outside Processing

Enter all or part of the variance outside processing general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Scrap Expenses

Enter all or part of the scrap expenses general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Accts 2 Tab Fields and Buttons

Field or Button

Description

Stock Adj. Expense

Enter all or part of the adjustments expense general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Transfer Buy

Enter all or part of the transfer buy general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Standard Cost Var

Enter all or part of the standard cost variance general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Transfer Expense

Enter all or part of the transfer expense general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

A/P Inventory Recon

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, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Drop Ship Cost of Good Sold

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, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Drop Ship In Transit

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, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Catch Weight Variance

Enter all or part of the catch weight variance general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element.

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.

Lot Expiration

Enter all or part of the lot expiration general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element.

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.

VAT Accts

Note This tab is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.

Field or Button

Description

Input VAT Clearing

Enter all or part of the input VAT clearing general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Input VAT

Enter all or part of the input VAT general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Input VAT Write-off

Enter all or part of the input VAT write-off general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Input VAT Pending

Enter all or part of the input VAT pending general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Output VAT

Enter all or part of the output VAT general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

Output VAT Variance

Enter all or part of the output VAT variance general ledger account to use when resolving the account from products in the product category, or click the Lookup button to display G/L Prompting, which allows you to select all or part of an account by element. 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.

U/M Tab Fields and Buttons

Field or Button

Description

Available U/M

This grid displays available units of measure for products in the category. For each unit of measure, the unit of measure code and name are displayed. When creating a new product category, this grid only displays units of measure after you enter a unit of measure in the Stocking U/M field on the General tab.

Add

Click this button to add the unit of measure selected in the Available U/M grid to the Selected U/M grid.

Add All

Click this button to add all the units of measure in the Available U/M grid to the Selected U/M grid.

Remove

Click this button to remove the selected unit of measure from the Selected U/M grid.

Remove All

Click this button to remove all units of measure from the Selected U/M grid.

Selected U/M

This grid displays the selected units of measure for products in the category. This grid can contain multiple units of measure, but only one unit of measure can be used as the default selling, default purchasing, and default display unit of measure. When creating a new product category, this grid automatically includes the unit of measure entered in the Stocking U/M field on the General tab.

For definitions of all unit of measure columns, see Unit of Measure Fields FAQ.

Profitability Tab Fields and Buttons

Field or Button

Description

Profit Category Code Sales (Customer)

Enter a customer scorecard profit category code for sales for the product category, or click the Lookup button to select a customer scorecard profit category code. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

Profit Subcategory Code Sales  (Customer)

Enter a customer scorecard profit subcategory code for sales for the product category, or click the Lookup button to select a customer scorecard profit subcategory code. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

Profit Category Code Cost (Customer)

Enter a customer scorecard profit category code for costs for the product category, or click the Lookup button to select a customer scorecard profit category code. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

Profit Subcategory Code Cost  (Customer)

Enter a customer scorecard profit subcategory code for costs for the product category, or click the Lookup button to select a customer scorecard profit subcategory code. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

Profit Category Code Sales  (Supplier)

Enter a supplier scorecard profit category code for sales for the product category, or click the Lookup button to select a supplier scorecard profit category code. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance..

Profit Subcategory Code Sales (Supplier)

Enter a supplier scorecard profit subcategory code for sales for the product category, or click the Lookup button to select a supplier scorecard profit subcategory code. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance..

Profit Category Code Cost (Supplier)

Enter a supplier scorecard profit category code for costs for the product category, or click the Lookup button to select a supplier scorecard profit category code. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance..

Profit Subcategory Code Cost (Supplier)

Enter a supplier scorecard profit subcategory code for costs for the product category, or click the Lookup button to select a supplier scorecard profit subcategory code. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance..

Profit Category Code Sales (Product)

Enter a product scorecard profit category code for sales for the product category, or click the Lookup button to select a product scorecard profit category code. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance..

Profit Subcategory Code Sales (Product)

Enter a product scorecard profit subcategory code for sales for the product category, or click the Lookup button to select a product scorecard profit subcategory code. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance..

Profit Category Code Cost (Product)

Enter a product scorecard profit category code for costs for the product category, or click the Lookup button to select a product scorecard profit category code. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance..

Profit Subcategory Code Cost (Product)

Enter a product scorecard profit subcategory code for costs for the product category, or click the Lookup button to select a product scorecard profit subcategory code. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance..

VAT Tab Fields and Buttons

Note This tab is only available if Show is selected for the VAT Display Level field in Tax Control Maintenance.

Field or Button

Description

Country

Enter a country code for which you want to enter VAT information for the product category, or click the Lookup button to select a country. For information on setting up countries, see Country Maintenance.

VAT Class Code

Enter a VAT class code associated with the entered country for the product category, or click the Lookup button to select a VAT class code. For information on setting up VAT class codes, see VAT Class Maintenance.

VAT Exempt

Select this check box if products in the product category are exempt from VAT in the entered country.

VAT Exempt Reason Code

Enter a VAT exempt reason code to explain why orders for the country are exempt from VAT, or click the Lookup button to select a VAT exempt reason code. For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance.

Add

Click this button to add the country-specific VAT information to the product category.

Remove

Click this button to remove the country-specific VAT information from the Selected VAT Class grid.

Selected VAT Class

This grid displays country-specific VAT classes and reasons for the product category.