Inventory Detailed Transactions Report

The Inventory Detailed Transactions report shows every inbound or outbound movement of products in your warehouses, one line for each product in each transaction: sales and purchase invoices and returns, requisitions, transfers between warehouses, stocktakings, manufacturing orders, and manual adjustments. The report starts with the quantity before the period, then shows the inward and outward quantities in chronological order. You can filter it by period, product, warehouse, and transaction type, then print it or export it to Excel, CSV, or PDF. This report is also known as the item card.

View the report

1. Open Inventory Detailed Transactions.
2. Set Date From and Date To.
3. Choose the Product, Warehouse, and Type, or leave them on All.
4. Click Generate Report.

Report filters

Filter	Use
Date From / Date To	The period of the transactions. If you set Date From, the report calculates the Starting quantity before that date.
Product	One product, an item group to show the movement of all its products together, or All. Search by name or code.
Warehouse	One warehouse or All. Only the warehouses you’re allowed to view appear.
Type	The transaction type, such as Invoice or Requisition Manual Outbound. The list also shows the manual transaction categories you added. See Transaction types.
Work order	Appears when work orders are enabled, and shows the transactions linked to a specific work order from Work Orders.

Transaction types in the Type filter

The transaction type depends on how it was carried out: if Requisitions for Sales Invoices or Requisitions for Purchase Invoices is enabled in the inventory settings, the invoice’s movement appears with the Requisition Invoice or Requisition Purchase Invoice type; otherwise, it appears with the Invoice or Purchase Invoice type.

Group	Types in the filter
Sales	Invoice, Refund Receipt, Credit Note, Requisition Invoice, Requisition Refund, Requisition Credit Note, Requisition Sales Order
Purchases	Purchase Invoice, Purchase Refund, Purchase Debit Note, Requisition Purchase Invoice, Requisition Purchase Refund, Requisition Purchase Debit Note
Manual requisitions	Requisition Manual Inbound (inbound requisition), Requisition Manual Outbound (outbound requisition), Requisition
Transfers between warehouses	Transfer Stock, Requisition Transfer, Requisition Transfer IN, Requisition Transfer OUT
Stocktaking	Requisition Stocktaking IN (surplus), Requisition Stocktaking OUT (shortage)
Point of sale	Requisition POS IN, Requisition POS OUT
Manufacturing	Outbound manufacturing order Material, Manufacturing Order Main Product Inbound Requisition, Manufacturing Order Scrap Items Inbound Requisition, Manufacturing Order Returned Materials
Bundle products	Bundle Product, Bundle Outbound
Other	Manual Adjustment, and the manual transaction categories you added

Report columns

Column	Content
Time	The date and time of the transaction. The first line is Inventory quantity before (start date) with the Starting quantity type.
Type	The transaction type, or the manual transaction category.
Product Code and Product	The product’s code and name.
Inward	The quantity that entered the warehouse.
Outward	The quantity that left, shown as a negative number.
Notes	The transaction notes, or the requisition notes if there are none.
Warehouse	The warehouse where the transaction took place.
Stock Level After	The balance after each transaction. It appears when you choose a specific product, if you have more than one warehouse.

When multiple units of measure are enabled, the quantity appears in the unit used in the transaction, and the balance appears in the product’s base unit.

Print and export

• Click Print to print the report.
• From Export Options, choose Export to Excel, Export to CSV, or Export to PDF. The report is exported with the same filters and visible columns, one line for each product in each transaction.

Common scenarios

What do you want to know?	Report setup
Items issued by outbound requisitions in a period	Type: Requisition Manual Outbound, and Product: All, then Export to Excel. See the next section.
Items added by inbound requisitions	Type: Requisition Manual Inbound.
Items sold in a period	Type: Invoice, or Requisition Invoice if sales requisitions are enabled. Repeat with Refund Receipt to see the returns.
Items received from suppliers	Type: Purchase Invoice or Requisition Purchase Invoice.
Transfers between warehouses	Type: Transfer Stock or the Requisition Transfer types, and choose the warehouse to see what left it and what entered it.
Stocktaking differences	Type: Requisition Stocktaking OUT for shortages, and Requisition Stocktaking IN for surpluses. You can find the stocktaking sheets in Stocktakings.
Manual adjustments to quantities	Type: Manual Adjustment, or the manual transaction category you used.
Materials issued for manufacturing	Type: Outbound manufacturing order Material, and for the finished product: Manufacturing Order Main Product Inbound Requisition.
One product’s movement and its balance after each transaction (item card)	Choose the product and warehouse, and leave Type on All, so the Stock Level After column appears.
Why a product’s balance differs from what you expect	Choose the product without a period, and review each transaction and the Stock Level After column to find the transaction that changed the balance.
The movement of all the products in an item group	Choose the item group from Product.
Materials issued to a work order	Choose the Work order.
The balance at the start of a period	Set Date From and choose the product, so the balance appears in the Starting quantity line.

Find and export the items issued by requisitions

To find all the items issued by requisitions and export them with all their items, use one of two methods:

Method 1: From the Inventory Detailed Transactions report (by item)

1. Open Inventory Detailed Transactions.
2. Set the period, leave Product on All, and choose the warehouse or All.
3. From Type, choose Requisition Manual Outbound for the requisitions you created manually, or the requisition type you need, such as Requisition Invoice.
4. Click Generate Report, then Export Options → Export to Excel.

You get one line for each item in each requisition, with the date, code, name, issued quantity, warehouse, and notes. To total the quantity for each item, use a Pivot Table in Excel. The Type filter selects one type at a time, so repeat the report for each type you need.

Method 2: From the requisitions list (by requisition)

1. Open Manage Requisitions.
2. Filter the list: Requisition Source, Warehouse, and Status. From Advanced Search, you can also filter by Date and Product.
3. Select the requisitions, or select all the search results, and choose Export from the Actions menu.
4. On the export page, choose the type: items to export one line for each item, or requisitions to export one line for each requisition.
5. Choose the requisition fields and item fields you need, the sort order, and the file type, then click Export.

This method shows the requisition number, its status, the unit price, and the requested quantity, and includes requisitions that are Under Delivery or Rejected based on the filter, while the report shows executed transactions only.

	Inventory Detailed Transactions report	Exporting the requisitions list
Line	An item in an executed transaction	A requisition, or an item in a requisition when you export items
Unapproved requisitions	Don’t appear	Appear based on the Status filter
Requisition number and unit price	No	Yes
Limit	All transactions are shown; with a large number, it suggests downloading a CSV file	5000 requisitions per export

Related reports

Report	When to use it
Detailed Stock Transactions For Each Product	The same transactions grouped by product, with the stock before, the average cost price, the total transaction value, and the stock value after, and with the Source (more than one type), Brand, and Category filters. It requires the permission to add purchase invoices.
Inventory Transactions Summary	The total inward and outward quantities for each product instead of each transaction.
Inventory Consumption for Invoices and Returns	To compare invoice quantities with requisition quantities and find the difference that hasn’t been issued yet.
Inventory Consumption for Purchase Invoices and Returns	The same comparison for purchase invoices.
Estimated Inventory Value	The value of the current stock balance.

Important notes

• Each line in the report is one transaction for one product from one document, such as an invoice or a requisition. So inward and outward quantities appear in separate lines based on the date of each transaction, and never in the same line. To see the total inward and outward quantities for each product in one line, use Inventory Transactions Summary.
• The report shows executed transactions only; requisitions that are Under Delivery or Rejected don’t appear until they’re accepted.
• Inactive products, and products that don’t track stock, don’t appear.
• A bundle product appears based on how it’s tracked: a transaction for the bundle product itself, or transactions for its components.
• If you don’t set Date From, the Starting quantity is zero, and the report shows all transactions from the beginning.
• Editing or deleting the original document, such as the invoice or requisition, changes its transaction in the report.

Error messages and solutions

Message	Cause	Solution
The report will display a large number of records…	The report result has more than 1000 transactions.	Click Download to download a CSV file, or go back and shorten the period or choose a product or warehouse.
You can’t export more than 5000 records, please change the filters to fit the limit	Exporting more than 5000 requisitions from the requisitions list.	Split the export into shorter periods.
The report doesn’t show the transaction of a requisition you created	The requisition is Under Delivery, or in a warehouse you aren’t allowed to view.	Accept the requisition from Manage Requisitions, or review the warehouse permissions.
The Stock Level After column doesn’t appear	You didn’t choose a specific product, or you have only one warehouse.	Choose the product, or track the balance from Detailed Stock Transactions For Each Product.

FAQs

How do I issue an item card?

The item card is the Inventory Detailed Transactions report. Open Inventory Detailed Transactions, set Date From and Date To, choose the item from Product and the warehouse from Warehouse, leave Type on All, then click Generate Report. The report shows the item’s transactions with the time, type, inward, and outward quantities, and the Stock Level After column shows the item’s balance after each transaction if you have more than one warehouse. For value and cost, use Detailed Stock Transactions For Each Product.

How do I find the items issued by requisitions and export them with all the items?

From Inventory Detailed Transactions, choose Type: Requisition Manual Outbound and the period, leave Product on All, then Export to Excel. Or, from Manage Requisitions, select the requisitions and choose Export with the items type.

How do I find the quantity of an item issued to a client or department?

Write the client or department name in the requisition notes, so it appears in the Notes column, or filter Manage Requisitions by client and export the items.

Why does the transaction type show Requisition Invoice instead of Invoice?

Because Requisitions for Sales Invoices is enabled, so the invoice is issued by a requisition.

Can I choose more than one transaction type in the same report?

No; choose one type or All. To choose more than one type, use the Source filter in Detailed Stock Transactions For Each Product.

Does the report show the value or cost of transactions?

No, it shows quantities only. For value and cost, use Detailed Stock Transactions For Each Product.

Why are the values in the Outward column negative?

Because outward quantities reduce the balance, so they appear with a negative sign.

Why do inward and outward quantities appear in separate lines instead of the same line?

Because the report shows each stock transaction in its own line based on the document that created it, such as an invoice or a requisition. An inward transaction and an outward transaction are two different transactions, so each appears in its own line with its own date, and the number appears only in the Inward or Outward column while the other stays empty. To see the total inward and outward quantities for each product in one line, use Inventory Transactions Summary.