Trial Balance Report
The trial balance report shows the summarized balances of accounts up to a specific date. It delivers the opening balance, activity, and closing balance of each account. Unlike the Ledger Report, this report can be produced for any level. For example, you
- PDF / 286,321 Bytes
- 13 Pages / 504 x 720 pts Page_size
- 5 Downloads / 168 Views
Trial Balance Report The trial balance report shows the summarized balances of accounts up to a specific date. It delivers the opening balance, activity, and closing balance of each account. Unlike the Ledger Report, this report can be produced for any level. For example, you can run a Trial Balance Report for the first level only simply to see top-level account activities. You can also filter the report to display a specific range of financial accounts from the COA along with a cost center, should you want to see account balances for only one cost center. The parameters form has just one date picker from where you select the date up to which closing balances are calculated and displayed in the report.
19.1 Trial Balance Report Table The transaction data, entered through vouchers, are stored in the gl_tran_master and gl_tran_detail tables. After generating the trial balance report from these two tables, you store the result in the following temporary table. It holds trial balance data for each user until the user runs the report again. The data in this table is populated through a process to be created later in Table 19-4. CREATE TABLE gl_trial_balance (coacode VARCHAR2(11), coatitle VARCHAR2(50), coalevel NUMBER(1), opendr NUMBER(15,2), opencr NUMBER(15,2), activitydr NUMBER(15,2), activitycr NUMBER(15,2), closingdr NUMBER(15,2), closingcr NUMBER(15,2), coname VARCHAR2(50), tbdate DATE, fromaccount VARCHAR2(11), toaccount VARCHAR2(11), cccode VARCHAR2(5), cctitle VARCHAR2(25), reportlevel NUMBER(1), userid VARCHAR2(50), grand_total NUMBER(1))
© Riaz Ahmed 2019 R. Ahmed, Cloud Computing Using Oracle Application Express, https://doi.org/10.1007/978-1-4842-4243-8_19
205
Chapter 19
Trial Balance Report
19.2 Create a List of Values Using Table 19-1, create a LOV from scratch. It will be used to allow you to select any account level for the trial balance report. If you run this report for the transaction level (level 4), all parent levels (i.e., 1, 2, and 3) also appear on the report by default, unless you put a check on the parameter option labeled Print Selected Level.
Table 19-1. LOV Attributes Action
Attribute
Value
Create LOV
Name
COA All Levels
Type
Dynamic
Query
SELECT coacode||‘-’||coatitle d, coacode r FROM gl_coa WHERE cocode=(select cocode from gl_users where userid = :APP_USER) ORDER BY coacode
19.3 Create Page and Parameters Form Using Table 19-2, create a blank page and its components for this segment.
Table 19-2. Page and Component Attributes Action
Attribute
Value
Create Blank Page
Page Number
73
Name
Trial Balance Report
Page Mode
Normal
Breadcrumb
—Don’t use breadcrumbs on page—
Navigation Preference
Identify an existing navigation menu entry for this page.
Existing Navigation Menu Entry
Reports
(continued)
206
Chapter 19
Trial Balance Report
Table 19-2. (continued) Action
Attribute
Value
Create Region
Title
Trial Balance Report Parameters
Type
Static Content
Template
Standard
Name
P73_ACCOUNTFROM
Type
Popup LOV
Label
From Account
Region
Data Loading...
