Menu Path: Purchasing Module Setup Products Product Location Maintenance
Alternate Menu Path: Warehouse Management Module Setup Products Product Location Maintenance
Assign a product to one or more locations (a product can only be sold or shipped from locations to which it is assigned).
Use Product Location Maintenance to link a specific product to a specific location. For information on locations, see Sales Location / Shipping Location.
When creating a product at a location, Product Location Maintenance defaults to the information entered for the product in Product Maintenance. This information can be changed for the selected location and will be used whenever the product is accessed for this location.
The data in many of the fields and grids in this window default from the product information in Product Maintenance. If you want to change any default, you can do so in Update mode. You can also enter data into fields that were not defaulted from the product’s record.
Product Location Maintenance has the following tabs:
Tab |
Purpose |
Enter purchasing requirements for a product, including supplier information, minimum and maximum stocking levels, and a buying method. |
|
Enter costing methods and product costs. |
|
Enter selling requirements for a product, including minimum and maximum margin percentages, and class information. |
|
Enter pricing settings for a product, including price classes and various pricing levels. |
|
Enter sales tracking levels, quantity tracking levels, product unit and cubic weight, and other options for drop shipping a product. |
|
Enter the various units of measure in which a product can be purchased, sold, and picked. Specify a single default purchasing, selling, and display unit of measure. |
|
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. |
|
Enter cycle count information. |
|
View catch weight costs and enter estimated weights for suppliers. |
|
Enter a VAT class and/or reason code and view the current VAT rate for the product/location. |
|
Set up 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. |
Note You cannot delete a product location record if there is existing inventory at the location. In addition, if you want to delete the product, all product locations must be deleted first.
To create a product location record:
Enter the location prefix or name in one of the Location fields.
Enter the product code or name in one of the Product fields.
Click the New button in the ribbon. Product settings default for the product location record.
Make any changes to the product location record, as necessary.
Click the OK button in the ribbon. The product location is created.
Button |
Description |
Exit |
Click this button to close the Product Location Maintenance window. |
New |
Click this button to create a new product location. |
Update |
Click this button to edit the selected product location. |
Delete |
Click this button to delete the selected product location. Note You cannot delete a product location if it is used for a bill of material or a purchase order. |
OK |
Click this button to accept an action. This button is only available if you click the New, Update, or Delete button in the ribbon. If you edit information for a product that is assigned a style, Product Style Selection may appear, and allow you to copy the changes to other products in the style. For more information, see Copying Data Between Products in a Style. |
Cancel |
Click this button to cancel an action. This button is only available if you click the New, Update, or Delete button in the ribbon. |
First |
Click this button to display the first product 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 and enter notes for a selected product and location. This button is only available if the Warehouse tab is displayed. |
Field or Button |
Description |
Enter a location prefix or name, or click the Lookup buttons to select a location prefix or name. |
|
Click the Lookup button and select one of the following methods for exporting data for the product/location to a WMS:
This overrides the default settings for the location. This field is only available if the location for the product/location uses a third-party WMS and users are allowed to change the export method for products/locations in the location. |
|
Enter a product code or name, or click the Lookup buttons to select a product code or name. |
Field or Button |
Product Default |
Description |
No |
Select this check box if the product can be replenished by purchasing directly from a supplier. You can select as many replenishment paths as apply. |
|
No |
Select this check box if the product can be replenished by transferring it from another location. You can select as many replenishment paths as apply. |
|
No |
Select this check box if the product is a bill of material product and can be replenished by creating work orders in this location. You can select as many replenishment paths as apply. |
|
No |
Enter the location that the product is being replenished from, or click the Lookup button to select a location. This field is only enabled if you select the Transfer radio button. Note You can only select locations that have been previously set up for this product and for which the product is not marked discontinued. |
|
No |
Select the default replenishment path for this product at this location for DRP. You can select the following:
Note When you select the primary replenishment path, the corresponding Replenishment Path check box is selected automatically. If you select Purchase or Build, the Replenishment Location and Forecast Transfer Rule fields are disabled. |
|
Yes |
Enter the current status of the product, or click the Lookup button to select a status. For more information, see Product Status Maintenance. |
|
Yes |
Enter the supplier name of the primary supplier for a product, or click the Lookup button to select the 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. |
|
Yes |
Enter the supplier code of the primary supplier for a product, or click the Lookup button to select the 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. |
|
Yes |
Enter a 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. |
|
No |
Enter the lead time to replenish. 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 Management and DRP - Lead Time Calculation FAQ. |
|
No |
Select this check box to automatically update lead times in the Lead Time field. |
|
Yes |
Enter 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. For information on how this field impacts DRP calculations, see DRP - Desired On-Hand FAQ. |
|
No |
Enter 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, the purchase order ship date is calculated as 06/05. |
|
Yes |
Enter 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. |
|
Yes |
Enter 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. |
|
Yes |
Enter the minimum purchase quantity used by purchasing and DRP. The quantity defined in this field is in the default purchasing unit of measure. NOTE This cannot be less than the value entered in the Purchase Increment field. For information on how this field impacts DRP calculations, see DRP - Suggested Planned Receipt FAQ. |
|
No |
Click the Lookup button to select whether transfer orders initiated for this product location are used to update sales demand for DRP. This is a required field if you select the Transfer radio button.
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 in 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. |
|
Yes |
Enter 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. |
|
No |
Select a unit of measure for displaying quantities on this tab. |
|
No |
Enter the expected normal forecast for the product/location for DRP. If you enter a value in this field, it 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. |
|
Yes |
Enter the product's buying method, or click the Lookup button to select a 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:
|
|
Yes |
Enter a seasonal class, or click the Lookup button to select a seasonal class. A seasonal class is used exclusively for DRP. For more information, see Seasonal Class Maintenance. |
|
Yes |
Enter a DRP product class for the product/location, or click the Lookup button to select a DRP product class. For information on setting up DRP product classes, see DRP Product Class Maintenance. |
|
No |
This field displays the display unit of measure. |
|
Yes |
Enter the user ID of the buyer generally responsible for the replenishment of this product, or click the Lookup button to select a user ID. |
Field or Button |
Product Default |
Description |
Yes |
This field displays the accounting cost basis. The accounting cost basis controls general ledger entry amounts, and therefore, only the generally accepted accounting principles (GAAP) methods of Average, Standard, LIFO, and FIFO are available. To change this cost, use Inventory Cost Adjust. |
|
Yes |
Enter the standard cost in the product unit of measure. For more information, see cost basis. |
|
Yes |
Click the Lookup button to select the product's sales cost basis. The sales cost basis is used in gross margin determination for sales reporting and is used for calculating royalties and commissions. Average, Standard, LIFO, FIFO, Burden, and Last Cost can be used depending on your specific needs. This Lookup button is disabled for kit and service products. |
|
Yes |
Enter the burden cost in the product unit of measure. For more information, see cost basis. |
|
Yes |
Click the Lookup button to select 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. This Lookup button is disabled for kit and service products. |
|
Yes |
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. |
|
Yes |
Enter a cost class, or click the Lookup button to select a 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. |
|
Yes |
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. |
|
No |
Enter the beginning year cost. It is used for specialized LIFO layer calculations. This field is disabled for kit and service products. |
|
Yes |
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. |
|
Yes |
These fields display the quantity and unit of measure for the FIFO cost. |
|
Yes |
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. |
|
Yes |
These fields display the quantity and unit of measure for the LIFO cost. |
Field or Button |
Product Default |
Description |
Yes |
Enter 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. |
|
Yes |
Enter the order quantity multiple allowed to be entered during sales order entry (in the stock, or lowest, level unit of measure). When setting up order minimums and order multiples, be careful if the product has multiple units of measures defined so that expected results are achieved. 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). |
|
Yes |
Enter the minimum quantity that can be allocated for the product in the selling default unit of measure. This must be less than or equal to the order minimum entered in the Order Minimum field. 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. Note If there is an allocation multiple value entered in the Allocation Multiple field, the allocation minimum must be specified in that allocation multiple value. For example, if an allocation multiple is 4 each, then the allocation minimum must be 4, 8, 12, etc. |
|
Yes |
Enter a 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. |
|
Yes |
Enter the product's commission class, or click the Lookup button to select a 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. |
|
Yes |
Enter a drop-ship commission additional charge type to use for the product/location on drop-ship commission orders for which commissions are based on costs, or click the Lookup button to select a drop-ship commission additional charge type. For more information, see Drop-Ship Commission Orders FAQ. For information on setting up additional charge types, see Order Entry Additional Charge Maintenance. |
|
Yes |
Select this check box if the extended price includes tax. |
|
Yes |
Select a method for handling sales orders that are below the margin percentage entered in the Min Margin % field or above the margin percentage entered in the Max Margin % field. You can select to place these orders on margin hold, display a warning, or to not check margin percentages. For more information, see Gross Margin Testing FAQ. |
|
Yes |
Enter 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 is only enabled if you select the Place on Hold or Give Warning radio button. |
|
Yes |
Enter 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 is only enabled if you select the Place on Hold or Give Warning radio button. |
|
Yes |
Select this check box if the product is considered a co-op product. If this check box is selected, you must select whether the co-op will be calculated based on an amount per unit or percentage, and you must assign an amount in the Co-Op Amount field. For more information, see Co-Op Year Maintenance and Co-op Sales Process Flow. |
|
Yes |
Select whether the co-op is calculated based on an amount per unit or percentage. These radio buttons are only enabled if you select the Co-Op Product check box. |
|
Yes |
Enter the product's co-op amount or percentage. The value entered represents a currency 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. |
|
No |
Enter the product's companion class if another product is sold as a companion of this product, or click the Lookup button to select a companion class. For more information, see Companion Class Maintenance. |
|
No |
This field displays the name of the selected companion class. |
|
No |
Click this button to add the product to the companion class. |
|
No |
Click this button to remove the product from the selected companion class in the Companion Classes grid. |
|
Yes |
This grid displays companion classes for the product/location. |
Field or Button |
Product Default |
Description |
Yes |
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:
Select a list price to display all future prices for it in the Future Prices grid. |
|
No |
Enter a future price for the selected list price. |
|
No |
Enter the effective date for the future price. |
|
No |
Click this button to add the entered future price for the selected list price. |
|
No |
Click this button to remove the selected future price selected in the Future Prices grid. |
|
Yes |
This grid displays future prices for the selected list price in the List Prices grid. |
|
Yes |
This field displays the default selling unit of measure for the product/location. |
|
Yes |
Select whether the product/location prices include or exclude VAT. Note This radio set is disabled for configuration kits. |
|
No |
Enter a price class used to group together similar products solely for pricing, or click the Lookup button to select a price class. Price classes can be used to create price matrices for price books (groups of customers) in Price Book Price Maintenance or for specific customers in Customer Price Maintenance. Price classes are defined and maintained in Price Class Maintenance. Note This field is disabled for configuration kits. |
|
No |
This field displays the description of the selected price class. |
|
No |
Click this button to add the price class to the product/location. |
|
No |
Click this to remove the price class selected in the Price Classes grid from the product/location. |
|
Yes |
This grid displays the price classes for the product/location. You can use the arrow buttons to the right of this grid to change the hierarchy of price classes for the product/location. |
|
No |
Click this button to move the selected price class up in the price class hierarchy. |
|
No |
Click this button to move the selected price class down in the price class hierarchy. |
Field or Button |
Product Default |
Description |
Yes |
This check box is selected to indicate that quantity of the product is tracked. |
|
Yes |
This check box is selected to indicate that quantity of the product is tracked by location. |
|
Yes |
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. |
|
Yes |
Select this check box if quantities for the product/location are tracked by lot. For more information, see Serial and Lot Tracking FAQ. This check box is only enabled if the product has zero quantity on hand in the location. |
|
Yes |
Select this check box if quantities for the product/location are tracked by serial number. For more information, see Serial and Lot Tracking FAQ. This check box is only enabled if the product has zero quantity on hand in the location. |
|
Yes |
Select 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, use only 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. |
|
Yes |
Select this check box to allow the product to 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. This check box is selected by default. |
|
Yes |
Select this check box to flag products that are intended to 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 minimum and maximum stock levels entered on the Buying tab must be zero. |
|
Yes |
Select this check box to allow the product to 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 only enabled if you clear the Must Drop Ship check box. |
|
Yes |
Select this check box if the product must be drop shipped. If you select this check box, the Drop Ship Allowed check box is also selected, and is disabled. If you select this check box, the product is a non-stocked product. |
|
No |
Select this check box if there is a potential discrepancy for the product's physical (cycle counting) inventory. This check box can also be automatically selected if there is a discrepancy during the accounts payable reconciliation process. |
|
No |
Select this check box 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. |
|
Yes |
Select this check box to permit a larger unit of measure to 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. |
|
Yes |
Select this check box to permit a larger unit of measure to be assembled from smaller units of measure to fulfill a sales order allocation. 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. |
|
Yes |
Select this check box to permit this product to 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. |
|
Yes |
Select this check box if the product is no longer available for sale. Existing inventory of the 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 the 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. Note If you have this product location set up as the primary replenishment path for other locations, then you must change the primary replenishment path of those other locations before marking this product location as discontinued. Note You can change a product style's status in Style Maintenance to select or clear this check box for all products in a style. |
|
Yes |
Select this check box if you want to include the on order quantity in the order validation that occurs for discontinued products during order entry. This setting only affects the product if it is discontinued. 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. |
|
Yes |
Enter the discontinued date if the product is discontinued. This field is only enabled if you select the Discontinued check box. |
|
Yes (in Product Location Selection) |
Select this check box to use the bin defined in the Primary Pick Bin field as the default bin for picking and putting away, and as the default work order bin. This check box is only enabled if you enter a valid bin in the Primary Pick Bin field. |
|
Yes (in Product Location Selection) |
Enter an available bin from which the product will be picked, or click the Lookup button to select a bin. |
|
Yes (in Product Location Selection) |
Enter an available bin into which the product will be put away, or click the Lookup button to select a bin. This can be the same bin as a picking bin. This field is only enabled if you clear the Use Primary Pick Bin for All Bins check box. |
|
No |
Select this check box if the component must be issued from a backflush bin for the selected operation. This check box is only enabled if you clear the Use Primary Pick Bin for All Bins check box, the Must Use Primary Work Order Bin check box, and the Primary Work Order Bin field. |
|
No |
Enter the backflush bin for the product/location, or click the Lookup button to select the backflush bin. The backflush bin is used when inventory is not allocated until it is used (and confirmed in Work Order Confirm). You can require a product/location or bill of material component to be taken from the backflush bin. This field is only enabled if you select the Must Backflush check box. |
|
No |
Select this check box if you only want allocations for material issues to 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. This check box is only enabled if you clear the Must Backflush check box. |
|
Yes (in Product Location Selection) |
Enter the primary bin that is used to allocate the component for material issues, or click the Lookup button to select the bin. 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. This field is only enabled if you clear the Use Primary Pick Bin for All Bins and Must Backflush check box. 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. |
|
No |
Enter a 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. |
|
No |
Enter a 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. |
|
No |
Enter a 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. |
|
Yes |
Enter the package unit of measure, or click the Lookup button to select a 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. |
|
Yes |
Enter a pick method, or click the Lookup button to select a pick method. |
|
Yes |
Leave 0 in this field if you want to allocate regardless of an order’s required date (which, if an order is entered with a required date 6 months in the future, the product will sit on the shelf reserved for that order for 6 months). If you only want to reserve this product for orders required within a certain number of business days, enter the number of business days. Business days are calculated based on how your business calendar is set up in Business Calendar Day Maintenance. Example You allocate inventory 10 days before the required date for Product A. You create an order for this product with the order date 01/05 and the required date 01/18. If sufficient inventory exists, it will be allocated for Product A on 01/05 because there are 9 business days between 01/05 and 01/18. The number of units allocated displays on the Items tab in Order Entry. |
|
Yes |
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. Use the up and down arrow buttons to rearrange the backorder release priority. 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. |
|
No |
Click this button to move the selected backorder release priority higher in the backorder release priority list. |
|
No |
Click this button to move the selected backorder release priority lower in the backorder release priority list. |
|
Yes |
Select this check box to hold inventory for backorders before releasing 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. |
|
Yes |
Select this check box to only allow backorders to 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. |
|
Yes |
Select this check box to automatically put all sales order line items for the product/location on backorder even if inventory is available. This ensures that allocation of the product is monitored. |
|
Yes |
Enter a product pick group, or click the Lookup button to select a pick group. |
|
Yes |
Select one of the following options:
|
|
Yes |
Select one of the following options:
Example If you select this option and a user is picking 15 cases, the user must scan each case (15 scans).
|
|
No |
Enter a warehouse product code for the product/location. If this code is transmitted from a third-party warehouse on warehouse shipping advices and/or warehouse stock transfer receipt advices, set up the EDI trading partner to use this code in Warehouse Advice Options. |
|
No |
Enter a warehouse product name for the product/location. This is used if a third-party warehouse uses a different product name for the product. |
Field or Button |
Product Default |
Description |
No |
This grid lists available units of measure for the product. For each unit of measure, the unit of measure code and name are displayed. |
|
No |
Click this button to add all the units of measure in the Available U/M grid to the Selected U/M grid. |
|
No |
Click this button to add the unit of measure selected in the Available U/M grid to the Selected U/M grid. |
|
No |
Click this button to display the available units of measure in the Available U/M grid. |
|
No |
Click this button to remove the selected unit of measure from the Selected U/M grid. |
|
No |
Click this button to remove all units of measure from the Selected U/M grid. |
|
Yes |
This grid lists all units of measure for the product. For definitions of all unit of measure columns, see Unit of Measure Fields FAQ. Double-click the Break to U/M column to display Break to U/M Selection, which allows you to select a unit of measure to which to break down the product for each unit of measure. Double-click the Primary Pick Zone column to display Zone Selection, which allows you to select a primary pick zone for each unit of measure. Double-click the Velocity column to display Velocity Selection, which allows you to select a velocity code for each unit of measure. Note You cannot clear the check boxes in the Sell, Purch, and Pick columns for a unit of measure. One of the three check boxes must be selected for each unit of measure. |
Field or Button |
Product Default |
Description |
No |
Select this check box to view landed costs for all dates. |
|
No |
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. |
|
No |
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. |
|
No |
Click this button to display calculated average landed costs based on the selected date range. |
|
No |
Enter an additional charge type if you want to enter an additional charge associated with the product's landed cost, or click the Lookup button to select an additional charge type. You can only enter additional charges for which the Include in Landed Cost check box is selected in Purchase Additional Charge Maintenance. |
|
No |
Enter the estimated costs for each additional charge associated with a product's landed cost. |
|
No |
Click this button to add the additional charge to the Landed Cost grid. |
|
Yes |
This grid displays details of additional charges included in the landed costs for the product. The grid includes the following columns:
Note To remove an additional charge from this grid, change the estimated quantity to zero. This only allows removal of items with no receipt activity. |
|
No |
Select how landed costs are compared. Landed cost comparisons can be made between:
|
|
No |
This field displays the currency for displayed costs. |
|
No |
This field displays the product's receipt cost. |
|
No |
This field displays the product's invoiced cost. |
|
No |
Enter an estimate of the product’s purchase cost. This estimate is used as the estimated cost in the Purchase Price Variance Report. |
|
No |
This field displays the difference between product costs based on the selected option in the Difference Based On field. |
|
No |
This field displays the total of the additional charges receipt cost. |
|
No |
This field displays the total of the additional charges invoiced cost. |
|
No |
This field displays the total of all estimated costs of additional charges. |
|
No |
This field displays the difference between additional charges costs based on the selected option in the Difference Based On field. |
|
No |
This field displays the total receipt cost of the product and additional charges. |
|
No |
This field displays the total invoiced cost of the product and additional charges. |
|
No |
This field displays the total estimated cost of the product and additional charges. |
|
No |
This field displays the difference between total costs based on the selected option in the Difference Based On field. |
Field or Button |
Product Default |
Description |
No |
Enter a cycle class code, or click the Lookup button to select a cycle class code. The cycle class code is used to group together similar products and locations for wireless warehouse cycle counting. For information on setting up cycle class codes, see Product Cycle Count Class Maintenance. |
|
Yes |
Enter a recount variance amount. This field is used in conjunction with Wireless Warehouse Cycle Counting. |
|
No |
This field displays the last date the product was counted. |
|
Yes |
Enter the recount variance percentage. This field is used in conjunction with Wireless Warehouse Cycle Counting. |
|
Yes |
Select this check box to not allow the automatic reclassification of the cycle class code when running product cycle count reclassification. |
|
Yes |
Click the Lookup button to select the recount display. This field is used in conjunction with Wireless Warehouse Cycle Counting. |
|
Yes |
Select this check box to require a recount. This field is used in conjunction with Wireless Warehouse Cycle Counting. A recount is only required if this check box is selected and a recount variance amount or percentage is entered. |
|
Yes |
Click the Lookup button to select the count display. This field is used in conjunction with Wireless Warehouse Cycle Counting. |
Field or Button |
Product Default |
Description |
No |
Select this check box to view catch weights for all receipt dates. |
|
No |
Enter the first date in a range of receipt dates for which to view catch weights, or click the drop-down arrow to select a date. |
|
No |
Enter the last date in a range of receipt dates for which to view catch weights, or click the drop-down arrow to select a date. |
|
No |
Click this button to display catch weights based on the selected receipt date range. |
|
No |
Enter a supplier code if you want to enter an estimated weight, or click the Lookup button to select a supplier. This field is only enabled if the Catch Weight check box is selected on the Warehouse tab in Product Maintenance. |
|
No |
Enter the estimated weight. This field is only enabled if the Catch Weight check box is selected on the Warehouse tab in Product Maintenance. |
|
No |
This field displays the weight unit of measure. |
|
No |
Click this button to add the weight to the Catch Weights grid. This button is only enabled if the Catch Weight check box is selected on the Warehouse tab in Product Maintenance. |
|
No |
This grid displays suppliers and the average weight per unit of measure for receipts in the selected range of dates. If you entered an estimated weight for a supplier, the difference between the actual and estimated weight is also displayed. |
|
No |
This field displays total actual weight. |
|
No |
This field displays estimated total weight. |
|
No |
This field displays the difference between actual and estimated total weight. |
Field or Button |
Product Default |
Description |
No |
This field displays the country associated with the location of the product/location. For information on setting up countries, see Country Maintenance. |
|
Yes |
Enter a VAT class code for the product/location, or click the Lookup button to select a VAT class code. This determines the VAT rate for the product/location. For information on setting up VAT class codes, see VAT Class Maintenance. This field is only enabled if the VAT Exempt check box is cleared. |
|
Yes |
This field displays the current VAT rate for the product/location. This rate is based on the VAT class selected for the product/location. |
|
Yes |
Select this check box if the product/location is exempt from VAT. |
|
Yes |
Enter a VAT exempt reason code to explain why orders for the product/location are exempt from VAT, or click the Lookup button to select a VAT exempt reason code. For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance. This field is only enabled if the VAT Exempt check box is selected. |
Field or Button |
Product Default |
Description |
Yes |
Select this check box if you want to create a lot shipping rule for all customers. This check box is only enabled if the Transfer Orders check box is cleared. |
|
Yes |
Enter a customer code for which you want to create a lot shipping rule, or click the Lookup button to select a customer code. This field is only enabled if you clear the All check box. |
|
Yes |
Enter a customer name for which you want to create a lot shipping rule, or click the Lookup button to select a customer name. This field is only enabled if you clear the All check box. |
|
Yes |
Select this check box if you want to create a lot shipping rule for transfer orders. |
|
Yes |
Enter the number of days before the lot expiration date that picking for the product should not occur. |
|
No |
Click this button to add the lot shipping rule to the product. |
|
No |
Click this button to remove the lot shipping rule from the Lot Shipping Rules grid. |
|
Yes |
This grid displays all lot shipping rules for the product. These rules may be overridden for specific lots. |