Product Transaction List Report

Shows, for a date range, each product's stock at the start, the quantity moved by each type of transaction, and the stock at the end.

Menu: Reports › Product Reports › Product Transaction List Report

Required permission

Reports › Product Transaction List Report › View

What it's for

Use it to explain why a product's stock changed, to reconcile stock with a physical count, and to find products that had (or didn't have) a certain kind of movement, for example products received but never sold.

Example

A count found 88 pieces of Bath Soap but the system says 100. The auditor runs the report for the month: Beginning 60, Purchase Inbound +144, POS Sales −98, Stock Delivery Outbound −6, ending Inventory 100. Every movement has a document, so the 12 missing pieces are a real loss and are written off with an inventory adjustment.

Options on the screen

• From / To, Branch and Location: the period and the stock to look at.
• The transaction types (Check All ticks them all): the movement columns to show.
• With Transactions / Without Transactions: show only products that had, or didn't have, the ticked movements. Select preferred condition for the selector: ALL of the selected transaction type or ANY of the selected transaction type. Example: tick Purchase Inbound and POS Sales, choose Without Transactions and ANY: products that were neither received nor sold.
• Show Advanced Info: adds the product's prices and other details.

Filters

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

Stock No., Unit Barcode, Name, Chinese Name, Status, Default Supplier, Supplier, Category Tag, Category, Brand, Date Created, Last Modified, Group Type, Memo.

Columns

Column	What it shows
Particular	The customer, supplier or branch on the other side of the transaction.
Purchase Inbound	Quantity received from suppliers.
Purchase Return Outbound	Quantity returned to suppliers.
Sales Outbound	Quantity delivered to customers from back-office sales.
Sales Return Inbound	Quantity returned by customers.
Stock Delivery Inbound	Quantity received from other branches.
Stock Delivery Outbound	Quantity sent to other branches.
Stock Return Inbound	Quantity returned to this branch by other branches.
Adjustment Increase	Quantity added by inventory adjustments.
Stock Return Outbound	Quantity returned to other branches.
Damage Outbound	Quantity written off as damaged.
Adjustment Decrease	Quantity removed by inventory adjustments.
Product Conversion Increase	Quantity added by product conversions (manual group or ungroup).
Product Conversion Decrease	Quantity used up by product conversions.
Auto Product Conversion Increase	Quantity added by automatic group conversions.
Auto Product Conversion Decrease	Quantity used up by automatic group conversions.
POS Sales	Quantity sold at the POS.
Product	The product name.
Supplier	The product's default supplier.
Parent Category	The category one level above the product's category.
Status	The product's status: Active, Inactive or Discontinued.
Memo	The product memo.
Product Tag	The product's tags.
Cost	The product's purchase price (cost) in the branch.
Wholesale Price	The product's current wholesale price.
Selling Price	The product's current selling (retail) price.
Beginning	Stock at the start of the date range.
Inventory	Stock at the end of the date range.

Also shows: Check All, Barcode, Stock No., Chinese Name, Description, Brand, Category, Wholesale Qty.

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