Product Days of Supply Report
Shows how many days each product's stock will last at the rate it sold during the chosen period.
Menu: Reports › Product Reports › Product Days of Supply Report
What it's for
Use it to find products about to run out (few days of supply) and overstocked products (many days). Days of Supply = Total Inventory ÷ (Sold Qty ÷ number of days in the Transaction Date range). It is empty when nothing was sold in the period.
With the last 30 days as Transaction Date, Shampoo Sachet has Inventory 150, Intransit Qty 50 and sold 600: 200 ÷ (600 ÷ 30) = 10 days of supply. The supplier needs 14 days to deliver, so the buyer orders today.
Filters
Click Filters to narrow the report. You can filter by:
Branch Area, Transaction Date, Stock No., Name, Brand, Category Tag, Inventory Status, Product Tag, Product Branch Remarks, Branch Promoter, Branch Remarks, Branch, All Branch (Merged).
Columns
| Column | What it shows |
|---|---|
| Code | The product's stock number. |
| Product Branch Remarks | The product's remark for the branch. |
| Branch Promoter | The promoter assigned to the product's brand in the branch. |
| Name | The product name. |
| Inventory | Current stock, in the product's default unit. |
| Intransit Qty | Quantity sent to the branch by stock delivery and not yet received. |
| Total Inventory | Inventory plus Intransit Qty. |
| Sold Qty | Quantity delivered on sales outbounds in the date range. |
| Days of Supply | Total Inventory ÷ average quantity sold per day. |
| Date of First Purchase | When the product was first received. |
| Days Since Purchase | Days since the last purchase inbound. |
| Last Purchase Date | Date of the last purchase inbound. |
| Branch Remarks | The product's remark for this branch (Branch tab of the product). |
Also shows: Branch, Brand, Description, Branch Area.
Good to know
Tick All Branch (Merged) in the filters to add all branches together into one line per product.
For searching, express filters, sorting, column settings, exporting and printing, see About reports.