Internal Ledger Analysis—Key Exercises

Basic Data Setup

To be able to work with internal ledger transactions, you must have set up the basic data in the following exercise:

Internal Ledger Basic Data and Requirements

Required Data

To analyze internal ledger transactions, these transactions must have been entered according to the instructions in the following exercise:

Internal Ledger Entry

Main Exercises

Queries in IFS/Internal Ledger

Voucher Information Queries

Purpose: The purpose of this exercise is to show you how to use the voucher information queries.

Windows:
IL Vouchers Analysis
IL Voucher Rows Analysis
IL Voucher Details Analysis

  1. Populate the IL Vouchers Analysis  window to see all vouchers and the information about them.
  2. To see more detailed information, right-click and then click Internal Voucher Rows. The IL Voucher Rows Analysis window is displayed on the screen. Alternatively, you can open this window directly from the Navigator. 
  3. To see the highest level of detail, right-click and then click Internal Voucher Details. The IL Voucher Details Analysis window is displayed on the screen. Alternatively, you can open this window directly from the Navigator.  
  4. To query related general-ledger voucher information, right-click and then click GL – Voucher Details.  

Balance Information Queries

Purpose: The purpose of this exercise is to show you how to use the IL Balance Analysis query window with different selections and the Zoom-In function.

Windows:
IL Balance Analysis

  1. Open the query window, and select the desired query criteria, e.g., Year, Period, Account, and Budget Version.
  2. Click OK. The Zoom-In window is displayed on the screen.  
  3. Specify how you want to present the information.
  4. The Balance Analysis report is a useful tool for quickly analyzing information in the internal ledger. Run this report, making different selections.

Reports in IFS/Internal Ledger

Purpose: The purpose of this exercise is to show you how to use the standard reports in the internal ledger.

Windows:
Analysis and Reports

Voucher Detail Report

This report shows voucher information from either the hold table or the internal ledger. This information is printed according to the criteria that you specify. 

Internal Ledger Transaction Report

This report is printed according to the voucher types for a period or date interval. This information is printed according to the criteria that you specify. For example, you can specify whether the report will be either summarized or detailed.

Internal Ledger Report

Order Reports.