Skip to main content

Forecasting: Viewing/Updating Inventory Record

Distributor steps for viewing and bulk-editing product forecasting fields (target/max DOI, lead time, forecast group, forecast method) on the Inventory (Forecasting) table in Encompass. Requires v22.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 22.01

Steps

How to View or Update Inventory Records
​
​

1. Expand Purchasing on the menu
​
​

2. Click Purchasing Home
​
​

3. Go to the Inventory (Forecasting) table. This table view is specifically for viewing forecasting information
​
​

  • Here you can view or batch update (edit/fill down) forecasting fields on the inventory table
    ​
    ​

4. Inventory Forecasting Fields:

  • Purchase By Unit - Default is Pallet. This is used to calculate estimated orders in the forecast tool. If cases per pallet are 60 then the estimated order will be 60. If you are transferring full layers or even cases to another warehouse, you would want to change this to Layer or Case.

  • Target DOI - Overrides Target DOI Effective.

  • Target DOI Effective - Days of inventory goal for the product (safety stock). This will inherit from the Suppliers Vendors table.

  • Max DOI - Overrides Max DOI Effective

  • Max DOI Effective - Used to prevent the system from generating an estimated order if it would cause DOI to go over the Max DOI.

  • Lead Time Days - Overrides Lead Time Days Effective

  • Lead Time Days Effective - How many days it takes an order from the supplier or shipper to get the product to the warehouse.

  • Last Forecast Date Time - The last time a product was forecasted in the system.

  • Forecast Group - Overrides Forecast Group Effective.

  • Forecast Group Effective - Forecast Group set on the product. This will inherit from the Suppliers Vendors table.

  • Product Launch Date - Earliest Date the product was on a verified invoice.

  • Forecast Method - Trend, Average, Model, or Last Year's Sales.

  • System Forecast Method - Forecast Method the system will use for auto-forecasting, and these are independent of the forecast method that users can change.

  • Sales Period By Week - Number of weeks used to calculate the forecast for weekly trends from the prior year.

  • Trend Period By Week - Number of weeks used to calculate the forecast for weekly trends from the prior year.

  • Sales Period By Month - Number of months used to calculate forecasts for a monthly average.

  • Trend Period By Month - Number of months used to calculate the forecast for monthly trends from the prior year.

  • Model Forecast Product - Product used when the forecast method is set to Forecast by Model.

  • Combined Forecast Product - Product used when the forecast method is combined.

  • Exclude Backorder - When False, backorders will be included with historic sales to create forecasted sales.

  • Forecast Percent - When False, backorders will be included with historic sales to create forecasted sales.

Did this answer your question?