How Does Simple Fact View Report Works in iDempiere
The Simple Fact View Report provides a summarized view of General Ledger accounting transactions. It displays account balances based on the selected Accounting Schema, Organization, Account, and Accounting Date.
The report helps Finance and Accounting users review account balances, analyze ledger postings, and verify financial transactions. It is commonly used for reconciliation, financial analysis, and management reporting.
Business Rules
- Retrieves data from the RV_Fact_Simple view.
- Uses accounting entries from RV_Fact_Acct.
- Includes only Actual Posting (PostingType=’A’).
- Groups records by Accounting Date and Account.
- Calculates Accounting Balance as Debit minus Credit.
- Displays Financial Year and Financial Year-Month.
- Classifies accounts as Balance Sheet or Profit & Loss.
- Supports filtering by Accounting Schema, Organization, Account, Account Key and Accounting Date.
- Returns only records matching selected parameters.
- Provides summarized ledger information.
Report Parameters
Parameter Window
The Simple Fact View Report parameter window allows users to filter records before generating the report.
Simple Fact View Report – Parameter Window
| Parameter | Purpose | Filtering Behavior | Sample Value | |
| Accounting Schema | Choose Accounting Schema | Filters by accounting schema. | POTS Accounting | |
| Organization | Choose Organization | Filters by organization. | POTS Chennai | |
| Account | Choose Account | Filters by General Ledger account. | Sales Revenue | |
| Account Key | Choose Account Key Range | Filters by account key. | 1000-1999 | |
| From Account Date | Choose From Accounting Date | Filters from selected date. | 01/07/2026 | |
| To Account Date | Choose To Accounting Date | Filters up to selected date. | 31/07/2026 | |
| Run as Job | Run report in background | Runs as background job. | Checked | |
Report Output
- The report provides a summarized view of General Ledger balances for the selected accounting period. It displays account-wise balances together with financial year information for reporting and analysis. Users can review ledger movements, verify account balances, and analyze financial postings. The report supports reconciliation, month-end review, and management reporting.
- Accounting Schema
- Organization
- General Ledger Account
- Account Value
- Account Type
- Accounting Date
- Financial Year
- Accounting Balance
