During the day, or at the end of the day, you may want to retrieve information on any of the several operations that were performed during the day in your bank. You can generate this information in the form of reports for microfinance in Oracle FLEXCUBE.
For microfinance you can generate reports, which give you data about the various events in the life of a specific contract, or across contracts, at a specific point in time. You can have analysis reports, daily reports, exception reports (reports on events that ought to have taken place on the contract but have not, due to various reasons), history reports and so on. A set of report formats is pre-defined.
This chapter contains the following sections:
From the Application Browser, select the Reports option. The system displays a list of all the reports to which you have access rights. Select the report that you want to generate. The system displays a screen where you can set the filters for the reports to be generated.
Set the filters and click ‘OK’ button to generate the report. To cancel the operation, click on ’Exit’ button.
You can set your preferences as to the output of a report using ‘Client Summary and History Report’ screen. You can invoke this screen by typing ‘MFRACCNT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you can enter the following details:
Group
You have to indicate the group type. The options available are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Group
Specify the group. The option list displays all valid groups maintained in the system. Choose the appropriate one.
Client
You have to indicate the client type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Client
Specify the client. The option list displays all valid clients maintained in the system. Choose the appropriate one.
Product
You have to indicate the product type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Product
Specify the product code. The option list displays all valid product codes maintained in the system. Choose the appropriate one.
Account Number
You have to indicate the account number type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Account Number
Specify the account number. The option list displays all valid MF account numbers maintained in the system. Choose the appropriate one.
Set the filters and click ‘OK’ button to generate the report. To cancel the operation, click on ’Exit’ button.
The following details get displayed when you generate reports
You can set your preferences as to the output of a report using ’Client Fees, Charges and Penalties Report’ screen. You can invoke this screen by typing ‘MFRCFPNT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can enter the following details in this screen:
Account Number
You have to indicate the account number type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Account Number
Specify the account number. The option list displays all valid account numbers maintained in the system. Choose the appropriate one.
Set the filters and click ‘OK’ button to generate the report. To cancel the operation, click on ’Exit’ button.
The following details get displayed when you generate reports:
You can set your preferences as to the output of a report using ‘Clients Settlement info Report’ screen. You can invoke this screen by typing ‘MFRCSINT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Yon can enter the following details in this screen:
Group
You have to indicate the group type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Group
Specify the group. The option list displays all valid groups maintained in the system. Choose the appropriate one.
Client
You have to indicate the client type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Client
Specify the client. The option list displays all valid clients maintained in the system. Choose the appropriate one.
Set the filters and click ‘OK’ button to generate the report. To cancel the operation, click on ’Exit’ button.
The following details get displayed when you generate reports:
You can set your preferences as to the output of a report using ‘Client Loan Repayment Schedule Report’ screen. You can invoke this screen by typing ‘MFRSCHNT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can enter the following details in this screen:
Account Number
You have to indicate the account number type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Account Number
Specify the account number. The option list displays all valid account numbers maintained in the system. Choose the appropriate one.
From Date
Specify from date.
To Date
Specify to date.
Set the filters and click ‘OK’ button to generate the report. To cancel the operation, click on ’Exit’ button.
The following details get displayed when you generate reports
You can set your preferences as to the output of a report using ‘Branch Due Disbursement Report’ screen. You can invoke this screen by typing ‘MFRBRDNT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button
You can enter the following details in this screen:
Branch Code
You have to indicate the branch code type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Branch Code
Specify the branch code. The option list displays all valid branch codes maintained in the system. Choose the appropriate one.
From Date
Specify from date.
To Date
Specify to date.
Set the filters and click ‘OK’ button to generate the report. To cancel the operation, click on ’Exit’ button.
The following details get displayed when you generate reports:
You can set your preferences as to the output of a report using ‘Loan Arrears Report’ screen. You can invoke this screen by typing ‘MFRARRNT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can enter the following details in this screen:
Group
You have to indicate the group type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Client
You have to indicate the client type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Group
Specify the group. The option list displays all valid groups maintained in the system. Choose the appropriate one.
Client
Specify the client. The option list displays all valid clients maintained in the system. Choose the appropriate one.
From Date
Specify from date.
To Date
Specify to date.
Set the filters and click ‘OK’ button to generate the report. To cancel the operation, click on ’Exit’ button.
The following details get displayed when you generate reports:
You can set your preferences as to the output of a report using ‘Group Performance Report’ screen. You can invoke this screen by typing ‘MFRGRPRM’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can enter the following details in this screen:
Group Code
You have to indicate the group code type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Group Code
Specify the group code. The option list displays all valid group codes maintained in the system. Choose the appropriate one.
Set the filters and click ‘OK’ button to generate the report. To cancel the operation, click on ’Exit’ button.
The following details get displayed when you generate reports
You can set your preferences as to the output of a report using ‘Center Performance Report’ screen. You can invoke this screen by typing ‘MFRCNPFM’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can enter the following details in this screen:
Centre Code
You have to indicate the centre type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Centre Code
Specify the centre code. The option list displays all valid centre codes maintained in the system. Choose the appropriate one.
Set the filters and click ‘OK’ button to generate the report. To cancel the operation, click on ’Exit’ button.
The following details get displayed when you generate reports:
You can set your preferences as to the output of a report using ‘MFi Customer Related Information Report’ screen. You can invoke this screen by typing ‘MFRCRINF’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can enter the following details in this screen:
Customer
You have to indicate the customer type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Customer
Specify the customer. The option list displays all valid customers maintained in the system. Choose the appropriate one.
Set the filters and click ‘OK’ button to generate the report. To cancel the operation, click on ’Exit’ button.
The following details get displayed when you generate reports:
You can set your preferences as to the output of a report using ‘Account Officer Linkage Report’ screen. You can invoke this screen by typing ’ MFRAOFLR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can enter the following details in this screen:
Account Officer
You have to indicate the account officer type. The available options are:
Note
In case of ‘Specific’ option, if you do not select any value from the option list and in case of ‘All’ option, if you select any of the value from the option list. In both the cases the system will through an error once you click ‘OK’ button.
Account Officer
Specify the account officer. The option list displays all valid account officers maintained in the system. Choose the appropriate one.
Set the filters and click ‘OK’ button to generate the report. To cancel the operation, click on ’Exit’ button.
The following details get displayed when you generate reports:
You can set your preferences as to the output of a report using ‘Collection Sheet’ screen. You can invoke this screen by typing ‘MFRCOLRP’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can enter the following details in this screen:
Branch Code
The system displays the branch code.
Report Generation Date
The system displays the report generation date.
MFI Level
Select the microfinance level for which you wish to generate a collection sheet from the adjoining drop-down list. The available options are:
Center/Group Code
Specify the center/group code. The option list displays all valid center/group codes maintained in the system. Choose the appropriate one.
Account Officer
Specify the account officer. The option list displays all valid account officers maintained in the system. Choose the appropriate one.
Set the filters and click ‘OK’ button to generate the report. To cancel the operation, click on ’Exit’ button.
The following details get displayed when you generate reports: