Versions Compared

Key

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

...

What are the fields on the Raw Sales Data screen?

  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

    1. 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

    1. is product category - useful for planning across suppliers for a single category
  4. Date Range

    1. is the period that will be shown
  5. Display order

    1. is the Grouping of the results - you have different options to see the information in different ways.
  6. Recalculate Sales Data

    1. (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 and includes JIT items parts etc, sell rate 2 which is updated weekly and based only on sales orders, reorder triggers)
    2. 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. 
    3. Sales data is kept in Raw_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

    -

    1. 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

SKU's being replaced 

When a product is no longer to be purchased but still has stock (so cannot yet be made inactive) AND there is a clear replacement item that will be purchased as an alternative.

...