Inventory Velocity Report

This report calculates reorder dates and suggests reorder quantities using the lead time, safety stock and velocity (units sold/day) parameters. Use this report to make sure you have enough inventory in stock to meet your forecasted sales.


This report can be scheduled to run automatically in the Report Scheduling module and delivered to your inbox.


NOTE: The Inventory Velocity Report is not available for DEAR business accounts that have been cancelled or are in arrears. In these cases, the Inventory Velocity Report page will show the last generated report, if any.


Prerequisite:


Data from this report can be exported in Excel, PDF or RTF format. 


Input:

Time PeriodAllow user to select the time period from a list of options.
Recommended ActionFilter report results by recommended action (Specify reorder quantity, Reorder product, Inventory product is OK, All)
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets layout to the default layout or selected saved layout.


Every time the report is generated, the data for the previously generated one is written over. Only users with active Reporting permissions can generate the report.


If you have an active Report Scheduling module, the Inventory Velocity Report can be scheduled to run using the module.


If you do not have an active Report Scheduling module, the Inventory Velocity Report can be generated manually by clicking the Upload Report button on the Inventory Velocity Report page.


Output:


Fields
Location    Name of the location
Supplier
Name of the supplier
Product NameName of the product
Product SKUSKU number of the product
ActiveIndicates if the product is active
On B2B portalIf the product is listed in B2B portal = True
If the product is not listed in B2B portal = False
On Sales ChannelsIf the product is listed in Sales Channels = True
If the product is not listed in Sales Channels = False
ComponentIf the item is a component in BOM = True
If the product is not a component in BOM = False
Finished GoodIf there is a BOM for the product = True
If there is no BOM for the product = False
On HandQuantity of units on hand
Recommended Action
The number of available units.
If the number of available units + awaiting units < 0 and reorder quantity is specified for a product, then the recommended action for the product = reorder, even if velocity=0.
Last SaleDate of last sale
Date AddedDate of 1st movement in DEAR
Days Since AddedNumber of days since the product was added to DEAR
Data Headers
Available
The number of available units.
If the number of available units + awaiting units < 0 and reorder quantity is specified for a product, then the recommended action for the product = reorder, even if velocity=0.
On Hand
Quantity of units on hand
Units SoldThe number of products sold in the last 7/14/30/60/90 days
Shipped Per DayProducts shipped per day
VelocityUnits sold per day based on movement from the last 7/14/30/60/90 days.
Computed as {Quantity of items sold for the reporting time}/{reporting time}.
Quantity of items sold for the reporting time is the sum of sold items in Sale, Assembly, Disassembly, and Write-off tasks.
Even if velocity = 0, if the number of available units + awaiting units < 0 and reorder quantity is specified for a product, DEAR will recommend reordering the product.
Days to ZeroExpected number of days until the inventory of the product becomes zero. Computed as {available units} / {inventory velocity}.
Available units value is taken from the Available column.
On OrderExpected number of days open POs will add to supply.
Computed as {awaiting units} / {sales velocity}.
Awaiting units refer to the quantity of items not yet received from all authorised POs.
Lead StockExpected number of days between opening and submitting the PO to the supplier and receiving the stock.
Safety Defined
Preferred minimum number of days of inventory (safety stock).


  • When computing for the Product Reorder Quantity, DEAR considers the following:
    • The Reorder Quantity value under the Suppliers tab on a product's Details page.  
    • If the Reorder Quantity is not specified for the Supplier+Location combination under the Suppliers tab, the system gets the Reorder Quantity for a specified location from the Reorder Levels tab instead.
    • If the Reorder Quantity is not specified for the location under the Reorder Levels tab, the system gets the Reorder Quantity from the product's Details page.
  • When computing for the Minimum before Reorder Quantity, DEAR considers the following: 
    • The Minimum Before Reorder quantity under the Reorder Levels tab on a product's Details page.
    • If the Minimum before Reorder quantity is not specified for the product, the system gets the Minimum before Reorder quantity from the product's Details page.
    • The Minimum before Reorder quantity that is set up under General Settings > Purchase Process Customisation is not considered in the computation.
  • The Minimum Before Reorder quantity on a product's Details page and the Minimum To Order quantity under the Suppliers tab are different from each other.
    • Minimum Before Reorder is part of the final Reorder Quantity formula, i.e. Reorder Quantity = Product Reorder Quantity + Minimum Before Reorder - Available - On Order.
    • Minimum To Order prevents you from ordering anything less than the stated quantity from a particular Supplier.
  • If the number of available units + awaiting units < 0 and the Reorder Quantity is specified for a product, then the recommended action = reorder, even if product velocity = 0.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.