Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Warehouse choice
    1. If you choose no warehouse - the system lists all warehouse as below
    2. If you choose all warehouses - you will get a summary view company wide (no warehouses)
    3. Or you can choose an individual warehouse
  2. Supplier is optional - but useful if planning for a purchase order.  Supplier factory limits products to those shipped from that factory (See settings at bottom).
  3. Category is product category - useful for planning across suppliers for a single category
  4. Date Range is the period that will be shown
  5. Display order is the Grouping of the results - you have different options to see the information in different ways.
  6. Recalculate Sales Data (Sales Snapshot - per item per week per warehouse includes sell rate - warehouse item table (article ID, date ID, sell rate 1 which is updated weekly, sell rate 2, reorder triggers)
    1. The sales data will recalculate every Sunday night looking back 4 weeks for changes to sales orders.  However if you make some changes to sales orders or other changes and you then want the sales history data used by forecasting updated - use this button. 
    2. Sales data is kept in Raw_UnitWarehouseWeeklySales Unit_Warehouse_Weekly_Sales which is based on sales orders (SKU, weekending date, warehouse, SKU, plan qty, shipped qyt, promotion qty, adjusted quantity as could have been manually adjusted)
  7. Minimum Lead Days - forecasting will not consider any stock item that has a lead time below this value (on the SKU or if none there then on the supplier) as this will be managed through the daily purchase order screen

...