In this article, you'll find examples of common errors that impact your consumption data.
Example - Missing Invoice
In this example, we’ll show how a missed invoice affects your variance.
High Sales & Low Consumption
Looking at this Coors Light tall can, we sold 50 units based on our POS mapping and sales data, but only consumed 2.
If we click the Details button, we can get more information:
When we look at the Sold / Consumed tab, we see we:
Started with 28 units
Had no invoices for this period
And ended with 26 units
This puts our consumption at 2 units, but as we see 50 were sold during the period.
When we look at the "Sold" section, the quantity sold matches the data from our POS. We know for a fact that we sold 50 units.
So now it's clear that the issue is with our consumption. This is a good time to ask those three questions:
Was this my beginning inventory count?
Did I receive this amount in this period?
Was this my ending inventory count?
In this example, we're confident our inventory counts are correct, but we know we received more of this item, despite it showing as 0 received on invoices.
It's possible that the invoice was added, but dated incorrectly. To see the item's full history, click the "Inventories / Invoices / Depletions" tab.
On this screen we see that this item has only appeared in our two inventory counts, and there are no invoices on record containing it.
This rules out that the invoice was added with the incorrect date/time.
At this point you could also check your other invoices. If you received a delivery from the distributor that normally supplies this product, it's possible it wasn't entered on the invoice. In that case you would edit the existing invoice:
In this example, let's say we received two cases of 24 units earlier in the week, for a total of 48 units, but forgot to enter it in WISK.
To fix the consumption, we must add this invoice into the system. You can check to see if there are any open purchase orders, or you can add a manual invoice.
Now that we have added our invoice of 2 cases of 24 units (for a total of 48), we can go back to the Inventories/Invoices/Depletions tab:
The invoice appears, but you can see that when we entered the invoice we forgot to backdate it. Even though we've added it into the system, it's not applying to the most recent inventory period between Mar 3, 10:19am and Mar 10, 10:39am.
Set Correct Invoice Time
We need to go back into that invoice and edit the time to reflect when it was put into stock. The date/time should fall in between the inventory period.
You can edit the time in the app or WISK Web Portal.
After changing the time, wait a few moments for your update to be pushed to the rest of your data. When you go back to the Inventories / Invoices / Depletions tab, you’ll see that the invoice now falls in between the two most recent inventories:
When we go back to the Variance page, we’ll now see that the Consumption and Sales match, and there is no longer a variance.