New Product Location

Purpose: Use the New Product Location screen to complete entry of a product location and to enter availability information.

Note:

Typically, you create product locations through integrations with external systems. For example, product locations might be created as part of the product import process or based on the results of an inventory inquiry.

Used for the Routing Engine module.

How to display this screen: Select a location and click New at the Product Locations screen.

Note:

Only users with Products authority can display this screen. See the Role Wizard for more information.

Completing the creation of a product location: Update any of the fields described below and click Save, or click Cancel to return to the Product Locations screen without creating the product location.

Note:

Any changes you make at this screen can be overwritten the next time you import product location information, as described in Importing Items/Products, Inventory, Barcodes, Images, and Locations into the Database.

Fields at this screen

Field	Description
Informational fields:
Organization	The organization code and name are separated by a hyphen (-).
System Product	The system product code and name are separated by a hyphen (-).
Location	The location code and name are separated by a hyphen (-).
Availability fields: Order Management System integration: The availability calculation in Order Management System is: `On hand - Protected - Reserved - Reserve Transfer - Backordered = Quantity available` Note: It is important to run the Batch Purchase Order Layering program (BPOL) in Order Management System before scheduling periodic import of inventory information into Order Broker. See the Order Management System online help for more information.
Available Quantity	The quantity of the product available in this location. This information can by updated through integration with an external system, or by entry at this screen. Order Broker uses this quantity to calculate the Available to Promise if: the location is in an offline system, or the location is in an online system, but Order Broker cannot communicate with the system when it receives an inventory inquiry, and the No Offline Response Action setting at the Preferences screen is Use offline. Note: The available quantity is a maximum of 6 positions, and can be a negative number. It cannot include decimals. For more information: See the Available to Promise field at the Edit Product Location screen for a discussion.
Reserved Quantity	Not implemented at the New Product Location screen. See the Reserved Quantity at the Edit Product Location screen for a discussion.
Fulfilled Quantity	Not implemented on this screen. See the Fulfilled Quantity at the Edit Product Location screen for a discussion.
Available to Promise	The Available Quantity minus the Reserved Quantity and the Fulfilled Quantity, if any, for the product location. This field is not implemented at the New Product Location screen. See the Calculating the Available to Promise Quantity for a discussion.
Next PO Date	The next date when a purchase order for this product is expected for delivery. Order Management System integration: The date is calculated using purchase order layering, in which the expected quantity on a purchase order may be “reserved” for older backorders. See the Order Management System online help for more information.
Next PO Quantity	The number of units ordered on the next purchase order. This quantity can be up to 6 positions. It cannot include decimals.
Attributes The following product attributes are available to guide selection of fulfilling or sourcing locations for orders: probability rules: See the Probability Rule Wizard for more information standard brokering: optionally, the Routing Engine can use the Sales Velocity for ranking weighted brokering: the Science Engine can use various product location attributes based on the configured weighted brokering percentages Each of the product attributes are user-defined.
Daily Sell Through Quantity	Typically represents the average quantity of the product sold in this location on a daily basis. You might use this quantity as part of a probability rule that subtracts the daily sell-through quantity from the available quantity, especially if the location is in an offline system. This quantity can be up to 6 positions, and must be a whole number. It cannot be a negative number.
Status	The status of the product in this location. Informational only. Possible statuses are: Active (default) = Can be ordered. Inactive = Cannot currently be ordered. Discontinued = Can still be ordered, but will be inactive at some point in the future. Required.
Sell Quantity/Multiple	Typically represents the selling multiple for a product; for example, you might sell tires in quantities of 4. You might use this quantity as part of a probability rule that indicates to exclude a product location, or display an available quantity of 0, if the available quantity is lower than the sell quantity/multiple. This quantity can be up to 6 positions, and must be a whole number. It cannot be a negative number. You might also use the Minimum Sell Quantity to fulfill the same function.
On Clearance	Indicates whether the product is on clearance in this location: Selected = The product is on clearance. Unselected (default) = The product is not on clearance. Used in LocateItems Sequence and Splitting Examples (Standard Brokering) calculation. If you use LocateItems Sequence and Splitting Examples (Standard Brokering) and this flag is selected, the Science Engine uses a selling price of .01 to calculate margin.
Minimum Sell Quantity	See the Sell Quantity/Multiple, above. This quantity can be up to 6 positions, and must be a whole number. It cannot be a negative number.
Selling Price	The single-unit selling price of the product in this location. Can be up to 19 positions with a 4-position decimal. It can also be 0, but cannot be a negative number, and should not include a currency symbol. Optional, but should be specified if Gross Margin is used in the LocateItems Sequence and Splitting Examples (Standard Brokering) calculation.
Shrink Rate %	Typically represents the percentage loss experienced for the product in this location due to theft or breakage. You might use the shrink rate as part of a probability rule that reduces the available quantity by the shrink rate percentage. This percentage can be up to 2 positions, and must be a whole number. It cannot be a negative number.
Cost	The single-unit cost of the product in this location. Can be up to 19 positions with a 4-position decimal. It can also be 0, but cannot be a negative number, and should not include a currency symbol. Optional, but should be specified if Gross Margin is used in the LocateItems Sequence and Splitting Examples (Standard Brokering) calculation.
Sales Velocity	A numeric ranking you can use to indicate how well a product sells in a particular location. You can use the sales velocity ranks assigned to product locations as part of the criteria for selecting fulfilling or sourcing locations for orders, either through standard or weighted brokering. Numeric; 2 positions with an optional 2-position decimal. Can be blank, or any number from 0 to 99.99. See the Standard Brokering or Weighted Brokering tabs at the Preferences screen for more information.
Margin	The Selling Price minus the Cost. If no Cost is specified, the Margin is equal to the Selling Price. If a Cost is specified, but no Selling Price, the Margin is negative. If no Cost or Margin is specified or if you set them to 0, the Margin is blank or 0.0000. System-calculated when either the Selling Price or Cost is entered. Display-only.