Item Transaction Report

Report Module Guide: Item/Service Transaction Report

Module Location

Sales > Reports > Item Reports > Item Transaction Report

Module Objective

The Item/Service Transaction Report module is used to generate a report that resembles a "stock card," which is to say it displays a detailed transaction history for each item or service. This report is very flexible as it can display transactions from both the Sales and Purchasing sides, thereby providing a complete overview of an item's movement.

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:

• Item:

  • Select All to display transactions for all items, or Selected to choose specific items.

• Document Date:

  • Specify the From and To date range to define the period of transactions to be displayed (e.g., August 1, 2025, to August 31, 2025).

• Transaction Type Filter:

  • Use these radio buttons to define the type of transaction you wish to see. You can select Sales or Purchasing.

• Customer:

  • Filter transactions by All customers or a Selected customer.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Select all the parameters you need, especially defining the Document Date range and the transaction type (Sales or Purchasing).

Step 2: Generate the Report

After all parameters are set, click one of the two buttons in the bottom-left section of the page:

• Display Report: To preview the item transaction report directly on your screen.

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

  

3. Example of the Report View

After you click, the system will generate a detailed report like the following, which will detail the transactions under each item name.

Report Explanation: The report will display a list of the products you selected. Under each product, there will be a detailed list of every transaction (sales or purchase) that occurred within the selected period. In this example, no transactions were found ("Tidak Ada Transaksi").

Content: This report will contain details such as the transaction date, document number, quantity, and value for each item movement.

Tips & Important Notes

• Use this report to trace the complete history of a product, both from the purchasing side (goods in) and the sales side (goods out).

• This report is very useful for the Inventory and PPIC (Production Planning and Inventory Control) teams for stock movement analysis.

• By choosing between Sales and Purchasing, you can get a complete 'in-out' picture for an item.