...
The report uses Sales Orders data of delivered quantity or shipped quantity to determine weekly sales looking back to the first sales order found in the period covered by "Sell Rate Days" on stock control form then calculating weekly sell rate. The most recent sales order date and qty are shown.
- Aging in report is based on stock audit records, searched from most recent to oldest.
- Looks at audit records of type: initial stock, PO receipt, positive stock adjustments and RA returns.
- Accumulates the quantity in aging periods up to the current stock on hand.
- Calculates the value as quantity x current average cost.
- Note that counts and values are across all warehouses
- Filters, including warehouse filter, are ignored for this report.
| Note |
|---|
For performance reasons we build a summary of sales by week, article and warehouse for the past 4 weeks each Sunday night. We rebuild the data for the past 4 weeks in case the orders are changed, but we assume that they will be stable after 4 weeks. The weekly sell rate is calculated using this summary data. The last order date and quantity is found from the actual sales records so it is not reliant on the summary data. Before an order is picked it is treated as a sale of the ordered quantity. If it is short picked it is expected that this will be picked up in the recalculations over the next 4 weeks. If an order was picked more than 4 weeks after the order date the short pick will not be reflected in the summary. Therefore it will have a sell rate. The last order date and quantity is taken from the actual order so it recognises that the order was short shipped so it does not list it. If a SKU is no longer in a sales order - something must have been done to remove it more than 4 weeks after the order date. It was only ordered, never picked. if a SKU is in an order that has still not been picked they are counted as sales for calculating the sell rate but not for the last sale date and quantity. |
...