Product Inquiry

If you edit this topic, review Product Maintenance.

Menu Path: Warehouse Management Images\bluerarw.gif Inquiries Images\bluerarw.gif Products Images\bluerarw.gif Product Inquiry

Alternate Menu Path: Purchasing Images\bluerarw.gif Inquiries Images\bluerarw.gif Products Images\bluerarw.gif Product Inquiry

Purpose

View detailed information about products.

Overview

Use Product Inquiry to view all information about your products. This is the inquiry-only mode of Product Maintenance.

Product Inquiry has the following tabs:

Tab

Purpose

General

View a product's description, search name, category, product unit of measure, and other general information.

Buying

View purchasing requirements for a product, including supplier information, minimum and maximum stocking levels, and a buying method.

Selling

View selling requirements for a product, including minimum and maximum margin percentages, and various class information.

Pricing

View pricing requirements for a product, including price classes and various pricing levels.

Cost

View cost methods, and landed cost information.

Profitability

View sales and gross profit for the preceding 12 months, and key customers for a product.

Quality

View sales and returns for the preceding 12 months, quality-related business intelligence, and collaboration Web sites.

Planning

View a CAD image for a product.

Status

View the product life cycle stages of a product.

Warehouse

View sales tracking levels, quantity tracking levels, product unit and cubic weight, count settings and cycle class for physical inventory, and other options for drop shipping a product.

Locations

View related locations for a product.

Unit of Measure

View the various units of measure in which a product can be purchased, sold, and picked. View the default purchasing, selling, and display unit of measure.

Accounts

View various sales, expense, inventory, and other general accounts for resolution.

Other Information

View user-defined fields that contain extra information about a product.

Catch Weights

View catch weight costs and enter estimated weights for suppliers.

VAT

View VAT classes and/or reasons associated with countries for the product.

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

Lot Shipping Rules

View rules for picking lots a specific number of days before lot expiration dates for all or specific customers. This tab is only available for lot-tracked products.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Product Inquiry window.

First

Click this button to display the first product.

Prev

Click this button to display the previous product.

Next

Click this button to display the next product.

Last

Click this button to display the last product.

History

Click this button to display Product History Inquiry, which allows you to view product history information by location. This button is only available if the Buying, Selling, or Profitability tab is displayed.

Product Sales

Click this button to display Product Sales Inquiry, which allows you to view sales for a product based on an invoice date range. This button is only available if the Profitability tab is displayed.

Product/Order

Click this button to display Product / Style Order Inquiry, which allows you to view orders for a selected product. This button is only available if the Selling or Profitability tab is displayed.

Product Location

Click this button to display Product Location Maintenance, which allows you to view and update detailed information for the selected product and the location selected in the Locations of Product grid. This button is only available if the Locations tab is displayed.

Note If you are not authorized to use Product Location Maintenance, Product Location Inquiry appears instead, and allows you to view detailed information for the selected product location.

Inventory Matrix

Click this button to display Inventory Matrix Inquiry, which allows you to view inventory and transaction information for products.

Supplier Product

Click this button to display Supplier Product Inquiry, which allows you to view supplier-specific product information. This button is only available if the Buying tab is displayed.

Auto Additional Charge

Click this button to display Purchase Automatic Additional Charge Management, which allows you to view and delete purchase automatic additional charges for the selected harmonization code. If you are not authorized to use Purchase Automatic Additional Charge Management, Purchase Automatic Additional Charge Inquiry appears instead, and allows you to view purchase automatic additional charges for the selected harmonization code. This button is only available if the Buying tab is displayed.

Purchase Cost Matrix Maintenance/Inquiry

Click this button to display Purchase Cost Matrix Maintenance, which allows you to set up and maintain purchase costs matrixes.

Note If you are not authorized to use Purchase Cost Matrix Maintenance, Purchase Cost Matrix Inquiry appears instead, and allows you to view purchase cost matrixes.

This button is only available if the Buying tab is displayed.

Lifecycle Data Entry

If the icon for this button includes a check mark, a product lifecycle management workflow exists for the product. You can then click this button to display Lifecycle Data Entry, which allows you to enter data for the workflow.

If the icon for this button does not include a check mark, click this button to display Lifecycle Data Entry Management, which allows you to manage workflows for product lifecycle management data entry.

Attachments

Click this button to display Attachment Entry, which allows you to view attachments for a selected product. This button is only available if the General, Quality, or Planning tab is displayed.

Product Notes

Click this button to display Notes Entry, which allows you to view notes for a selected product. This button is only available if the General, Quality, or Planning tab is displayed.

Product Remarks

Click this button to display Product Standard Remark Maintenance, which allows you to view standard remarks that can be placed on output documents. This button is only available if the General tab is displayed.

Approval Number

Click this button to display Approval Number Inquiry, which allows you to view approval numbers for the selected product. A state approval number may be required to purchase and/or sell a product, especially if the product is from the chemical or liquor industry. This button is only available if the Selling tab is displayed.

Commission Rate Inquiry

Click this button to display Commission Rate Inquiry, which allows you to view commission rate and sales representative selection data for the selected product. This button is only available if the Selling tab is displayed.

Profit Site

Click this button to display the profit collaboration Website entered for the product in Collaboration File Maintenance. This button is only available if the Profitability tab is displayed.

Profit Site Setup

This button is only available if the Profitability tab is displayed, and is disabled in this window.

Quality Control Detail

Click this button to display Quality Control Detail Inquiry, which allows you to view defective product information for the product. This button is only available if the Quality tab is displayed. The icon for this button includes a check mark if defective product records exist for the product.

Quality Site

Click this button to display the quality collaboration Website entered for the product in Collaboration File Maintenance. This button is only available if the Quality tab is displayed.

Quality Cube

Click this button to display the quality business intelligence cube entered in BI File Maintenance. This button is only available if the Quality tab is displayed.

Supplier Cube

Click this button to display the supplier business intelligence cube entered in BI File Maintenance. This button is only available if the Quality tab is displayed.

Quality Site (Setup)

This button is only available if the Quality tab is displayed, and is disabled in this window.

Quality Cube (Setup)

This button is only available if the Quality tab is displayed, and is disabled in this window.

Supplier Cube (Setup)

This button is only available if the Quality tab is displayed, and is disabled in this window.

Return Analysis

Click this button to display Returns Analysis Report, which allows you to create a report of return orders. This button is only available if the Quality tab is displayed.

Design

Click this button to display the design collaboration Website entered for the product in Collaboration File Maintenance. This button is only available if the Planning tab is displayed.

Customer

Click this button to display the customer collaboration Website entered for the product in Collaboration File Maintenance. This button is only available if the Planning tab is displayed.

Market Research

Click this button to display the market research collaboration Website entered for the product in Collaboration File Maintenance. This button is only available if the Planning tab is displayed.

Supplier

Click this button to display the supplier collaboration Website entered for the product in Collaboration File Maintenance. This button is only available if the Planning tab is displayed.

Design Site

This button is only available if the Planning tab is displayed, and is disabled in this window.

Customer Site

This button is only available if the Planning tab is displayed, and is disabled in this window.

Market Research Site

This button is only available if the Planning tab is displayed, and is disabled in this window.

Supplier Site

This button is only available if the Planning tab is displayed, and is disabled in this window.

Bill of Material

Click this button to display Bill of Material Maintenance, which allows you to define and maintain bill of materials. This button is only available if the Planning tab is displayed.

BOM Import

Click this button to display Bill of Material Import, which allows you to import bills of material from an external file. This button is only available if the Planning tab is displayed.

Product User Defined Field Update

Click this button to display Product User Defined Field Update, which allows you to update the value of the fourth product user-defined field for the selected product. This button is only available if the Other Information tab is displayed, if at least one invoice or credit memo exists for the product, and if incentives or incentive goals exist.

Fields and Buttons

Field or Button

Description

Product Code

Enter the product's identification code, or click the Lookup button to select a product code. The format of the code is set up in Product Code Length Maintenance and Product Code Element Maintenance.

Elements

Click this button to display Product Prompting, which allows you to view or select a product by elements (if more than one element is defined). For more information, see Product Code Length Maintenance.

Product Name

Enter the product's name, or click the Lookup button to select a product name.

Navigate by

Select whether to navigate by product code or name when you click the First, Prev, Next, and Last buttons in the ribbon.

General Tab Fields and Buttons

Field or Button

Description

Description

This field displays a short description of the product. This description can be used for searching by product.

Product Style

This field displays the style for the product. The style is used as another search criterion in Lookup windows for rapid selection. In Order Entry, during line item entry, you can enter the product style and a list of products with that product style will appear. For information on setting up product styles, see Style Maintenance.

Search Name

This field displays a search name for the product. The search name is used as another search criterion in Lookup windows for rapid selection. In O/E Line Item Entry, users can enter the search name in the Product Code field instead of the product code.

Size Code

This field displays the size of the product. A size code can be used in conjunction with a product style. For information on setting up sizes, see Size Maintenance.

Product U/M

This field displays the smallest inventory transaction unit of measure for the product.

Example A canned product is only sold in cases, but the customer can return damaged cans for credit. If these cans are restocked and resold (at a discount, for example), then the smallest unit of measure is can, not case. If these cans are thrown (or given) away, then the smallest unit of measure is case, not can.

Units of measure are defined and maintained in Unit of Measure Maintenance.

Color Code

This field displays the color of the product. A color code can be used in conjunction with a product style. For information on setting up colors, see Color Maintenance.

Generate UPC Code

This check box is disabled in this window.

UPC Code

This field displays the product's UPC.

Note If the product has more than one unit of measure, then the unit of measure specific UPC is displayed on the Unit of Measure tab.

Generate UPC at U/M Level

This check box is disabled in this window.

Generate GTIN

This check box is disabled in this window.

GTIN

This field displays the product's GTIN. This is the number that will be used for Electronic Product Code (EPC) and RFID requirements.

Generate GTIN at U/M Level

This check box is disabled in this window.

Category

This field displays the product's category. For more information, see Product Category Maintenance.

Subcategory

This field displays the product's subcategory. A subcategory is an optional hierarchical level below the category. For more information, see Product Subcategory Maintenance.

Merchandise/Service

This field displays whether the product is merchandise or a service. Inventory is tracked for merchandise products, but not for service products. Separate pick demands are created for service products, and these pick demands must be confirmed before you can invoice an associated order.

Example Repackaging services would be set up as a service.

Image File 1

This field displays the path and file name for a product's image file. You can enter the label for this field in the Product Image Label 1 field in Warehouse Management Control Maintenance.

View Image

Click this button to view the product's image file entered in the Image File 1 field.

Delete

This button is not used in this window.

Detail Description

This field displays detailed characteristics of the product. This field can be used for word searching.

Buying Tab Fields and Buttons

Field or Button

Description

Buying Method

This field displays the product's buying method. The buying method determines how a product is purchased. For more information, see Buying Method Maintenance.

The following buying methods are available by default:

  • Default - The default buying method.

  • Demand Forecasting - Use a third-party demand forecasting software for purchasing.

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

Season Class

This field displays the seasonal class for the product. A seasonal class is used exclusively for DRP. For more information, see Seasonal Class Maintenance.

Production Monitoring Class

This field displays the supplier production monitoring class for the product. You can use supplier production monitoring classes to group products for supplier production monitoring rules. For information on setting up supplier production monitoring classes, see Monitoring Class Maintenance.

Internal Buyer

This field displays the user ID of the buyer generally responsible for the replenishment of the product.

Cost Class

This field displays the cost class for the product. Cost classes are used 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.

DRP Product Class Code

This field displays the DRP product class for the product. For information on setting up DRP product classes, see DRP Product Class Maintenance.

Exclude from Goal Seeking

This check box is selected if the product is excluded from goal seek calculations. If this check box is selected, the product will not appear in the Purchase Details grid on the Purchase tab in Summary DRP Management or in output production forecast spreadsheets. For information on goal seek, see Using Goal Seek.

Harmonization Code

This field is disabled in this window.

Add

This button is not used in this window.

Remove

This button is not used in this window.

Harmonization Codes

This grid displays harmonization codes that are associated with the displayed product and the hierarchy of the harmonization codes. The hierarchy is used to determine which purchase automatic additional charge to use when adding duty charges to purchase orders.

This button is not used in this window.

This button is not used in this window.

Minimum Stock Level

This field displays the minimum stocking level for the product. This is used for min-max purchasing and DRP. Both a minimum and maximum stock level is necessary to purchase a product using min-max (Min-Max Buying Recommendations). Stocking levels defined in this field are in the default purchasing unit of measure.

Note If the product is a non-stocked product, this quantity must be zero.

Maximum Stock Level

This field displays a maximum stocking level for the product. This is used for min-max purchasing and DRP. Both a minimum and maximum stock level is necessary to purchase a product using min-max (Min-Max Buying Recommendations). Stocking levels defined in this field are in the default purchasing unit of measure.

Note If the product is a non-stocked product, this quantity must be zero.

Safety Stock

This field displays the safety stock level for the product. The quantity in this field is in the default purchasing unit of measure. This is informational only, and not used in any calculations.

Minimum Purchase Quantity

This field displays the minimum purchase quantity used by purchasing and DRP. The quantity defined in this field is in the default purchasing unit of measure.

For information on how this field impacts DRP calculations, see DRP - Suggested Planned Receipt FAQ.

Purchase Increment

This field displays the purchase increment used by purchasing and DRP. The increment quantity defined in this field is in the default purchasing unit of measure.

For information on how this field impacts DRP calculations, see DRP - Suggested Planned Receipt FAQ.

Perform Sanity Check on Product Cost

This check box is selected if the system performs a sanity check when a product cost is manually entered in Purchase Order Maintenance. If this is selected, a warning appears if the cost varies from the most recent purchase order product cost, from the same supplier, by a given cost variance percentage. If this check box is selected, the cost variance percentage is displayed in the Cost Variance %  field.

Cost Variance %

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

Country of Origin

This field displays the country code for the product's country of origin. For information on setting up country codes, see Country Maintenance.

Review Days

This field displays the number of days the product is to be reviewed in determining purchase levels for the product. This field is used for the Demand Forecasting buying method.

Primary Supplier Code

This field displays the supplier code of the primary supplier for the product. For more information, see Supplier Maintenance and Supplier Code and Name. This field displays Restricted if you are not authorized to access the entered supplier.

Name

This field displays the supplier name of the primary supplier for the product. For more information, see Supplier Maintenance and Supplier Code and Name. This field displays Restricted if you are not authorized to access the entered supplier.

Show Relations

Click this button to refresh the Related Suppliers grid.

Related Suppliers

This grid displays supplier product records for the product. Double-click a record to display Supplier Product Inquiry, which allows you to view supplier-specific product information.

Selling Tab Fields and Buttons

Field or Button

Description

Sales Tax Category

This field displays the product's sales tax category. Sales tax categories are used to group together similar products solely for sales taxation. 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.

Order Minimum

This field displays the minimum order quantity allowed to be entered during sales order entry for the product (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 4, 8, 12, etc.

Excise Tax Category

If the product is subject to excise taxes, this field displays the excise tax category for the product. For information on setting up excise tax categories, see Excise Tax Category Maintenance.

Order Multiple

This field displays the order quantity multiple allowed to be entered during sales order entry (in the stock, or lowest, level unit of measure).

Example A product has a stock, or lowest, unit of measure of each, an inner pack consisting of 3 eaches unit of measure, and a master carton consisting of 30 eaches. The order minimum was set up as 6 eaches and the order multiple was set up as 4 eaches. If an order is entered for 2 inner packs, it has met the minimum requirement (6), but not the multiple (6 is not evenly divisible by 4). So, it would either warn the user or round down (for information on specifying how this situation is handled, see Customer Service Control Maintenance).

Commission Class

This field displays the product's commission class. Commission classes are used to group together similar products solely for sales representative commissions. For more information, see Commission Class Maintenance.

Allocation Minimum

This field displays the minimum quantity that can be allocated for the product in the selling default unit of measure. This can be overridden by the allocation minimum value entered for the product in Product Location Maintenance and Customer Product Maintenance. This value functions in conjunction with the Allocation Qty Min/Mult Automatic and Allocation Qty Min/Mult Manual options in Customer Service Control Maintenance.

Royalty Class

This field displays the product's royalty class if the product is part of a royalty arrangement. For more information, see Royalty Class Maintenance.

Allocation Multiple

This field displays the value of which a multiple can be allocated for the product in the selling default unit of measure. This can be overridden by the allocation multiple value entered for the product in Product Location Maintenance and Customer Product Maintenance. This value functions in conjunction with the Allocation Qty Min/Mult Automatic and Allocation Qty Min/Mult Manual options in Customer Service Control Maintenance.

Bookings Class

This field displays the product's bookings class. For more information, see Bookings Class Maintenance.

Special Product Code

This field displays a user-defined special product code for the product. 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.

Commission Cost Charge Type

This field displays the drop-ship commission additional charge type to use for the product 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.

Catalog Page

This field displays the catalog page on which the product is displayed if your company's products are catalogued. This field is only informational.

Sales Tax Code

Enter the appropriate and unique Avalara tax code for the product, which determines the applicable tax rules and rates for the transaction. This field is only used when the system is integrated with AvaTax. For more information, see AvaTax Interface FAQ.

Place on Hold/Give Warning/Ignore Margins

This field displays the method used for handling sales orders that are below the margin percentage entered in the Min Sales Margin % field or above the margin percentage entered in the Max Sales Margin % field. For more information, see Gross Margin Testing FAQ.

Min Sales Margin %

This field displays the minimum sales margin percentage for a sales order. If the margin for an order falls below this amount, the order is either placed on margin hold or a warning is displayed. For more information, see Gross Margin Testing FAQ. This field only displays a value if the Place on Hold or Give Warning radio button is selected.

Max Sales Margin %

This field displays the maximum sales margin percentage for a sales order. If the margin for an order is above this amount, the order is either placed on margin hold or a warning is displayed. For more information, see Gross Margin Testing FAQ. This field only displays a value if the Place on Hold or Give Warning radio button is selected.

Co-Op Product

This check box is selected if the product is considered a co-op product. If this check box is selected, the co-op is calculated based on an amount per unit or percent, and the amount or percent is displayed in the Co-Op Amount field. For more information, see Co-Op Year Maintenance and Co-op Sales Process Flow.

Co-Op Amount

This field displays the product's co-op amount or percentage. The value 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.

Amount Per Unit/Percent

This field specifies whether the co-op is calculated based on an amount per unit or percent.

Image File 2

This field displays the path and file name for the product's second image file. You can enter the label for this field in the Product Image Label 2 field in Warehouse Management Control Maintenance.

View Image (Image File 2)

Click this button to view the product's image entered in the Image File 2 field.

Delete (Image File 2)

This button is not used in this window.

Image File 3

This field displays the path and file name for the product's third image file. You can enter the label for this field in the Product Image Label 3 field in Warehouse Management Control Maintenance.

View Image (Image File 3)

Click this button to view the product's image entered in the Image File 3 field.

Delete (Image File 3)

This button is not used in this window.

Allow Samples

This check box is selected if the product can be entered as a line item on sample orders.

Sample Frequency Days

This field displays the number of days a customer must wait after receiving a sample of the product before the customer can receive a sample of the product again. If this is 0, there is no limit to how often the customer can receive a sample of the product. The frequency can be overridden by the sample frequency days entered for specific sample reason codes.

Beverage Bottle Size

If the product is a beverage product, these fields display the size and unit of measure of the bottle.

Alcohol Content

If the product is a beverage, enter the alcohol content of the product. This is used in conjunction with excise tax category rules to control reporting.

Market Groups

The check box is selected for each market segment and/or market group associated with the product. 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. For information on setting up market groups and market segments, see Market Group and Segment Maintenance.

Companion Class

This field is disabled in this window.

Companion Class Name

This field is disabled in this window.

This button is not used in this window.

This button is not used in this window.

Companion Classes

This grid displays the product's companion classes if another product is sold as a companion of this product. For more information, see Companion Class Maintenance.

Pricing Tab Fields and Buttons

Field or Button

Description

List Prices

This grid displays the list prices for the product. These prices can be used to manually assign prices for the product in the default selling unit of measure. This grid includes the following columns:

  • List Price Label - This column displays the label for each list price. The labels are set up in Customer Service Control Maintenance. The labels should conform to the types of prices offered by your company, such as wholesale, retail, dealer, etc.

  • Current Price - This column displays the current price for each of the list prices. Prices are defined in two to four decimal places. The prices in this column can be used to create price matrix records in the Multiply against field in Price Book Price Maintenance or Customer Price Maintenance.

  • Effective Date - This column displays the date from which each list price is in effect.

  • Ship and Debit Amount - This column displays the default ship and debit amount for each list price.

  • Free Goods Billback % - This column displays the percentage of cost to bill back to the supplier if the product is shipped free of charge to a customer for each list price.

  • Future Price - This column displays the future price for each list price (if a future price was entered).

  • Future Effective Date - This column displays the date for the next entered price change for the each list price.

Select a list price to display all future prices for it in the Future Prices grid.

NOTE This grid cannot be sorted.

Price

This field is disabled in this window.

Effective Date

This field is disabled in this window.

(Future Price)

This button is disabled in this window.

(Future Price)

This button is disabled in this window.

Future Prices

This grid displays future prices for the selected list price in the List Prices grid.

Default Selling U/M

This field displays the default selling unit of measure for the product.

Price Includes VAT/Price Excludes VAT

The selected radio button indicates whether the product prices include or exclude VAT. This setting is used as the default for the product in Inventory Matrix Inquiry.

Family Price Code

This field displays the family price code for the product. A family price code is used to group together similar products for the purpose of giving a price break on the total quantity ordered for this group of products, instead of the quantity ordered for each product in the group. The family price code entered in this field is used as the default for price matrixes for the product.

Example You sell paint by the case. Each color is packed in a separate case, has a separate product code, and is priced at $10.00 per case. You want to give a special price break for customers that buy 100 cases, regardless of color, of $7.00 per case.

For more information, see Family Price Maintenance.

Price Class

This field is disabled in this window.

Description

This field is disabled in this window.

(Price Class)

This button is disabled in this window.

(Price Class)

This button is disabled in this window.

Price Classes

This grid displays the price classes for the product.

This button is disabled in this window.

This button is disabled in this window.

Cost Tab Fields and Buttons

Field or Button

Description

Accounting Cost

This field displays the product's 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.

Standard Cost

This field displays the standard cost in the product unit of measure. For more information, see cost basis.

Sales Reporting Cost

This field displays the product's sales reporting cost basis. The sales reporting cost basis is used in gross margin determination for sales reporting. Average, Standard, LIFO, FIFO, Burden, and Last Cost can be used depending on your specific needs.

Burden Cost

This field displays the burden cost in the product unit of measure. For more information, see cost basis.

Cost U/M

This field displays the cost unit of measure for the product.

Commission Cost

This field displays the product's commission cost basis. The commission cost basis is used for gross margin determination for commission reporting. Average, Standard, LIFO, FIFO, Burden, and Last Cost can be used depending on your specific needs.

All

Select this check box to view landed costs for all dates.

From

Enter the first date in a range of dates for which to view calculated average landed costs, or click the drop-down arrow to select a date.

To

Enter the last date in a range of dates for which to view calculated average landed costs, or click the drop-down arrow to select a date.

Show Data

Click this button to display calculated average landed costs based on the selected date range.

Type

This field is disabled in this window.

Est. Amount

This field is disabled in this window.

This button is disabled in this window.

Landed Cost

This grid displays details of additional charges included in the landed costs for the product.

The grid includes the following columns:

  • Type - This column displays the type of the additional charge.

  • Estimated Cost - This column displays the estimated costs.

  • Difference - This column displays the difference between the columns based on the selected option in the Difference Based On field.

  • Receipt Cost - This column displays costs captured during a purchase order receipt of a product.

  • Invoiced Cost - This column displays costs that are entered (and captured) during accounts payable invoice reconciliation as the pay amount. Any additional charge that is of type none has a paid cost equal to the receipt cost (This happens because an additional charge of type none never receives an accounts payable invoice). For more information, see Purchase Additional Charges and Landed Cost FAQ.

Difference Based On

Select how landed costs are compared. Landed cost comparisons can be made between:

  • Receipt and estimated costs

  • Receipt and invoiced costs

  • Invoiced and estimated costs

Currency

This field displays the currency for displayed costs.

Product (Estimated)

This field displays the product's estimated cost.

Product (Receipt)

This field displays the product's receipt cost.

Product (Invoiced)

This field displays the product's invoiced cost.

Product (Difference)

This field displays the difference between product costs based on the selected option in the Difference Based On field.

Add. Charges (Estimated)

This field displays the total of all estimated costs of additional charges.

Add. Charges (Receipt)

This field displays the total of the additional charges receipt cost.

Add. Charges (Invoiced)

This field displays the total of the additional charges invoiced cost.

Add. Charges (Difference)

This field displays the difference between additional charges costs based on the selected option in the Difference Based On field.

Total (Estimated)

This field displays the total estimated cost of the product and additional charges.

Total (Receipt)

This field displays the total receipt cost of the product and additional charges.

Total (Invoiced)

This field displays the total invoiced cost of the product and additional charges.

Total (Difference)

This field displays the difference between total costs based on the selected option in the Difference Based On field.

Profitability Tab Fields and Buttons

Field or Button

Description

Profit Category Code Sales (Customer)

This field displays the customer scorecard profit category code for sales for the product. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

Profit Category Code Cost (Customer)

This field displays the customer scorecard profit category code for costs for the product. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

Profit Subcategory Code Sales (Customer)

This field displays the customer scorecard profit subcategory code for sales for the product. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

Profit Subcategory Code Cost (Customer)

This field displays the customer scorecard profit subcategory code for costs for the product. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

Profit Category Code Sales (Supplier)

This field displays the supplier scorecard profit category code for sales for the product. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

Profit Category Code Cost (Supplier)

This field displays the supplier scorecard profit category code for costs for the product. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

Profit Subcategory Code Sales (Supplier)

This field displays the supplier scorecard profit subcategory code for sales for the product. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

Profit Subcategory Code Cost (Supplier)

This field displays the supplier scorecard profit subcategory code for costs for the product. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

Profit Category Code Sales (Product)

This field displays the product scorecard profit category code for sales for the product. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

Profit Category Code Cost (Product)

This field displays the product scorecard profit category code for costs for the product. For information on setting up scorecard profit categories, see Scorecard Profit Category Maintenance.

Profit Subcategory Code Sales (Product)

This field displays the product scorecard profit subcategory code for sales for the product. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

Profit Subcategory Code Cost (Product)

This field displays the product scorecard profit subcategory code for costs for the product. For information on setting up scorecard profit subcategories, see Scorecard Profit Category Maintenance.

Profit Group

This field displays the scorecard profit group for the product. For information on setting up scorecard profit group codes, see Scorecard Profit Group Maintenance.

Profit

This grid displays the sales and gross profit by month for the selected product.

Top Customers

This grid displays the top customers based on units sold of the selected product.

Quality Tab Fields and Buttons

Field or Button

Description

Quality

This grid displays the sales and returns by month for the selected product.

Planning Tab Fields and Buttons

Field or Button

Description

CAD Image

This field displays the path and file name for a CAD image file for the product.

View Image

Click this button to display the CAD image file entered in the CAD Image field.

Delete

This button is not used in this window.

Image File 1

This field displays the primary image file for the product entered in the Image File 1 field on the General tab. You can enter the label for this field in the Product Image Label 1 field in Warehouse Management Control Maintenance.

Status Tab Fields and Buttons

Field or Button

Description

Product Status

This field displays the current status of the product. For more information, see Product Status Maintenance.

Active

This check box is selected if this is an active product. If this check box is selected, users can enter sales orders and purchase orders for the product.

Note If this check box is cleared, users can still enter sales orders and purchase orders for the product. However, the product will not be available for selection in the Lookup window.

Created By

These fields display the user ID of the person who created the product, and the date/time the product was created.

Can Be Sold

This check box is selected if the product can be sold regardless of what quantity is available in inventory. During order processing, the system verifies if this product can be sold by the selling and shipping locations. If there is a record for the product's selling location, the Can Be Sold check box must be selected for that location. If there is no such record, the system will verify if the check box is selected for the product's shipping location.

Update By

These fields display the user ID of the person who last updated the product, and the date/time the product was updated.

Discontinued

This check box is selected if the product is no longer available for sale. Existing inventory of this product can be ordered; however, the product will not go on backorder for insufficient order quantity. This allows for the product to be phased out of inventory. The quantity available and quantity on hand will determine how much of the product can be sold. If there are existing backorders for this product, they must be manually cancelled by the order processor. On the purchasing side, discontinued products are not recommended for purchases in Min-Max Buying Recommendations. You can also exclude discontinued products from 3rd Party Forecasting Export and reports, such as Inventory Status Report. You will still be able to create standalone purchase orders in Purchase Order Maintenance, but when the discontinued product is selected, a warning message appears, which indicates that the product is discontinued. You can then continue processing the purchase order for the product, or remove the discontinued product from the order.

Discontinued Date

This field displays the discontinued date if the product is discontinued. A date is only entered in this field if the Discontinued check box is selected.

Display on Purchase Order Lookup

This check box is selected if the product appears in the Lookup window when entering a purchase order in Purchase Order Maintenance. If this check box is cleared, you cannot view or search for this product during purchase order entry; however, if you type in the product code or name in the appropriate fields, the product can still be ordered.

Include On Order Quantity in OE Discontinued Validation

This check box is selected if the on order quantity of the product is included in the order validation that occurs for discontinued products during order entry. If this check box 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 this check box 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.

Note You can change a product style's status in Style Maintenance to clear this check box for all products in a style.

Display on Order Entry Lookup

This check box is selected if the product appears in the Lookup window accessed during order entry in O/E Line Item Entry. If this check box is cleared, you cannot view or search for this product during order entry; however, if you type in the product code or name in the appropriate fields, the product can still be ordered.

Completed

These check boxes are selected for any product life cycles that are completed. Up to 10 product life cycles can be set up in Purchasing Control Maintenance.

Note These check boxes are only available for fields for which labels are set up.

Completed By

These fields display the user ID of the person that marked the product life cycle as complete. Up to 10 product life cycles can be set up in Purchasing Control Maintenance.

Note These fields are only available for labels that are set up.

Completed Date

These fields display the date the product life cycle was completed. Up to 10 product life cycles can be set up in Purchasing Control Maintenance.

Note These fields are only available for labels that are set up.

Warehouse Tab Fields and Buttons

Field or Button

Description

Product

This check box is selected to indicate that quantity of the product is tracked.

Location

This check box is selected to indicate that quantity of the product is tracked by location.

Bin

This check box is selected for merchandise products or cleared for service products. If it is selected, it indicates the product is tracked by bin.

Lot

This check box is selected if product quantities are tracked by lot. Lot or serial information is required for inbound (receipts), within (location transfers), and outbound (sales) procedures. For more information, see Serial and Lot Tracking FAQ.

Serial Number

This check box is selected if product quantities are tracked by serial number. Lot or serial information is required for inbound (receipts), within (location transfers), and outbound (sales) procedures. For more information, see Serial and Lot Tracking FAQ.

Sales Track at

This field indicates a sales tracking level for lots and serialized products, or neither. A product that is tracked at the sales level is assigned a tracking number (lot or serial) only when the product is shipped. This is in contrast to the Track Quantity At option that requires lot or serial 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, just use the Sales Track at option. After a product has been 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.

Lot Life

This field displays the default number of days after which a lot expires.

Drop Ship Allowed

This check box is selected if the product can be drop shipped to customers. During order processing, if you want to drop ship the product, select the Drop Ship from Supplier check box, and then select a supplier from which the product will be ordered.

Must Drop Ship

This check box is selected if the product must be drop shipped. If this check box is selected, the product is a non-stocked product.

NMFC Number

This field displays the National Motor Freight Classification (NMFC) number used for bill of lading printing. For more information, see National Motor Freight Classification Maintenance.

Package U/M

This field displays the package unit of measure. This unit of measure is used in package building determination.

Example Some products, such as a refrigerators, come in a box from a vendor that is already a packaged unit of measure, and the UCC128 label is placed on the box. When you set up a package unit of measure, you are specifying the packages to create automatically for pick demand confirmation. A pallet of refrigerators has labels on each box so if you are shipping a pallet you still make packages in terms of 1 each refrigerator.

Allow Larger U/M Picking Recommendations

This check box is selected if a larger unit of measure can be broken to fulfill a sales order allocation for a smaller unit of measure. The alternative would be 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 the pallet/100 to pick another case/10.

Allow Smaller U/M Picking Recommendations

This check box is selected if a larger unit of measure can be assembled from smaller units of measure to fulfill a sales order allocation.

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.

Pick Method

This field displays the pick method for the product.

Pick Group

This field displays the product pick group.

Quantity Scan

One of the following options is selected for the product:

  • 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 this option is selected, it overrides the selected Quantity Scan option in Zone Task Options.

Example If this option is selected 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 this option is selected, it overrides the selected Quantity Scan option in Zone Task Options.

Product Scan

One of the following options is selected for the product:

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

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

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

Cycle Class Code

This field displays the cycle class code for the product. 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.

Recount Variance Amt

This field displays the recount variance amount. This field is used in conjunction with Wireless Warehouse cycle counting.

ABC Product Class

This field displays a letter to represent the product class. This field is used in conjunction with paper-based cycle counting. This field displays A for high-value products that can be selected for cycle counting.

Note Only A, B, C ,or X are used in this field.

Recount Variance %

This field displays the recount variance percentage. This field is used in conjunction with Wireless Warehouse cycle counting.

Do Not Reclassify

This check box is selected if the automatic reclassification of the cycle class code is not allowed when running product cycle count reclassification.

Recount Required

This check box is selected if a recount is required for the product. This field is used in conjunction with Wireless Warehouse cycle counting.

Recount Display

This field displays the recount display for the product. This field is used in conjunction with Wireless Warehouse cycle counting.

Count Display

This field displays the count display for the product. This field is used in conjunction with Wireless Warehouse cycle counting.

Non Stocked Item

This check box is selected if the product can be purchased only when there is a sales order. If this check box is selected, the Hold Inventory for Backorders check box must be selected, and the minimum and maximum stock levels on the Buying tab must be zero.

Kit Item

This check box is selected if the product is a kit or phantom assembly. Kits are a compilation of products and/or components that are used to make up a whole product. Kits are set up in Bill of Material Maintenance. If the product is a kit, select the type of kit.

Phantom Assembly / Kit/Config. Kit

This field indicates the type of kit for a product that is a kit, as follows:

  • Phantom Assembly / Kit - A phantom assembly or fixed kit is composed of a fixed set of products and/or components. No alterations to the product mix can be made. For more information, see Fixed Kit FAQ.

  • Config. Kit - A configuration kit is composed of a set of products and/or components where you can change the mix.

These radio buttons are only available if the Kit Item check box is selected.

Allocate X Business Days before Required Date

This field displays the number of business days before the required date on which the product is allocated. 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 the order date 01/05/2021 and the required date = 01/18/2021. If sufficient inventory exists, it will be allocated for Product A on 01/05/2021 because there are 9 business days between 01/05/2021 and 01/18/2021. The number of units allocated displays on the Items tab in Order Entry.

Backorder Release Priority

This field displays the product's backorder release priority. 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.  If the product is ordered and goes on backorder, its backorder release priority is used to determine the release of the backorder.

This button is disabled in this window.

This button is disabled in this window.

Allow Re-Allocation

This check box is selected if the product can be reallocated to other sales orders. This is useful for a product where 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.

Hold Inventory for Backorders

This check box is selected if inventory of the product is held for backorders before releasing inventory to new orders.

Example If a product has 0 available, 100 on backorder, and you receive 120, only 20 become available for new orders if this check box is selected. If the check box is cleared, all 120 become immediately available for new orders and some backorders may end up not being released.

Only Release Backorders Manually

This check box is selected if backorders can 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 this product.

Restricted Allocation

This check box is selected if all sales order line items for the product are put on backorder even if inventory is available.

Dimensional Basis

This field displays the unit of measure (basis) for the height, width, and length on the Unit of Measure tab.

Unit Gross Weight

This field displays the gross unit weight (including packaging) and its weight basis (unit of measure) for the product in its stock unit of measure. Units of measure are defined and maintained in Unit of Measure Maintenance.

Example A 40 lb bag of dog food is 40 net lbs and 41 gross lbs.

Unit Net Weight

This field displays the net unit weight (excluding packaging) and its weight basis (unit of measure) for the product in its stock unit of measure.

Example A 40 lb bag of dog food is 40 net lbs and 41 gross lbs.

Volume

This field displays the cube unit of measure for the product in its stock unit of measure.

Single-single Line Carton Code

This field displays the carton code associated with the product.

Density

This field displays the density of the product. Density is the ratio of mass per volume.

Density Mass Basis

This field displays the unit of measure (basis) for the mass.

Density Volume Basis

This field displays the unit of measure (basis) for the volume.

Hazard Code

This field displays a hazard code if one is required for the product. Hazard codes are identification codes for products that have special handling, selling, or purchasing requirements (usually products for the chemical materials industry). Hazard codes are defined and maintained in Hazardous Material Maintenance.

Hazard Description

This field displays the description of the entered hazard code.

MSDS Number

This field displays the Material Safety Data Sheet (MSDS) number for the product if the product is a hazardous chemical. The MSDS number corresponds to hazards of various chemicals.

Locations Tab Fields and Buttons

Field or Button

Description

Locations of Product

This grid displays the locations from which and to which the product can be bought and sold. For more information on locations, see Sales Location / Shipping Location.

Select a location, and then click the Product Location button in the ribbon to display Product Location Maintenance, which allows you to view and edit detailed information for the selected product and location. You can also double-click a location in this grid to display Product Location Maintenance.

Note If you are not authorized to use Product Location Maintenance, Product Location Inquiry appears instead, and allows you to view detailed information for the selected product location.

Unit of Measure Tab Fields and Buttons

Field or Button

Description

Available Units of Measure

This grid lists available units of measure for the product. For each unit of measure, the unit of measure code, name, and description are displayed.

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

Show U/M

Click this button to display all available units of measure.

This button is disabled in this window.

This button is disabled in this window.

This button is disabled in this window.

This button is disabled in this window.

Product Units of Measure

This grid lists the selected units of measure for the product. This grid can contain multiple units of measure, but only one unit of measure can be used as the default selling, purchasing, display, receipt, and web unit of measure.

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

Accounts Tab Fields and Buttons

Field or Button

Description

Sales

This field displays the sales account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Sales Discount

This field displays the sales discount account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Returns

This field displays the returns account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Returns Discount

This field displays the returns discount account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Drop Ship Sales

This field displays the drop-ship sales account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Drop Ship Cost of Goods Sold

This field displays the drop-ship cost of goods sold account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Drop Ship In Transit

This field displays the drop-ship in transit account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Inventory

This field displays the inventory account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Cost of Goods Sold

This field displays the cost of goods sold account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Cost of Goods Sold Returned

This field displays the cost of goods sold returned account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Returns Expense

This field displays the returns expense account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Ship and Debit

This field displays the ship and debit account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Ship and Debit Variance

This field displays the ship and debit variance account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Bill and Hold Clearing

This field displays the bill and hold clearing account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Bill and Hold Variance

This field displays the bill and hold variance account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Transfer Sale

This field displays the transfer sale account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

In Transit

This field displays the in transit account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Transfer Buy

This field displays the transfer buy account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Transfer Expense

This field displays the transfer expense account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Adjustments Expense

This field displays the adjustments expense account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Standard Cost Variance

This field displays the standard cost variance account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

A/P Inventory Variance

This field displays the accounts payable inventory variance account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Catch Weight Variance

This field displays the cost weight variance account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Lot Expiration

This field displays the lot expiration account to use for the product. General ledger account resolution can be assigned as category defaults in Product Category Maintenance that become the product's default.

For more information, see General Ledger Account Resolution and General Ledger Resolution FAQ.

Elements

This button is disabled in this window.

Input VAT Clearing

This field displays all or part of the input VAT clearing general ledger account to use when resolving the account from the product. For more information on input VAT clearing accounts, see VAT Account Resolution.

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

Input VAT

This field displays all or part of the input VAT general ledger account to use when resolving the account from the product. For more information on input VAT accounts, see VAT Account Resolution.

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

Input VAT Write-off

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

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

Input VAT Pending

This field displays all or part of the input VAT pending general ledger account to use when resolving the account from the product. For more information on input VAT pending accounts, see VAT Account Resolution.

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

Output VAT

This field displays all or part of the output VAT general ledger account to use when resolving the account from the product. For more information on output VAT accounts, see VAT Account Resolution.

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

Output VAT Variance

This field displays all or part of the output VAT variance general ledger account to use when resolving the account from the product. For more information on output VAT variance accounts, see VAT Account Resolution.

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

Inventory

This field displays all or part of the inventory general ledger account to use when resolving the account from the product. For more information on inventory accounts, see Manufacturing Account Resolution.

Work in Process - Material

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

Work in Process - Labor

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

Work in Process - Overhead

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

Work in Process - Outside Processing

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

Absorbed - Labor

This field displays all or part of the absorbed labor general ledger account to use when resolving the account from the product. For more information on absorbed labor accounts, see Manufacturing Account Resolution.

Absorbed - Overhead

This field displays all or part of the absorbed overhead general ledger account to use when resolving the account from the product. For more information on absorbed overhead accounts, see Manufacturing Account Resolution.

Absorbed - Outside Processing

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

Variance - Labor

This field displays all or part of the variance labor general ledger account to use when resolving the account from the product. For more information on variance labor accounts, see Manufacturing Account Resolution.

Variance - Overhead

This field displays all or part of the variance overhead general ledger account to use when resolving the account from the product. For more information on variance overhead accounts, see Manufacturing Account Resolution.

Variance - Outside Processing

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

Scrap Expenses

This field displays all or part of the scrap expenses general ledger account to use when resolving the account from the product. For more information on scrap expenses accounts, see Manufacturing Account Resolution.

Other Information Tab Fields and Buttons

Field or Button

Description

User Defined 1-20

These fields display additional information about the product. To set up these fields, use User Defined Fields Maintenance.

These user-defined fields are divided into four sections of five fields. The label for each group can be set up in Purchasing Control Maintenance.

Catch Weights Tab Fields and Buttons

Field or Button

Description

This is a Catch Weight product

This check box is selected if the product is a random weight. If this check box is selected, the fields in the Sanities section define a range for the catch weight, and you can also use the other fields on the Catch Weights tab.

All

Select this check box to view catch weights for all dates. This check box is only enabled if the Catch Weight check box is selected on the Warehouse tab.

From

Enter the first date in a range of dates for which to view catch weights, or click the drop-down arrow to select a date. This field is only enabled if the Catch Weight check box is selected on the Warehouse tab.

To

Enter the last date in a range of dates for which to view catch weights, or click the drop-down arrow to select a date. This field is only enabled if the Catch Weight check box is selected on the Warehouse tab.

Show Data

Click this button to display catch weights based on the selected date range. This button is only enabled if the Catch Weight check box is selected on the Warehouse tab.

Supplier

This field is disabled in this window.

Est. Weight

This field is disabled in this window.

Weight U/M

This field displays the weight unit of measure.

This button is disabled in this window.

Sanity Over Amount

This field displays the acceptable maximum variance amount over the gross packaged weight.

Sanity Under Amount

This field displays the acceptable maximum variance amount under the gross packaged weight.

Sanity Over Percent

This field displays the acceptable maximum variance percentage over the gross packaged weight.

Sanity Under Percent

This field displays the acceptable maximum variance percentage under the gross packaged weight.

Catch Weights

This grid displays product catch weight information.

Total (Actual)

This field displays total actual weight.

Total (Estimated)

This field displays estimated total weight.

Total (Difference)

This field displays the difference between actual and estimated total weight.

VAT Tab Fields and Buttons

Field or Button

Description

Country

This field is disabled in this window.

VAT Class Code

This field is disabled in this window.

VAT Exempt

This check box is disabled in this window.

VAT Exempt Reason Code

This field is disabled in this window.

This button is disabled in this window.

This button is disabled in this window.

Selected VAT Class

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

Lot Shipping Rules Tab Fields and Buttons

Field or Button

Description

All

This check box is disabled in this window.

Customer Code

This field is disabled in this window.

Customer Name

This field is disabled in this window.

Transfer Orders

This check box is disabled in this window.

Do Not Pick X Days Before Lot Expiration

This field is disabled in this window.

This button is disabled in this window.

This button is disabled in this window.

Lot Shipping Rules

This grid displays all lot shipping rules for the product. These rules may be overridden for product locations or specific lots.