Product Locations
Purpose: Use the Product Locations screen to review or work with existing product locations, or create a new one.
Used for the Routing Engine module. Not used by the Supplier Direct Fulfillment module.
What is a product location? A product location is a record of a product at a location where it is stocked or sold. For example, an item warehouse record in your order management system, such as Order Administration, corresponds to a product location. Order Orchestration keeps track of availability information for the product location, including the available quantity and the date and expected quantity of any open purchase orders. The availability information is displayed at the Edit Product Location screen.
Created how? Typically, you create product locations through an integration with an external system. For example, product locations are created as part of the product import process or based on the results of an inventory inquiry. You can also create product locations through the availability update request or product update request, as well as through OCDS or Merchandising Omni Services Imports.
Note:
A system product must first exist for the product and system owning the selected location before you can create a product location. For example, if product AB123 does not exist in system 10, then you cannot create a product location for AB123 in system 10’s warehouse 1.Available quantity updated when? For an offline system, the available quantity is updated only when you perform the product import process from the system, or through the availability update request or product update request. For an online system, Order Orchestration updates the available quantity for the product location when it receives a response to an inventory inquiry. Typically, inventory levels in the Order Orchestration database are updated daily, or whenever scheduled by your systems administrator.
The available quantity is also updated through the OCDS or Merchandising Omni Services Imports.
Product relationships: See Product, System Product and Product Location for an overview of the relationships among Order Orchestration elements, including product locations.
How to display this screen: Click the product location icon () next to a product at the Products screen.
Note:
-
Only users with Products authority can display this screen. See Roles for more information.
-
If the Product Locations screen was already open in another tab when you clicked the product location icon, you advance to this screen with the product locations for the previously-selected product displayed.
Options at this screen
Option | Procedure |
---|---|
create a product location Note: Normally, you should not create product locations using this method. By creating a product location in Order Orchestration directly rather than using the process described under Importing Items/Products, Inventory, Barcodes, Images, and Locations into the Database, you run the risk that product location information will be inconsistent with that in the external system, such as Order Administration System or Xstore. |
Note: If you click Cancel at the New Product Location screen, the product location is not created. |
search for a product location |
Use 1 or both of the fields at the top of the screen to restrict the search results to matching product locations:
|
select a product location for review or maintenance of availability information |
Click the edit icon () next to product location to advance to the Edit Product Location screen. Note: If the Edit Product Location screen is already open in another tab, you advance to that screen, where the previously-selected product location is displayed. |
delete a product location |
Select the delete icon () next to a product location to delete the product location from Order Orchestration. You might need to delete a product location if it was deleted in the remote system. For example, if you transfer all the inventory for an item from one warehouse in Order Administration to another, this does not automatically delete the product location in Order Orchestration. Note: You cannot delete a product location unless the available quantity, reserved quantity, and fulfilled quantity are all zero. |
browse product locations |
Double-click a product location to open the Browse Product Locations window, where you can review the availability information, attributes, and other information about a product location. |
Fields at this screen
Field | Description |
---|---|
Informational fields: | |
Organization |
See organization. The organization code is separated from the organization description by a hyphen (-). |
Product |
See product. The product you selected at the Products screen. The product code is separated from the product name by a hyphen (-). |
Type |
Optionally, select a location type from the Type drop-down box to restrict the list of locations to this type. Only location types that have been created in the product’s organization are available for selection. |
Search/New fields: | |
Location |
Searching for a location: enter a full or partial location in the Location field and click Search to display product locations that match your entry. Creating a location: enter a valid location in the Location field and click New to create the product location. As you enter characters in the Location field, it displays locations that match your entry, and you can select a location. Required when creating. See create a product location, above, for more information. See location for background. The location code and the location name are separated by a hyphen (-). |
Search Results fields: | |
Type |
See location type. |
Location |
See location. The location code and the location name are separated by a hyphen (-). |
System |
The system associated with the system product and location. |
System Product |
The system product associated with the system and location. |
Edit |
Select the edit icon () to advance to the Edit Product Location screen, where you can review and work with availability information and see when the information was most recently updated. Note: If the Edit Product Location screen is already open in another tab, you advance to that screen, where the previously-selected product location is displayed. |
Delete |
Select the delete icon () to delete the product location from Order Orchestration. |
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.
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 Administration System integration: The availability calculation in Order Administration 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 the Order Administration before scheduling periodic import of inventory information into Order Orchestration.See the Order Administration 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 Orchestration uses this quantity to calculate the Available to Promise if:
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 Administration 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 Administration 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:
|
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. You might use the status as part of a probability rule that excludes discontinued products. Possible statuses are:
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:
You might use this setting as part of a probability rule that reduces the quantity that is expected to be available to fulfill orders. 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. You might use the selling price in a probability rule to exclude lower-priced items. |
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. You might use the cost in a probability rule to exclude higher-cost items. |
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. |
Browse Product Locations
Purpose: Use the Browse Product Locations window to review availability information for a product location, or to check the last time this information was updated.
Used for the Routing Engine module.
Product relationships: See Product, System Product and Product Location for an overview of the relationships among Order Orchestration elements, including product locations. Also, see the Product Locations screen for more information on how product locations are created in Order Orchestration.
Updated how? The availability information displayed at this screen can be updated by:
- a periodic refresh from an external system (such as product import processing from the order management system, such as Order Administration System)
- entry at the Edit Product Location screen
- the Fulfilled Inventory Export
- the availability update request
- the product update request
- an on-demand refresh triggered by a locate items search or product availability search for an online system
- OCDS or Merchandising Omni Services Imports
Order Orchestration uses the availability information displayed here to select a fulfilling location, or sourcing location for a ship-for-pickup order, when:
- the location is in an offline system, or
- the location is in an online system, but Order Orchestration cannot communicate with the system and the No Offline Response Action setting at the Preferences screen is Use offline
Systems that use purchase order layering: The Next PO date and quantity listed might not reflect the date and quantity on the next open purchase order for a product if you integrate with a system such as Order Administration, which uses purchase order layering. In purchase order layering, the system accounts for the total quantity backordered to determine which purchase order might be able to fulfill a new order for the product. For example, the backorder quantity for a product is 115. There are 2 open purchase orders for the item, each with an order quantity of 100. Purchase order layering uses the date of the second purchase order as the Next PO Date since the full order quantity of the first purchase order is already fully committed to prior backorders. Also, it reports that the Next PO Quantity is 85, since the first 15 on the second purchase order is also already committed.
Note:
It is important to run the Batch Purchase Order Layering program (BPOL) in the Order Administration before importing inventory information into Order Orchestration.About attributes: The product attributes (Daily Sell Through Quantity, Sell Quantity/Multiple, Minimum Sell Quantity, Shrink Rate %, and Sales Velocity) are metrics that you can define for a product location in order to use them in probability rules. For example, you might want to display an available quantity of 0 if the actual available quantity is not more than the daily sell-through quantity for an off-line location. You can also have the Routing Engine use the Sales Velocity for product location ranking.
Additional attributes (Status, On Clearance, Selling Price, Cost, and Margin) can be used as part of LocateItems Sequence and Splitting Examples (Standard Brokering).
How to display this window: Click to highlight a product location at the Product Locations screen.
Options at this window
Option | Procedure |
---|---|
review the next product location |
Click the next icon () to display the next product location. |
review the previous product location |
Click the previous icon () next to display the previous product location. |
edit the current product location |
Select Edit to advance to the Edit Product Location screen. |
Fields at this window
Note:
All fields at this window are display-only.Field | Description |
---|---|
Informational fields: | |
Location |
The location code and name are separated by a hyphen (-). |
System Product |
The system product code. The name is not displayed. |
Type |
The location type code. The name is not displayed. |
System |
The system code and name are separated by a hyphen (-). |
Availability fields | |
Available Quantity |
The quantity of the product available in this location as of the most recent update, before subtracting the Reserved Quantity and any Fulfilled Quantity, or applying any probability rules. This information can by updated through:
See the discussion above under Browse Product Locations for more information. Up to 6 positions, and can be a negative number. Order Orchestration uses this quantity to calculate the Available to Promise unless it receives an update from an online system. Probability rules: Probability rules use the Available to Promise in tests, calculations, and results. See Probability Rule Wizard for background. |
Reserved Quantity |
The quantity on all order lines assigned to this product location that are in a status indicating the inventory is reserved for existing orders. The reserved quantity and any fulfilled quantity are subtracted from the Available Quantity to determine the Available to Promise quantity. Up to 6 positions. You can use the System screen to select the statuses that indicate an order line is reserved. In the case of ship-for-pickup orders, the reserved quantity is updated at the sourcing location. The reserved quantity displayed here is 0 if there are no order lines in a selected status assigned to this product location. For more information: See the Reservation tab at the System screen for information on selecting reserved statuses, and see Calculating the Available to Promise Quantity for an overview. |
Fulfilled Quantity |
The quantity that has been fulfilled on delivery or pickup orders, or put in transit for ship-for-pickup orders, since the last fulfilled quantity export to the system, or inventory import from the system. The reserved quantity and any fulfilled quantity are subtracted from the Available Quantity to determine the Available to Promise quantity. Up to 6 positions. In the case of ship-for-pickup orders, the fulfilled quantity is increased at the sourcing location when the pickup location changes the status to fulfilled. Tracked when? The Track Fulfilled Quantity field at the System screen controls whether to track the fulfilled quantity and, if so, when to reset it. For more information: See the Track Fulfilled Quantity field for a discussion of how the fulfilled quantity is tracked, and see Calculating the Available to Promise Quantity for an overview. |
Available to Promise |
Used for: The quantity for the system to use when determining the available quantity to return in the LocateItems response and the product availability search, and to evaluate locations for order assignment. Up to 6 positions, and can be a negative number. Calculation: Calculated by subtracting the Reserved Quantity and any Fulfilled Quantity from the Available Quantity for the product location. When you update the Available Quantity at this screen and press the tab key, the screen updates the Available to Promise quantity based on your entry. Probability rules: If a probability rule applies to the product location, it is calculated based on this quantity. For more information: See Calculating the Available to Promise Quantity for an overview. |
Next PO date |
The next date when a purchase order for this product is expected for delivery. Order Administration integration: The date is calculated using purchase order layering, in which the expected quantity on a purchase order may be “reserved” for older backorders. This information is not updated automatically from the Order Administration each time you enter or maintain a purchase order. Some other activity, such as a change to the available quantity above or below the specified threshold, is required to trigger an update from the Order Administration to Order Orchestration. See the Order Administration 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. Order Administration integration: This information is not updated automatically from the Order Administration each time you enter or maintain a purchase order. Some other activity, such as a change to the available quantity above or below the specified threshold, is required to trigger an update from the Order Administration System to Order Orchestration. |
Last Updated |
The last date and time when this product location was updated through the product and inventory import process, Fulfilled Inventory Export, inventory inquiry, or interactively at this screen. Up to 6 positions. Not updated when Order Orchestration updates the Reserved Quantity or the Fulfilled Quantity. |
Attributes |
The following product attributes are available to guide selection of fulfilling or sourcing locations for orders:
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. You might use the status as part of a probability rule that excludes discontinued products. Possible statuses are:
|
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:
You might use this setting as part of a probability rule that reduces the quantity that is expected to be available to fulfill orders. 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. You might use the selling price in a probability rule to exclude lower-priced items. |
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. You might use the cost in a probability rule to exclude higher-cost items. |
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. |
Edit Product Location
Purpose: Use the Edit Product Location screen to review or update availability information for a product location, or to check the last time this information was updated.
Used for the Routing Engine module.
Product relationships: See Product, System Product and Product Location for an overview of the relationships among Order Orchestration elements, including product locations. Also, see the Product Locations screen for more information on how product locations are created in Order Orchestration.
Updated how? The availability information displayed at this screen can be updated by:
- a periodic refresh from an external system (such as product import processing from the Order Administration system)
- entry at the Edit Product Location screen
- the Fulfilled Inventory Export
- the availability update request
- the product update request
- an on-demand refresh triggered by a locate items search or product availability search for an online system
- OCDS or Merchandising Omni Services Imports
Order Orchestration uses the availability information displayed here to select a fulfilling location or a sourcing location for a ship-for-pickup order when:
- the location is in an offline system, or
- the location is in an online system, but Order Orchestration cannot communicate with the system and the No Offline Response Action setting at the Preferences screen is Use offline
Order Orchestration uses the availability information displayed here in the locate items response when:
- the location is in an offline system, or
- the location is in an online system, but Order Orchestration cannot communicate with the system and the No Offline Response Action setting at the Preferences screen is Use offline
Systems that use purchase order layering: The Next PO date and quantity listed might not reflect the date and quantity on the next open purchase order for a product if you integrate with a system such as Order Administration, which uses purchase order layering. In purchase order layering, the system accounts for the total quantity backordered to determine which purchase order might be able to fulfill a new order for the product. For example, the backorder quantity for a product is 115. There are 2 open purchase orders for the item, each with an order quantity of 100. Purchase order layering uses the date of the second purchase order as the Next PO Date since the full order quantity of the first purchase order is already fully committed to prior backorders. Also, it reports that the Next PO Quantity is 85, since the first 15 on the second purchase order is also already committed.
Note:
It is important to run the Batch Purchase Order Layering program (BPOL) in Order Administration before importing inventory information into Order Orchestration.About attributes: The product attributes (Daily Sell Through Quantity, Sell Quantity/Multiple, Minimum Sell Quantity, Shrink Rate %, and Sales Velocity) are metrics that you can define for a product location in order to use them in probability rules. For example, you might want to display an available quantity of 0 if the actual available quantity is not more than the daily sell-through quantity for an off-line location. You can also have the Routing Engine use the Sales Velocity for product location ranking.
Additional attributes (Status, On Clearance, Selling Price, Cost, and Margin) can be used as part of LocateItems Sequence and Splitting Examples (Standard Brokering).
How to display this screen:
- Click Edit for a product location at the Browse Product Locations window
- Select the edit icon () for a location at the Product Locations screen
- Only users with Products authority can display this screen. See Roles for more information.
- If the Edit Product Location screen was already open in another tab when you clicked the edit icon, you advance to this screen with the previously-selected product location displayed.
Updating a product location
Update any of the fields described below and click Save, or click Cancel to return to the Product Locations screen without making any changes.
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 space. |
Last Updated |
The last date and time when this product location was updated through the product and inventory import process, Fulfilled Inventory Export, inventory inquiry, or interactively at this screen. Up to 6 positions. Display-only. Not updated when Order Orchestration updates the Reserved Quantity or Fulfilled Quantity. |
Availability fields: | |
Available Quantity |
The quantity of the product available in this location as of the most recent update, before subtracting the Reserved Quantity and any Fulfilled Quantity, or applying any probability rules. This information can by updated through:
See the discussion above under Edit Product Location for more information. Order Orchestration uses this quantity to calculate the Available to Promise unless it receives an update from an online system. Note: The available quantity is a maximum of 6 positions, and can be a negative number. It cannot include decimals. Probability rules: Probability rules use the Available to Promise in tests, calculations, and results. See Probability Rule Wizard for background. |
Reserved Quantity |
The quantity on all order lines assigned to this product location that are in a status indicating the inventory is reserved for existing orders. The reserved quantity and any fulfilled quantity are subtracted from the Available Quantity to determine the Available to Promise quantity. Up to 6 positions. In the case of ship-for-pickup orders, the reserved quantity is updated at the sourcing location. You can use the System screen to select the statuses that indicate an order line is reserved. The reserved quantity displayed here is 0 if there are no order lines in a —toselected status assigned to this product location. Display-only. For more information: See the Reservation tab at the System screen for information on selecting reserved statuses, and see Calculating the Available to Promise Quantity for an overview. |
Fulfilled Quantity |
The quantity that has been fulfilled on delivery or pickup orders, or put in transit for ship-for-pickup orders, since the last fulfilled quantity export to the system, or inventory import from the system. The reserved quantity and any fulfilled quantity are subtracted from the Available Quantity to determine the Available to Promise quantity. Up to 6 positions. In the case of ship-for-pickup orders, the fulfilled quantity is increased at the sourcing location when the pickup location changes the status to fulfilled. Tracked when? The Track Fulfilled Quantity field at the System screen controls whether to track the fulfilled quantity and, if so, when to reset it. Display-only. For more information: See the Track Fulfilled Quantity field for a discussion of how the fulfilled quantity is updated, and see Calculating the Available to Promise Quantity for an overview. |
Available to Promise |
Used for: The quantity for the system to use when determining the available quantity to return in the LocateItems response and the product availability search, and to evaluate locations for order assignment. Up to 6 positions, and can be a negative number. Display-only. Calculation: Calculated by subtracting the Reserved Quantity and any Fulfilled Quantity from the Available Quantity for the product location. When you update the Available Quantity at this screen and press the tab key, the screen updates the Available to Promise quantity based on your entry. Probability rules: If a probability rule applies to the product location, it is calculated based on this quantity. For more information: See Calculating the Available to Promise Quantity for an overview. |
Next PO Date |
The next date when a purchase order for this product is expected for delivery. Order Administration integration: The date is calculated using purchase order layering, in which the expected quantity on a purchase order may be “reserved” for older backorders. This information is not updated automatically from Order Administration each time you enter or maintain a purchase order. Some other activity, such as a change to the available quantity above or below the specified threshold, is required to trigger an update from Order Administration to Order Orchestration. See the Order Administration 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. Order Administration integration: This information is not updated automatically from Order Administration each time you enter or maintain a purchase order. Some other activity, such as a change to the available quantity above or below the specified threshold, is required to trigger an update from Order Administration System to Order Orchestration. |
Attributes |
The following product attributes are available to guide selection of fulfilling or sourcing locations for orders:
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. You might use the status as part of a probability rule that excludes discontinued products. Possible statuses are:
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:
You might use this setting as part of a probability rule that reduces the quantity that is expected to be available to fulfill orders. 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. You might use the selling price in a probability rule to exclude lower-priced items. |
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. You might use the cost in a probability rule to exclude higher-cost items. |
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. |