Home

Data Entry User Manual

1. Transaction MIS 9 i Composite MIS 9 Fund MIS 10 6 2 7 Specifying Interest Details Based on the ICCF maintenance at the product level the charge details are defaulted for the contract However you can change them Charges will be recovered from the charge or tax account specified in this screen Click ICCF button and invoke the following screen Allow Amendment ESN Contract Reference 1 1077 P K Go Rate Currency Amount Component Event Status Refer the section titled Specifying Charge Details in the chapter Defining Attributes of a Teller Product in this User Manual for details about this screen SCH ORACLE 6 2 8 Specifying Tax Details Based on the tax maintenance at the product level the tax details are defaulted for the contract However you can change them Charges will be recovered from the charge or tax account specified in this screen Click Tax button and invoke the Tax Details screen Tax Details Contract Reference Tax Scheme Waiver Rule Details 1 Of 1 Rule Basis Component Event Waiver oO Amount Details 1 Of 1 Value Date Transaction Date Currency Event Sequence Number Refer the section titled Specifying Tax Details in the chapter Defining Attributes of a Teller Product in this User Manual for details about this screen 6 2 9 Viewing Batch Sum
2. Serial Number Branch Code Account Number Percent Maker Date Time Checker Date Time Mod No Record Status Authorization Status Indicating Offset Entries For the offset leg of the transaction you can select multiple accounts that belong to different branches of your bank The option list provided for the Account field gets populated with the relevant accounts depending on the branch code selected For each account that is selected you can specify either the amount or the percentage of the amount If you specify the amount the percentage is automatically calculated with respect to the amount that you specify for the main leg of the transaction in the MAIN tab Similarly the amount is automatically calculated if you decide to specify the percentage for each offset account R ORACLE 3 5 The Serial Number is automatically displayed on selection of an offset account from the option list provided Note The sum total of all the amounts specified for each offset account must be equal to the amount of the main leg So also the total of the percentages should not exceed 100 At the time of processing multi offset transactions you can associate a template with the transaction The details from the template will get defaulted to the transaction Maintaining Multiple accounts Dr Cr Transactions The journal entry template for multiple debits to multiple
3. button Signatory Details Branch Account Customer Number Description Account Message Minimum No of Signatories Name 10f1 Signature Id Signatory Message Signatory Type Approval Limit Solo Sufficient Refer the User Manual on Signature Verification for further details about this screen SS ORACLE Capturing MIS Details MIS details are defaulted to the transaction from the product maintenance However you can change them for the contract Click MIS button and invoke the MIS screen Contract Reference Link To Group Rate At Rate Type Transaction MIS MIS Group Transaction MIS 1 Transaction MIS 2 Transaction MIS 3 Transaction MIS 4 Transaction MIS 5 Transaction MIS 6 Transaction MIS 7 Transaction MIS 8 Related Reference Related Account Pool Code Contract Level MIS Group Related Account Related Reference MIS Head Interest Method Refinance Rate Pool Code Composite MIS MIS Group Composite MIS 1 Composite MIS 2 Composite MIS 3 Composite MIS 4 Composite MIS 5 Composite MIS 6 Composite MIS 7 Composite MIS 8 Fund MIS Rate Code Spread Cost Code 1 Cost Code 2 Cost Code 3 Cost Code 4 Cost Code 5 Fund MIS 1 Fund MIS 2 Fund MIS 3 Fund MIS 4 Fund MIS 5 Fund MIS 6 Fund MIS 7 Fund MIS 8 Fund MIS 9 E Link To Group
4. The input in this field determines the variance in number of units note NOT percentage between the default value and the value changed Specifying Use Exchange Rate History Often you may enter back dated transactions That is you may enter a transaction date that is earlier than your current system date On such a transaction a teller may want to apply the exchange rate that prevailed on the transaction date This rate must be retrieved from history By clicking on the box adjacent to Use Exchange Rate History you can indicate that you would like to apply the exchange rate from history on back dated transactions If you do not choose this option the Spot Rate maintained for the day on which the transaction is entered in the system will be used for the transaction For example if the default equivalent of a FCY transaction is 120 units in the LCY and the allowed variance amount that you have specified is 10 units in the LCY then the LCY equivalent if changed should be between 110 and 130 units Opting for Denomination Tracking You can opt for tracking denominations for data entry transactions by checking the Denomination Tracking Required checkbox Specifying Back Value Details You can post back value dated transactions in Oracle FLEXCUBE However for the purpose of risk tracking you can specify a limit beyond which users will be prevented from posting a back value dated transaction in the system Se ORA
5. local currency equivalent of the transaction amount using the Exchange rate that is displayed in the previous field If the transaction is a cross currency transaction the system calculates the LCY equivalent based on the standard rate It is arrived at for each leg of the transaction as follows e When customer account is debited the rate used Standard Rate Spread SS ORACLE 6 2 1 1 6 2 2 e When customer account is credited the rate used Standard Rate Spread The LCY equivalent for the transaction is taken as the average of the LCY equivalents for both the legs Changing the local currency equivalent Yes you can change the local currency equivalent but within a specified range This range is referred to as the local currency variance limit The local currency variance limit is defined at the branch level Note The variance that you specify is not a percentage but an absolute value in the local cur rency Related Customer Specify the customer of the transaction The adjoining option displays all valid CIF maintained in the system You can select the appropriate one Offset Amount Dispenser The amount dispensed by or deposited into the cash dispenser will be displayed in this field Note If the amount deposited into the dispenser is greater than the offset amount the offset amount user will be a negative value Offset Amount User The amount dispensed by or deposited into the teller s till will
6. 4 5 Maintaining Journal Upload Preferences You can set your preferences specific to journal upload using Journal Upload Preferences Maintenance screen SCH ORACLE To invoke the screen type DEDUPLPF in the field at the top right corner of the Application Browser and click the adjoining arrow button Journal Upload Preferences Maintenance E New enter Query Source Code Suspense GL Credit Debit Real Local Currency Real Local Currency Real Foreign Currency Real Foreign Currency Contingent Local Currency Contingent Local Currency Contingent Foreign Currency Contingent Foreign Currency Maker Date Time Checker Date Time Mod No Record Status Authorization Status You can maintain Suspense GLs where entries have to be posted for each external system in the event of failure of account validation during DE Upload You can capture the following details on this screen Source Code Specify the source code for upload Real Local Currency Specify the suspense GL for real local currency on credit as well as debit transactions Real Foriegn Currency Specify the suspense GL for real foreign currency on credit as well as debit transactions Contingent Local Currency Specify the suspense GL for contingent local currency on credit as well as debit transactions Contingent Foreign Currency Specify the suspense GL for contingent foreign currency on credit as well as d
7. LCY The maximum and minimum transaction amount for a product can be defined in this screen These limits should be specified in the local currency Minimum Transaction Amount Specify the minimum transaction amount for the product The teller cannot enter a transaction if the transaction amount is less that what you specify here Maximum Transaction Amount Specify the maximum transaction amount for the product A teller cannot enter a transaction involving the product if the amount exceeds the maximum transaction size that you specify here Rate Type You can define an exchange rate type for every product that you create For example you can specify the exchange rate type as TC sell rate for a traveller s cheque product that you sell When you enter a transaction involving the product the exchange rate which you maintain at the beginning of day in the currency table corresponding to the Exchange Rate Type will be applied This is referred to as the default exchange rate Click the adjoining option list and view all exchange rate types that are maintained Double click on the Rate Type that you wish to specify for the product Exchange Rate Variance For a special customer or in special cases you may want to use an exchange rate a special rate that is greater than the default exchange rate Normal Rate Variance In this field you can specify the default or normal percentage difference of the special rate fr
8. Number Template Id Default Temolate Main Offset Multi Offset Detail r i A Serial Number Branch Code x Account Amount Instrument Number 4 I i MIS Signature Verification Fields Input By Authorized By id Authorization Status Date Time e Date Time e Specify the following details Branch In this field enter the branch IDs of each of the offset accounts Account Enter the account number of each of the offset accounts in this column Amount For each of the offset accounts enter the offset amounts Instrument Number If the Offset leg of the transaction involves an instrument number enter the same in this column The total offset amount will be displayed at the bottom of the screen After you have made your specifications in the above columns map each offset entry to the branch an account and the amount Saving and Authorising Transaction When you have entered all the details of a transaction you have to save the transaction in the system To save a transaction select Save from the Actions menu in the Application tool bar or click save icon To authorize an account click Authorize icon on the Application toolbar SS ORACLE 6 9 4 Transaction Code Main Batch Number Transaction Code Offset Current Number Value Date Maker id Amount Overrides 10f1 us sn m Confirm Override Tet Status Authorized By Authorized Date Remarks The
9. ORACLE Specifying Events Click Events button and invoke the Events screen Through this screen you can define events for transactions and also specify details of accounting entries and advices that have to be generated for the events that take place during the life cycle of transactions Product Code Product Description Class Details Default From Class Class Code Class Description Event Details 1 Of 1 Event Code Description H Accounting Entries Advices Refer the Product Definition User Manual under Modularity for further details a ORACLE 5 1 2 1 Specifying Accounting Entries Click Accounting Entries button in the Events screen and invoke the Accounting Entries screen to define accounting entries for every event Accounting Entries Event Code Event Description Accounting Entries Details 1 Of 1 Accounting Role Amount Tag DriCr Transaction Code Netting Debit v MIS Head ProftGL No gt Refer the Product Definition User Manual under Modularity for further details 5 1 2 2 Specifying Advices Click Advices button in the Events screen and invoke the Advices screen to define advices for every event Event Code Description Advices Details 1 Of 1 Advice Name Description Generation Time Suppress Priority Charges Authorize No Hi O Refer the Prod
10. Transaction Amount Limit LCY Minimum Transaction Amount Maximum Transaction Amount Description Default Offset Currency Default Charge Collection Amount Cheque Type Exchange Rate Variance Normal Rate Variance Maximum Rate Variance Transaction Currency Local Currency Transaction Offset Bank code Required Unpaid Clearing Transaction Online Authorization Required Dispenser Allowed Normal Rate Type Back Value Details Minimum Amount for Signature Verification Exchange Rate Back Value Check Required Buy Rate z Back Value Days You can capture the following details Product Code and Description The system displays the product code and its description from the main screen Rekey Required All transaction entered in the system should be ratified or authorized by a user with the requisite rights This is a security feature When a transaction involving a product is authorized you can indicate in this screen if the transaction details need to be rekeyed by the authorizer If you opt for rekey of details click on the button against Yes under Rekey Required You can indicate which of the details that you would like the authorizer to rekey Click on the box adjacent to any or any of the following to indicate that it should be rekeyed e Rekey Transaction Account e Rekey Transaction Amount e Rekey Offset Account a ORACLE e Rekey Value Date e Rekey I
11. accounting entries that are generated by transactions of a particular type are posted in a batch Purpose of Batch All transactions that have been entered into the system have to be authorized at the end of the day by a user with the required authorization rights You can authorize transactions of a particular type by authorizing the batch into which they have been posted since all transactions of a particular type are posted into a batch 41 ORACLE 4 2 2 Opening Batch You can invoke the Journal Batch Authorization screen by typing DEDBTHAU in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Journal Batch Authorization Enter Query Batch Number Batch Type Description Entry Total Debit Credit Description Last Auth By Date Time Date Time If automatic generation of batch numbers has been allowed at your bank in the Bank Wide Parameters screen the system automatically generates the batch numbers sequentially The number of the first batch will be 0000 The series in which the subsequent batch numbers are generated is as follows e 0000 to 0009 e 000a to 000z e 0010 to 0019 e 001a to 001z e 0020 to 0029 e 002a to 002z and so on When all the batch numbers are used up system will display a message stating that all the available batch numbers have been exhausted Batch Number If your bank has not opted for automatic
12. applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliate
13. can choose the appropriate one Note that a till that you have opened cannot be used by any other user during the day unless it is balanced and reassigned to another user Narrative Specify any additional information Balancing Till Till balancing involves checking of the physical balance in the Till actual balance against the till balance according to the system All Tills that have been used for Teller transactions during the day have to be balanced before the end of day Note that a Till used by a teller cannot be assigned to another unless it is balanced Note All currencies in a Till have to be balanced for the Till to be considered balanced You can balance a Till through the Till Balancing screen You can invoke this screen by typing DEDTILBL in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Till Balancing ES New amp Enter Query Branch Code Cash Counted Till ld Cash Available Currency Code Difference 1 Of 1 E Denomination Code Denomination Value Units Counted Total Cash Counted Specify the following details Branch Code The currency logged in branch is displayed Till Identification Specify the till that has to be balanced The adjoining option list displays all valid tills maintained in the system You can select the appropriate one 44 ORACLE 4 5 Currency Code Specify the currency in which
14. field You can correct the check total values in the Check Total field and update them in the system You may or may not opt to use the changed values If you opt not to use the original Check Total values the system will use the original values to tally the actual entries that you post to the batch Se ORACLE Viewing Transaction Summary You can view a summary of all teller transactions using the Transaction Summary screen You can invoke this screen by typing DESTLRON in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button C Advanced Search Reset Authorization Status Contract Status Transaction Date d Batch Number Reference Number Records per page 15 Ed Authorization Status Contract Status Transaction Date Batch Number Reference Number Tillld Transaction Ci You can query on records based on any or all of the following criteria e Authorization Status e Transaction Date e Reference Number e Contract Status e Batch Number Click Search button The system identifies all records satisfying the specified criteria and displays the following details for each one of them e Authorization Status e Contract Status e Transaction Date e Batch Number e Reference Number e Tillid e Transaction Currency e Transaction Amount e Transaction Branch e Transaction Account e Event e Event Sequence No Double
15. financial details that the teller enters into For example you can e Define exchange rate variance limits e Specify the limit over which signature verification is required e Specify the values that the authorizer of a transaction has to rekey before the complete details of a transaction are displayed e Specify transaction amount limits e Display online override for overdrafts Specifying an Exchange Rate Variance When a transaction involves a currency conversion the rates defined for the Rate Type specified for the product will be picked up by default examples for Rate Type could be TC buy rate cash rate etc This default can be changed You can impose some restrictions on this changed rate as follows Normal Variance If the exchange rate variance exceeds the exchange rate for the Rate Type by this value normal variance the system will ask the teller for an override before proceeding to apply the exchange rate This override will be recorded and retrieved along with the transaction Further the transaction has to be authorised by another user with the requisite rights before it is stored Maximum Variance A teller cannot apply an exchange rate on a transaction involving the product that is greater than the value that you specify as the Maximum Variance If the teller specifies an exchange rate that exceeds the standard rate by the maximum variance you have defined for the product the system will not store the tran
16. in the currency of the account number that you specified Now you must indicate if the amount is to be credited to the account or debited from the account To do this you must click on either of the buttons adjacent to this field If the amount is to be credited to the account click on the button against Cr If the amount is to be debited click on the button against Dr On saving the transaction after entering all the required details in the system the system validates the value of the transaction amount against the following e Product transaction limit e User Input limit If the transaction currency and the limit currency are different then the system converts the amount financed to limit currency and checks if the same is in excess of the product transaction limit and user input limit If this holds true the system indicates the same with below override error messages e Number of levels required for authorizing the transaction e Transaction amount is in excess of the input limit of the user Transaction Code Select the transaction code that you want to enter from the adjoining option list Period Code The financial year of your bank is divided into four quarters These details are maintained in the Global Parameters module When you input a journal transaction you must indicate the financial period to which the transaction belongs Select the financial period for the journal entry you are entering from the adjoin
17. is not balanced system will display the error message as Batch not balanced If you see such an error message you need to manually post equivalent entries in order to balance the batch If you cancel this operation at the end of transaction input the system does not verify the batch balance Further the batch gets locked in Batch Unlock Screen While creating a new batch if you have not checked the option Balancing in Batch Open screen the input transaction need not be balanced in order to exit the batch Thus when you click Batch Close button if the transaction is balanced the system processes the batch and unlocks it If the transaction is not balanced the system unlocks the batch and save the transaction The Validations The system performs the following cross validations during transaction input It ensures that e Al the mandatory fields have been input by the user e The transaction amount is within the allowed limit for the teller e The exchange rate variance conforms to that defined at the branch level e The local currency variance limit Deleting Journal Transaction In special circumstances you may want to remove a transaction from the system In Oracle FLEXCUBE you have the option of deleting a journal transaction When a transaction can be deleted If a transaction that you have input has not been authorized you can delete it Remember that only the user who input a transaction c
18. limits for a Till Vault that you have maintained in your bank For each Till the following parameters have to be defined e Minimum balance in each currency e Maximum balance in each currency e The Cash GL for each currency a ORACLE 3 4 3 4 1 3 4 2 The Minimum balance for each currency that you define for a Till is the minimum amount that the Till should contain in the currency The Maximum balance that you define is the maximum amount that the Till can contain in the currency Every currency that you have maintained for a Till Vault should be linked to a Cash GL While defining a product if you specify TILL as the Accounting Head all accounting entries that are generated for Teller type transactions involving the product will be posted to the Cash GL that you specify for the currency Note that for a Vault you can maintain only the Cash GL You cannot define a maximum and a minimum currency balance Maintaining Bank Codes You can use the Clearing Bank Code Maintenance table to maintain a list of banks that participate in your clearing house Maintaining a list of such banks helps you track and clear cheques bank wise at the End of Day In the following table you must assign each bank a unique Bank Code The bank code that you specify will be common to all the branches of your bank If a cheque drawn on another bank which you have maintained is input into the system tellers can identify the drawee bank w
19. maintain exchange rate variation limits for Journal and Multi offset transactions When you input a Journal transaction the exchange rate which you maintain at the beginning of day in the currency table will be applied This is referred to as the default exchange rate However for a special customer or in special cases you may want to use an exchange rate that is greater than the default exchange rate In this field you can specify the maximum and minimum percentage difference of the special rate from the default rate In other words you can specify the Maximum and Minimum Exchange Rate Variance Note When you enter a transaction the system will not seek an override if the Exchange Rate that you choose to apply is lower than the Minimum Exchange Rate Variance specified in the Minimum Exchange Rate Variance field If the Exchange Rate is between the Minimum and the Maximum Exchange Rate Variance defined the system will display an override message The system will not store a transaction if you apply an Exchange Rate that is more than the Maximum Exchange Rate Variance defined Specifying Local Currency Equivalent Variable Limit Another parameter that you can define for Teller and Journal type transactions in this screen is the LCY Equivalent Variance Limit When a teller enters a transaction Teller Journal Multi offset she can change the local currency equivalent for the transaction if it is a foreign currency transaction
20. the date on which a transaction comes into effect The system displays the current system date here You can however enter a back dated that is a date prior to the current system date or a future dated transaction The system will display an override message in the following cases e Ifthe value date is back dated or future dated e If the value date is a holiday Cheque Type Select the type of cheque from the adjoining drop down list You can choose any one of the following options Ga ORACLE e Normal e Circular e A Type Exchange Rate Different types of exchange rates can be maintained in your branch For example you can define an exchange rate for travelers checks in USD and an exchange rate for cash transactions in USD When you define a product you specify an Exchange Rate Type for it The exchange rate corresponding to the Rate Type defaults to all transactions entered for the product Please note that the exchange rate that the system uses is the exchange rate corresponding to the exchange rate type that is defined for the product the transaction involves For example while creating Money for Nothing a travelers check product for sale you would specify an exchange rate type TCsale When you enter a transaction for Money for Nothing that is when you sell Money for Nothing the exchange rate corresponding to TCsale will be displayed in the Exchange Rate field You can chang
21. the record the details of the teller record will be made available to the user concerned Upon authorization of the details of the record by the user concerned the system notifies the maker of the record with an authorization notification message You will be allowed to authorize transactions online only if you have enabled this option for the Teller Product linked to the particular transaction To allow online authorization choose the OnlAuth Required option in the DE Product Preferences screen Leave the box unchecked if you do not want to perform the online authorization of transactions associated with the product Dispenser Allowed Enable Dispenser Allowed to indicate that data entry product being defined has to have the cash dispenser facility This facility will be applicable for the product only if it has been enabled for your branch in the Data Entry Branch Conditions screen Unpaid Clearing Transaction Check this box to capture the reason for clearing transaction for all transactions under this product Transfer Type Specify the type of transfer The adjoining option list displays all valid transfer types available in the system You can select the appropriate one 21 ORACLE 5 1 5 1 Cheque Type Select the type of cheque applicable on transactions under this product from the adjoining drop down list You can choose any one of the following options e Normal e Circular e A Type Transaction Amount Limit
22. wgl Di o Debit Exchange Rate ail Instrument Number Additional Text Value Date Fund d Raith Cl sa MIS Signature Verification Fields Input By Authorized By Jg Authorization Status Date Time e Date Time e D The following are the details of a Multi offset transaction that you need to enter in this screen e Currency Code e Account e Amount e Exchange Rate e Instrument Number and Description e Additional text e Fund Identification e Transaction Code for the main leg e Transaction Code for the offset leg Geen ORACLE 6 9 2 e Indicate Debit Credit e Value Date Batch Number The batch that you have opened to post the multi offset transaction is displayed at the top of the Multi offset Input screen Every such transaction that you enter into the batch is assigned a current number by the system This helps you to identify the multi offset transactions that you enter for the day Template Identification You can process a multi offset transaction by associating a relevant template to the transaction The details maintained for the template will be defaulted to the transaction You will be required to capture only the remaining mandatory details if any to save the transaction The option list for Template ID field displays the templates maintained for a particular branch You need to choose a Template ID from this list Further click Default Template button to get the selected template d
23. you are creating Main ES New amp Enter Query Branch Code TillMVaultDispenser Vault Till Id Till Description Dispenser Parent Vault Shortage Overage General Ledger Allow Cash Transfer Between Branches Currency Preferences 1 Of 1 Currency Code Cash General Ledger Minimum Balance Maximum Balance Minimum Dispenser Amount Maker Date Time Checker Date Time Mod No Record Status Authorization Status In this screen you must first of all indicate whether you are maintaining a till a vault or a dispenser If you are maintaining a till click on the button against Till If you are maintaining a vault click on the button against Vault and if you are maintaining details of a dispenser click on the button against Dispenser Branch Code The code of the branch through which you have logged in will be displayed in this screen Specifying whether Till Vault Dispenser Specify whether you are maintaining a Till Vault Dispenser You can then maintain the related details Till Identification and Description In the Till ID field enter a unique code to identify the Till Vault you are maintaining You may enter a brief description of the Till Vault for future reference You must also link the Till you are maintaining to a valid Parent Vault The adjoining option list displays a list of the Vaults that you have maintained in your bank From the option list choose the Parent Vault to w
24. A Refer the User Manual on Tax under Modularity for further details Capturing User Defined Fields Product User Defined Fields Product Code Product Description Fields 1 Of 1 Field Number Field Name Here you can capture the following details Product Code and Description The system displays the product code and its description from the main screen Field Number The system displays the field number SP ORACLE 5 2 Field Name Specify the name of the UDF The adjoining option list displays all UDFs maintained in the system You can select the appropriate one Viewing Product Summary You can view a summary of all products maintained in the system using the Teller Product Summary screen You can invoke this screen by typing DESPRMNT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button et Advanced Search f Reset Authorization Status Record Status Product Code Product Description Product Group Data Entry Product Type Records perpage 15 Ed Authorization Status Record Status Product Code Product Description Product Group Data Entry Product Type You can query on records based on any or all of the following criteria e Authorization Status e Product Code e Product Group e Record Status e Product Description e Data Entry Product Type Click Search button The syst
25. Authorizing Batches annue aE EE EA AA EAA AAEE aia 8 1 83 R assigning Batch EE 8 3 8 3 1 Reassigning Patch 8 3 BA Processing Journal Batch enana a EET 8 3 8 4 1 Viewing Journal Batches eeesssseneesrrneerrennnnenrrrennrrnnnnnenrrrnnnrrnnnnnnnernnnrnna 8 4 8 4 2 Unlocking Journal DBatches essre aaeeei a ar E EE AES 8 4 8 4 3 Reserving Journal DBatches 8 5 8 4 4 Maintaining Journal Batch Upload 8 6 8 4 5 Maintaining Journal Upload Preferences ccccccescceccetsieeeteentieeteeeenaaes 8 9 Ds O REpOTIS EE 9 1 FT INtrOGUCTION EE 9 1 9 2 Batch Totals RePOMt TE 9 1 9 2 1 Contents Of RERO iseia airite aaa apaa aea eiea a EEE E EE 9 2 9 3 Report on Currency Positions of your Branche 9 2 10 Function ID Glossary nssssssssssssssnnunnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn nna 10 1 1 1 1 2 1 3 1 4 1 Preface Introduction This manual is designed to help you quickly get acquainted with the Data Entry module of Oracle FLEXCUBE It provides an overview to the module and provides information on using the Data Entry module of Oracle FLEXCUBE You can further obtain information specific to a particular field by placing the cursor on the relevant field and striking lt F1 gt on the keyboard Audience This manual is intended for the following User User Roles Role Function Back office clerk Input functions for contracts Back office managers officers Autho
26. Branch Conditions that can be Defined The authorizer of the above transaction will have to rekey for example the Account Number of the customer the Amount of the transaction and the Value Date of the transaction if you have indicated that these values have to be rekeyed at the time of authorization You can define the following branch conditions in the Data Entry Branch Conditions table e Rekey at the time of authorization of journal and multi offset transactions e Transaction codes for cash transfers amongst Tills Vaults and Cash Dispensers e Exchange Rate Variance e Local currency equivalent of the Exchange Rate Variance e Denomination input for teller transactions e Use Exchange rate history e Allow Cash Dispenser functionality and define the minimum dispensable amount e Defining the maximum amount to be dispensed during an alarm situation Defining Branch Conditions Journal Entry Branch Parameters Maintenance ES New Enter Query Branch Code Journal Entry Rekey Required Rekey Fields Local Currency Equivalent Variable Limit Back Value Details Value Date Amount Transaction Required Account _ Use Exchange Rate History Denomination Tracking Required C Back Valuation Check Required Multi Offset Entry Rekey Required Multi Rekey Fields Exchange Rate Variance Normal Maximum Back Value Days You can invoke the Journal Entry Branch Parameters Mainten
27. CLE 3 3 3 3 1 3 3 2 Check against the option Back Valuation Check Required if you want enable back value dated transactions You then need to specify the number of days to which a transaction posted by a user can be back valued dated in Oracle FLEXCUBE If a user specifies a date that does not fall within the back value days limit measured in calendar days i e this period is inclusive of holidays maintained here the system will display the error message as The value date is earlier than the Permitted value days e If the message is configured as an error you will not be able to proceed with the transaction until you specify a date which is within the limits maintained e __If the message is configured as an override you will be able to proceed with entering the transaction but an override is logged into the database that the date specified does not fall within the limits maintained e If itis configured as a ignore message then no back valuation check will be performed The same validations are carried out for transactions that are uploaded from external systems Note You will be allowed to specify the Back Value Days only if the Back Valuation Check Required option is checked If the option is not enabled the system will allow you to post back valued transactions upto any date in the past no check will be done Further if the option is checked but you have not maintai
28. F Clearing Details Messages Maker Date Time Status Checker Date Time Authorization Status In this screen you have to specify the following details for a transaction Product Based on the type of transaction that you are entering you have to select a product that you have maintained in the system To select a product click on the option list adjoining the Product Code field A list of the products that you have maintained in the branch will be displayed Click on the product that you would like to offer the customer When you select a product the transaction acquires the attributes that you have defined for the product Reference Number All transactions that are entered into the system are assigned a unique identification number known as the Transaction Reference number The reference number for a transaction is based on the Branch Code the Product Code the date on which the transaction is entered in the Julian Date format and a running serial number for the day The Julian Date is of the following format YYDDD Here YY stands for the last two digits of the year and DDD for the number of day s that has have elapsed in the year Capturing Main Details You can capture the following details G2 ORACLE Transaction Branch Specify the branch code wherein transaction is being posted The adjoining option list displays all valid branch codes available in the system You can select the approp
29. In case one leg of the transaction involves a check you have to enter the instrument number here if the transaction code specifies an instrument number Description Enter a brief description for the Instrument Number that you have specified Additional Text If required enter any additional information related to multi offset transactions Fund Identification Select the fund id to which the journal entry account will be linked from the adjoining option list The system defaults the value of Default Mudarabah Fund as fund id Transaction code Under Transaction Code on the right top of the screen you will observe two fields Main and Offset In the Main field the adjoining option list displays a list of all the transaction codes that are maintained in your branch Double click on the transaction code that you want to specify as the transaction code of the main leg of the transaction In the Offset field the adjoining option list displays a list of all the transaction codes that are maintained in your branch Double click on the transaction code that you want to specify as the transaction code for the offset leg of the transaction SR ORACLE Currency The system defaults to the currency of the account number that you have entered in case of a customer account If the account is a GL the system defaults to the local currency If you have to enter the currency of the transaction you can do so The adjoining
30. ORACLE Data Entry User Guide Oracle FLEXCUBE Universal Banking Release 12 0 2 0 0 Part No E49740 01 September 2013 Data Entry User Guide September 2013 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2007 2013 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous
31. Variance limit defined e Availability of funds in the specified accounts e Teller limit verification e Override incase the value date is back date or future dated Authorisation Validations You cannot authorise a transaction from the Teller Transaction Input screen in the following cases e the contract has multilevel of authorization pending the same will be done using the Multilevel Authorization Detailed screen e the level of authorization is greater than or equal to N e the Nth or the final level of the users authorisation limit is less than the difference between amount financed and sum of the limits of all the users involved in authorizing Slp ORACLE 6 4 6 4 1 a transaction this case holds good when the Cumulative field is checked in the Product Transaction Limits Maintenance screen e the transaction amount is greater than the authoriser s authorisation limit if the Cumulative field is unchecked in the Product Transaction Limits Maintenance screen Transaction Delete In special circumstances you may want to remove a transaction from the system In Oracle FLEXCUBE you have the option of either deleting the transaction or reversing it When is deletion possible If a transaction that you have input has not been authorized you can delete it Remember that only the user who input a transaction can delete it You have to reverse a transaction that has b
32. Verification Fields Maker Checker Jg Authorized Date Time e Date Time e Specify the following details Batch Number The batch that you have opened to post the journal transaction is displayed at the top of the Journal Entry screen Fund Identification Select the fund id to which the journal entry account will be linked from the adjoining option list The system defaults the value of Default Mudarabah Fund as fund id Current Number Every journal transaction that you enter into the batch is assigned a current number by the system This helps you identify the journal transactions that you enter for the day Account Number Select the account number from the adjoining option list in the Account Number field The journal entry will be posted to this account or GL In case you are posting to several accounts it is advisable to manually enter the account number in this field rather than choose it from the displayed list Account Branch In the Account Branch field system defaults to the branch that you have logged in to You can choose the branch to which you want to post the journal entry Currency The system displays the currency of the account number if it is a customer account Else you have to enter the transaction currency in this field Select the currency from the adjoining option list SS ORACLE Amount In this field enter the amount of the transaction The amount that you enter here must be
33. al entry input using the Journal Input Entry Summary screen You can invoke this screen by typing DESJNLON in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Journal Entry Online C advanced Search Reset Authorization Status J Batch Number Reference No Template Code Records per page 15 v 10f1 Authorization Status Branch Code Batch Number Current Number Reference No Value Date Template Coc Here you can query on journal entry input details based on any one or all of the following criteria e Authorized e Batch number e Template code e Reference number Click Search button The system identifies all records satisfying the specified criteria and displays the following details for each one of them e Authorized e Branch Code e Batch number e Current Number e Reference number e Value date SZ ORACLE 7 1 7 2 7 Miscellaneous Transactions Introduction This chapter details the following operations e Cash Transfer e Denomination Exchange Transferring Cash You can transfer cash from one Till to another or from one Vault to another or from a Till to a Vault and vice versa You can do this in the Cash Transfer screen You can invoke this screen by typing DEDCSHMV in the field at the top right corner of the Application tool bar and clicking the adjoining arrow butt
34. an delete it How to delete a transaction When you are in the Journal Input Form select Delete from the Actions menu in the Application tool bar or click delete icon The transaction that is displayed in the screen will be deleted All accounting entries passed for the transaction will be removed Entering Multi offset Transactions Specifying a Multi offset transaction Brae ORACLE 6 9 1 What is a Multi offset transaction A multi offset transaction is one in which multiple accounting entries are passed to balance one main entry For example if cash that is debited from an account and credited to several other accounts multiple offset entries are passed to balance the one debit entry When you enter a multi offset transaction the system ensures that the total amount of the offset entries is equal to the amount of the main entry Note Before you can enter multi offset transactions for the day you must open a batch to post these transactions Entering a Multi offset Transaction You can invoke the Journal Multi Offset Input screen by typing DEDMJONL in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Journal Multi Offset Entry E new Enter Query Batch Number Batch Description Current Number Template Id E ora Currency Code Transaction Code Default Temolate Account Main Description offsett
35. ance screen by typing DEDBRCON in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Yes No Value Date C Main Transaction Code Offset Transaction Code Amount Fields Maker Checker Mod No Branch Code Select the branch for which you are maintaining the parameters Date Time Date Time Record Status Authorization Status 3 2 Click new icon You can now maintain the branch conditions for your branch ORACLE 3 2 2 1 3 2 2 2 Specifying Journal Entry and Multi Offset Entry You can specify the values that the authorizer of a transaction has to rekey when authorizing it All operations on a transaction input modification etc have to be authorized e By a user other than the one who carried out the operation e Before you can begin the end of day operations When you invoke a transaction for authorization as a cross checking mechanism to ensure that you are calling the right transaction you can specify that the values of certain fields should be entered before the other details are displayed The complete details of the transaction will be displayed only after the values to these fields are entered This is called the re key option The fields for which the values have to be given are called the re key fields If no re key fields have been defined the details of the transaction will be displayed immediatel
36. ance Name e Remittance Address 1 and 2 e Related Reference Number e Beneficiary ID e Beneficiary Account e Reason Code e BLEI Code e Resident Status e Beneficiary Address 1 and 2 e Payment Details os ORACLE 6 2 12 Viewing Messages Click Messages button and invoke the View Messages screen to view messages that have been generated based on the advices defined at the product level EX New amp Enter Query Contract Reference ESN Event Messages 10f1 Message Type SWIFT Message Type Medium Message Status Authorization Status Receiver Receiver Name S Message Details You can view the following details e Contract Reference Number e Event Sequence Number e Event e Medium e Receiver e Name e Message Status e Test Status e Authorization Status Saving and Authorising Transaction When you have entered all the details of a transaction you have to save the transaction in the system To save a transaction choose Save from the Actions menu The system checks whether the accounts mentioned in the from and to leg of the transaction belong to the same netting group or not If they belong to the same netting group the accounting entries will not be posted Instead the transaction will be logged for the netting batch The system will automatically place an amount block on the debit account However for the credit account the amoun
37. ange rate variance is specified at the Branch Level for journal transactions Note In case you are entering a Foreign Currency back value dated transaction the system will pickup the exchange rate applicable on the Value Date This is possible only if you have maintained the Exchange Rate History for your branch refer the Branch Conditions screen Related Customer The ID of the Customer involved in the transaction is entered in this field This is used for MIS purposes The adjoining option list displays a list of the Customer IDs that have been maintained in your branch Double click on the ID that you want to enter in this field MIS Group The MIS group to which the transaction belongs gets displayed here Total Debit The total amount debited for the whole batch is converted into the local currency equivalent and displayed here Total Credit The total amount credited for the whole batch is converted into the local currency equivalent and displayed here Saving and Authorising Transaction When you have entered all the details of a transaction you have to save the transaction in the system To save a transaction select Save from the Actions menu in the Application tool bar or click save icon The system will update the transaction as an unauthorized transaction The user ID of the teller who entered the transaction and the date and time at which the transaction was saved will be displayed at the bott
38. ansactions e You can retrieve information relating to transactions in the form of reports Account Statements You can maintain the format of account statements to suit your requirements You can generate the account statement at regular intervals or when required The account statements that you provide your customer will contain details of all the transactions involving the account You can choose to view an account statement without actually printing it to provide your customer with transaction details for an account Opting to Track Denominations involved in Transactions You can opt to track the denominations involved in cash transactions If you choose to enforce denomination tracking tellers also have to specify the denominations involved at the time of entering cash transactions and transferring cash between tills and vaults Retrieving Information 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 This information may be generated in the form of reports oe ORACLE A report is information retrieved mostly in a printed format However you can direct a report to one of the following destinations e The printer e The screen as a display e A spool file stored as a spool file to be printed later The reports that you have spooled can be printed or viewed through the Reports Browser screen The fol
39. 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 v2 ORACLE GLRPCCY in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button EN Currency Position Report Turnovers Branch Consolidation Consolidate ES History Report Past Period Financial Year FY2011 Period Code M01 Kai Report Format DE e Pinter At Client e Report Output Print v Printer 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 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 The Report contains the following details in the summary view e Currency e Total position of the Currency specified The Report contains the following details in the detailed view e ID e Teller ID e Currency e Total Position of the Currency e Currency position of a specified Till SS ORACLE 10 Function ID Glossary D DEDTILPO geet steen 4 5 DEDACSTA coccc
40. ations are referred to as Beginning of day Teller operations Please refer the chapter Beginning and End of Day operations for details Entering Teller Transactions Now that you have opened a batch and a till with sufficient cash in it you can begin teller operations for the day Typically the transactions that a teller can perform are e Cash Deposits e Cash Withdrawals e Sale of Traveller s cheques e Purchase of Traveller s cheques e Cheque clearance The procedure to input teller type transactions is explained below Si ORACLE 6 2 1 You can enter a teller type transaction in the Teller Transaction Input screen You can invoke this screen by typing DEDTLRON in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Retail Teller Contracts New amp Enter Query Product Batch Number Reference No Additional Text Related Reference WET Tax Accounting Entries Advices Transaction Branch Instrument Number Transaction Account Clearing Bank Code Description Value Date Transaction Account Type Cheque Type Normal Transaction Currency Exchange Rate Transaction Amount Exchange Rate Local Currency Equivalent Transfer Type Related Customer Transfer Description Offset Amount Offset Branch Offset User Offset Account Description Offset Account Type Offset Currency Offset Amount Signature Verification MIS ICCF Tax Batch Summary UD
41. ault maintenance Mention the currency specific minimum amount that can be either dispensed by or deposited into the dispenser This will be the lowest denomination available in the dispenser for the specific currency Specifying Additional Information You can capture additional information that you would like to use either for your convenience or to suit the requirements of your bank Adding to its flexibility Oracle FLEXCUBE now provides the option to add fields based on your specifications to meet your needs Based on your requirement and the nature of the field you can specify default values and validations for the field Oracle FLEXCUBE will validate all entries made to the field against the validations you define for a field Click Fields button to maintain the additional fields Refer the User Defined Fields chapter in the Modularity User Manual for details Closing a Till Vault You may close a Till Vault that you are not using In the Teller Till Vault Maintenance screen select Close from the Actions menu in the Application tool bar or click close icon The system ensures that the Till is not in use and that the balance in the Till is zero To reopen a closed Till Vault select Reopen from the Actions menu in the Application tool bar or click reopen icon The system ensures that the Parent Vault and all Cash GLs linked to the Till are open Defining Till Currency Limits You can define currency
42. be displayed in this field Entering Denominations If your bank has opted for denomination tracking the system will prompt you to input denominations when you enter the transaction You can enter the denominations in the Denominations Input screen that is displayed on clicking D button If the Till GL is involved in both legs of the transaction for example FCY sale you have to input denominations for both the transaction and the offset amounts Viewing Charges and Tax details The taxes and charges defined for the product default to the transaction You can view the tax and charge details that apply on a transaction In the Teller Transaction Input screen choose the Charge Tax tab The taxes and charges that apply to the transaction will be displayed GR ORACLE You can change the tax charge amount calculated for the transaction To change the charge tax amount displayed click the Tax button in this screen Retail Teller Contracts EX New Enter Query Product Batch Number Reference No Additional Text Related Reference Main REX Accounting Entries Advices Basis Amount Charges Tax Account Transaction Account Total Charges Offset Account Total Tax Net Amount Signature Verification MIS ICCF Tax BatchSummary UDF ClearingDetails Messages Maker Date Time Status Checker Date Time Authorization Status While processing a transaction you should indicate the
43. ber of days Check this box to indicate this preference Back Value Days You can specify the number of days to which a transaction posted by a teller can be back valued dated in Oracle FLEXCUBE If the teller specifies a date that does not fall within the back value days limit measured in calendar days i e this period is inclusive of holidays maintained here the system displays the following error message as The value date is earlier than the Permitted value days e If the message is configured as an error you will not be able to proceed with the transaction till you specify a date which is within the limits maintained e If the override is configured as a warning you will be able to proceed with entering the transaction but an override is logged into the database that the date specified does not fall within the limits maintained e If itis configured as a ignore message then no back valuation check will be performed The same validations are carried out for transactions that are uploaded from external systems Note If you have enabled this preference as a Branch Parameter it will be defaulted to this screen You will not be allowed to change it However if you have not maintained it as a preference for your branch you can specify the details here If the option is checked but you have not maintained the Back Value Days maintained as NULL the system will in terpret it to be Zero days allowed f
44. can use it Please note that you cannot reopen a batch that is in use Deleting Batch If you want to delete all the transactions that you posted to a batch you can opt to delete the batch You can delete a batch under the following conditions e if you are original user of the batch e if all transactions posted to the batch are yet to be authorized e ifthe batch is not in use currently How to delete a batch Open the Batch Browser screen Navigate to the batch that you want to delete Choose delete icon on the Toolbar or choose Delete from the Actions menu All the transactions posted to the batch will be deleted Remember that you can only delete a batch if all the transactions posted to the batch are unauthorized Sh ORACLE 6 7 3 6 8 Teller Till Balancing At the end of the day when you complete all operations that involve the till you must balance it If you do not balance a till you cannot proceed with the end of day operations To balance a till is to ensure that the cash that is left in the till is the right amount In other words Till balancing involves checking the physical balance in the Till actual balance against the balance in the Till according to the system Refer the chapter Beginning and end of day operations in this User Manual for further details Entering Journal Transactions What is a Journal transaction Simple voucher entries such as interest adjustments payments
45. cccccccccccccccccccce 8 DEDTLRON niisiis 6 2 DEDBATOT cccccccccceccccceeeee 8 4 DEDTVSET oaiiiaooooooonnoanneea 3 5 DEDBRCON 3 2 DEDUPLOG ee ceeeceeeeeee 9 DEDBTASN n s iisiiiiiniieeee 8 3 DEDUPLPR sessesseeeseses 8 10 DEDBTAUT ccccccccccccceceeeee 4 2 DERBATOT oaaioaoooonnonnnnnneena 9 1 DEDBTRES 8 5 DESBTULK eee 8 4 DEDCSHMV ccccccccccecceeeee 7 1 DESJNLON 6 34 DEDENMX issssssii111eeeean 7 2 DESINLPR os eessseeeeteeesnees 3 12 DEDIJNLON det 6 30 DESPRMNT eee 5 16 DEDUNLPR onosi 3 11 DESTLRON nsssssssnirirrensn 6 17 DEDJRMLT cceeeeee 6 24 G DEDJRONL onoiiisionnnnnsnnnaene 6 20 DEPARA k 5 1 GLRPCCY aaaasnniosnisosnennsena 9 3 DEDTEMPL cccceee 3 9 o DE EE Sen easety E DEE 3 10 DED TILOR niaiiiosnooinnnnnnnnna 4 3 10 1 ORACLE
46. ch button once you enter the Template Code the system will display the following details e Serial Number e Debit Credit indicator e Account e Transaction code Branch Code Specify the branch code The branch code specified needs to be validated against the Allowed Disallowed lists maintained in the branch restrictions screen oa ORACLE Fund Id Select the fund id from the adjoining option list The system defaults the value of Default Mudarabah Fund as fund id Serial No The system displays the serial number User Reference No The system displays the reference number for the journal transaction Dr Cr The system displays the debit or credit indicator based on the account class GL for the selected template code However you can indicate if template code is not specified Acc or GL The system displays the account number selected in the Template However you can specify the account number GL The adjoining option list displays all valid account numbers GLs available in the system You can select the appropriate one Amount Enter the amount to be debited or credited Ex Rate For the foreign currencies entered the system displays the mid rate by default based on the value date entered However you can modify it The tolerance will be validated Amount LCY The system displays LCY equivalent amount Instrument Number In case the transaction is through an instrument you need to specify the i
47. cific to the Data Entry module It is therefore maintained in the Data Entry module You can maintain static data specific to the Data Entry module in three different screens e Data Entry Branch Conditions screen e Till Vault Dispenser Maintenance screen e Clearing Bank Code Maintenance screen The procedure to invoke and maintain the tables is explained below Maintaining Data Entry Branch Conditions The mandatory operations and the default parameters that you can define for your branch are referred to as Branch Conditions For example you can establish operational controls in your branch such as e Enforce rekey of important values of a transaction at the time of authorization e Set default parameters for your branch such as enforcing the input of currency denominations for teller transactions e Defining an exchange rate variance explained below for your branch which will apply to journal and multi offset transactions The advantages The Rekey at authorization facility is a cross checking mechanism which has been provided in Oracle FLEXCUBE By rekeying the values of a transaction the authorizer can ensure that a transaction is error free For example you have debited a sum of 100 USD from a customer account The account number of the customer is USDUS100003D The Value Date of the transaction is 20 12 99 ORACLE 3 2 1 3 2 2 By doing so the authorizer can ensure that the transaction is error free
48. circumstances you may want to remove a transaction from the system In Oracle FLEXCUBE you have the option of deleting a multi offset transaction When can a transaction be deleted If a transaction that you have input has not been authorized you can delete it Remember that only the user who input a transaction can delete it SE ORACLE How to delete a transaction When you are in the Multi offset Input Form select Delete from the Actions menu in the Application tool bar or click delete icon The transaction that is displayed in the screen will be deleted All accounting entries passed for the transaction will be removed 6 10 Maintaining Journal Entry Online Details You can invoke the Journal Entry Input screen by typing DEDJNLON in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Once you invoke the Journal Entry Input screen click on New option in the Application tool bar to invoke Batch Open screen Batch Open Batch Number Description Check Total Debit Balancing Credit Last Operated By Last Authorized By Date Time Date Time In this screen you can enter the following details Batch Number Specify the batch number Description Enter a brief description about batch Check Total Debit Enter the total debit amount of the journal transaction Credit Enter the total credit amount of the journal transac
49. click on a record to view the detailed screen SZ ORACLE 6 6 6 7 6 7 1 6 7 2 Closing Batch Once you complete operations for the day you can close the batch that you opened before commencing teller operations You cannot post further transactions to a batch that is closed You have to reopen a closed batch to post transactions You can close a batch when you e complete operations for the day e complete operations of a particular type eg entering journal transactions and proceed to other operations eg selling travelers cheques Normally you can close a batch by choosing the close icon in the Toolbar However in case of a General Protection Fault you can close a batch using the Batch Closure screen Please refer to the chapter Beginning and end of day operations in this User Manual for further details Other Operations on Batch You can perform the following operations on a batch e Reopening a batch e Deleting a batch Reopening Batch The following example illustrates the concept of reopening a batch How to reopen a batch When in the Batch Opening screen click on reopen icon on the Toolbar or choose Reopen in the Actions Menu to reopen a closed batch When you attempt to reopen a batch the system ensures that you are the user who originally opened the batch You cannot reopen a batch that was opened by another user The System Administrator has to reassign the batch to you before you
50. credits can be maintained in the Journal Entry Template Definition screen You can invoke this screen by typing DEDJNLPR in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Journal Template Maintenance EX New amp Enter Query Template Code Description 1 Of 1 SerialNumber Dr Cr Account GL Number Currency Customer No Branch Code Debit Maker Date Time Checker Date Time Mod No Record Status Authorization Status In this screen you can enter the following details Template Code Enter a unique journal template code Description Enter a brief description about journal template SI No By default the system generates the serial number starting from 1 Dr Cr You can indicate whether the amounts entered in the online screen is debited or credited by selecting one of the option given below e Debit on ORACLE 3 6 e Credit Account GL Number Specify the account GL number for which the template is defined The adjoining option list displays all valid accounts and internal leaf GL codes available in the system You can select the appropriate one Transaction code Specify the transaction code for the entry The adjoining option list displays all valid transaction codes available in the system You can select the appropriate one Additional text Specify the narration for the entire transa
51. ct The following are the preferences you can define e Whether certain important details relating to the transaction need to be rekeyed by the authorizer of the transaction The details could be any of the following transaction account offset account value date transaction amount instrument number transaction currency e Whether the charges that you want to levy are to be collected by default from the transaction account offset amount Others e Whether the default offset currency is the transaction currency or the a ORACLE local currency e Whether bank codes of other banks should be entered in case of cheque transactions e You can specify the Maximum and Minimum Transaction amount in the local currency e The percentage of the Maximum and Minimum Exchange Rate Variance e The Exchange Rate Type e You can opt to verify the signature of the customer involved in a transaction exceeding a specified amount These preferences will apply to all transactions involving the product In the Data Entry Product Definition screen click Preferences to invoke the Product Preferences screen Product Preferences Product Code Transaction Authorization Rekey Required Transfer Type Yes No Rekey Transaction Account Rekey Transaction Amount Rekey Offset Account Rekey Value Date Rekey Instrument Number Rekey Transaction Currency
52. cted class and display them in this screen However you can change the preferences for a product Branch Restrictions Indicate whether you want to create a list of allowed branches or disallowed branches by selecting one of the following options e Allowed e Disallowed G ORACLE Currency Restrictions Indicate whether you want to create a list of allowed currencies or disallowed currencies by selecting one of the following options e Allowed e Disallowed Branch Code Depending on whether you have opted to create an Allowed or Disallowed list you can specify the branches to be included in the list Branch Code Specify the branch code that should be included in the Allowed or Disallowed list The adjoining option list displays all valid branch codes maintained in the system You can select the appropriate one Branch Description Based on the branch code the system displays a brief description of the branch You can maintain multiple branches in the list Currency Restrictions Depending on whether you have opted to create an Allowed or Disallowed list you can specify the currencies to be included in the list Currency Code Specify the currency code that should be included in the Allowed or Disallowed list The adjoining option list displays all valid currency codes maintained in the system You can select the appropriate one Currency Description Based on th
53. ction Viewing Journal Template Summary You can view the summary of all journal templates created using the Journal Template Maintenance screen You can invoke this screen by typing DESJNLPR in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button You can search based on the Template code authorization status and Record status Journal Template Maintenance C advanced Search Reset Authorization Status Record Status Template Code S Description Records per page 15 v Authorization Status Record Status Template Code Description In the above screen you can base your queries on any or all of the following parameters and fetch records e Authorization Status e Record Status e Template Code e Description Select any or all of the above parameters for a query and click Search button The records meeting the selected criteria are displayed System displays the following details pertaining to the fetched records e Authorization Status e Record Status e Template Code e Description SC ORACLE 3 13 ORACLE 4 1 4 2 4 2 1 4 Beginning and End of Day Operations Introduction Tellers or the Customer Service Representatives of your branch can perform three types of input operations in Oracle FLEXCUBE They can enter e Teller type transactions e Journal type transactions e Multiple Offset Entry transact
54. currency are different then the system converts the amount financed to limit currency and checks if the same is in excess of the product transaction limit and user input limit If this holds true the system indicates the same with below override error messages e Number of levels required for authorizing the transaction e Transaction amount is in excess of the input limit of the user Transfer Type Specify the transfer type The adjoining option list displays all valid transfer types maintained in the system You can select the appropriate one Transfer Type Description The system displays a brief description of the chosen transaction type Offset Account Branch Based on the offset account the system displays the branch in which the account resides SS ORACLE Offset Account The offset account that you defined for the product which you selected in the Product Code field will be displayed by default in this screen Invariably this would be an internal account of the bank On occasion this could be a customer account If the offset account is a customer account you will have to manually enter the account number in this field Remember that if the offset account is a customer account as in the case of customer to customer transfers you have to manually enter the offset account number in this field If you click the adjoining option list a list of the GLs that are maintained in your branch will be displayed Double cl
55. current branch You can delete or authorize the batches based on your requirement Select the record records that you wish to delete or authorize by checking the adjoining box Further click the delete button or authorize button for respective actions 8 4 2 Unlocking Journal Batches While entering a transaction through Journal Single and Multi Offset entries if you have not checked the option Batch Close the system locks the batches in You can unlock such locked journal batches using Journal Batch Unlock screen To invoke the screen type DEDBATUK in the field at the top right corner of the Application Browser and click the adjoining arrow button Journal Batch Unlock E New amp Enter Query Batch Number Last Operator Id Description Batch Type 1 Of 1 Unlock Batch Batch Number Last Operator Id Description Batch Type 54 ORACLE 8 4 3 You can search for the records based on batch number and or operator The system fetches the records based on the search criteria Select the batches that you wish to unlock and click Batch Unlock button The system unlocks the selected batches Reserving Journal Batches You can reserve journal batches for DE Macro upload purpose excel upload for a specific branch and source combination To invoke Journal Batch Reservation screen type DEDBARES in the field at the top right corner of the Application Browser and c
56. d also find information on setting up accounting roles and heads accounting entries and advices for events as well as the branch currency and customer restrictions e Interest e Charges and Fees e Tax e User Defined Fields Product Code Specify a unique code to identify the product Product Description Specify a brief description for the product Slogan Specify a slogan that should be used for the product Type The first attribute that you define for a product is its type You can broadly classify products into two types in the Data Entry module of Oracle FLEXCUBE Cash and Others For example you have created a product for USD traveller s cheques called TravelUS Assume you would like to offer this product only to customers who have an account with you and will accept payments only in cheques When you create TravelUS you would indicate the product type as Others If on the other hand you choose to offer the product TravelUS to anyone for a cash payment you would define the product type as cash Under each product type you can create any number of products Data Entry Product Type Specify the Data Entry product type to which the product belongs The adjoining option list displays all valid Data Entry product types maintained in the system You can select the appropriate one Description A brief description of the chosen Data Entry product type is displayed here Clearing Product Code Specify the Clea
57. displays all valid branch codes maintained in the system You can select the appropriate one Click Query button The system displays the following details for all tills in the branch e Balance Indicator e Till Identification e Teller e Currency Code e Current balance e Minimum Balance e Maximum Balance Viewing Denomination Details You can view denomination details for tills by checking the box alongside a record and clicking the Denomination Details button Till Position Branch Code Current Balance Till ld Minimum Balance Teller Maximum Balance Currency Code 1 Of 1 Denomination Code Description Denomination Value Available Units You can view the following details e Branch Code e Till Identification e Currency Code e Teller e Current Balance e Minimum Balance e Maximum Balance e Denomination Code e Description e Denomination Value e Available Units 4 6 ORACLE 4 6 End of Day Cash Dispenser Validations As part of the End of Transaction Input the dispenser log s credibility will be checked against the cash dispenser position and an error will be raised if the two do not match The cash dispenser daily log will be archived in the archive table and cleaned as a part of EOD processing An EOD batch will post accounting entries for the cash GL s during online transactions This batch will read the journal entries which gets logged o
58. ducts is highlighted in this chapter Chapter 6 Miscellaneous Transactions explains transactions pertaining to cash trans Chapter 7 fer and denomination exchange Data Entry Control Operations details the data entry control operations for Chapter ue Data Entry module Reports provides a list of reports that can be generated in this module and Chapter9 iso explains their contents Function ID Glossary has alphabetical listing of Function Screen ID s used Chapter 10 in the module with page references for quick navigation Related Documents e Procedures User Manual e Settlements User Manual e Products User Manual e Charges and Fees User Manual e Tax User Manual e Settlements User Manual e User Defined Fields User Manual Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function K Exit Add row Delete row a Option List Ve ORACLE 2 1 2 An Overview of Data Entry Module Introduction The Data Entry module is a sub system of Oracle FLEXCUBE This module is designed primarily for the use of the tellers in your bank Typically the different operations that a teller performs in the course of the day are the e Disbursement and receipt of cash e Processing of checks for clearing e Sale and purchase of travelers checks e Transfer of cash between accounts e Passing adjustment entri
59. e Units Out Exchanging Denominations A customer may approach your bank to exchange currency denomination That person may or may not be an actual bank customer with a valid CIF or customer account He or she may give you two notes of USD 50 each and ask for 10 notes of USD 10 each This transaction involves only denomination exchange from your till The total value in the till will remain the same Hence there won t be any accounting entries for this exchange However the denomination count in the till will change and hence it needs to be updated You can capture such a transaction through the Denomination Exchange screen You can invoke this screen by typing DEDENMx in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Denomination Exchange E New amp Enter Query External Reference Branch Code Transaction Currency Denomination Details 1 Of 1 Currency Denomination Code In Out Denomination Val e Here you can capture the following details External Reference Number The system generates a unique number to identify the transaction Branch Code The system displays the current logged in branch code We ORACLE Transaction Currency Specify the currency in which your customer wishes to exchange denominations The adjoining option list displays all the currency codes maintained in the system Choose the approp
60. e currency code the system displays a brief description of the currency You can maintain multiple currencies in the list SZ ORACLE Specifying Customer Restrictions Click Customer button to invoke the Customer Restrictions screen In this screen you can specify the categories of customers or the customers themselves with whom you can enter into bills involving the product Customer Restrictions Product Code Product Description Class Details Default From Class Class Code Class Description Branch restriction Categories List Disallowed Allowed Customers 1 Of 1 e Description Customer Id Customer Name Restric Disalk Specify the following details Product Code and Description The system displays the product code and description Class Details You can link a class code to the product Class Code Specify the class code that you want to link to the product The adjoining option list displays all valid class codes maintained in the system You can select the appropriate one Class Description The system displays a brief description of the chosen class Click Default from Class button The system will then pick up all preferences maintained for the selected class and display them in this screen However you can change the preferences for a product Restriction Type Indicate whether you want to create a list of allowed customers o
61. e the Exchange rate that is displayed in this field Only the changed value should be within a certain range referred to as the Exchange Rate Variance The exchange rate variance is specified at the product level Note In case you are entering a Foreign Currency back value dated transaction the system will pick up the exchange rate applicable on the Value Date This is possible only if you have maintained the Exchange Rate History for your branch refer the Branch Conditions screen The system will display an override message in the following cases If you change the exchange rate to a value beyond the normal and maximum exchange rate variance range If you change the exchange rate to a value that is greater than the specified maxi mum exchange rate variance Local Currency Exchange Rate This field is enabled only if you check the IB in LCY option in the Transaction Code Maintenance screen for the transaction code mentioned in the accounting entry setup for that leg where transaction type is Fcy1 Fcy1 The exchange rate you specify here Teller Entry Form screen would then be used to calculate the local currency equivalent of the foreign currency transaction The default value would be standard mid rate Local Currency Equivalent The system displays the offset amount here in case the transaction involves the local currency If the transaction that you are entering involves a foreign currency the system calculates a
62. ebit transactions Once you have captured all the details save the maintenance If an invalid account is specified in the upload process the respective Suspense GLs maintained for that external system will be debited or credited based on the nature of the transaction SH ORACLE 9 1 9 2 9 Reports Introduction The following are the reports that you can generate in Data Entry module e Batch Totals report e Currency Position report 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 Batch Totals Report 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 e Batch No e Batch description e LCY Debit e LCY Credit e The Difference between the Debit and Credit e User ID e Batch Type This report can be generated at any time of the day using the Batch Totals screen You can also invoke this screen b
63. ee 6 18 G72 Doing BUO Se nie ai EE E TETE O Aa ae 6 18 6 7 3 Teller Till Balanting 02 ccceecccccccesteccccecnneacectecnnacnecenenbasaeedeeneasedenbennasedenene 6 19 6 8 Entering Journal Transactions cceeececceeeeeeeeeeeenneeeeeeenaeeeeeeecaeeeeeseenaeeeeeeenaes 6 19 6 8 1 Saving and Authorising Transachon 6 22 D Bath Eegeregie 6 23 6 8 3 Deleting Journal Transachon 6 23 6 9 Entering Multi offset Transactions ccceseeeeeeeeeeeeeeeeenaeeeeeeeenaeeeeeeeenaeeeeeeeeaas 6 23 6 9 1 Entering a Multi offset Transachon 6 24 6 9 2 Entering Details Of Main en 6 25 6 9 3 Entering Details of the Offset Leg of the Transachon 6 28 6 9 4 Deleting TranSactiOn e erse erna EE E E E E 6 29 6 10 Maintaining Journal Entry Online Details 6 30 6 10 1 Batch Summary DGutton ccc cette eet t tect eee tnne eee eetaaeeeeeetaaeeeeettnaeeeeeniaa 6 33 6 10 2 E 6 33 6 11 Viewing Journal Entry Input Summary 000 0 cece eee eeetceeeeeeeaeeeeeeeeaeeeeeeenaaes 6 34 7 Miscellaneous Transactions ccccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeseeneeeeeeees 7 1 CM nu eeler Le 7 1 T2 Transferring Cash cc cctce ciscleceeciaccccie ei i AA A A 7 1 7 3 Exchanging Denominations seaessssseesesernnesinrrnesinnnnansnnnnnnstenaaeastanaaaannnnaaannannaaanna 7 2 8 Data Entry Control Operations ssssssssssssnnnnnnunnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 8 1 St OTUSO oaia a EE E E AN EE A EEE EAE 8 1 32 Batch AMONI O E 8 1 8 2 1
64. een authorized Deleting a transaction When you are in the Teller Transaction Input choose Delete from the Actions menu or click delete icon on the Toolbar The transaction that is displayed in the screen will be deleted All accounting entries passed for the transaction will be removed The Advises specified at the product level will be suppressed if they have not already been printed Note that the Charges and Tax components for the transaction will also be deleted In case a Wrong Check Total has been Entered In case the actual debit and credit totals that you post to the batch do not match your entry in the Check Total field in the Batch Opening screen you cannot close the teller entry form or close the batch If you are unable to close a batch check the transactions that have been posted to the batch and correct those that have been erroneously entered or missed out Changing the Check Total On occasion you may not be able to close a batch because you entered an erroneous Check Total while opening the batch In such a case you can correct the check total in the Batch Summary screen To correct the check total invoke the Batch Summary screen from the Teller Transaction Input screen In the Check Total field in this screen you can enter the correct debit and credit check totals for the batch The total of the debit and credit entries that you have posted in the batch will be displayed in the Entry Total
65. efaulted However you cannot type in a Template ID in the Template Identification field Current Number Every such transaction that you enter into the batch is assigned a current number by the system This helps you to identify the multi offset transactions that you enter for the day On selection of the template the following details get defaulted to the transaction In the MAIN tab 1 The Account Number for the main leg of the transaction and the associated description 2 The currency and amount of the transaction The debit credit indicator for the same 3 The transaction code associated with the main entry and the offset entry of the transaction 4 Additional remarks if any In the OFFSET tab 5 The branch codes and the accounts for the offset leg of the transaction 6 The amount for each account You can process a multi offset transaction without a template also This is explained in detail in the following sections of this manual Entering Details of Main Leg Click on Main to enter the details of the main leg of the transaction Account Select the account or the GL of the main leg of the transaction from the adjoining option list Amount In this field enter the amount of the transaction The amount that you enter here must be in the currency of the account number that you specified On saving the transaction after entering all the required details in the system the system validates the value of the
66. em identifies all records satisfying the specified criteria and displays the following details for each one of them e Authorization Status e Record Status e Product Code e Product Description e Product Group e Data Entry Product Type e Start Date e End Date Double click on a record to view the detailed screen 2 ORACLE 6 1 6 1 1 6 2 6 Data Entry Operations Introduction Broadly speaking teller functions would include entering e Teller type transactions e Journal type transactions e Multiple Offset Entry transactions e Multiple accounts Dr Cr transactions The sale and purchase of travelers checks foreign currency transactions and cash deposits and withdrawals are examples of Teller transactions Journal transactions are typically used to post adjustment entries passed to internal accounts If a transaction involves one debit entry and multiple credit entries or one credit entry and multiple debit entries it may be referred to as a multi offset entry transaction The following is an example of a multi offset transaction Beginning of Day Teller Operations Before you start your regular teller operations for the day such as cash deposit cash withdrawal etc you have to perform two preliminary operations You have to e Open tills and vaults e Move cash into vaults through teller transaction input e Move cash between the vault s and tills through the cash movement function These oper
67. er basic information relating to a teller product such as the Product Code the Description etc Teller Product Definition Detailed E New amp Enter Query Product Code Product Description Slogan Type Cash Others Data Entry Product Type Description Clearing Product Code Role to Head Class Product Group Description Start Date End Date Remarks Accounting Roles Events Branch Currency Customer Preferences MIS Charges Tax Fields Maker Date Time Checker Date Time Mod No Record Status Authorization Status For any product you create in Oracle FLEXCUBE you can define generic attributes such as branch currency and customer restrictions interest details tax details etc by clicking on the appropriate button in the horizontal array of buttons in this screen For a teller product in addition to these generic attributes you can specifically define other attributes These attributes are discussed in detail in this chapter a ORACLE You can define the attributes specific to a teller product in the Data Entry Product Definition Main screen and the Data Entry Product Preferences screen In these screens you can specify the product type and set the product preferences respectively For further information on the generic attributes that you can define for a product please refer the following Oracle FLEXCUBE User Manuals under Modularity e Product Definition In the Products manual you woul
68. es For the sake of convenience these operations are classified in the Data Entry module of Oracle FLEXCUBE as e Teller type transactions e Journal entries e Multiple offset entry transactions The sale and purchase of traveler s checks foreign currency transactions check transactions and cash deposits and withdrawals are examples of teller transactions These are transactions that are typically processed across the teller counter When a transaction involves one debit entry and multiple credit entries or vice versa it is referred to as a multi offset entry transaction Examples of such transactions could be the posting of entries for clearing transactions where you credit your customers accounts for incoming checks and debit the clearing account Classifying teller operations in such a manner helps your teller easily access the appropriate input screen required to perform an operation Each screen in turn is streamlined to capture only the data peculiar to the operation For example if a teller has to debit an account and credit several other accounts for salary purposes she can access the multi offset transaction input screen and enter only the required data Similarly for a cash withdrawal transaction the appropriate screen is easily accessed and only data specific to the transaction captured Organizing Transactions into Batches Batches help you organize information and therefore simplify teller operations In a
69. following details Amount The transaction amount specified in the Main tab is displayed here Total Charges The sum of all charges applicable as per the linked product is displayed here Total Tax The system computes the tax applicable on the transaction amount and displays it here Net Amount The net transaction amount post deduction of applicable charges and tax is displayed here Charges Tax Collection Account Indicate the account from which you would like to collect the tax Typically this would be the account that you have designated as the Transaction Account You may also choose the Offset Account Click the Tax or Charge button to specify the collection account oF ORACLE 6 2 3 Viewing Accounting Entries You can view the accounting entries generated by the transaction that you are processing by clicking on the A c Entries tab in the Teller Transaction Input screen Retail Teller Contracts E New amp Enter Query Product Batch Number Reference No Additional Text Related Reference Account Branch Account Number Transaction Code Account Currency Foreign Currency Amount Local Currency Amount Debit Credit Value E E See Posted Entries Contract Overrides 10f1 Signature Verification MIS ICCF Tax Batch Summary UDF Clearing Details Messages Maker Date Time Status Checke
70. generation of batch numbers enter a number for the batch in the Batch Number field You can enter a number between 1 and 9999 If the Batch Number that you have specified is not already in use you can use the batch to post the transactions that you will enter during the day At the description field you may enter a description for the batch Every time you reopen view delete or authorize the batch the description will be displayed An entry in the Check Total field is not mandatory If the total debit and the total credit generated by the transactions fo be posted in a batch is known upfront you can enter the values in LCY in the Check Total field In case the actual debit and credit totals posted to the batch do not match the entries in this field you cannot leave the Teller Entry Form In sucha case check the transactions that have been entered and correct those that have been erroneously entered or missed out on 2 ORACLE 4 2 3 4 2 4 4 3 In case you entered a wrong check total in this field you can change it in the Batch Summary screen Click on Batch in the Teller Entry Form The Batch Summary screen will be displayed Entry Total Enter any value as the debit and credit total Reopening batch You can reopen a batch that you opened earlier To reopen a batch select Reopen from the Actions menu in the Application tool bar or click reopen icon When you reopen a batch the system ensure
71. hich you want to link the Till Parent Vault Parent Vault is a vault being maintained in the same function having the type as Vault All tills and only tills must be linked to any vault And in currency preferences for the till only currency maintained for the parent vault can be maintained Shortage Overage General Ledger You should specify the Shortage Overage GL for every Till that you create This GL is used in Teller transactions for posting the difference between the actual transaction amount and the amount of denominations available E ORACLE 3 3 2 1 3 3 3 3 3 4 3 3 5 Allow cash transfer between branch Check this box to indicate that you can perform cash transfer to another branch from this vault Specifying Currency Preferences Currency preferences are mandatory for all till Vault Dispenser for corporate teller It is not mandatory for retail teller If the type is Vault and if the Vault is being used as a parent vault for another till then the same currencies have to be maintained in the child till also This is applicable only to corporate teller Based on the type of Till Vault Dispenser the parameters are maintained for the currencies Minimum and maximum balance validations are applicable to corporate teller However that validation is not applicable for retail teller Specifying the Minimum Dispensable amount This will be applicable only for Dispenser maintenance and not for Till or V
72. ication tool bar and clicking the adjoining arrow button Batch Authorization EN New Enter Query Batch Number Batch Type Description Entry Total Debit Credit Description Last Auth By Date Time Date Time e Summary Authorization of a batch with limits e Summary Authorization of a batch without limits The Batch authorization screen can be invoked from the Application Browser Summary Authorization of a batch with limits It is possible to define authorization limits for a user with authorization rights Refer the SMS Manual If such a limit has been defined for you you cannot authorize transactions which cross the limit That is if the transaction amount exceeds the limit specified you will not be allowed to authorize the transaction A user whose authorization limits have been defined can perform a summary authorization of a batch If the transaction size of any transaction posted to the batch exceeds the authorization limit defined for the authorizer it will not be authorized When the summary authorization of the batch is complete the number of transactions that were authorized and the number of transactions that were not authorized those that crossed the authorization limit will be displayed Summary Authorization of a batch without limits If no authorization limits have been specified for you you can authorize transactions of any size If a user with an unspecified authorization limits does a summary authori
73. ick on the GL that you want to specify as the offset account Description A brief description of the offset account is displayed here Offset Account Type Indicate whether the account should be debited or credited Offset Currency The currency of the transaction that you are entering will be displayed in this field The system will display the transaction currency or the local currency as per your setup for the product the transaction involves You can change the value that is displayed if required To change the currency that is displayed click the adjoining option list A list of the currencies that you have allowed for the product the transaction involves will be displayed Double click on the currency that you want to specify as the Offset Currency Offset Amount The transaction amount will be displayed in this field in the offset currency If your branch has opted for denomination tracking the system will prompt you to enter the denominations for the offset amount of the transaction The Denominations Input screen will be displayed Instrument No You have to enter the instrument number here if the transaction code of either leg of the transaction specifies an instrument number If the Cheque Required box is checked at the product level input to this field will be mandatory Bank Code If the cheque is drawn on another bank you can enter the Bank Code if maintained of the clearing bank Value Date The Value Date is
74. ing C Credit Debit Check MIS Required C Ignore Overrides Currency Details 10f1 Currency Debit Credit Account Statistics ELC ale Checker Id Maker Date Stamp Checker Date Stamp You can capture the following details on this screen Source Code Select the source code from the adjoining option list Branch Specify the branch code Batch Number Specify the batch number Batch Description Provide description for the batch code specified Debit Total Specify the debit total Number of Debits Specify the number of debits Credit Total Specify the credit total Number of Credits Specify the number of credits ee ORACLE 8 4 4 1 Difference Specify the difference Variance Specify the variance Positioning Required Check this box if positioning is required Credit Debit Check Check this box to check debit credit Balancing You can indicate whether the entries being uploaded should be balance at the branch level If you have enabled this option and if the batch does not balance a message is displayed at the end of the upload session MIS Required Check this box if MIS is required Ignore Overrides Check this box to ignore override Currency Details Currency Specify the currency Debit Specify the debit amount Credit Specify the credit amount Difference Specify the difference amount in local currency Oracle FLEXCUBE supports batch up
75. ing option list Financial Cycle The period code is further divided into financial cycles For example your bank s Board of Directors meet once a month therefore you would divide the financial cycle into monthly periods When you input a journal transaction indicate the financial cycle to which the transaction belongs Instrument Number In case you are entering a check transaction you have to enter the instrument number here if the transaction code specifies an instrument number Additional Text Enter any other additional information related to the transaction Local currency Amount The system displays the transaction amount in case the transaction is in the local currency If the transaction that you are entering involves a foreign currency the system calculates a local currency equivalent of the transaction amount using the Exchange rate that is displayed in the previous field 6 21 ORACLE 6 8 1 Value Date The system will display the current system date here You can however enter a back dated or a future dated transaction In Oracle FLEXCUBE the interest is calculated on the basis of the Value Date Exchange Rate In case the currency of the transaction is a foreign currency the system displays the standard mid rate for the currency You can change the Exchange rate that is displayed in this field Only the changed value should be within a certain range referred to as the Exchange Rate Variance The exch
76. ions Cash transactions and trade in travelers checks are typical teller type transactions Simple voucher entries such as interest adjustments payments made by the bank towards taxes internal book entries of the bank etc are examples of Journal transactions If a transaction involves one debit entry and multiple credit entries or one credit entry and multiple debit entries it is referred to as a multi offset transaction The following is an example of a multi offset transaction For example Cavillieri and Barrett Finance Corporation has an account with your bank They have instructed you to debit their account with you and credit their employees salary accounts on the last day of every month When you carry out these instructions at the end of the month you would be entering a multi offset transaction However before you can commence teller operations you must perform two functions You must open a batch and a Till These operations may be referred to as Beginning of Day operations Batch Operations In a manual accounting system you may maintain the details of transactions in a register For easy retrieval you may write down all transactions belonging to one type on a page For example you may write details of all Teller transactions on one page loan transactions on another page and so on In Oracle FLEXCUBE this is achieved by grouping transactions in batches Each batch corresponds to a page The
77. isor would perform e Batch authorization e Unlocking a batch e Reassigning a batch to another user etc e Batch upload Batch Authorization Authorization is a cross checking mechanism that Oracle FLEXCUBE offers The transactions that tellers enter during the day must be authorized by the Data Entry Supervisor at the end of day This ensures that all the transactions that have been entered by tellers conform to the parameters that have been defined for your branch Authorizing Batches At the Beginning of Day each teller opens a batch to post a particular type of transaction A teller who enters three different types of transactions will open as many batches Instead of authorizing individual transactions that have been entered during the day you can authorize the batches into which they have been posted This is called summary authorization Summary Authorization of a batch At the End of Day authorizing every transaction could be a tedious process You can instead do what is called a Summary Authorization of the batch into which the transactions have been posted Only users other than the one who posted transactions the Data Entry supervisor for example into a batch can authorize the transactions in the batch Summary Authorization is possible in two ways S1 ORACLE You can invoke the Journal Batch Authorization screen by typing DEDBTHAUVU in the field at the top right corner of the Appl
78. ith this code These codes are used by the system to process and sort cheques bank wise Maintaining Codes for other Banks You can invoke the Clearing Bank Code Maintenance screen from the Application Browser To maintain a new Bank Code click new icon in Application Toolbar The Clearing Bank Code Maintenance screen will be displayed with no values in the fields Specify a unique code for the bank in the Bank Code field In the Description field you can enter the name of the bank to which you are assigning the code and its location Maintaining Templates for Multi Offset Transactions If a transaction involves one debit entry and multiple credit entries or one credit entry and multiple debit entries it may be referred to as a multi offset entry transaction In other words a multi offset transaction is one in which multiple accounting entries are passed to the offset accounts to balance a single entry You can maintain templates that can be used for processing multi offset transactions The attributes of the templates will be defaulted to the transaction thereby minimizing the time and effort required to process such transactions SC ORACLE 3 4 2 1 You can invoke the Journal Multi Offset Template Maintenance screen by typing DEDMJTMT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Journal Multi Offset Template Maintenance E New E3 Ente
79. lick the adjoining arrow button Journal Batch Reservation Maintenance E New E3 Enter Query Branch Code Source Code Batch Restriction Detail 1 Of 1 Batch Number Maker Date Time Checker Date Time Mod No Record Status Authorization Status Here you can capture the follwoing details Branch Code Specify the branch code for which you wish to apply the restriction Source Code Specify the source code The system will apply this restriction to the branch source combination maintained here Batch Number This is the batch identification number Remarks This field captures the remarks about the branch You can add more rows to the restriction list by clicking add button Once you save the maintenance the system considers these batches as reserved You cannot input transactions through Single or Multi Offset Entry These batches can be used for DE Excel Upload transactions only ORACLE 8 4 4 Maintaining Journal Batch Upload You can upload journal batches into Oracle FLEXCUBE using Journal Batch Upload screen To invoke the screen type DEDUPONL in the field at the top right corner of the application toolbar and click the adjoining arrow button Journal Batch Upload E New amp Enter Query Source Code Branch Batch Number Batch Description Debit Total Number of Debits Credit Total Number of Credits Difference Variance M Positioning Required Balanc
80. load of DE save operations For this you need to first maintain a job GIUPLOAD using Job Maintenance screen You can schedule your batch upload in Journal Batch Upload screen The system will consider the records for upload based on the value of the parameter IS UPLOAD_SCHEDULED If the value is Y then the system will consider the record for upload as part of the job The parameter IS UPLOAD SCHEDULED determines whether an upload is scheduled or not If the value of the parameter is set to Y then it indicates that an upload is scheduled As part of the job the system will pick up all records that are scheduled for upload and start the process Viewing Account Statistics You can view the status of each record in Journal Batch Upload Account Statistics screen Click Account Statistics button on Journal Batch Upload screen to view this screen You can a ORACLE also invoke this screen by typing DEDACGTA in the field at the top right corner of the application toolbar and clicking the adjoining arrow button Account Statistics E gt Execute Query Batch Number Source Code es Branch Code Upload Status Unprocessed D Total Entries Uploaded Entries 1 0f1 CurrentNumber Overrides Branch Account Currency Code Amount Debit Credit MIS Group Value Date Financial Year Period Code This screen shows the status of all the records up
81. loaded for a specific batch branch and source combination You can search for the details based on the following parameters e Batch number e Branch code e Source code e Upload status Once you have specified the search parameters click Execute Query button The system displays the following details e Total number of entries in the results e Number of uploaded entries in the result e Current number e Whether there are any overrides e Branch e Account e Currency code e Amount e Whether debit or credit e MIS group e Value date e Financial year e Period code ORACLE To view the upload logs for a selected entry click Upload Logs button You can also invoke this screen by typing DEDUPLOG in the field at the top right corner of the application toolbar and by clicking the adjoining arrow button Journal Batch Upload Logs ES Execute Query Source Code Batch Number Branch Code Current Number 1 Of 1 F SerialNumber Error Error Type Error Message op In this screen the system displays the upload logs for the selected record You can search for the journal batch upload logs based on the following parameters e Source code e Branch code e Batch number e Current number Once you have specified the search criteria click Execute Query button The system displays the following details in the log e Serial number e Error e Error type e Error message 8
82. lowing are the reports specific to teller operations that you can generate e Batch totals e Currency positions e Till Vault positions e Teller transactions for the day e Exchange of denominations e Cash transactions for the day e Till liquidation e Till closing report e Till balancing exceptions SS ORACLE 3 1 3 2 3 Maintaining Data Specific to Data Entry Module Introduction Before you begin operations in the Data Entry module of Oracle FLEXCUBE you must maintain certain basic information in the system For example you must maintain the following e Branch specific parameters you can opt to enforce denomination tracking e Till Vault Cash Dispenser details of your branch e Bank codes for other banks This data is maintained first since it is required to create your teller products enter teller transactions and so on In other words this is the foundation on which you build the superstructure Products to which you can link transactions Maintaining Static Data Static data which is maintained in Oracle FLEXCUBE can be either common to several modules or specific to a module For example data relating to exchange rates is common to modules like Foreign Exchange and Money Market Static Data that is commonly accessed by several modules is maintained centrally Data that is specific to a module is maintained in the module itself For example data relating to Tills Vaults and Cash Dispensers is spe
83. made by the bank towards taxes internal book entries of the bank etc can be entered into the system as journal transactions In a journal transaction only one accounting entry is passed either a debit or a credit The difference between a journal and a teller transaction A journal type transaction is different from a teller type transaction in that it generates only one account entry The offset entry is not generated as in the case of Teller transactions Note Before you can enter journal transactions for the day you must open a batch to post these transactions Now that you have opened a batch you are ready to input a journal transaction In the Journal Entry screen you can enter the following details of the journal transaction that you want to enter Sh ORACLE You can invoke the Journal Single Entry Input screen by typing DEDTRONL in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Journal Single Entry Input Ep New Enter Query Batch Number Description Current Number Fund ld Account Branch Account Number Description Currency Local Currency Amount Amount Value Date DebitiCredit Indicator Debit Exchange Rate Transaction Code Period Code Related Customer Financial Cycle MIS Group Instrument Number Additional Text Total Debit Batch Close Total Credit MIS Signature
84. manual accounting system you may maintain the details of transactions in a register For easy retrieval you may write down all transactions belonging to one type on a page For example you may write details of all Teller transactions on one page loan transactions on another page and so on In Oracle FLEXCUBE this is achieved by grouping transactions as batches Each batch corresponds to a page in the register The accounting entries that are generated by transactions of a particular type are grouped under a batch For example a teller could choose to post the multi offset transactions entered during the day into a batch all cash withdrawals into another and so on This facilitates quick retrieval of information and easy balancing of books S ORACLE 2 2 2 2 1 2 2 2 2 2 3 Grouping transactions into batches also helps you to authorize transactions in batches In Oracle FLEXCUBE all operations performed by a user should be authorized by another user with the requisite rights At the end of day you do not have to authorize transactions individually If you print the transaction journal for the batch you can authorize transactions in batches Cross checking Mechanisms The Data Entry module of Oracle FLEXCUBE is designed not only to simplify but also to ensure the accuracy of the operations that a teller performs There are a host of cross checking mechanisms that you can opt to ensure the accuracy of the
85. mary Click Batch Summary button and invoke the Batch Summary screen You can view the cheque and entry total pertaining to the batch Batch Summary Batch Number Description Check Total Entered Total Debit Debit Credit Last Operator Id Last Operated By Credit Last Auth Id Last Authorized By ORACLE You can view the following details here e Batch No e Description e Check Total Debit and Credit e Last Oper By e Last Operated By e Entry Total Debit and Credit e Last Auth By e Last Authorised By 6 2 10 Capturing UDF Details Click UDF button and invoke the Fields screen to specify values for user defined fields a Field Name Value Description Value Description Here you can capture the following details Field Name The system displays all UDFs linked to the product Value Specify a value for each UDF Ble ORACLE 6 2 11 Specifying Clearing Details Click Clearing Details button and invoke the Clearing Details screen to view clearing details for the transaction Clearing Details Clearing Details Related Reference Beneficiary Id Beneficiary Account Remittance Name Reason Code Remittance Address Offset User Resident Status Resident Non Resident Remittance Details Beneficiary Details Beneficiary Address 1 Beneficiary Address 2 Payment Details You can view the following details e Remitt
86. n list displays a list of unauthorized batches that are opened for the day Choose the batch that you want reassign in the batch number field Reassign Identification Choose the User Id of the teller to whom you want reassign the batch in the Reassign ID field The system ensures that the batch is not currently in use If you choose to reassign the batch to yourself the system will seek an override Entry Total Total Entries indicates the total amount debited and credited for a particular batch Click Ok button to confirm the reassign operation If you do not want to continue with the reassign operation choose Exit or Cancel button to exit the function Processing Journal Batch Using Oracle FLEXCUBE you can view unlock reserve journal batches and set your preferences with regard to journal upload ae ORACLE 8 4 1 Viewing Journal Batches You can search and view all journal batches using Journal Batch Browser screen To invoke the screen type DEDBTTOT in the field at the top right corner of the Application Browser and click the adjoining arrow button Journal Batch Browser E New E3 Enter Query Batch Number Last Operator Id Authorization Status Authorized v Batch Browser 1 Of 1 Batch Number Batch Type Operator Authorizer Local Currency Debit Local Currency Credit This screen displays all the batches that have been created in the
87. ned the Back Value Days maintained as NULL the system will interpret it to be Zero days allowed for back valued transactions This Functionality will be available for your branch only if the Denomination Track ing Required functionality is not enabled for your branch Maintaining Teller Till Vault Dispenser Details Both Tills and Vaults are cash repositories Tills are cash boxes that tellers use All Tills are linked to the one Safe or Vault in the bank Sometimes however a bank may choose to maintain several Vaults a Vault for every currency for example Details to be Maintained For each till or vault that you create in your branch you have to define the following e A unique ID for the till vault e The currency details e The vault to which the till is linked e The shortage overage GL e The minimum and the maximum balance for tills Maintaining Details You can maintain Till or Vault details in the Till ault Maintenance screen In the Till Vault Dispenser Maintenance screen click new icon in the Application tool bar You can invoke the Till amp Vault Parameter Maintenance screen by typing DEDTVSET in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button ORACLE The Till amp Vault Parameter Maintenance screen will be displayed with no values in the fields Specify a unique Till Vault ID for the Till Vault
88. nline for every transaction and process the accounting entries for the cash GL s for the cash dispenser functions like Partial Load Partial Unload Empty Dispenser Give Change Notes Counting Give Alarm Deposit and Withdrawal Transactions Apart from processing accounting entries this batch job will update the cash till and dispenser balances Sa ORACLE 5 1 5 Defining Attributes of Teller Product Introduction As a bank you will offer your customers a variety of financial services For example you may deal in traveller s cheques offer loans accept short and long term deposits and so on Each of these services can be further classified Take for example travellers cheques You can e buy traveller s cheques in the local currency e sell traveller s cheques in the local currency e buy travellers cheques in USD e sell traveller s cheques in USD e buy travellers cheques in GBP e sell traveller s cheques in GBP etc You can make a product of each of these traveller s cheques that you deal in In this chapter we shall discuss the manner in which you can define attributes specific to a Teller product You can create a Teller product in the Teller Product Definition Detailed screen invoked from the Application Browser You can invoke this screen by typing DEDPRMNT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button In this screen you can ent
89. nstrument Number e Rekey Transaction Currency Default Charge Collection Account You can indicate if the charges are to be collected by default from the transaction account or the offset account involved in the transaction Click on the button adjacent to the account which you would like to debit for the charge Default Offset Currency In this field you can specify the offset currency for transactions involving the product The offset currency can either be the local currency or the transaction currency Click on the button adjacent to Txn Ccy if you would like to specify that as the offset currency for transactions involving the product Or click on LCY to indicate if the offset currency is the local currency Bank Code Required You can maintain a list of banks that participate in your clearing house refer the branch conditions table Maintaining a list of such banks helps you track and clear cheques bank wise at the End of Day You can indicate if the Bank Code should be entered when a teller enters a cheque transaction for the product Online Authorization Required Oracle FLEXCUBE gives you the option of authorizing teller transactions as and when you process them While saving the details of a teller transaction the system displays the Choose Authorizer screen through which you can choose the User ID of the person who has the required authorization rights After you select the ID of the user who is to authorize
90. nstrument number Customer Specify the customer The adjoining option list displays all valid customer ids and names available in the system You can select the appropriate one Total Debit Amount The system displays the net debit amount Total Credit Amount The system displays the net credit amount Additional text The system displays the narration from the Template However you can modify it SS ORACLE 6 10 1 6 10 2 Batch Summary Button Click Batch Summary button on Journal Entry input screen to invoke the Batch summary screen Batch Summary Batch Number Check Total Debit Credit MIS Description Entered Total Click MIS button on Journal Entry input screen to invoke MIS screen In this screen you can maintain the MIS value for a transaction screen and functionality similar to single entry and multi offset entry L mis Contract Reference Transaction MIS MIS Group Input Link To Group Related Reference Related Account Rate At Rate Type sl Pool Code Contract Level MIS Group Related Account Related Reference MIS Head Interest Method Refinance Rate Pool Code Composite MIS MIS Group 6 33 C Link To Group Rate Code Spread X Cost Code 1 Cost Code 2 Cost Code 3 Cost Code 4 Cost Code 5 Fund MIS MIS Group ORACLE 6 11 Viewing Journal Entry Input Summary You can view the summary of all journ
91. ntroductions ii i ci eege Oe EE eine eee 4 1 4 2 Ee RI te E 4 1 4 2 1 Purpose of BatCh vincent hn ni tees da enh 4 1 42 2 Opening Batch E 4 2 42 3 Y Reopening Deich 2 2ceuESEEEEEEEAEE EEEEEEEEEEEEEEEEEEEEEEEEEEEEEER KEES EES 4 3 42 4 Deleting Baies ee Saat all ee ee e 4 3 Aa QCpening Ties scsi issencess lace r a E sidadeheeeiladelecetsaddaacteanad 4 3 AAs Balancing ER UE 4 4 db Marking Till Posio gedet adie ddd hd eid eee 4 5 4 5 1 Viewing Denomination Details 4 6 4 6 End of Day Cash Dispenser Validations 0 ceccceececeeeeeeeeeneeeeeeeteeeeeetnaeeeeereas 4 7 Defining Attributes of Teller Product ccccceeeeeeeeeeeeeeeeeeeeeeeeneeeeeneees 5 1 Sills IMtrOGUCHION eos t5 cee aie eases eis ad Patera akc teaes gases don dundee eecaeecars 5 1 5 1 1 Capturing Accounting Roles ecccccccceteeeeceentne eee eeenteeeteeenaaeeeeeeeiaeeeeeeeeaaes 5 3 d Speciying Eemer seer ress sbesiias edd 5 4 5 1 3 Indicating Branch Currency Restrictions ccccccceieeceeeenteeeeeeeeneeeeeeeaaes 5 6 5 1 4 Specifying Customer esirictons 5 8 9 1 5 Indicating Preferences for a Product 5 9 5 1 6 Specifying MIS Details 5 14 5 1 7 Specifying Charge Details srets isea isiiiei i anii iaria lakai iias eiki deiai 5 14 5 1 8 Specifying Tax Details m orsenenssrensesriiitinseri nrag reri ane i EEE E 5 15 5 1 9 Capturing User Defined Fields cccecccccceetteeeceeennneeeeceenaeeeeeeenaaeteeeneaaas 5 15 5 2 Viewing Product Summa
92. ntry Module cc ceseeeeeeeeeeees 3 1 Sel ue Le EE 3 1 3 1 1 Maintaining Static Data 3 1 3 2 Maintaining Data Entry Branch Conditions 0 eee eeeeeeeeeeeeeeeeeeeeeeeeneeeeeeeeeaaeees 3 1 3 2 1 Branch Conditions that can be Defined 0 cece tere ee tnneeeeeettnteeeeteeee 3 2 3 2 2 Defining Branch CGondtons cece eneeee eee enne eee ee tienes eetaaeeeeeeenaaeeeenees 3 2 3 2 3 Opting for Denomination Trackiog 3 4 3 3 Maintaining Teller Till Vault Dispenser Details 2 0 0 0 eee eeeeeeeeeeeeeeeeeneeeeeeteeaeeees 3 5 3 3 1 Details to be Maintained myser reee eera AEAEE N AOS 3 5 3 3 2 Maintaining Detallls erisir E ARRO 3 5 3 3 3 Specifying Additional Information occ ecectetttteeteeeetnneeeeeeetneeeeeeetnaeeeeeteas 3 7 33 4 Closing a RA 3 7 3 3 5 Defining Till Currency Lmts eee ceeeete eee eeeeeeeeeteeeeaeeeeseeaaaeeeetneaaanees 3 7 at Maintaining Bank CodeS eeren a see cei E E E 3 8 3 4 1 Maintaining Codes for other Banks ccccccccseeeeeceeteneeeeeetnneeeeeeetnneeeeettae 3 8 3 4 2 Maintaining Templates for Multi Offset Transactions 000sisseeeeneneeea 3 8 3 4 3 Specifying Details for the Offset Leg of Transachons 3 10 3 5 Maintaining Multiple accounts Dr Cr Transactions ccccceeeeeeeeeeeeeeeeeeteeeeeeeeaes 3 11 3 6 Viewing Journal Template Gummarm cece eeeeeee eee eeennaeeeeeeeaaeeeeeeeeneeeeesenaaes 3 12 Beginning and End of Day Operations cccceeetetetceeeeeeeeeeeeeeeeeeeeneneees 4 1 SET I
93. om the exchange rate In other words you can specify the Normal Exchange Rate Variance for a product Maximum Rate Variance In this field you can specify the maximum percentage difference of the special rate from the default rate In other words you can specify the Maximum Exchange Rate Variance for a product Note When you enter a transaction the system will not seek an override if the Exchange Rate Variance is lower than the Normal Exchange Rate Variance that you have specified in the Minimum Exchange Rate Variance field If the Exchange Rate Variance is between the Minimum and the Maximum Exchange Rate Variance that you have defined the system will display an override message The system will not store a transaction if the Exchange ol ORACLE Rate Variance is more than the Maximum Exchange Rate Variance defined for the prod uct Minimum Amount for Signature Verification Specify the minimum amount on exceeding which a transaction should mandate signature verification Exchange Rate Select the type of exchange rate to be applied for transactions under this product from the adjoining drop down list e Buy Rate e Sell Rate e Standard Mid Rate Back Value Details You can post back value dated transactions in Oracle FLEXCUBE Back Value Check Required For the purpose of risk tracking you can indicate that users should be prevented from posting a back value dated transaction in the system beyond a certain num
94. om of the screen To authorize an account click Authorize icon on the Application toolbar Note You cannot authorise a transaction from the Journal Single Entry Input screen in the fol lowing cases the contract has multilevel of authorization pending the same will be done using the Multilevel Authorization Detailed screen the level of authorization is greater than or equal to N SS ORACLE 6 8 2 6 8 3 6 9 the Nth or the final level of the users authorisation limit is less than the difference between amount financed and sum of the limits of all the users involved in authorizing a transaction this case holds good when the Cumulative field is checked in the Product Transaction Limits Maintenance screen the transaction amount is greater than the authoriser s authorisation limit if the Cu mulative field is unchecked in the Product Transaction Limits Maintenance screen Batch Close You can validate a batch to check whether it is balanced or not using Batch Close button The system unlocks the batch further to the validation While creating a new batch if you have checked the option Balancing in Batch Open screen you need to balance the transaction in order to exit the batch Save the transaction and click Batch Close button If the transaction is balanced the system will process and unlock the batch If the transaction
95. on Cash Transfer E New amp Enter Query Reference Number To TillVault From Till Vault To Teller From Teller Currency Amount Shaw Denomination 10f1 Denomination Code Value Opening Units Units In Units Out S a Maker Date Time Mod Number Checker Date Time Authorization Status Open Specify the following details Reference Number This is system generated reference number for the transaction From Till Vault Specify the till or vault from which you want to transfer cash The adjoining option list displays all valid tills and vaults maintained in the system You can select the appropriate one To Till Vault Specify the till or vault to which you want to transfer cash The adjoining option list displays all valid tills and vaults maintained in the system You can select the appropriate one From Teller The system displays the user ID of the teller who opened the From Till Vault To Teller The system displays the user ID of the teller who opened the To Till Vault We ORACLE 7 3 Currency Select the currency to be transferred from the Till Vault The adjoining option list displays all valid currency codes maintained in the system You can select the appropriate one Amount Specify the amount to be transferred Click Show Denom button to view the following denomination details e Denom Code e Value e Opening Units e Units In
96. option list displays a list of valid currencies Double click the currency that is the transaction currency Debit Credit You must indicate if the amount is to be credited to the account or debited from the account To do this you must click either of the buttons adjacent to this field If the amount is to be credited to the account click the button against Cr If the amount is to be debited click the button against Dr Value Date The system will display the current system date here You can however enter a back dated or a future dated transaction In Oracle FLEXCUBE the interest is calculated on the basis of the Value Date Overrides e Ifthe value date is back dated or future dated e If the value date is a holiday Batch Close While creating a new batch you need to check the option Balancing in Batch Open screen in order to balance the input transaction To exit the batch the transaction need to be mandatorily balanced When you click Batch Close button if the transaction is balanced the system processes the batch and unlocks it If you cancel the batch the batch gets locked in Batch Unlock screen However you can unlock it manually G27 ORACLE 6 9 3 6 9 3 1 Entering Details of the Offset Leg of the Transaction To enter details of the Offset leg of the transaction click Offset Journal Multi Offset Entry X Eye amp enter Query Batch Number Batch Description Current
97. or back valued transactions ORACLE 5 1 6 Specifying MIS Details Click MIS button to define Management Information Details MIS details for the product you are defining MIS Details Product Code MIS Group Pool Code Default From MIS Groun MIS Classes 10f1 Cost Code MIS Class MIS Code Refer the User Manual on MIS under Modularity for further details 5 1 7 Specifying Charge Details Click Charges button to define the charges or fees that are to be collected for transactions involving this product Charge Details Product Description Component Description Rule Description Event Description Rate Type Fixed Rate Code Currency Limits Details 1 Of 1 E Currency Default Rate Minimum Rate Amount Type Category Settlement Currency Code Usage Maximum Rate Normal X Accrual Required Main Component Stop Application S Allow Amendment Minimum Spread 5 14 ORACLE 5 1 9 Refer the User Manual on Charges and Fees under Modularity for further details Specifying Tax Details Click Tax button to indicate the tax schemes that are applicable to the product you are creating Tax Details Product Code Product Description Tax Scheme Scheme Description Default Fram Schame Tax Details 1 Of 1 Tax Rule Tax Component Basis Amount Tag Event Tax Type
98. r Date Time Authorization Status The following details are displayed here e Branch e Account Number e Transaction code e Currency e Foreign Currency Amount e Local Currency Amount e Debit Credit e Value Date e Exchange Rate See Position Entries Check this box to view currency position of the entries A list of all the system overrides displayed when the transaction was input can also be viewed es ORACLE 6 2 4 Suppressing Advices You can print the advices specified for the product the transaction involves You can view the advices specified for the product while processing a transaction by clicking on the Advices tab in the teller input screen Retail Teller Contracts E Hen amp Enter Query Product Batch Number Reference No Additional Text Related Reference Advices 1 0f1 Message Type Suppress Priority No D Low Signature Verification MIS ICCF Tax Batch Summary UDF Clearing Details Messages HI Date Time Status Checker Date Time Authorization Status Here you can opt to generate or suppress an advice that has been defined for the product the transaction involves You can also prioritize advice generation according to your convenience 6 2 5 Verifying Signature While booking the transaction you can verify the signature of the customer by invoking the Signatory Details screen To invoke this screen click Signature Verification
99. r Query Template Id Description W I Offset Currency Debit Credit Indicator Debit Account No Credit General Ledger Description Amount Additional Text Transaction Code Fields Maker Date Time Checker Date Time Mod No Record Status Authorization Status Specify the following details Specifying Details for the Main Leg of Transactions Specify the following details in this MAIN tab of the screen Template Identification and Description Specify a unique id to identify the template throughout the system You can also capture a brief description of the template being maintained Account Number and Description Select the account number and the description for the template All the account numbers that are maintained in the branch are available in the option list provided The entry passed to this account will represent the main leg of the multi offset transaction On selection of the account number the associated description is displayed in the next field Currency The currency of the account number that you have entered in case of a customer account is displayed here However you are allowed to maintain a different currency All the valid currencies in the branch are available in the option list provided You can select the appropriate currency from the list Amount In this field enter the amount of the transaction The amount that you enter here will be considered to be in the c
100. r disallowed customers by choosing one of the following options Allowed Disallowed oe ORACLE Category Specify the following details Code Specify the customer category code that should be included in the allowed or disallowed list The adjoining option list displays all customer category codes available in the system You can choose the appropriate one Description The system displays a brief description of the branch code You can choose multiple customer categories Customers You can exclude certain customers belonging to the allowed disallowed category from being part of the list Customer ID Specify the customer ID that you want to exclude from the allowed disallowed list The adjoining option list displays all customer identification number CIF available in the system You can choose the appropriate one Customer Name The system displays the name of the customer Restriction Type If you have maintained an allowed list choose the option Disallowed and vice versa Indicating Preferences for a Product When you create a product you can specify certain operational procedures that you would like Tellers and Data Entry Supervisors to follow when they enter or authorize transactions involving the product These specifications are referred to as Preferences for a product The preferences that can be specified In the Preferences screen you can define preferences for a produ
101. riate one Denomination Details This block allows you to capture exact details of the denominations being exchanged Currency Code Specify the currency in which the transaction is being performed You can select the appropriate code from the adjoining option list Denomination Code Specify the denomination of the currency used in the transaction For every currency the various denominations are assigned separate denomination codes These codes are displayed in the adjoining option list Choose the appropriate one Value The system computes the face value of the denomination and displays it For instance if the denomination code represents a USD 100 the value will be displayed as 100 Units Indicate the number of units of the specified denomination In Out Indicate whether you are disbursing the specified denominations or receiving the denominations The total amount against In should be equal to the amount against Out Denomination Value The system computes the denomination value by multiplying the denomination value with the number of units For instance if the denomination code represents a USD 100 and the number of units is 10 the denomination amount will be 1000 ES ORACLE 8 1 8 2 8 2 1 8 Data Entry Control Operations Introduction The Data Entry Supervisor of your branch performs certain operations during the day The following are the functions that the Data Entry Superv
102. riate one Transaction Account Typically you would have to manually enter the account number of the customer involved in the transaction in this field However if the transaction account is a GL you can click the adjoining option list to invoke a list of the GLs that have been maintained in your branch Double click on the GL that is the transaction account Note If you defined an Account Head the GL SL for a product while creating it it will default as the Transaction Account for a transaction involving the product Description The system displays a brief description of the account Transaction Account Type Indicate whether the account should be debited or credited Transaction currency The Transaction Currency by default is the local currency or the currency of the transaction account If you want to enter a transaction in any other currency click on the adjoining option list Choose a currency from the displayed list by double clicking on it Transaction Amount Enter the Transaction Amount The amount entered should be within the maximum and minimum transaction amount defined for the product The transaction size should not exceed the limit defined for the teller On saving the transaction after entering all the required details in the system the system validates the value of the transaction amount against the following e Product transaction limit e User Input limit If the transaction currency and the limit
103. ring product to which the product belongs The adjoining option list displays all valid Clearing product codes maintained in the system You can select the appropriate one RTH Class Specify the Role to Head Mapping class to which the product belongs The adjoining option list displays all valid Role to Head class codes maintained in the system You can select the appropriate one G ORACLE Product Group Specify the group to which the product belongs The adjoining option list displays all valid group codes maintained in the system You can select the appropriate one Description The system displays a description for the chosen product group Start Date Specify the date from which the product should come into effect using the adjoining calendar End Date Specify the date until which the product should be effective using the adjoining calendar Remarks You can specify remarks for the product Capturing Accounting Roles Click Accounting Roles button and invoke the following screen to define accounting roles for the product you are creating In this screen you can map accounting roles to accounting heads Accounting Roles Product Code Product Description Class Details Default Fram Class Class Code Class Description Roles 1 Of 1 Accounting Role Role Description Account Head GL Description Refer the Products User Manual under Modularity for further details a
104. rization functions Product Managers Product definition and authorization End of day operators Processing during end of day beginning of day Financial Controller Product Managers Generation of reports Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http Awww oracle com pls topic lookup ctx acc amp id docacc Organization This manual is organized into the following chapters About this Manual gives information on the intended audience It also lists Chapter 1 the various chapters covered in this User Manual An Overview of the Data Entry Module is a snapshot of the features that hapten the module provides Maintaining Data specific to the Data Entry Module gives information on Chapter 3 basic information that needs to be maintained in the system before begin ning operations in the DE module Beginning and End of Day Operations explains the beginning and end of Chapter 4 day operations for the data entry module Defining Attributes of a Teller Product explains the process of setting up a ehapices product t1 ORACLE Data Entry Operations described in this chapter is the procedure to pro cess all types of Data Entry Teller type and Multiple Off set entry transac tions Also explained is the method of associating a DE product with a DE contract The advantage of defining pro
105. ry sora rnrn ar EEE T E A TOEA 5 16 Data Entry EISE begeestert geet 6 1 Git ul Le EE 6 1 6 1 1 Beginning of Day Teller Operations assssiinneeininnneeeennneennnnneeernnnneeenennne 6 1 6 2 Entering Teller Transachons 6 1 6 2 1 Capturing Main Details ccccccecccceccetteeeeceennneeeeeeentaeeeeeesaeeeeeseeaeeeeeeenaas 6 2 6 2 2 Viewing Charges and Tax detailS cccccccccseceeeeceeenneeeeeeeenteeeeeeenaeeeeeeeaaas 6 6 6 2 3 Viewing ACCOUNTING ENKIICS evresi iiceirt r ari a E ETEA IO ECET EEEIEE E 6 8 6 2 4 Suppressing ACVICES ccccccccceecnennecaececeeeeeeetesceenaneaaeeeseeteeeseesneenenaneas 6 9 6 2 5 Verifying SIQNQtUre piresi nsiieiraor heana aa iaaa ea a aa aeiaai 6 9 6 2 6 Capturing MIS Deiais 6 10 6 2 7 Specifying Interest Details usssseeeesrrinerrrrnrrrnrrrnnnrrrrnnnrerrnerrrrnnnnrerrnne 6 10 6 2 8 Specifying Tax Details 6 11 6 2 9 Viewing Batch SUMMALY resite ninen TEE RE T ee EE e OSA EEEE 6 11 6 2 10 Capturing UDF Details 6 12 6 2 11 Specifying Clearing Details 6 13 6 2 12 Viewing MOSSAQOCS cc e ccccccuesscnctenenscenerecsnencadecubeonseneeennensenenenbenetnetsns 6 14 6 3 Saving and Authorising Transacthon 6 14 GZ transaction Delete ziessen ageet ste AER 6 16 6 4 1 In case a Wrong Check Total has been Entered 6 16 6 5 Viewing Transaction Summary 6 17 616 Closing Ne E 6 18 6 7 Other Operations on Batch trn ttnn nnn nn nanne nnt 6 18 OFT Reopening BIC r on e E O EE E ge eds
106. s that you are the user who originally opened the batch You cannot reopen a batch that has been opened by another user even if it is not in use The System Administrator has to reassign the batch to you before you can use it Deleting batch If you opt to delete a batch the system checks if the entries that have been passed into the batch were passed by you That is if you were the original user of the batch If not you cannot delete the batch The system also checks if the batch is in use If it is you cannot delete the batch You can delete a batch from the Batch Browser To delete a batch select Delete from the Actions menu in the Application tool bar or click delete icon Note When you delete a batch all unauthorized transactions in it will be deleted Opening Till For cash transactions the system ensures that you have opened a Till If you have not opened a Till type DEDTILOP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button The Open Teller Till screen will be displayed Till Open E New amp Enter Query Branch Code Till ld Narrative You can capture the following details ES ORACLE 4 4 Branch Code The system displays the current logged in branch code Till Identification Specify the till that should be opened The adjoining option list displays all valid tills available in the current logged in branch You
107. s will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services Contents LL 1 1 S Ware UL ET 1 1 N T 1 1 1 3 Documentation Accessibility 0 00 cece ee eecteeeeeeencneeeeeeeneeeeeeeaeeeeeseiaeeeeeeeaes 1 1 TA Organizatora aaa a ran AE Eei a EEE A O AERE A 1 1 TC Related DOCUMOMNIS orc neron nan a E ARA 1 2 1o Glossary or ICONS aerea an a E A A ENO 1 2 An Overview of Data Entry Module ssssssssssnnunnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 2 1 2i Introduction EE 2 1 2 1 1 Organizing Transactions into Poatches 2 1 2 2 Cross chechking Mechanisms serrin riannee IA En AAAA PERAIRE EATARRA E TARTTEE 2 2 2 2 1 Specifying an Exchange Rate Variance sseeessrseeeeeireeeerrrnnrrrnnnnreerennne 2 2 2 2 2 Enforcing Signature Verification eseessreereserrrrrerrennenrnnrreeerrnnrerennnrrerrnnnne 2 2 2 2 3 Indicating Values to be Rekeyed during Autbortzaton 2 2 2 2 4 Defining Transaction and Authorization Amount Limite 2 3 2 2 5 Online Authorization for Overdrafts seessesneeeeesnneeerenneeernnneeerrnnneeerennee 2 3 2 3 OtheriReatures S i a heel teh da ee aie al A 2 3 2 3 1 Account Statements E 2 3 2 3 2 Opting to Track Denominations involved in Transactions ccceee 2 3 2 4 Retrieving Information ccc ceeeeeeeeeeeeeeee eee ceeeaaeeeeeeeaaaeeeeeeeaeeeeeeeenaeeeeeeenaeeeeeeeaas 2 3 Maintaining Data Specific to Data E
108. saction Enforcing Signature Verification You can opt to enforce the verification of a customer s signature for transactions that exceed a limit that you specify The system will enforce verification of the customer s signature if the transaction amount exceeds the limit that you specify Indicating Values to be Rekeyed during Authorization All operations on a transaction input modification etc have to be authorized e By a user other than the one who carried out the operation e It should be done before you can begin the end of day operations To ensure that an authorizer is calling the correct transaction you can specify that certain transaction details should be entered before the other details are displayed For example you can specify that you would like the authorizer of a transaction to rekey values such as the ee ORACLE 2 2 4 2 2 5 2 3 2 3 1 2 3 2 2 4 transaction amount the transaction currency the transaction account and so on The complete details of the transaction will be displayed only after the authorizer enters these values This is called the re key option The fields for which the values have to be given are called the re key fields The details of a transaction will not be displayed for authorization even if the authorizer of the transaction enters them correctly if the teller had captured erroneous values while entering the transaction A transaction will be displayed for authoriza
109. system will update the transaction as an unauthorized transaction The user ID of the teller who entered the transaction and the date and time at which the transaction was saved will be displayed at the bottom of the screen The Validations The system performs the following Cross Validations during Transaction Input It ensures that e Al the mandatory fields have been input by the user e The transaction amount is within the allowed limit for the user e The exchange rate variance conforms to that defined at the branch level e The sum of the offset amounts is the same as the main amount Note You cannot authorise a transaction from the Journal Multi Offset Input screen in the fol lowing cases the contract has multilevel of authorization pending the same will be done using the Multilevel Authorization Detailed screen the level of authorization is greater than or equal to N the Nth or the final level of the users authorisation limit is less than the difference between amount financed and sum of the limits of all the users involved in authorizing a transaction this case holds good when the Cumulative field is checked in the Product Transaction Limits Maintenance screen the transaction amount is greater than the authoriser s authorisation limit if the Cu mulative field is unchecked in the Product Transaction Limits Maintenance screen Deleting Transaction In special
110. t will be reflected only after the netting batch The system will update the transaction as an unauthorized transaction The user ID of the teller who entered the transaction and the date and time at which the transaction was saved will be displayed at the bottom of the screen SR ORACLE Transaction Code Batch Number Value Date Current Number Account Input By Amount Override Text Authorized By Authorized Date To authorize a transaction select Authorize icon from the Actions menu On authorisation the transaction will be made available for the netting batch if logged for netting batch Refer the section Maintaining Netting Group in the chapter Accounts for Inter Branch Transactions in the Core Services User Manual for further details about netting Cross Validations The system performs the following cross validations when you input a transaction It ensures that e you have entered all the mandatory details in the appropriate fields e the product related restrictions are not violated e you have the Cash GL linked to the transaction currency and or offset currency in case of cash based products e the exchange rate variance conforms to that defined at the product level Validations for a transaction When you save a transaction the following validations will be carried out e Transaction amount is within the Minimum and the Maximum specified in the Branch conditions Table e Exchange rate conforms to the
111. the till has to be balanced The adjoining option list displays all valid currency codes maintained in the system You can select the appropriate one Cash Counted Specify the amount counted based on which till has to be balanced Cash Available The system displays the till balance Difference The system displays the difference between the system computed till balance cash available and the manual amount that has been counted cash counted Denomination Code Specify the denomination code based on which you have counted the balance in the till Denomination Value The system displays the value of the denomination based on the code Units Counted Specify the number of units counted per denomination Total Counted The system computes the total amount based on the units counted per denomination and displays the amount Marking Till Position You can query on till position through the Till Position screen You can invoke this screen by typing DEDTILPO in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Till Position EX New E3 Enter Query Branch Code 1 Of 1 Balanced Till ld Currency Code Current Balance Mi Denomination Here you can capture the following details SS ORACLE 4 5 1 Branch Code Specify the branch code based on which you want to query on till position The adjoining option list
112. tion Balancing Check this box to indicate whether the total debit amount and total credit amount has to be balanced SS ORACLE Once you specify the batch number in the Batch Open screen you can specify the transaction details in the Journal Entry input screen Journal Entry Online E Hem amp Enter Query Batch Number Reference No Record Template Code Value Date Current Number Currency Branch Code Fund Id 1 Of 1 SerialNo User RefNo DriCr Account Description AccorGL Currency Branch Code E Debit Total Dr Total Cr Batch Summary MIS Maker Authorized By Status ez Authorization Status Date Time Date Time In this screen you can enter the following details Batch Number The system displays the batch number for which the journal entry transaction is to be created Template code Specify the template code The adjoining option list displays all valid template codes available in the system You can select the appropriate one Value Date Specify the value date of the transaction By default the system displays current branch date value Currency The system displays the branch local currency here Reference Number The system will generate a unique reference number based on the batch number Current number The system displays the current number for which the journal entry transaction is to be created Click Fet
113. tion only if the values entered by the teller and the authorizer are identical If no re key fields have been defined the details of the transaction will be displayed when the authorizer calls the transaction for authorization Defining Transaction and Authorization Amount Limits You can define the transaction amount limits for the teller products that you create A teller cannot enter into a transaction that exceeds the limit defined for the product which it involves By defining transaction and authorization limits for tellers and supervisors you can control the teller transactions that are entered and authorized in your branch Online Authorization for Overdrafts You can define whether an online authorization is required when an account gets into overdraft When a teller inputs a transaction and the account goes into an overdraft the teller should have the transaction authorized by a supervisor The transaction cannot be saved without an authorization from the supervisor A transaction that results in an overdraft should be authorized by a third person subsequently In effect such a transaction will have to be authorized twice as against the mandatory authorization required for normal transactions Other Features The following are some of the other salient features of the Data Entry module e You can define the format of the account statements to suit your requirements e You can opt to track the denominations involved in tr
114. transaction amount against the following e Product transaction limit GER ORACLE e User Input limit If the transaction currency and the limit currency are different then the system converts the amount financed to limit currency and checks if the same is in excess of the product transaction limit and user input limit If this holds true the system indicates the same with below override error messages e Number of levels required for authorizing the transaction e Transaction amount is in excess of the input limit of the user Exchange Rate In case the currency of the transaction is a foreign currency the system displays the standard mid rate for the currency You can change the Exchange rate that is displayed in this field Only the changed value should be within a certain range referred to as the Exchange Rate Variance The exchange rate variance is specified at the Branch Level for Journal transactions Note In case you are entering a Foreign Currency back value dated transaction the system picks up the exchange rate applicable on the Value Date This is possible only if you have maintained the Exchange Rate History for your branch refer the Branch Conditions screen Overrides If you change the exchange rate to a value between the maximum and minimum exchange rate variance You cannot change the exchange rate to a value that is greater than the specified maximum exchange rate variance Instrument Number
115. uct Definition User Manual under Modularity for further details ORACLE Indicating Branch Currency Restrictions Click Branch Currency button and invoke the Branch Currency Restriction screen In this screen you have the option of allowing all the branches of your bank to use the product or restricting its use to only some branches By default when a new product is created no branches will be disallowed You can also specify the currencies allowed or restricted for the product This currency corresponds to the transaction currency By default when a new product is created no currencies will be disallowed Branch Currency Restriction Product Code Product Description Class Code Default From Class Class Description Branch Restrictions Disallowed Currency Restrictions Disallowed Allowed Allowed Branch Currency 1 Of 1 1 Of 1 E Branch Code Branch Name E Currency Code Currency Name A Specify the following details Product Code and Description The system displays the product code and description Class Code Specify the class code that you want to link to the product The adjoining option list displays all valid class codes maintained in the system You can select the appropriate one Class Description The system displays a brief description of the chosen class Click Default from Class button The system will then pick up all preferences maintained for the sele
116. urrency that you select in the previous field You must also indicate whether the amount is to be credited to the account or debited from the account To do this you must select either Dr or Cr depending on the nature of the entry GE ORACLE 3 4 2 2 3 4 3 3 4 3 1 Additional Text You can capture any additional remarks regarding the template in this field This is a free format text and is used only for information purposes Debit Credit Indicator Debit Credit Indicator defines if the template is being maintained for Debit or Credit In the Main Tab you can give an Account from that account if you mark as Debit the amount will be debited Under the Offset tab those are the accounts which you credit for this debit in main account Specifying Transaction Code A transaction code is used to identify the nature of the entries that are passed You can specify a transaction code for the main leg of the transaction as well as for the offset entry An option list consisting of all the valid transactions maintained in your branch is provided for each field Main and Offset You can select the appropriate transaction codes from this list Specifying Details for the Offset Leg of Transactions The details of the offset leg of the transaction are captured in the OFFSET tab of the screen Journal Multi Offset Template Maintenance ES New E3 Enter Query Template Id Description Offset Entries 1 Of 1
117. y typing DERBATO in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Batch Totals From Batch Number Batch Number Description To Batch Number Batch Number Description Report Format PDF Printer At Client Report Output Printer Si ORACLE 9 2 1 9 3 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 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 It holds the value of the Total Debit amount of a particular Debit Entries Total Batch It holds the value of the Total Credit amount of a particular Credit Entries Total Batch This is remaining balance after the debit and the credit trans Balance actions Gross Cr Totals This is the total credit balance Gross Dr Totals This is the total debit balance Report on Currency Positions of your Branch You can ascertain the position of a currency across the Tills Vaults that are maintained in your branch
118. y when the authorizer calls the transaction for authorization The re key option also serves as a means of ensuring the accuracy of inputs You can specify the values of Journal and Multi offset transactions that the authorizer should rekey in this screen Under Journal Entry on the top left corner and Multi Offset Entry top right corner you will find the following option Rekey Required Under this option you will see two buttons against Yes and No respectively Click on the button against Yes if you want the authorizer of journal transactions to rekey values Similarly click on the button against Yes if you want the authorizer of multi offset transactions to rekey important fields Click on the button against No in these fields if you do not want the authorizer to rekey values at the time of authorization Indicating Re Key and Multi Rekey Fields Under Journal Entry and Multi Offset Entry respectively you will see a list of re key fields Check against the fields that you want to be re keyed at the time of authorizing for Journal and Multi Offset entries The fields that can be re keyed for journal entries are e Value Date e Amount e Transaction Code e Account The fields that can be re keyed for multi offset entries are e Value Date e Main Transaction Code e Offset Transaction Code e Amount me ORACLE 3 2 2 3 3 2 2 4 3 2 2 5 3 2 3 3 2 3 1 Specifying Exchange Rate Variance You can
119. zation of a batch all the transactions in the batch will be authorized When the summary authorization of the batch is complete the number of entries that were authorized will be displayed To Authorized the transactions in a batch choose Jrnl Teller Batch Op in the Application Browser Click on Auth Without Limits The Batch Authorization screen will be displayed The date and the time at which the batch was authorized will be displayed in the bottom of the screen ZS ORACLE 8 3 8 3 1 8 4 Reassigning Batch To reassign a batch is to allow a teller who did not originally open a batch to use it The Data Entry Supervisor has the rights to reassign a batch to a teller who did not originally open a batch However only unauthorized batches can be reassigned You can invoke the Journal Batch Reassign screen by typing DEDBATRE in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Journal Batch Reassign E New amp Enter query Batch Number Reassign Id Entry Total Debit Credit Last Operator Details Last Authorizer Details Last Operated By Last Authorised By Date Time Date Time Reassigning Batch To reassign a batch to a different user click on Jrnl Teller Batch Op in the Application Browser Choose Reassign Batch displayed under it The Batch Reassign screen will be displayed Batch Number The adjoining optio

Data Entry User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents