Article Contents
Introduction
If an invoice isn't added with the correct date and time, your consumption data may be inaccurate. To have a complete understanding of its impact, you need to know two things:
Your consumption between two inventory counts is calculated as follows:
Consumption = Starting Inventory + Invoices - Ending Inventory
WISK uses the start time of inventory counts for all calculations
Editing an Invoice Date / Time
If you have added an invoice with the wrong date/time, you can edit it on either the WISK Web Portal or mobile app. Learn more here:
Impact of an Incorrect Date / Time
Wrong Invoice Date
If an invoice is added on the wrong date, it may not fall into the correct inventory period. It's very important that the invoice be sandwiched between the right dates so that the Consumption calculation above contains the correct values.
Wrong Invoice Time
The same issue can arise when adding an invoice on the same date as an inventory session.
Since WISK uses the inventory's Start Time to determine when it occurred, it will make a difference whether the invoice time is before or after the inventory has started.
For these instances, we recommend leaving your received stock to the side, doing your inventory (while excluding these new items), then adding the invoice after the inventory has been completed.
Example
Let's say for a given week, you start off with 10 units of an item, receive 6 units from an invoice, then count 9 units the next time you take inventory. Based on the Consumption calculation, you should have consumed 7 units.
10 (beginning) + 6 (received) - 9 (ending) = 7 units consumed
If your invoice with the 6 units was entered at the incorrect time (at a date/time outside of the inventory period), the consumption calculation for the period will look like this:
10 (beginning) + 0 (received) - 9 (ending) = 1 unit consumed
The resulting consumption will be too low for the period that was supposed to contain this invoice and it will be too high for the period that now mistakingly contains this invoice.
Stock Error / Negative Consumption
Whenever you see a Stock Error, also known as Negative Consumption in your reports, it is either due to miscounts or misdated invoices.
If you take the same example as above, but start off with 7 units, look what happens to your consumption when an invoice isn't added correctly:
7 (beginning) + 6 (received) - 9 (ending) = 4 units consumed
7 (beginning) + 0 (received) - 9 (ending) = -2 units consumed
It shows that you gained 2 units with no reason to account for the increase.
You can learn more about stock errors/negative consumption here: