This report shows the current inventory level of each SKU.
Things to know:
- Only stocked products are listed in the report
- Status is based on the "Min" level set from POS > Inventory
To access this report:
Navigate to Dashboard
Select the Reports tab
Under the Point Of Sale section, select the Inventory report
When the report opens, you can filter by a specific location. If the By Location button is used at the top of the report, you will be able to easily compare metrics across locations and location groupings to see which locations are doing better or worse on that dimension.
Below the date and location filter, you will the following features:
Create Snapshot - Provides the ability to record historical inventory levels by saving a snapshot of the data as of that moment and downloading it later as a CSV. The Snapshots can be accessed from the Snapshot tab above. Learn more here
Search bar - This enables you to search for products on the report by SKU#
Excel, PDF and Print icons - you have the ability to export this report to Excel, PDF, or print
Once you have selected your filters, click on the UPDATE button to generate the desired data.
|Brand||Brand of the product|
|Product||The full name of the SKU|
|SKU #||The product ID used by your wholesaler or distributor|
The price paid to the vendor for the SKU. If an SKU has multiple shipments, the cost basis will be calculated as the total cost value of all shipments/quantity of all shipments.
Total cost basis = Total cost / Total quantity
70 / 11 = $6.36
|Retail Price||The price paid by the client for the SKU|
|Vendor||The supplier of the product|
|Retail Stock||The total retail quantity of the product on hand|
|Back Bar Stock||The total back bar quantity of the product on hand|
|On Order Stock||The total quantity from a Purchase Order in ordered status|
|Retail Cost Value||Total retail stock x cost basis|
|Back bar Cost Value||Total back bar stock x cost basis|
|Cost Value||Total retail and back bar stock x cost basis|
|Retail Value||Total retail stock x retail price|
|Min||The quantity at which you want to be alerted to re-order on MyTime.|
|Max||The quantity of each SKU you want to maintain. This is used to calculate the reorder
The quantity level at which you need to reorder the product.
Reorder = Max - Current Retail & Back Bar Quantity OR 0 if total quantity > max
Max = 4
Retail Stock = 2
Backbar Stock = 1
Reorder = 4 - (2 + 1) = 1
Indicates whether a product needs to be replenished.
The alert threshold (Min) is 5.
If the retail/back bar quantity =/< 0, status is OUT
If the retail/back bar quantity < alert threshold (Min), status is LOW
Otherwise, the status is OK