Product Location Inquiry

Buying

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

Cost

View costing methods and product costs.

Selling

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

Pricing

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

Warehouse

View sales tracking levels, quantity tracking levels, product unit and cubic weight, and other options for drop shipping a product.

Units of Measure

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

Landed Cost

View estimated, received, and supplier invoice costs for a product at a location. The information on this tab helps you analyze product landed costs by comparing estimated and actual costs. All costs are in the default purchasing unit of measure.

Cycle Count

View cycle count information.

Catch Weights

View catch weight costs and 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.

Exit

Click this button to close the Product Location Inquiry window.

First

Click this button to display the first product for a selected location.

Prev

Click this button to display the previous product for a selected location.

Next

Click this button to display the next product for a selected location.

Last

Click this button to display the last product for a selected location.

Notes

Click this button to display Notes Entry, which allows you to view notes for a selected product and location. This button is only available if the Warehouse tab is displayed.

Location

Enter a location prefix or name, or click the Lookup button to select a location prefix or name.

Product

Enter a product code or name, or click the Lookup buttons to select a product code or name.

Purchase

This check box is selected if the product can be replenished by purchasing directly from a supplier.

Transfer

This check box is selected if the product can be replenished by transferring it from another location.

Build

This check box is selected if the product is a bill of material product and can be replenished by creating work orders in this location.

Replenishment Location

This field displays the location from which the product is replenished. This field only displays a location if the Transfer radio button is selected.

Primary

This field displays the default replenishment path for this product at this location for DRP purposes, as follows:

• Purchase - For DRP, the product is primarily replenished by purchasing directly from a supplier.

• Transfer - For DRP, the product is primarily replenished by transferring it from another location.

• Build - For DRP, the product is a bill of material product and is primarily replenished by creating work orders in this location.

Product Status

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

Primary Supplier Name

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

Primary Supplier Code

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

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.

For information on how this field impacts DRP calculations, see DRP - Desired On-Hand FAQ.

Lead Time

This field displays the lead time to replenish the product.

Note This is the actual number of days, not the number of business calendar days.

Lead times are calculated based on the value stored here and are updated with actual lead times if the Auto Update check box is selected. For more information, see Lead Time Inquiry and DRP - Lead Time Calculation FAQ.

Auto Update

This check box is selected if lead times are automatically updated in the Lead Time field.

Maximum Stock Level

This field displays the maximum stocking level for the product. This is used for min-max purchasing and DRP. Both a minimum and 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.

For information on how this field impacts DRP calculations, see DRP - Desired On-Hand FAQ.

In Transit Lead Time

This field displays the in-transit lead time for the product, which is the number of days between when the product is shipped and received. This is used by DRP to calculate purchase order and blanket release ship dates.

Example If the in-transit lead time is 10 days, and the purchase order delivery date is 06/15/2020, the purchase order ship date is calculated as 06/05/2020.

Safety Stock

This field displays the safety stock level for the product used by DRP.

For information on how this field impacts DRP calculations, see DRP - Desired On-Hand FAQ.

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.

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.

Forecast Transfer Rule

This field indicates whether transfer orders initiated for this product location are used to update sales demand for DRP, as follows:

• Sale - This option updates sales demand when the transfer order is prepped in Invoice Create and Print (this is not the typical scenario).

• Transfer - This option does not update sales demand for transfer orders; the sales demand will ultimately happen when the product is sold from the location to which it was transferred (this is the typical scenario).

Example Location B is a warehouse and location A is a retail outlet. Product is transferred from location B to location A. Location A has its own POS system for dealing with the retail public. Once a month, a physical inventory is done to adjust the inventory levels at location A. Location A is set up with Sale selected at the Forecast Transfer Rule field. Whenever product is transferred into Location A (from any other location), the quantity transferred is added to the sales demand of the transfer-from location.

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.

Display Qty U/M

The selected radio button displays the unit of measure for displaying quantities on this tab.

Expected Normal Forecast

This field displays the expected normal forecast for the product/location for DRP. This value can be used as a constant forecast by time bucket instead of using the actual forecast (which may contain promotional spikes). For information on how this field impacts DRP calculations, see DRP - Safety Stock Method FAQ.

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.

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

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

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.

DRP Product Class Code

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

U/M

This field displays the display unit of measure.

Internal Buyer

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

Accounting Cost

This field displays the 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. To change this cost, use Inventory Cost Adjust.

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 cost basis. The sales 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.

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.

Average Cost

This field displays the average cost in the product unit of measure. For more information, see cost basis. To change this cost, use Inventory Cost Adjust.

Cost Class

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

Last Cost

This field displays the last cost in the product unit of measure. For more information, see cost basis. To change this cost, use Inventory Cost Adjust.

Beginning Year Cost

This field displays the beginning year cost. It is used for specialized LIFO layer calculations.

FIFO Cost

This field displays the FIFO cost in the product unit of measure. For more information, see cost basis. To change this cost, use Inventory Cost Adjust.

For (FIFO Cost)

These fields display the quantity and unit of measure for the FIFO cost.

LIFO Cost

This field displays the LIFO cost in the product unit of measure. For more information, see cost basis. To change this cost, use Inventory Cost Adjust.

For (LIFO Cost)

These fields display the quantity and unit of measure for the LIFO cost.

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.

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

Allocation Minimum

This field displays the minimum quantity that can be allocated for the product in the selling default unit of measure. This overrides the allocation minimum value entered for the product in Product Maintenance, but is overridden by the value entered in 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.

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 overrides the multiple allocation value entered for the product in Product Maintenance, but is overridden by the value entered in 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.

Commission Class

This field displays the product's commission class. Commission classes are used to group together similar products solely for sales representative commission purposes. Commission classes are defined and maintained in Commission Class Maintenance. Sales commissions are derived based on commission classes and rates.

Commission Cost Charge Type

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

Tax Included

This check box is selected if the extended price includes tax.

Sales Margin

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

Min 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 Margin %

This field displays the minimum 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 percentage is displayed in the Co-Op Amount field. For more information, see Co-Op Year Maintenance and Co-op Sales Process Flow.

Amount Per Unit/Percent

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

Co-Op Amount

This field displays the product's co-op amount or percentage. The value entered represents a monetary amount if the Amount Per Unit radio button is selected, or a percentage if the Percent radio button is selected.

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 companion classes for the product/location if another product is sold as a companion of this product. For more information, see Companion Class Maintenance.

List Prices

This grid displays the list prices for the product/location. These prices can be used to manually assign prices for the product/location 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 from the location 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.

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/location.

Price Includes VAT/Price Excludes VAT

The selected radio button indicates whether the product/location prices include or exclude VAT.

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/location.

This button is disabled in this window.

This button is disabled in this window.

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 quantities for the product are tracked by lot. For more information, see Serial and Lot Tracking FAQ.

Serial Number

This check box is selected if quantities for the product are tracked by serial number. For more information, see Serial and Lot Tracking FAQ.

Sales Track at

This field displays the 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 an item 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.

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, this check box must be selected for that location. If there is no such record, the system will verify if this check box is selected for the product's shipping location.

Non Stocked Item

This check box is selected if your company purchases the product from a supplier only when a sales order is received. If this check box is selected, the Hold Inventory for Backorders check box must be selected, and minimum and maximum stock levels entered on the Buying tab must be zero.

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.

Potential Discrepancy

This check box is selected if there is a potential discrepancy for this product's physical (cycle counting) inventory. This check box can be automatically selected if there is a discrepancy during the accounts payable reconciliation process.

Cross Dock Allowed

This check box is selected if the default putaway bin during purchase order receiving is the cross-dock bin for the dock (if the product has backorders). If this check box is selected, the product can be received on to the dock for filling backorders.

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.

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.

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 will have to 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.

Include On Order Quantity in OE Discontinued Validation

This check box is selected if the on order quantity 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.

Discontinued Date

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

Use Primary Pick Bin for All Bins

This check box is selected if the bin defined in the Primary Pick Bin field is the default bin for picking and putting away, and if the bin is the default backflush bin.

Primary Pick Bin

This field displays the bin from which the product will be picked.

Primary Putaway Bin

This field displays the bin into which the product will be put away. This can be the same bin as a picking bin.

Must Backflush

This check box is selected if the component must be issued from a backflush bin for the selected operation.

Primary Backflush Bin

This field displays the bin into which manufactured products are placed. This is required only for manufactured products.

Must Use Primary Work Order Bin

This check box is selected if allocations for material issues must come from the primary work order bin. If this check box is cleared, product is first allocated from the primary work order bin, and if additional quantities are required, other bins are used for allocation.

Primary Work Order Bin

This field displays the primary bin that is used to allocate the component for material issues. If the Must Use Primary Work Order Bin check box is selected, products can be only allocated from this bin. If the check box is cleared, product is first allocated from this bin, and if it is not available, then other bins are used for allocation.

Note The primary work order bin can also be set up for work centers in Work Center Maintenance and bills of material in Bill of Material Maintenance. The primary work order bin for the bill of material overrides the primary work order bin for the work center and the product/location.

Backflush Bin Min. Level

This field displays the minimum quantity of the product in the backflush bin if a backflush bin is entered. This is the minimum number of units of the product that the backflush bin should hold at the specified location.

Scrap Factor

This field displays the scrap factor for the product/location if the product is a component used for manufacturing. This is the excess quantity of the component that is typically scrapped during the manufacturing process, and for which material must be issued.

Pick Bin Min. Level

This field displays the minimum bin level for the primary pick bin. This is the minimum number of units of the product that the specified pick bin should hold.

Note This minimum is not used during replenishment. Replenishment uses the value entered in the Replenish Min column in the Selected U/M grid on the Units of Measure tab.

Pick Bin Max. Level

This field displays the maximum bin level for the primary pick bin. This is the maximum number of units of the product that the specified pick bin should hold.

Note This maximum is not used during replenishment. Replenishment uses the value entered in the Replenish Max column in the Selected U/M grid on the Units of Measure tab.

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.

Pick Method

This field displays the product's pick method.

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 Priority

This grid 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 priority is also used to determine the hierarchy of sales/transfer orders associated with partially confirmed work orders.

This button is disabled in this window.

This button is disabled in this window.

Hold Inventory for Backorders

This check box is selected if inventory for backorders is held 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/location are put on backorder even if inventory is available. This ensures that allocation of the product is monitored.

Pick Group

This field displays the product pick group.

Product Scan

One of the following options is selected:

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

Quantity Scan

One of the following options is selected:

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

Warehouse Product Code

This field displays a warehouse product code for the product/location. This is used if a third-party warehouse uses a different product code for the product.

Warehouse Product Name

This field displays a warehouse product name for the product/location. This is used if a third-party warehouse uses a different product name for the product.

Available U/M

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.

This button is disabled in this window.

This button is disabled in this window.

Show U/M

Click this button to display the available units of measure in the Available U/M grid.

This button is disabled in this window.

This button is disabled in this window.

Selected U/M

This grid lists all units of measure for the product.

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.

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

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

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 (Receipt)

This field displays the product's receipt cost.

Product (Invoiced)

This field displays the product's invoiced cost.

Product (Estimated)

This field displays the product’s estimated purchase cost.

Product (Difference)

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

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 (Estimated)

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

Add. Charges (Difference)

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

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 (Estimated)

This field displays the total estimated 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.

Cycle Class Code

This field displays the product's cycle class code. The cycle class code is used to group together similar products and locations for wireless warehouse cycle counting. For more information, see Product Cycle Count Class Maintenance.

Recount Variance Amt

This field displays the product's recount variance amount. This field is used in conjunction with Wireless Warehouse Cycle Counting.

Last Count Date

This field displays the last date the product was counted.

Recount Variance %

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

This field displays the product's recount display. This field is used in conjunction with Wireless Warehouse Cycle Counting.

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.

Count Display

This field displays the product's count display. This field is used in conjunction with Wireless Warehouse Cycle Counting.

All

Select this check box to view catch weights for all dates.

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.

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.

Show Data

Click this button to display catch weights based on the selected date range.

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.

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.

Country

This field displays the country associated with the location of the product/location. For information on setting up countries, see Country Maintenance.

VAT Class Code

This field displays the VAT class code for the product/location. This determines the VAT rate for the product/location. For information on setting up VAT class codes, see VAT Class Maintenance.

Current VAT Tax Rate

This field displays the current VAT rate for the product/location. This rate is based on the VAT class selected for the product/location.

VAT Exempt

This check box is selected if the product/location is exempt from VAT.

VAT Exempt Reason Code

This field displays the VAT exempt reason code to explain why orders for the product/location are exempt from VAT (if applicable). For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance.

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 specific lots.