The Inventory Valuation Report By Category is a list of categories with available quantities and COGS. (RT)
The Inventory Valuation Report By Category Report can be accessed by navigating to Reports > Inventory. It will be located on that list of reports.
The following is a list of all the types of data you will get in this report, and what they all mean. There is also an example export of this report attached to this support document.
- Product Category: Category of the product as assigned in BLAZE®.
- Avg Unit Cost: The average price you have paid for the product from a vendor.
- Avg Excise Cost: The average excise cost per product.
- Unit + Excise Cost: The total price for the product after adding "Unit Cost" + "Excise Cost."
- Avg Retail Price: Average retail price for the product as assigned in BLAZE®.
- Avg Profit: The average amount of profit made per product.
- Avg Margin %: The average margin percentage per product.
- Avg Markup %: The average markup percentage per product.
- Total Available Quantity: The total amount of product as found in BLAZE®.
- Total Available COGS: The total COGS for the available products as found in BLAZE®.
- Total Available Excise: The total amount of excise tax for the product as found in BLAZE®.
- Total Available COGS + Excise: The total amount of excise tax and COGS per product as found in BLAZE®.
- Total Available Prepackage: The total amount of prepackaged inventory per product as found in BLAZE®.
- Total Available Prepackages COGS: The total amount of available prepackaged product COGS.
- All Holds: The total amount of holds per product.
- All Holds COGS: The COGS for On Hold products
- All Prepack Holds: The total amount of prepacked hold products.
- All Prepack Hold COGS: The total COGS for prepacked hold products.
In order to optimize our reporting, reports over a 2-week period will no longer be shown in our UI. Any reports over a 2-week period will be auto-generated and sent to the email you are logged in with.
- To access these generated reports in BLAZE®, navigate to Data Export > Generated, you will find a list of generated reports you can easily download.