22.3.1 Daily Balance Position Report– Adhoc Reports

This topic provides the systematic instructions to the user for generating the Daily balance position ad-hoc reports, which are created on demand or upon request.

Reports can be requested from the Reports screen. Adhoc reports can be viewed using My Reports screen.

To generate the daily balance position adhoc report:

1. In the Report Generation screen, click the Adhoc tab.
   The adhoc report generation screen appears.
2. From the Report Name list, select the desired report which is to be generated.
   The receptive report generation screen appears.
3. In the User Names field, click and add multiple active user IDs of party mapped to whom the adhoc report to be sent via their registered email IDs.
4. From the Report Format list, select the desired report format for generated report.
5. From the Duration - From and Duration - To list, specify the period for which the report is to be generated.
6. Perform one of the following actions:
   • Click Generate Report to view and generate the report.
   • Click Cancel to cancel the transaction.
   • Click Clear to reset the search parameters.

   Figure 22-10 Daily Balance Position - Adhoc Reports

   
   

   
   Description of "Figure 22-10 Daily Balance Position - Adhoc Reports"

   
   

   Note:

   The fields which are marked as Required are mandatory.

   For more information on fields, refer to the field description table.

   Table 22-7 Daily Balance Position - Adhoc Reports - Field Description

   Field Name	Description
   Report Name	The report type selected to generate the report.
   User Names	The active users of party mapped to whom the adhoc report to be sent via their registered email IDs.
   Report Format	The format in which report is to be generated. The options with Oracle Business Intelligence (BI) Publisher are: PDF The options with Internal Reporting Application are: PDF
   Duration	The period for which the report is to be generated. Start date of the date range from which you want to generate the report. End date of the date range up-to which you want to generate the report.

7. The success message along with the reference number, status and Report Request Id appears.
   Perform one of the following actions:

   • Click OK to close the screen and navigate to the dashboard.
   • Click on the View Reports link to download the report.

     The user is directed to the My Reports screen. The list of reports appears.

   • Click Generate another report to generate another report.

   A report will be generated in the format specified at the time of scheduling or generating an adhoc report.

   Note:

   You can also download the requested report from Corporate Dashboard, click Toggle Menu, then click Reports, and then click My Reports

   Figure 22-11 For reference, a specimen of the report generated is given below

   
   

   
   Description of "Figure 22-11 For reference, a specimen of the report generated is given below"

   
   

   Note:

   The fields which are marked as Required are mandatory.

   For more information on fields, refer to the field description table.

   Table 22-8 Daily Balance Position - Generated Specimen Report - Field Description

   Field Name	Description
   Report Parameters
   Party Name	The name of the party for whom the report is generated.
   Party ID	The Id of party for whom the report is generated.
   Start Date	The start date of the generated report.
   End Date	The end date of the generated report.
   Account Number	Account number of the user for whom report is generated and is selected at the time of report generation.
   Account Currency	Currency of the account.
   Branch Code	Branch code of the user's account.
   Date	Report creation date.
   Opening Balance	Opening balance of the user's account.
   Total Credits	Total amount credited on the user's account
   Credit Count	Total Credit count of the account at the time of transaction.
   Total Debits	Total amount debited on the user's account
   Debit Count	Total Debit count of the account at the time of transaction.
   Closing Balance	Closing balance of the user's account.