Transaction Report
Use the Transaction Report to see what transactions have occurred for specific products for a given time period, including the opening inventory, all the ins, outs, and adjustments, and the closing inventory for a particular location.
How to Run the Report
To access this report, go to Reporting>Transaction Report
Under Report Parameters:
Mandatory
- Select the time period you want to view transactions for by selecting the Start Date and End Date.
- Select the location that you want to see data for.
Optional Filters
- Select a Category.
- See transactions for specific products. Look for products using product codes or product names.
- See transactions for products in specific Tag.
- See transactions for products in specific Formulary.
Click on Run Report when ready.
This will load the report in HTML. To download this report, click the Download Data button on the report parameters box. Make sure you don’t click download until after you submit your parameters and see results. The report will download in CSV.
Detailed Field Description
See below explanations of each column in this report:
Code: the product code
Name: The product name
Product Family: The Family the product belongs to
Display Name: When running the report on a locale different from English, the Product Synonym will display here.
Category: The Product category
Formulary: See the Formulary for this product
Tag: See the Tag for this product
Unit Cost: See the unit cost of the product
Opening: The QOH on the start date indicated in the report parameters
Credits: The total quantity that was added to the product inventory during the selected time frame. This addition can be through transfer in or inventory adjustments.
Debits: The total quantity that was subtracted from the product inventory during the selected time frame. This subtraction can be through transfer out or inventory adjustments.
Adjustment: This shows the amount added to or subtracted from the stock through an inventory adjustment. Unlike the other columns, which are always positive, adjustments can be negative (an adjustment down) or positive (an adjustment up).
For example, if product A has two inventory adjustments: one of +1000 and another of -200, the Adjustment for this will be displayed as +800.
Consumption: The quantity marked as consumed.
Expired: The quantity of the product that was removed from inventory due to expiry during this time period (this does not count expired items that were not removed from inventory)
Damaged: The quantity of the product that was removed from inventory due to damage during this time period (this does not count damaged items that were not removed from inventory)
Transfer In: The quantity of the product that came into the warehouse during this time period. Recorded through Inbound Movement.
Transfer Out: The quantity of the product that went out of the warehouse during this time period. Recorded through Outbound Movement.
Closing: The QOH on the end date indicated in the report parameters. Unless there was a cycle count during the time period, the closing balance should be equal to Opening Balance + Inbound - Outbound - Expired - Damaged + Adjusted.
Backdated Inventory Correction: Quantity that was backdated for transactions.