Versions Compared

Old Version 12

changes.mady.by.user Paul Sawkins

Saved on

compared with

New Version Current

changes.mady.by.user Paul Sawkins

Saved on

Key

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

...

Right click to filter in the grid

  1. Stock Reports form, Report By; Stock Aging:

    1. Warehouse filter list:

      1. Include – Group --

      2. Only works for Stock Aging report.

      3. If selected for other reports then ‘This report does not support Warehouse -- Group --’ will display as a warning message.

      4. If selected for Stock Aging reports then results will be combined for warehouses in group.

    2. Aging Qty filter:

      1. Each:

        1. Displays the number of units to the left of the value for SOH and each of the day ranges, e.g. ‘0-30 Each’.

      2. Carton:

        1. Displays the number of units per carton to the right of SOH, headed '/Carton'.

        2. Displays the number of cartons to the left of the value for SOH and each of the day ranges, e.g. ‘0-30 Carton’.

        3. Calculated as the number of units divided by the Carton Qty (Article form, Physical Properties) rounded to 2 decimal places.

        4. If no Carton Qty then it defaults to 1.

      3. Pallet:

        1. Displays the number of units per pallet to the right of SOH, headed ‘/Pallet’.

        2. Calculated as Cartons Per Layer multiplied by Layers Per Pallet (Article form, Selling / Shipping / Warranty), if any.

        3. Otherwise calculated as 2.1 m3 (nominal pallet capacity in cubic metres) divided by carton volume, then truncated to whole number and multiplied by Carton Qty.

          1. Carton volume is Carton Width X Depth X Height (Article form, Physical Properties), if any, in Unit, defaults to cm.

        4. Otherwise calculated as 2.1 m3 (nominal pallet capacity in cubic metres) divided by product volume, then truncated to whole number.

          1. Product volume is Packaged Product Width X Depth X Height (Article form, Physical Properties), if any, in Unit, defaults to cm.

        5. Otherwise 1.

        6. Displays the number of pallets to the left of the value for SOH and each of the day ranges, e.g. ‘0-30 Pallet’.

        7. Calculated as the number of units divided by the pallet capacity rounded to 2 decimal places.

    3. Day ranges:

      1. > 90 split into 91-180 and >180.

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.

...