Inventory Report by Transaction

Report Module Guide: Inventory Report by Transaction

Module Location

Inventory > Reports > Inventory

Module Objective

The Inventory Report by Transaction module is used to generate a highly detailed stock mutation report, where each stock movement (in and out) is displayed in separate columns based on its transaction type. This report provides an in-depth analysis of where stock is coming from and where it is being used.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Warehouse Location / Bin Name:

  • Filter the report for a specific warehouse location or bin.

• Item/Service Category Type:

  • Select the item category you wish to analyze, for example, RAW MATERIAL.

• Period:

  • Specify the transaction date range in the From and To fields.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the Category Type and the Period.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a matrix that details all stock movements per item.

• Rows: Each row represents one Item/Service Name.

• Columns:

  • Beginning Balance: The stock quantity at the start of the period.

  • Stock Movement Columns: The middle section of the report displays many columns that represent the various types of transactions that cause stock to move, such as RCV (Receive), WTA (Warehouse Transfer), ENT, INC, etc. The number in these columns shows the total quantity that moved due to that transaction type.

• How to Read: By reading a single row, you can see an item's beginning balance, plus all inflows from various sources, minus all outflows for various purposes, which results in the ending balance.

Tips & Important Notes

• This report is a more detailed version of the Stock Card, which breaks down the 'In' and 'Out' columns into their specific causes.

• Use this report for in-depth analysis of the sources of your stock inflows and the destinations of your stock outflows (for example, how much stock came in from purchases vs. from warehouse transfers).

• This is a very useful analysis report for Inventory Analysts and Controllers.