- Go to
- Type a Warehouse ID or search for one.
Optional: Select a BuyerA user who purchases for a select group of vendors, typically used in companies with multiple purchasing agents. When selected, only the assigned vendor will appear in the results. Users can be assigned to a vendor in the vendor master., if applicable.
- Click Go.
The SporadicA product that has demand in less than 8 months of the previous 12 completed months. An accurate forecast formula cannot be applied to products with little demand. Alternatively, the mode (or if there is no mode, then the median average) of previous sales quantities is used. It can be overridden by setting a Max Stock Quantity. Demand panel displays a list of products with sporadic demand.
- Select a product row, and then review and analyze the twelve month transactions and demand.
- Based on the Suggested MaxCalculated from the mode, which is the most commonly ordered quantity. If no mode can be determined, then the median average demand is used. This suggestion keeps enough product in stock for most sales, without over ordering resulting in excess inventory., type a new maximum stock quantity in the Max cell.
- Optionally, mark infrequently sold items as Non-StockProducts with this status are hidden from Projected Purchase Orders, unless the item is committed to a sales order. This status is typically used for products that are not regularly stocked such as special order or a one-time purchase..
- Click Save.
- Items with a Max Stock Qty will be removed from the Sporadics list until expiration.
- An Expiration DateThe date on which the Max Stock Quantity will expire and be removed from the product. This expiration allows the product to be reevaluated with the new demand that has occurred since the last Max value was set. By default, the expiration is set to 180 days, but can be modified in Forecast Parameters. is applied automatically.
Tip: When no max value is set, the system will forecast to the Suggested Max value. This makes it possible to bypass this step entirely, though best practice is to review and make adjustments on an ongoing basis.