Menu Path: Warehouse Management Inquiries Products Product Inquiry
Alternate Menu Path: Purchasing Inquiries Products Product Inquiry
View detailed information about products.
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 |
View a product's description, search name, category, product unit of measure, and other general information. |
|
View purchasing requirements for a product, including supplier information, minimum and maximum stocking levels, and a buying method. |
|
View selling requirements for a product, including minimum and maximum margin percentages, and various class information. |
|
View pricing requirements for a product, including price classes and various pricing levels. |
|
View cost methods, and landed cost information. |
|
View sales and gross profit for the preceding 12 months, and key customers for a product. |
|
View sales and returns for the preceding 12 months, quality-related business intelligence, and collaboration Web sites. |
|
View a CAD image for a product. |
|
View the product life cycle stages of a product. |
|
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. |
|
View related locations for a product. |
|
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. |
|
View various sales, expense, inventory, and other general accounts for resolution. |
|
View user-defined fields that contain extra information about a product. |
|
View catch weight costs and enter estimated weights for suppliers. |
|
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. |
|
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. |
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. |
Field or Button |
Description |
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. |
|
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. |
|
Enter the product's name, or click the Lookup button to select a product name. |
|
Select whether to navigate by product code or name when you click the First, Prev, Next, and Last buttons in the ribbon. |
Field or Button |
Description |
This field displays a short description of the product. This description can be used for searching by product. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
This check box is disabled in this window. |
|
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. |
|
This check box is disabled in this window. |
|
This check box is disabled in this window. |
|
This field displays the product's GTIN. This is the number that will be used for Electronic Product Code (EPC) and RFID requirements. |
|
This check box is disabled in this window. |
|
This field displays the product's category. For more information, see Product Category Maintenance. |
|
This field displays the product's subcategory. A subcategory is an optional hierarchical level below the category. For more information, see Product Subcategory Maintenance. |
|
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. |
|
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. |
|
Click this button to view the product's image file entered in the Image File 1 field. |
|
This button is not used in this window. |
|
This field displays detailed characteristics of the product. This field can be used for word searching. |
Field or Button |
Description |
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:
|
|
This field displays the seasonal class for the product. A seasonal class is used exclusively for DRP. For more information, see Seasonal Class Maintenance. |
|
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. |
|
This field displays the user ID of the buyer generally responsible for the replenishment of the product. |
|
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. |
|
This field displays the DRP product class for the product. For information on setting up DRP product classes, see DRP Product Class Maintenance. |
|
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. |
|
This field is disabled in this window. |
|
This button is not used in this window. |
|
This button is not used in this window. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
This field displays the country code for the product's country of origin. For information on setting up country codes, see Country Maintenance. |
|
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. |
|
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. |
|
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. |
|
Click this button to refresh the Related Suppliers grid. |
|
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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). |
|
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. |
|
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. |
|
This field displays the product's royalty class if the product is part of a royalty arrangement. For more information, see Royalty Class Maintenance. |
|
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. |
|
This field displays the product's bookings class. For more information, see Bookings Class Maintenance. |
|
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. |
|
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. |
|
This field displays the catalog page on which the product is displayed if your company's products are catalogued. This field is only informational. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
This field specifies whether the co-op is calculated based on an amount per unit or percent. |
|
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. |
|
Click this button to view the product's image entered in the Image File 2 field. |
|
This button is not used in this window. |
|
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. |
|
Click this button to view the product's image entered in the Image File 3 field. |
|
This button is not used in this window. |
|
This check box is selected if the product can be entered as a line item on sample orders. |
|
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. |
|
If the product is a beverage product, these fields display the size and unit of measure of the bottle. |
|
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. |
|
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. |
|
This field is disabled in this window. |
|
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. |
Field or Button |
Description |
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:
Select a list price to display all future prices for it in the Future Prices grid. NOTE This grid cannot be sorted. |
|
This field is disabled in this window. |
|
This field is disabled in this window. |
|
This button is disabled in this window. |
|
This button is disabled in this window. |
|
This grid displays future prices for the selected list price in the List Prices grid. |
|
This field displays the default selling unit of measure for the product. |
|
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. |
|
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. |
|
This field is disabled in this window. |
|
This field is disabled in this window. |
|
This button is disabled in this window. |
|
This button is disabled in this window. |
|
This grid displays the price classes for the product. |
|
This button is disabled in this window. |
|
This button is disabled in this window. |
Field or Button |
Description |
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. |
|
This field displays the standard cost in the product unit of measure. For more information, see cost basis. |
|
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. |
|
This field displays the burden cost in the product unit of measure. For more information, see cost basis. |
|
This field displays the cost unit of measure for the product. |
|
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. |
|
Select this check box to view landed costs for all dates. |
|
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. |
|
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. |
|
Click this button to display calculated average landed costs based on the selected date range. |
|
This field is disabled in this window. |
|
This field is disabled in this window. |
|
This button is disabled in this window. |
|
This grid displays details of additional charges included in the landed costs for the product. The grid includes the following columns:
|
|
Select how landed costs are compared. Landed cost comparisons can be made between:
|
|
This field displays the currency for displayed costs. |
|
This field displays the product's estimated cost. |
|
This field displays the product's receipt cost. |
|
This field displays the product's invoiced cost. |
|
This field displays the difference between product costs based on the selected option in the Difference Based On field. |
|
This field displays the total of all estimated costs of additional charges. |
|
This field displays the total of the additional charges receipt cost. |
|
This field displays the total of the additional charges invoiced cost. |
|
This field displays the difference between additional charges costs based on the selected option in the Difference Based On field. |
|
This field displays the total estimated cost of the product and additional charges. |
|
This field displays the total receipt cost of the product and additional charges. |
|
This field displays the total invoiced cost of the product and additional charges. |
|
This field displays the difference between total costs based on the selected option in the Difference Based On field. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
This field displays the scorecard profit group for the product. For information on setting up scorecard profit group codes, see Scorecard Profit Group Maintenance. |
|
This grid displays the sales and gross profit by month for the selected product. |
|
This grid displays the top customers based on units sold of the selected product. |
Field or Button |
Description |
This grid displays the sales and returns by month for the selected product. |
Field or Button |
Description |
This field displays the path and file name for a CAD image file for the product. |
|
Click this button to display the CAD image file entered in the CAD Image field. |
|
This button is not used in this window. |
|
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. |
Field or Button |
Description |
This field displays the current status of the product. For more information, see Product Status Maintenance. |
|
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. |
|
These fields display the user ID of the person who created the product, and the date/time the product was created. |
|
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. |
|
These fields display the user ID of the person who last updated the product, and the date/time the product was updated. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
Field or Button |
Description |
This check box is selected to indicate that quantity of the product is tracked. |
|
This check box is selected to indicate that quantity of the product is tracked by location. |
|
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. |
|
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. |
|
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. |
|
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. |
|
This field displays the default number of days after which a lot expires. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
This field displays the pick method for the product. |
|
This field displays the product pick group. |
|
One of the following options is selected for the product:
Example If this option is selected and a user is picking 15 cases, the user must scan each case (15 scans).
|
|
One of the following options is selected for the product:
|
|
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. |
|
This field displays the recount variance amount. This field is used in conjunction with Wireless Warehouse cycle counting. |
|
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. |
|
This field displays the recount variance percentage. This field is used in conjunction with Wireless Warehouse cycle counting. |
|
This check box is selected if the automatic reclassification of the cycle class code is not allowed when running product cycle count reclassification. |
|
This check box is selected if a recount is required for the product. This field is used in conjunction with Wireless Warehouse cycle counting. |
|
This field displays the recount display for the product. This field is used in conjunction with Wireless Warehouse cycle counting. |
|
This field displays the count display for the product. This field is used in conjunction with Wireless Warehouse cycle counting. |
|
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. |
|
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. |
|
This field indicates the type of kit for a product that is a kit, as follows:
These radio buttons are only available if the Kit Item check box is selected. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
This check box is selected if all sales order line items for the product are put on backorder even if inventory is available. |
|
This field displays the unit of measure (basis) for the height, width, and length on the Unit of Measure tab. |
|
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. |
|
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. |
|
This field displays the cube unit of measure for the product in its stock unit of measure. |
|
This field displays the carton code associated with the product. |
|
This field displays the density of the product. Density is the ratio of mass per volume. |
|
This field displays the unit of measure (basis) for the mass. |
|
This field displays the unit of measure (basis) for the volume. |
|
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. |
|
This field displays the description of the entered hazard code. |
|
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. |
Field or Button |
Description |
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
This button is disabled in this window. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
Field or Button |
Description |
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. |
Field or Button |
Description |
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
This field is disabled in this window. |
|
This field is disabled in this window. |
|
This field displays the weight unit of measure. |
|
This button is disabled in this window. |
|
This field displays the acceptable maximum variance amount over the gross packaged weight. |
|
This field displays the acceptable maximum variance amount under the gross packaged weight. |
|
This field displays the acceptable maximum variance percentage over the gross packaged weight. |
|
This field displays the acceptable maximum variance percentage under the gross packaged weight. |
|
This grid displays product catch weight information. |
|
This field displays total actual weight. |
|
This field displays estimated total weight. |
|
This field displays the difference between actual and estimated total weight. |
Field or Button |
Description |
This field is disabled in this window. |
|
This field is disabled in this window. |
|
This check box is disabled in this window. |
|
This field is disabled in this window. |
|
This button is disabled in this window. |
|
This button is disabled in this window. |
|
This grid displays country-specific VAT classes and VAT-exemption reasons for the product. |
Field or Button |
Description |
This check box is disabled in this window. |
|
This field is disabled in this window. |
|
This field is disabled in this window. |
|
This check box is disabled in this window. |
|
This field is disabled in this window. |
|
This button is disabled in this window. |
|
This button is disabled in this window. |
|
This grid displays all lot shipping rules for the product. These rules may be overridden for product locations or specific lots. |