# Employee Wise Consumable Issue

Consumables issued grouped by recipient and item. Shows how much of each item each employee received over a selected period, with optional value.

On this page

Overview Use Cases Filters Columns Actions FAQ

Overview

Go to Inventory → Inventory Reports → Employee Wise Item Wise. Report title in ERP: Employee Wise Item Wise

What it shows. One row per recipient employee and item combination, with the employee the items were issued to (Employee (Issued To)), the item, item code and total Quantity issued in the period. Rows with no recipient are grouped as Others. Turn on Show Value to add the issued value. Click a row to open the matching consumable issue detail for that employee and item.

When to use it. Use to see who consumed which items, to control issuing per person, and to support cost allocation by recipient.

Use Cases

Department head — How much of each consumable did each of my people take? Review by employee and item.
Cost controller — What is the value of consumables issued per person? Turn on Show Value.
Store keeper — Who has been receiving a particular item? Filter by Item.
Auditor — Drill into a single employee-item line to see the issue documents. Click the row.

Filters

Date range, Inventory Adjustment Reason, Issued By and Issued To. Advanced Filter: Item, Center, Branch, Variant, Brand, Item Group.

Columns

| **Column** | **Description** | |------------|-----------------| | Employee (Issued To) | Employee the items were issued to (or Others when none). Click to open the detail. | | Item | Item issued. | | Item Code | Item code. | | Quantity | Total quantity issued to that employee for that item. | | Value | Value of the issues (shown when Show Value is on). | A Total row sums the quantity and, when shown, the value.

Actions

Generate — run the report for the selected filters
Show Value / Hide Value — toggle the value column
Export — export the report to Excel
Print — print the report
Advanced Filter — open additional filter fields
clear — reset active advanced filters

FAQ

What does the Others row mean?
Issues that were not recorded against a specific recipient are grouped under Others.

How is this different from the other consumable-issue reports?
This report groups by recipient employee and item. Item Wise Consumable Issue totals per item only, and Consumable Issue Item Wise lists each issue line.

How do I see the value issued?
Turn on Show Value to add the value column and total.

How do I drill into one person's issues?
Click any employee-item row to open the matching consumable issue detail.

Which consumable issue statuses are included?
Approved and closed consumable issues in the date range.

Why is my report empty?
No consumable issues match the period or employee filters.

Are only consumable item types included?
Yes. Lines are limited to consumable-type items issued through Consumable Issue.