The Inventory Limits screen has various settings controlling calculations and classifications for your inventory at different levels in your hierarchy. System-wide inventory limits settings can be found in the Global Inventory Limits screen
Inventory Settings
-
Stockout Basis: Whether an item is stocked out when On Hand is <= Out of Stock Quantity, or your Available Quantity is <= Out of Stock Quantity. For most organizations, where you will still receive demand and will fill backorders even if you are out of stock, "On Hand" is the appropriate setting. However, if, when you are out of stock or have no available, you will not receive orders from your customers (e.g. they can see inventory levels on your website or something), then it may be appropriate to set this to Available Quantity.
- NOTE: A related setting for situations where no backorders are done is the "Allow Forecast Backorders" setting in the Global Replenishment Settings screen.
- Excess Basis: Which value you want StockIQ to use to determine whether an item is in excess or not
- # Days Items New: The age of an item, based on either DateCreated or DateFirstStocked (see below) after which it is no longer considered new.
- Use First Sale Date: Many ERP's do not have good Date Created values for their Item-Sites. In that situation, StockIQ can fall back on using the first sale date of that item if no other data is available.
-
Allow Date First Stocked: Alternately, if we can determine the date first stocked in the extracts, this value can substitute for a Date Created.
- IMPORTANT: If a Date First Stocked is available, and this option is selected, this will be used as the item's creation date instead of the DateCreated value, even if a Date Created is present. This is due to the fact that the ERP Date Created is often an unreliable value, and this provides a useful alternative.
- Supply Days Excess Threshold: How many days above your current Max Stock level before an item moves from being "Overstocked" to "Excess."
- Dead Stock Days Back: How many days back to search for a sale before an item is considered dead. Usually 1 year.
- Slow Mover Days Back: How far back to search for a sale when considering an item might be slow, usually six months, or around 50% of your dead stock range is a good guideline.
- Slow Mover Max # Hits: In addition to the slow mover days back number, an item must have greater than this number of hits within that range to avoid being identified as slow.