# Inventory Adjustment Item Wise
Line-level list of inventory adjustments for a selected period. Shows every adjustment line — date, voucher, type, reason and item — with the in/out quantity and optional value.
Overview
Go to Inventory → Inventory Reports → Inventory Adjustment Item Wise.
Report title in ERP: Adjustment Item Wise
What it shows. One row per inventory adjustment line in the selected period, with the adjustment date, system ID, adjustment Type (gain or loss), center, employee, reason, item details and the quantity moved In or Out. Turn on Show Value to add the value of each in and out movement. Use the Type filter to show only gains or only losses. Click an ID to open the adjustment voucher.
When to use it. Use to review individual write-ups and write-downs line by line, to check adjustments by reason, type, center or employee, and to investigate a specific adjustment document.
Use Cases
- Inventory controller — Which adjustment lines increased or decreased stock this period? Review each row's In and Out.
- Auditor — Which adjustments were posted for a given reason, and on which voucher? Filter by reason and click the ID to open the document.
- Finance — What is the value impact of each gain or loss line? Turn on Show Value.
- Branch manager — Show only losses at my center. Set Type to Loss and filter by Center.
Filters
Date range, Employee, Item, Inventory Adjustment Reason and a Type selector (Type-All, Gain, Loss). Advanced Filter: Center, Item Group, Brand.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Date | Adjustment voucher date. |
| ID | System reference of the adjustment. Click to open the voucher. |
| Type | Adjustment type (gain or loss). |
| Center | Inventory center for the adjustment. |
| Employee | Employee who recorded the adjustment. |
| Reason | Inventory adjustment reason. |
| Item Name | Item adjusted. |
| Item Code | Item code. |
| HSN Code | Item HSN code. |
| Unit | Inventory keeping unit. |
| In | Net quantity (and value) increased on this line. |
| Out | Net quantity (and value) decreased on this line. |
When Show Value is on, the In and Out columns each show a Qty and Value sub-column. A Total row sums quantities and values.
Actions
- Generate — run the report for the selected filters
- Show Value / Hide Value — toggle the value columns
- Export — export the report to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active advanced filters
FAQ
How is this different from Item wise Inventory Adjustment?
This report is line-level: one row per adjustment line with the voucher, type and reason, and a Type (gain/loss) filter. Item wise Inventory Adjustment is an item summary that nets the in and out quantity per item.
Can I show only gains or only losses?
Yes. Set the Type filter to Gain or Loss before generating.
How do I see value, not just quantity?
Turn on Show Value to add value columns for the in and out movements.
How do I open the adjustment document?
Click the ID on any row to open the adjustment voucher.
Which adjustment statuses are included?
Approved and closed inventory adjustments in the period.
Why is my report empty?
No adjustment lines match the date range, reason, or type filters.
Why does the date range fail validation?
About 12 months maximum on many item-wise inventory reports.