You may notice that a quantity item still appears in the Quantity Item Cost Report even when there is no stock left at a location.
This article explains what happens when the stock quantity reaches zero and why previous cost information may still appear in your reports.
How quantity item costs are recorded
ON!Track records quantity item costs based on the quantity available at a location.
Each cost entry includes:
- Date Arrived: The date the stock quantity became available at the location.
- Date Left: The date that stock quantity ended or changed.
If Date Left is empty, the cost entry is still active.
When the stock quantity changes, for example after a restock, correction, or transfer, ON!Track records the change so that you can view the cost history over time.
What happens when the stock quantity reaches zero?
When the stock quantity is corrected to zero:
- ON!Track closes the current cost entry by adding a Date Left.
- No further cost is calculated for that entry.
- Previous cost entries are kept as part of the item's cost history.
What happens to the quantity item at the location depends on the type of allocation:
| Allocation | What happens when stock reaches zero? |
|---|---|
| Standard allocation without stock alerts | The allocation is removed, and the existing cost entry is closed. |
| Standard allocation with stock alerts | The allocation is kept but is no longer displayed. The existing cost entry is closed. |
| Main allocation | The allocation remains with zero stock. The system closes the previous cost entry and creates a new zero-stock entry. No cost is calculated for the zero-stock entry. |
| Locker or refill allocation | The allocation remains with zero stock. As with a Main allocation, the previous cost entry is closed and a new zero-stock entry is created at no cost. |
Note:
- Stock held by an employee does not create quantity item cost entries.
- If Consumables is not enabled for your company, locker and refill allocations behave like standard allocations.
What does this mean for your reports?
When reviewing the Quantity Item Cost Report:
- Cost calculation stops when the stock quantity reaches zero.
- Previous cost entries are kept so that you can review the item's cost history.
- A cost entry appears when your selected report period overlaps the period between its Date Arrived and Date Left.
- If your report period starts after the Date Left, that entry does not appear.
- An active entry without a Date Left can appear in report periods after its Date Arrived.
- If the quantity item itself is deleted, its cost history is also deleted.
Example
Jobsite A holds screws under a Main allocation :
| Date | What happens? | Cost record |
|---|---|---|
| 1 March | 100 boxes arrive at Jobsite A. | A cost entry starts on 1 March. |
| 10 March | 50 more boxes are added, bringing the total to 150. | The first entry ends on 10 March, and a new entry starts for 150 boxes. |
| 20 March | The stock quantity is corrected to zero. | The current entry ends on 20 March, and no further cost is calculated for it. |
If you create a report for 1 to 31 March, the previous cost entries appear because they were active during that period.
If you create a report for 1 to 30 April, those entries do not appear because they ended in March.
For a Main, Locker, or refill allocation, an additional zero-stock entry remains active. However, it does not add any cost because the stock quantity is zero.