What happens when the available stock of a quantity item reaches zero, and how does this affect the Quantity Item Cost Report?

  • Updated

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:

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 :

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.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request