This report shows the details about the inflow and outflow details of stock at a center.

Unable to generate the report??

Navigation

Follow these steps to run the report:

  1. Select the center for which you want to run the report.
  2. On the main menu, go to the Inventory tab.
  3. On the Inventory dashboard, click Reports > Consumption.
    The report appears.
  4. Select the filter criteria and click Refresh to see the report.

Note: To export the report, click the Excel or CSV options.

Filter Criteria

Criteria

Options

Description

Product Type

  • All
  • Retail
  • Consumable

Lets you view the report based on the type of product.

Category

List of all product categories

Lets you view the report based on a product category.

Subcategory

List of all product subcategories

Lets you view the report based on a product category within the main category.

Consumption Date

- 1 month

- 2 months

- 3 months

- 6 months

- Custom

Lets you select the period for which you want to view the report.

To select a date range, select Custom.

Note: For custom dates, you can view data for a maximum date range of 6 months at a time. For example, if you wish to see data from January to August, first view data from January to June and then view data from July to August.

Product Name, Code, Barcode

Lets you generate the report for a specific product by its name or code. You can also scan the product barcode.

Column Descriptions

Column

Description

Additional Information

Code

A unique code that identifies the product.

Name

The name of the product.

Note: Click the product name to view the product history.

Unit

The way you measure the product's quantity.

For example, ml, gallon, oz, grams can be the unit of measurement.

Category

The category to which this product belongs.

For example, in Zenoti your business may have a category such as Hair Care.

Subcategory

The subcategory to which this product belongs.

For example, in Zenoti your business may have a subcategory such as Hair Styling for the category, Hair Care.

Vendor

The vendor to which this product is associated.

Note: If a product is associated with multiple vendors, you will see Multiple in this column.

Opening Qty -

Store

The quantity of this product in store on the report start date.

Note: You will not see this column if your business follows the On-Hand quantity model.

For example, if the report is generated on Jan 1st, for a duration of one month, the report start date is Jan 1st and the report end date is Feb 1st. For this duration, the Opening Qty-Store column will display the quantity of the product on store as on Jan 1st.

Opening Qty - Floor

The quantity of this product on the floor on the report start date.

Note: You will not see this column if your business follows the On-Hand quantity model.

For example, if the report is generated on Jan 1st, for a duration of one month, the report start date is Jan 1st and the report end date is Feb 1st. For this duration, the Opening Qty-Store column will display the quantity of the product on floor as on Jan 1st.

Opening On-Hand Qty

The quantity of this product on the report start date.

Note: You will see this column only if your business follows the On-Hand quantity model.

For example, if the report is generated on Jan 1st, for a duration of one month, the report start date is Jan 1st and the report end date is Feb 1st. For this duration, the Opening Qty column will display the quantity of the product on Jan 1st.

Opening Value

The value of this product on both store and floor (on-hand) on the report start date.

For example, if the report is generated on Jan 1st, for a duration of one month, the report start date is Jan 1st and the report end date is Feb 1st. For this duration, the Opening Qty-Store column will display the quantity of the product on store and floor as on Jan 1st.

Inflow - PO

quantity

The quantity of this product from the purchase orders delivered at the current center.

Inflow - Value

The value of this product from the purchase orders delivered at the current center.

Inflow - Transfer quantity

The quantity of this product that is delivered at the center from transfer orders.

Inflow - Value

The value of this product from the transfer orders delivered at the current center.

Inflow - Converted quantity

The quantity of this product from the conversion process.

Note: In case you’ve selected All as the product type while generating the report, you will see 0 in this column.

  • For retail, this column shows the consumable quantity that is converted to retail.
  • For consumables, this column shows the retail quantity that is converted to consumables.

Inflow - Value

The value of this product from the conversion process.

Note: In case you’ve selected All as the product type while generating the report, you will not see any number in this column.

  • For retail, this column shows the value of consumables from retail-consumable conversions.
  • For consumables, this column shows the value of retail from consumable- retail conversions.

Inflow - Bundle quantity

The quantity of the product kit (bundle) after it is bundled on the Product Kit Management page.

Inflow - Value

The value of the product kit (bundle) after it is bundled on the Product Kit Management page.

Inflow - Unbundled quantity

The quantity of this individual product that is increased after product kits, containing this product, are unbundled on the Product Kit Management page.

Note: For product kits, you will see 0 in this column.

For example, if a product kit, Hair Care Kit, consists of two products, Hair Shampoo (quantity 2) and Hair Conditioner (quantity 1), when the kit is unbundled for quantity 5, the values in this column are as follows:

Hair Care Kit - 0

Hair Shampoo - 2x5 = 10

Hair Conditioner - 1x5 = 5

Inflow - Value

The value of this product that is increased after product kits containing this product are unbundled on the Product Kit Management page.

Note: For product kits, you will see 0 in this column.

Inflow - PO Return

The quantity of this product returned from other centers to the current center that is acting as a vendor.

Note: For centers that are not acting as vendors, you will see 0 in this column.

Inflow - Value

The value of this product due to returns from other centers to the current center (acting as a vendor).

Note: For centers that are not acting as vendors, you will see zero in this column.

Inflow - POS Return

The quantity of this product that is returned and restocked through POS.

Note: This number does not include the discarded quantity of this product from POS returns.

Inflow - Value

The value of this product because of returns from POS

Note: This number does not include the value of the discarded quantity of this product from POS returns.

Checkout - Qty

The quantity of this product that is checked out from store to floor.

Note: If your business follows the On-Hand quantity model, you will not see this column.

Checkout - Value

The value of this product from store-to-floor check-outs.

Note: If your business follows the On-Hand quantity model, you will not see this column.

Outflow - PO quantity

The quantity of this product that is delivered from the current center (acting as a vendor) to other centers through purchase orders.

Outflow - Value

The value of this product from purchase orders delivered from the current center (acting as a vendor) to other centers.

Outflow - Transfer quantity

The quantity of this product that is delivered from the current center to other centers through transfer orders.

Outflow - Value

The value of this product from transfer orders delivered from the current center to other centers.

Outflow - Bundle quantity

The quantity of this individual product that is used when a kit containing this product is bundled on the Product Kit Management page.

Note: For product kits, you will see 0 in this column.

For example, if a product kit, Hair Care Kit, consists of two products, Hair Shampoo (quantity 2) and Hair Conditioner (quantity 1), when the kit is bundled for quantity 5, the values in this column as follows:

Hair Care Kit - 0

Hair Shampoo - 2x5 = 10

Hair Conditioner - 1x5 = 5

Outflow - Value

The value of this individual product that is used when a kit containing this product is bundled on the Product Kit Management page.

Outflow - Unbundled quantity

The quantity of this product kit that is decreased after the unbundling process on the Product Kit Management page.

Note: For products, you will see 0 in this column.

For example, if a product kit, Hair Care Kit, consists of two products, Hair Shampoo (quantity 2) and Hair Conditioner (quantity 1), when the kit is unbundled for quantity 5, the values in this column as follows:

Hair Care Kit = 5

Hair Shampoo = 0

Hair Conditioner = 0

Outflow - Value

The value of this product kit that is decreased after the unbundling process on the Product Kit Management page.

Note: For products, you will see 0 in this column.

Outflow - Sold quantity

The quantity of this product that is sold from POS.

Note: For consumables, you will see 0 in this column.

Outflow - Value

The value of this product that is sold from POS.

Note: For consumables, you will see 0 in this column.

Outflow - Consumed quantity

The quantity of this product consumed in services. This is the bill of material associated with services.

Note: For retail, you will see 0 in this column.

Outflow - Value

The value of this product in BOM (Bill of Material) consumption.

Note: For retail, you will see 0 in this column.

Outflow - Converted quantity

The quantity of this product used in the conversion process.

Note: In case you’ve selected All as the product type while generating the report, you will see 0 in this column.

  • For retail, this column shows the retail quantity that is converted to consumables.
  • For consumables, this column shows the consumable quantity that is converted to retail.

Outflow - Value

The value of this product due to the conversion process.

Note: In case you’ve selected All as the product type while generating the report, you will not see any number in this column.

  • For retail, this column shows the value of retail due that is converted to consumables.
  • For consumables, this column shows the value of consumable that is converted to retail.

Outflow - InTransit quantity

The quantity of this product that is dispatched from the current center to the destination center, but not yet delivered.

Outflow - Value

The value of this product that is dispatched from the current center to the destination center, but not yet delivered.

Outflow - PO Return quantity

The quantity of this product that is returned from the current center to vendors. This number also includes the stock that is returned to any other center that is acting as a vendor.

Outflow - Value

The value of this product that is returned from the current center to vendors. This number also includes the stock that is returned to any other center that is acting as a vendor.

Did this answer your question?