Retail | Inventory Detail Report

After selecting an inventory (the setting will default to "all" if only one inventory is available), the Inventory Detail report will generate a list of products, current and sold quantity, and COGS.

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.

The Inventory Aging report can be accessed by navigating to Data Export > Inventory. It will be located in the list of reports.

 

NOTE: For this report, the term COGS (Cost of Goods Sold) will come up a lot. To calculate COGS, BLAZE uses the batch COG on a unit level and applies it to the quantity being purchased by the customer to get COGS. This does not include excise tax, excise tax is a separate line item.

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: Name of the product as assigned in BLAZE.
  • Category: Category of the product as assigned in BLAZE.
  • Status: Active / Inactive value for the product in BLAZE.
  • Low Inventory Threshold: Threshold value where low inventory alert processes are triggered.
    NOTE: This value is typically assigned during the product creation process, but can also be changed in the product profile.
  • Current Quantity: Current quantity of the product in the selected inventory / inventories.
  • Current COGS: Calculation of COGS for the current inventory / inventories. 
  • Sold Quantity: Current quantity of the product sold from the selected inventory / inventories.
  • Sold COGS: Calculation of COGS for the sold items for the current inventory / inventories. 
  • Current Packages: Current quantity of prepackages in selected inventory / inventories.
  • Current PACK COGS: Calculation of COGS for the prepackaged items in selected inventory / inventories. 
  • Sold Prepackages: Current quantity of prepackages sold