In this example, we’ll see how a missed invoice makes an impact on your variance.
Looking at this Coors Light, it shows we sold 50 cans, but only consumed 2. While this looks like a dream come true, it is in fact a data error.
If we click on the Details button, we can get more information:
When we look at the Sold / Consumed tab, we see we started with 60 units, added no invoices, and ended with 58 units. This puts our consumption at 2 units, but 50 were sold during the period.
If we click on the Item Inventory / Invoices tab, we see that there are no invoices for this item.
In this example, let's say we received two cases of 24 cans 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 Item Inventory / Invoices tab:
The invoice now appears, but you can see that when we entered the invoice we forgot to backdate it. Even though we have added it into the system, it is not applying to the most recent inventory period between Apr 2 3:59pm and Apr 9th 4:13pm.
We need to go back into that invoice and edit the time to reflect when it was put into stock. You can edit the time in the app or WISK Web Portal.
With the time changed, you’ll now see that the invoice 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.