Transaction Journal

Report Module Guide: Transaction Journal

Module Location

Sales > Transaction Journal

Module Objective

The Transaction Journal module is a powerful and comprehensive reporting and drill-down center. Its purpose is to display all transaction details from every module in the ERP system in a single, integrated view. Although it is located within the Sales menu, this module has the ability to pull data from all areas, providing full visibility into the accounting impact of every transaction.

1. Main View (Transaction Report Center)

The main page of this module is an interactive report equipped with various filtering tools to help you find specific data.

Advanced Filter Functions

The top section of the page provides various filters to screen the data:

• Date From / To: Specify a date range to limit the transaction period.

• Chart Of Accounts: Filter transactions that only affect a specific account.

• Cost Center & Project: Filter transactions that are only allocated to a specific department or project.

• Journal Status: Choose to display journals with a specific status (e.g., already approved).

Table Column Explanation

The main table will display the details of each journal line, including Journal Number, Account, Debit, Credit, Cost Center, Project Name, and a very detailed Description.

Main Button Functions

• Search / Show All: To apply the filters or display all data again.

• Export To MS Excel / Export To CSV File: An important feature to download the displayed data for further processing outside the system.

2. Usage Example (Case Study)

Case: The Sales team wants to see the complete journaling details (including COGS) of a sales transaction for the customer "Mega Global Food Industry".

Steps:

1. Open the Transaction Journal module.
   

2. Set the Date range to the known transaction date (e.g., 08/02/2025). 

   

3. Click Search.

4. Find the transaction rows related to "Mega Global Food Industry".

5. The result will display all related journal lines, from the recording of ACCOUNT RECEIVABLE TRADE, SALES, to COST OF GOOD SOLD (COGS). This data can then be exported to Excel for analysis.

Example of a Generated Report

The exported or printed report will display transaction details like the image below, detailing every debit and credit movement.

Tips & Important Notes

• This module is read-only. You cannot create or modify transactions here.

• This is a very useful tool for the Sales team to understand the accounting impact of every transaction they make, from revenue to the cost of goods sold.

• Use the Export to MS Excel feature for more in-depth data analysis.