Information about the application of profit or charges on accounts can be retrieved in many ways. You can retrieve data in two ways:
When you seek information in the form of a display, on the basis of certain parameters, you perform a ‘query’. Typically, you would ‘query’ the system to provide your customer with immediate information, such as the profit accrued on an account, the profit rates applicable, etc.
This chapter contains the following sections:
Oracle FLEXCUBE facilitates to query the customer account balance details of Islamic accounts using ‘Islamic Account Balance Query’ screen. You can invoke ‘Islamic Account Balance Query’ screen by typing ‘IPDABLQY’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.
You can query for records based on any one or all of the following criteria:
Click ‘Search’ button. The system identifies all records satisfying the specified criteria and displays the following details for each one of them:
Note
The system calculates the net balance using the following formula:
Minimum Balance will be considered only if it is lesser than the available balance. If the available balance is greater than zero and less than the minimum balance, then the system considers available balance as zero.
As the unauthorized debits and amount block are already considered for calculating the available balance, the unauthorized debits and amount block are not included in the formula for new net balance.
The net balance will be in the account currency.
Net balance is not applicable and will be empty if a valid non revolving line is linked to the customer account.
Last N Number of Transactions
Specify the last N number of transactions and click on ‘Account Details’ button to view the last N number of transactions of the selected account number.
Note
Oracle FLEXCUBE facilitates to query the Profit and Charges Rates details of Islamic accounts using ‘Profit & Charges Rates Query’ screen.
You can invoke ‘Profit & Charges Rates Query’ screen by typing ‘IPSRATEQ’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button
You can query for records based on any one or all of the following criteria:
Click ‘Search’ button. The system identifies all records satisfying the specified criteria and displays the following details for each one of them:
The Accrual Control list provides details of all accruals that were done for a period that you specify in the Accrual Control list options. You can invoke the screen by typing ‘IPRACCR’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.
You can specify the following parameters here:
From Date
Specify the date from when you want to generate the Accrual Control report from adjoining calendar.
To Date
Specify the date till when you want to generate the Accrual Control report from adjoining calendar.
Report Format
Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:
Report Output
Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:
Printer At
Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:
Printer
Select printer using which you wish to print the report from the adjoining option list.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Profit and Charges - Accrual Control Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Branch |
Indicates Branch Code and Branch Name |
Branch Date |
Indicates Current Date of the Branch |
User ID |
Indicates User ID |
Date & Time |
Indicates the Date and Time when the report was generated |
Module |
Indicates module for which report is generated. |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Accrual List as on |
Indicates accrual list on the date of generating the report |
Acc |
Indicates account number of the customer |
Ac Desc |
Indicates short description specified for the account number |
Product |
Indicates Product ID mapped to the account |
Formula Number |
The reference number for the formula |
CCY |
Indicates currency code of the account |
Current Accrual |
Indicates the current accrual type and the amount |
Accruals to Date |
Indicates the total accrual amount till date |
Accrual Account |
Indicates account number to which the accrual was credited |
P&L Account |
Indicates PI account number |
Current Accrual in LCY |
Indicates accrual amount in local currency |
The Islamic Profit Calculation report gives you the projected profit applicable on an account, for the current liquidation period. You can invoke the ‘Profit Calculation Report’ screen by typing ‘IPRIP’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.
You can specify the following parameters here:
Profit Calculation Details
You can generate Profit Calculation report based on the following criteria, for accounts in your branch:
Report Format
Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:
Report Output
Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:
Printer At
Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:
Printer
Select printer using which you wish to print the report from the adjoining option list.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Profit Calculation Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Branch |
Indicates Branch Code and Branch Name |
Branch Date |
Indicates Current Date of the Branch |
User ID |
Indicates User ID |
Date & Time |
Indicates the Date and Time when the report was generated |
Module |
Indicates module for which report is generated. |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Account |
Indicates account number of the customer |
Currency |
Indicates currency code of the account |
Rule ID |
Indicates the rule ID linked to the account |
Date |
Indicates the date of profit calculation |
Days |
Indicates the number of days |
Profit |
Indicates the profit for the account |
Total |
Indicates the total amount |
You can generate a profit statement whenever profit due to a rule is liquidated. In a profit statement, you can have the various values reported under specific headings. The Maintenance for Profit Statement report furnishes details of maintenance related activities carried out on profit statement headers for profit rules.
You can invoke ‘Profit Statement Maintenance Report’ screen by typing ‘IPRISFM’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.
You can specify the following parameters here:
You need to specify the following details from which you want to generate the report:
Rule Identification
Specify a valid ID of the rule from which you want to generate the report.
Formula Number
Specify a valid formula number from which you want to generate the report, from the adjoining option list.
You can specify the details up to which you would like generate the report.
Rule Identification
Specify a valid ID of the rule up to which you would like generate the report.
Formula Number
Specify a valid formula number up to which you would like generate the report, from the adjoining option list.
Report Format
Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:
Report Output
Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:
Printer At
Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:
Printer
Select printer using which you wish to print the report from the adjoining option list.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Profit Statement Maintenance Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Branch |
Indicates Branch Code and Branch Name |
Branch Date |
Indicates Current Date of the Branch |
User ID |
Indicates User ID |
Date & Time |
Indicates the Date and Time when the report was generated |
Module |
Indicates module for which report is generated. |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Rule ID |
Indicates the rule ID linked to the account |
Formula Number |
Indicates reference number for the formula |
Single Line |
Indicates description regarding the single line |
Element |
Indicates description regarding the element |
Language |
Indicates the language in which the report is generated |
Product |
Indicates the code of the product |
Maker ID |
Indicates the login ID of the user who has performed activity or event on the bill |
Maker Date Stamp |
Indicates the date and time when the activity or event on the bill |
Checker ID |
Indicates the login ID of the user who authorized the clause |
Checker Date Stamp |
Indicates the date and time when the clause was authorized |
Mod Number |
Indicates the Mod number of the report |
Auth Stat |
Indicates the authorization of the report |
Record Stat |
Indicates the record status of the report |
The Liquidation Control list provides details of all liquidations that were done for a period that you specify in the Liquidation Control list options. You can invoke the screen by typing ‘IPRLIQR’ in the field at the top right corner of the Application tool bar and click on the adjoining arrow button.
You can specify the following parameters here:
From Date
Specify the date from when you want to generate the Liquidation Control report from adjoining calendar.
To Date
Specify the date till when you want to generate the Liquidation Control report from adjoining calendar.
Report Format
Select the format in which you need to generate the report from the adjoining drop-down list. This list displays the following values:
Report Output
Select the output in which you need to generate the report from the adjoining drop-down list. This list displays the following values:
Printer At
Select location where you wish to print the report from the adjoining drop-down list. This list displays the following values:
Printer
Select printer using which you wish to print the report from the adjoining option list.
The parameters specified while generating the report are printed at the beginning of the report. Other content displayed in the Profit and Charges - Liquidation Control Report is as follows:
Header
The following details are displayed in the header section:
Field Name |
Field Description |
Branch |
Indicates Branch Code and Branch Name |
Branch Date |
Indicates Current Date of the Branch |
User ID |
Indicates User ID |
Date & Time |
Indicates the Date and Time when the report was generated |
Module |
Indicates module for which report is generated. |
Body of the Report
The following details are displayed as body of the generated report:
Field Name |
Field Description |
Account |
Indicates account number of the customer |
Description |
Indicates short description specified for the account number |
Prod |
Indicates Product ID mapped to the account |
Formula Number |
Indicates reference number for the formula |
Currency |
Indicates currency code of the account |
Book Currency |
Indicates the currency code of the book |
Book Acc |
Indicates account number of the book |
Book Currency Amount |
Indicates amount in the book currency |
LCY Amount |
Indicates amount in local currency |