Detail Inventory Adjust Report

Lists every Inventory Adjust transaction line by line, with its header details (date, branch, status, who created and approved it) and each product with quantity, prices, discounts and amounts.

Menu: Reports › Transaction Detail Reports › Detail Inventory Adjust Report

Required permission

Reports › Detail Inventory Adjust Report › View

What it's for

Use it when the transaction list isn't enough: to filter and export lines by product, brand, category, customer, supplier or status, for example for reconciliation, audits or analysis in Excel. Filter by any header field or product with Filters and Filter By Product. See Inventory Adjust for the transaction itself.

Example

After the year-end count, the auditor lists all adjustment lines with Diff. Qty, Lost Amount (Cost) and Gained Amount (Cost): the net loss is 38,200.00 at cost, mostly in Cosmetics.

Filters

Click Filters to narrow the report. You can filter by:

Branch, Trans. Date, Sheet No., Approval Status, Remarks, Requested By, Created by, Created Date, Last Modified By, Last Modified Date, Audit By, Audit Date, Product Barcode, Product Name, Product Brand, Category Tag, Product Category, Product Description, Stock No., Product Tag, Chinese Name, Default Supplier, Detail Remarks, Qty, UOM, Unit Specs, Pc Qty, Total Qty, Diff. Qty, Cost, MA Cost, Detail Total Amount, Amount (Cost), Lost Amount (Cost), Gained Amount (Cost), Amount (Wholesale), Lost Amount (Wholesale), Gained Amount (Wholesale), Amount (Retail), Lost Amount (Retail), Gained Amount (Retail), Deleted, Memo, Secondary Barcode, Default Unit, Management Type, Product Life Cycle, Senior, PNST (Discount), Solo Parent, Vatable, Parent Category.

Columns

Column	What it shows
Approval Status	Draft, For Approval, Approved or Declined.
Transaction Date and Time	The transaction's date and time.
Sheet No.	The transaction's sheet number; click it to open the transaction.
Created From	The branch where the transaction was created.
Created For	The branch the transaction is for (whose stock or money it affects).
For Location	The branch location whose stock the transaction affects.
Remarks	The transaction's remarks.
Request by	The person who requested the transaction.
Created by	User who created the transaction.
Created Date	When the transaction was created.
Audit By	User who approved (audited) the transaction.
Audit Date	When the transaction was approved.
Deleted	Whether the transaction has been deleted.
Product Tags	The product's tags.
Product Name	The product name.
Parent Category	The category one level above the product's category.
Default Supplier	The product's default supplier (ticked on its Supplier tab).
Product Description	The product's description.
Qty	Quantity on the line.
UOM	The unit of measure used on the line.
Unit Specs	The unit used on the line and how many default units it holds.
Pc Qty	Quantity counted, in default units.
Total Qty	Total quantity, in default units.
Diff. Qty	Counted quantity minus system stock.
Cost	The product's cost on the line.
MA Cost	Moving average cost: the average cost of the stock on hand, updated with each incoming transaction.
Amount	Line amount: quantity × price.
Detail Remarks	The remarks on the product line.
Transaction Date	The transaction's date.
Transaction Time	The transaction's time.
Amount (Cost)	Quantity × cost.
Lost Amount (Cost)	Value at cost of stock lost (negative differences).
Gained Amount (Cost)	Value at cost of stock gained (positive differences).
Amount (Wholesale)	Quantity × wholesale price.
Lost Amount (Wholesale)	Lost stock at wholesale price.
Gained Amount (Wholesale)	Gained stock at wholesale price.
Amount (Retail)	Quantity × retail price.
Lost Amount (Retail)	Lost stock at retail price.
Gained Amount (Retail)	Gained stock at retail price.

Also shows: Barcode, Stock No., Chinese Name, Brand, Category.

For searching, express filters, sorting, column settings, exporting and printing, see About reports.