8. Reports

To generate any of these reports choose Reports in the Application Browser. Choose Browser under it. A list of all the reports in each module will be displayed. You can choose to view or print the report.

The time and the operator who generated the report will be displayed.

This chapter contains the following sections:

Section 8.1, "Batch Totals Report"
Section 8.2, "Report on Currency Positions of your Branch"

8.1 Batch Totals Report

This section contains the following topics:

Section 8.1.1, "Reporting Batch"
Section 8.1.2, "Contents of Report"

8.1.1 Reporting Batch

You can retrieve the batch totals of all the batches into which transactions were posted during the day. The report gives the debit and credit totals for every batch. The name of the operator and the difference between the debit and credit totals are also given.

The report is in a spread sheet format. Those batches that have a difference in the debit and the credit totals will be highlighted.

The report contains the following details:

Batch No
Batch description
LCY Debit
LCY Credit
The Difference between the Debit and Credit
User ID
Batch Type

This report can be generated at any time of the day using the ‘Batch Totals’ screen. You can also invoke this screen by typing ‘DERBATOT’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

You can specify the following details:

From Batch Number

Batch Number

Specify the batch number.

Description

The system displays the description for the selected batch number.

To Batch Number

Batch Number

Specify the batch number.

Description

The system displays the description for the selected batch number.

Report Format

Select the format in which you want to generate the report. The following options are available:

HTML
RTF
PDF
Excel
XLSX

Report Output

Select the mode of output. The available options are:

Print
View
Spool

Printer

Specify the path of the printer if you want to print the report.

Printer At

Specify whether the printer is at the client or server.

8.1.2 Contents of Report

The contents of this report are discussed under the following heads:

Header

The Header carries the Branch of the report, information on the branch date, the ID of the user who generated the report, the date and time at which it was generated and the module of the report.

Body of the report

This report contains details of:

Field Name	Description
Batch Number	This is the number assigned to the batch.
Last Operator ID	This is the user id of the user last operated.
Type	This is the type of the batch.
Description	This gives a description of the batch.
Debit Entries Total	It holds the value of the Total Debit amount of a particular Batch
Credit Entries Total	It holds the value of the Total Credit amount of a particular Batch
Balance	This is remaining balance after the debit and the credit transactions.
Gross Cr Totals	This is the total credit balance
Gross Dr Totals	This is the total debit balance

8.2 Report on Currency Positions of your Branch

This section contains the following topic:

Section 8.2.1, "Reporting Currency Position"

8.2.1 Reporting Currency Position

You can ascertain the position of a currency, across the Tills/Vaults that are maintained in your branch, any time during the day. The position of a currency in your branch (i.e. the total amount of the specified currency in all the Tills and Vaults) can be generated in the form of a report using the ‘Currency Position Report’ screen. You can also invoke this screen by typing ‘GLRPCCY’ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button.

This summary and the detailed view of this report can be generated. The report will be in a tabular format. The user ID of the Teller who is using any particular Till, at the time the report is generated, will be displayed in the Detailed View of the report.

You can specify the following details:

Turn Over

Check this box if turn over is applicable.

Branch Consolidation

Consolidate

Check this box to generate the consolidated report.

Date

Specify the generation date.

History Report

Past Period

Check this box to generate report for past period.

Financial Year

Specify the financial year. Alternatively, you can select financial year from the option list. The list displays all valid years maintained in the system.

Period Code

Specify the period code. Alternatively, you can select period code from the option list. The list displays all valid period code maintained in the system.

In the summary view if you double click on a row (i.e. on a Till) the position of the Till in the specified Currency will be displayed.