Oracle FLEXCUBE Inventory User Manual Release 4.4.0.0.0 Part
Contents
1. Mandatory Drop Down Select the sell type to sell the inventory to MCA or CASA account or walk in customer from the drop down list The options are e Sellto MCA e None Conditional Numeric 20 Type the CASA multi currency account number The system displays the MCA name in the adjacent field This field is enabled if the Transaction Type is Sell of Inventory Conditional Alphanumeric 10 Type the valid stock code for the inventory being reported as lost The system displays the stock code description in the adjacent field If the stock code is not valid system will give error message This field is enabled and mandatory if the Transaction Type is Sell of Inventory Stock code is a manually generated unique number which enables the bank to track the inventory A stock code has to be unique in the system Conditional Alphanumeric 20 Type the inventory start number Inventory Start Number should exist in the inventory under the Stock Code Stock Series number combination TABOUT This field is enabled and mandatory if the Transaction Type is Sell of Inventory ORACLE Field Name Inventory End Number Quantity IV012 Sell of Inventory Description Conditional Alphanumeric 20 Type the inventory end number Inventory end number will be computed as Inventory Start Number Quantity 1 This field is enabled and mandatory if the Transaction Type is Sell of Inventory Displays2. If Denomination 100 and Quantity 20 Then Adjustment Total value 2000 Only stock or inventory items which are tracked denomination wise will have an Adjustment Total value Toggle Click the toggle status to change the value to Y if you want to delete the particular stock item from the list By default the system displays the value as N ORACLE IV001 Stock Transactions Receive Stocks Transaction Receive Stocks Purchase Order No Suzho Bisco HO Date of Receipt 30 04 2009 F dd Delete Sr No Requestid Stock catalog Code _ Denm Qtyrea Series Start End Total Confirm y n Delete y n a 20 0002 TC 100 100 1 100 10000 N N Input By Authorized By Last Mnt Date Last Mnt Action Authorized Field Description Field Name Description Purchase Order Mandatory Pick List No Select the purchase order number which is used to track the purchase order status from the pick list On receipt of the stock from supplier this purchase order number is used to indicate receipt Received From Mandatory Drop Down Select the supplier from whom the stock is received from the drop down list Inventory Branch Mandatory Drop Down Select the inventory branch that has placed the request for the stock from the drop down list Date of Receipt Mandatory Pick List dd mm yyyy Select the date of receipt from the pick li
3. Total Confirm y n Delete y n IV001 Stock Transactions Description Display This column displays the total based on the denomination and quantity specified Total Denomination Quantity For example If Denomination 100 and Quantity 20Then Total 2000 Only stock or inventory items tracked denomination wise will have an Adjustment Total value Toggle Click the toggle status to change the value to Y to confirm the physical receipt of either full or partial stock By default the system displays the value as N If the stock is received in partial the user will need to modify the quantity field to reflect the quantity actually received The stock level will not be updated at inventory till the confirmation flag is set to Y Toggle Click the toggle status to change the value to Y if you want to delete the particular stock item from the list By default the system displays the value as N ORACLE IV001 Stock Transactions Issue Stocks Transaction l I Tssue Stocks Request No Ee ed Issued To HO B Date of Issue 30 04 2009 ey eee ee 20 0002 TC 100 100 o 1 100 10000 N N _ Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Field Description Field Name Description Request No Mandatory Pick List Select the request number for which purchase order is placed
4. This field displays the quantity of the inventory to be sold If the inventory end number is entered then the system will compute the quantity and displays Quantity will be computed as Inventory End Number Inventory Start Number 1 This field will be displayed if the inventory start number and inventory end number is entered This field is disabled if the Transaction Type is Cancel Sell of Inventory 3 Select the transaction type from the drop down list The system enables the corresponding fields depending on the transaction type selected 4 Enter the user reference number 5 Select the sell type from the drop down list 6 Enter the required information in the various fields ORACLE Sell of Inventory Transaction Type Sell of Inventory s User Reference Number 111 Sell Type Sell to MCA MCA Number 210000170000076 UDAYHIREBET Stock Code 990 Other Bank Inventory Inventory Start Number 10020000000000000009 Inventory End Number 10020000000000000010 Quantity 2 IV012 Sell of Inventory 6 Click the Ok button The system displays the message Transaction completed successfully ORACLE IVM10 Multi Currency Package Stock Xref 1 7 IVM10 Multi Currency Package Stock Xref Using this option user can make the cross reference between multi currency package and stock code While issuing inventory to the MCA or account system will check that
5. from the pick list The pick list displays only those request numbers against which full orders or partial orders are placed Issued To Mandatory Drop Down Select the appropriate bank or branch for which the inventory bank had placed the request for stock from the drop down list Date of Issue Mandatory Pick List dd mm yyyy Select the date of issue from the pick list Column Name Description ORACLE IV001 Stock Transactions Column Name Description Srl No Display This column displays the system generated serial number for each stock item in the list Request id Display Stock catalog Code Denm Qty req Series Start End Total This column displays the request ID for each stock item in the list Display This column displays the stock catalogue code of the stock or the inventory item for which the request order is placed Display This column displays the denomination value of the requested stock Display This column displays the quantity of stocks In case of partial receipt for the stock request the user can modify the original values to reflect the received stock values The quantity can be reduced from the original requested but cannot be increased For example 50 units of banker s cheque It can be 50 leaves or booklets of banker s cheque Display This column displays the series number that has been defined for the particular stock code received Di
6. Trans Type Purchase Order Reference CJ paterrom pajz0 2009 To Branch j From Branch Stock Code Date To 04 10 2009 Current Balance of units Denomination Balance of units Field Description Column Name Description Stock Code Display This column displays the stock code Stock Name Display Branch Name User ID Issuer This column displays the stock name Display This column displays the branch code Display This column displays the ID of the user who has placed the request This column is displayed if Stock Transaction option is selected in the Stock Inquiry drop down list Display This column displays the issuer bank name ORACLE Column Name Currency Txn Date Req Date Req Type Req Flag Purchase ID Qty Recorder Level IV011 Stock Inquiries Description Display This column displays the currency in which the stock is issued Display This column displays the transaction date This column is displayed if the Stock Transactions option is selected from the Stock Inquiry drop down list Display This column displays the request date This column is displayed if the Indent Request Status option is selected from the Stock Inquiry drop down list Display This column displays the request type This column is displayed if the Indent Request Status option is selected from the
7. Date Last Mnt Action Authorized Field Description Field Name Description Action Details Action Mandatory Drop Down Select the action from the drop down list The options are e Register Lost Report e Lost Report of Lost Report Application Form ORACLE Field Name Loss Report Type IV004 Inventory Lost Report Registration Maintenance Description Conditional Drop down Select the loss report type for the lost report from the drop down list The options are e Temporary Loss e Inventory Loss e Password Loss e Inventory and Password Loss This field is enabled and mandatory when Register Lost Report is selected from Action drop down list Input Parameters Stock Code Inventory number Lost Report Register No Home Branch Mandatory Pick List Select the stock code for the inventory being reported as lost If the stock code is not valid system will give error message Stock code is a manually generated unique number which enables the bank to track the inventory Mandatory Numeric 20 Type the inventory number for the inventory being reported as lost If the inventory is not available under the stock code stock series number system will give error message If the lost report type is temporary lost report then the status of the inventory should either be Normal or Temporary Lost Optional Pick List Select the lost report register number from the pick list
8. PIN Maintenance 2 The system displays the Inventory PIN Maintenance screen Inventory PIN Maintenance a em oe oa oonan raoe ionov roven serene soere araar an ORACLE IV005 Inventory PIN Maintenance Field Description Field Name Description Search Criteria Search String Full Name Mandatory Drop Down Select the search criteria to search for the customer from the drop down list The options are e Customer short name e Customer IC Identification criteria IC e Customer ID Mandatory Alphanumeric 20 Type the search string corresponding to the search criteria selected This field list out all customers that were found to be matching the value entered in the search string corresponding to the option chosen in the search criteria If the search criterion is specified as customer s short name or IC then any of the letter s of the short name or IC can be entered The system displays the pick list of all those customers having those letters in their respective criteria Choose the appropriate customer from the existing customer list For example The customer s short name is George Abraham One can search the above customer by entering Geo in the search string field Display This field displays the customer ID of the selected customer A customer ID is an identification number generated by the system after customer addition is completed successfully T
9. Stock Inquiry drop down list Display This column displays the request flag type This column is displayed if the Indent Request Status or Stock Transactions option is selected from the Stock Inquiry drop down list Display This column displays the purchase ID This column is displayed if the Indent Request Status option is selected from the Stock Inquiry drop down list Display This column displays the quantity ordered Display This column displays the recorder level This column is displayed if the Balance on Hand option is selected from the Stock Inquiry drop down list 8 Double click a record to enable the Denomination Details tab ORACLE IV011 Stock Inquiries Denomination Details Stock Inquiry ance an Hia User ID Indent Request Reference Trans Type Purchase Order Reference asi tJ Date From 04 10 2009 To Branch mete From Branch il Stock Code Current Balance of units Denomination Balance of units Details Denomina Stock Details Purchase Details Field Description Column Name Description Denomination Display This column displays the denomination value in words Currency Short Display Name This column displays the currency code in which the denomination is made Denomination Display Value This column displays the denomination value in numbers Denomination Display Balance This c
10. The system generates this number when a new lost report is registered If the Action is Lost Report for Lost Report Application Form then this field is mandatory Display This field displays the home branch of the inventory issued Lost Report Details Received Channel Optional Drop Down Select the channel used for registering the lost report from the drop down list The options are e Branch ORACLE IV004 Inventory Lost Report Registration Maintenance Field Name Description Reporting Optional Pick List branch Select the branch code in which lost report is being registered if the reporting branch is not same as transaction branch from the pick list LR Register Display Date This field displays the lost report registration date This date will be the system process date LR Expiry Display Date This field displays the lost report expiry date LR Release Mandatory Pick List DD MM YYYY Term Date ar Select the lost report release term date from the pick list LR release term date is computed as system process date the number of days mentioned in the field Term For Release of LR LR release term date can be less than or greater than date computed by the system but can not be less than the system process date Telephone Optional Albhanumeric 30 no Type the telephone number used for registering the lost report Reason Optional Alphanumeric 120 Type the reason for the registering the lost
11. cross reference is maintained between the multi currency package and stock code If the cross reference is not maintained system will not allow to issue the inventory to the MCA opened under that multi currency package or issue an inventory to the account opened under the MCA which is linked to the multi currency package To allow inventory issuance facility should be made available in the product master as well there should exist the MCA package and stock code cross reference Note Multi currency account will be opened under multi currency package and account will be opened under MCA Definition Prerequisites e CHMO01 CASA Product Master Maintenance e TDMO01 TD Product Master e MCA01 Multi Currency Package Definition Modes Available Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add stock code details for cross reference 1 Type the fast path IVM10 and click Go or navigate through the menus to Global Definitions gt Master gt Multi Currency Package Stock Xref 2 The system displays the Multi Currency Package Stock Xref screen ORACLE IVM10 Multi Currency Package Stock Xref Multi Currency Package Stock Xref Field Description Field Name re ge Stock X OBE Multi Currency Package Details Multi Currency Package Code Description Module Corporat
12. from the pick list to view the stock status based on the purchase order reference The result for purchase order reference will show the supplier code the date of order placement in the Purchase Detail tab This field is enabled only if the Indent Request Status option is selected in the Stock Inquiry drop down list Optional Numeric 22 Type the number of inventory units that are currently available Optional Numeric 22 Type the number of denomination units that are available 3 Select the stock inquiries from the drop down list 4 The system enables the corresponding fields and tab depending on the stock inquiries selected 5 Enter the required information in the various fields ORACLE IV011 Stock Inquiries Stock Inquiries Stock Inquiry Sajance on Hand User ID v Indent Request Reference i Trans Type Purchase Order Reference m i manh amp Date From 04 10 2009 14 Toman Date To 04 10 2009 4 From Branch Stock Code CHQ v Current Balance of units Denomination Balance of units Denomination Details Stock Details Purchase Details 6 Click the Ok button 7 The system enables the Details tab ORACLE Details IV011 Stock Inquiries Stock Inquiry Branch User ID Indent Request Reference
13. report LR Register Display Status This field displays the status of the lost report Status of the LR can be e Open e Canceled e Released by Account Closure e Release by Reissue of Inventory 3 Click the Add button 4 The system displays the message This action will clear all data on the screen Do you want to continue Click the Yes button 5 Select the action and lost report type from the drop down list 6 Select the stock code from the pick list The system displays the LR register date LR expiry date and LR register status 7 Select the LR release term date from the pick list 8 Enter the other required information in the various fields ORACLE IV004 Inventory Lost Report Registration Maintenance Inventory Lost report Register maintenance Heer m Action Details Action Register Lost Report Eal Loss Report Type Temporary Loss _ E r Input Parameters Stock Code 738 Inventory No 0000000005 Lost Report Register No Home Branch m Lost Report Details Received Channel Branch v Reporting Branch a B PEE taal i 20 10 2011 LR Expiry Date 25710 2011 LR Release Term Date 30 11 2011 fags Telephone No Reason Temp Loss LR Register Status OPEN Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized 6 Click the Ok button 7 The sys
14. teller initiates a buy or sell of a specific inventory item s to the vault teller it is termed as the transfer of stocks You have to enter the stock code denomination and the total quantity he she wants to purchase or sell for successful completion of the transaction Definition Prerequisites Not Applicable Other Prerequisites e V001 Stock Transactions Modes Available Not Applicable To transfer the balance stock 1 Type the fast path 9019 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Inventory gt Transfer Stocks 2 The system displays the Transfer Stocks screen Transfer Stocks Transfer Option i Stock Code v Denomination Code Series No a 1a Quantity Start No End No Narrative Transfer Stocks ORACLE Field Description Field Name 9019 Transfer Stocks Description Transfer Option Stock Code Denomination Code Series No Quantity Start No End No Narrative Mandatory Drop Down Select the transfer option from the drop down list The options are e Sell to Vault Select this option to initiate a purchase of stocks e Buy from Vault Select this option to initiate a sale of stocks Mandatory Drop Down Select the stock code for the stock or inventory item which you want to transfer from the drop down list Mandatory Pick List Select the denomination code for
15. the stock code being transferred from the pick list The denomination needs to be selected for inventory items such as traveler s cheque etc which are tracked denomination wise Mandatory Alphanumeric 12 Type the number of the series from which the denominations starts Mandatory Numeric 10 Type the number of stocks that are being transferred For example 50 units of banker s check It can be 50 leaves or booklets of banker s cheque Mandatory Numeric 10 Type the start number in the stock series This number onwards the stock has to be transferred Display This field displays the end number of the series The end number is calculated and generated by the system depending on the quantity and the start number specified For example If Quantity 100 and Start No 50 Then End No 149 Mandatory Alphanumeric 40 Type the narration based on the transaction By default the system displays narration depending on the transaction ORACLE 9019 Transfer Stocks 3 Select the transfer option from the drop down list 4 Enter the required information in the various fields Transfer Stocks Transfer Option Sell To vaut Stock Code 112 REGTEST x Denomination Code Series No 5001 TE Quantity 1000 Start No 2001 End No 3000 Narrative Transfer Of Stocks 5 Click the Ok button 6 The system displays the message Authorization Requir
16. Click Ok to Continue Click the Ok button 9 The stock transaction details are added once the record is authorised Note Click Add button to add request stocks ORACLE IV002 Stock Adjustment 1 3 IV002 Stock Adjustment Using this option you can adjust amend the stock status to reflect the correct position of instruments that have been cancelled returned torn lost in transit etc Other than the issue and use of stock status for everyday transactions the teller or vault teller can maintain other statuses such as Rejected Torn Cancelled Lost Misplaced etc to indicate the position of stocks in hand e g The Central Inventory department required USD traveler s cheque of denomination 100 However the supplier issued INR traveler s cheque of denomination 100 that were marked as received These traveler s cheque can be marked as rejected Definition Prerequisites e V001 Stock Transactions Modes Available Not Applicable To adjust the balance stock 1 Type the fast path IV002 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Inventory gt Stock Adjustment 2 The system displays the Stock Adjustment screen Stock Adjustment Stock Code v Denomination Type of Adjustment v Adjustment Date 31 01 2008 ES From Branch x From User B To Branch n To User C Te Adjustment Quantity i Series Number Start Number End Nu
17. Current Balance of units Denomination Balance of units Details Denomination Details Stock Details Field Description Column Name Description Purchase Order Display This column displays the purchase order number Request No Display This column displays the request number Supplier Display This column displays the name of the supplier ORACLE IV011 Stock Inquiries Column Name Description Date of Order Display This column displays the date on which the order was placed 10 Click the Ok button to return to the Details tab 11 Click the Close button Note The results of the query are based on the requesting location and the Inputs The pending orders are displayed If no input specified all pending orders and their details are displayed ORACLE IV005 Inventory PIN Maintenance 1 5 IV005 Inventory PIN Maintenance This option is used for inventory PIN maintenance The screen maintains the PIN of passbook and CD assigns the initial PIN register reset unlock and change the PIN etc Definition Prerequisites e 8053 Customer Addition e IVMO01 Stock Codes e IVM10 Multi Currency Package Stock Code Cross Reference e Inventory linked to a CASA RD or TD account Modes Available Not Applicable To maintain the inventory PIN 1 Type the fast path IV005 and click Go or navigate through the menus to Global Definitions gt Master gt Inventory
18. Multi Currency Accounts MCA Inventory can be sold against MCA Alternatively inventory can be sold to walk in customer If the inventory is sold to MCA then it will be linked to that MCA User can sell the inventory as well as cancel the previous sold inventory Definition Prerequisites e List of inventories which are of sell category Modes Available Not Applicable To sell the inventory 1 Type the fast path IV012 and click Go or navigate through the menus to Global Definitions gt Master gt Sell of Inventory 2 The system displays the Sell of Inventory screen Sell of Inventory Transaction Type Sell of Inventory User Reference Number Sell Type Sell to MCA v MCA Number Stock Code Inventory Start Number Inventory End Number Quantity ORACLE Field Description Field Name IV012 Sell of Inventory Description Transaction Type User Reference Number Sell Type MCA Number Stock Code Inventory Start Number Mandatory Drop Down Select the transaction type from the drop down list The options are e Sell of inventory e Cancellation of Sell of Inventory Mandatory Numeric 25 Pick List Type the user reference number for sell of inventory Select the user reference number from the pick list If Transaction Type is Cancel Sell of Inventory then this field becomes a pick list The user reference number is assigned to identify the transaction
19. Oracle FLEXCUBE Inventory User Manual Release 4 4 0 0 0 Part No E52076 01 ORACLE FINANCIAL SERVICES ORACLE Inventory User Manual Table of Contents index RR Goss ss me cc es ce wc AE oc gone ce A ecm 3 ki ES Traner staat tee abies Sata as bt a elnino R 4 Ta POO Stock TANS GIS cece citer a Maruca ance hain abies gata tladaal has 7 T3 V002 SUG Adus hme aa aa e sees yee aaa aretacee 20 P Wag ae e T E e E renee E A E E E A A 26 1 5 IV005 Inventory PIN Maintenant uessur issus annu baaa aaae aE Eaa oF cra e gees E a deen Comer eRe etree eT em nny Tone A ee ener ren treet Tn er rere 41 1 7 IVM10 Multi Currency Package Stock Xref ccceeesceceeeeeeeeeeeeeeeeeeeeeseeeeeeaaeseeeeeeneeeees 45 1 8 IV004 Inventory Lost Report Registration Maintenance ccccccceeeseceeeeteeeeeeeeneees 49 ORACLE Inventory 1 Inventory Inventory of a bank is a valuable commodity and proper tracking needs to be in place to check its fraudulent usage The bank has to maintain the stock record of each inventory to initiate the tracking system Each stock in the inventory list has to be given a unique code which can be used to identify the stock with the issuer currency and inventory type Printed inventories are procured from external agencies that are appointed by the bank for which the bank needs to maintain the identification of the suppliers ORACLE 9019 Transfer Stocks 1 1 9019 Transfer Stocks When a
20. artment Requesting Branch Mandatory Drop Down Select the branch code from the drop down list This is the bank or branch that has initiated request for the stock Request Type Mandatory Drop Down Select the request type from the drop down list The options are e Adhoc When a request is placed before the re order level is reached it is termed as Ad hoc e Regular When a request is placed after re order alert is generated ORACLE Field Name Date of Request Ad hoc Request Reason Reference No 1 Reference No 2 IV001 Stock Transactions Description Mandatory Pick List dd mm yyyy Select the request date from the pick list By default this field displays the current posting date It must be less than or equal to current date and cannot be a future date Conditional Alphanumeric 40 Type the reason for requesting the stock This field is enabled if the user selects the Adhoc option in the Request Type field Optional Alphanumeric 12 Type the first reference number Optional Alphanumeric 12 Type the second reference number Column Name Description Srl No Display This column displays the system generated serial number Request id Display Stock catalog Code Denm Qty req This column displays the request ID Mandatory Drop Down Select the appropriate stock catalogue code of the stock or the inventory item for which the request order is placed from the
21. drop down list Mandatory Drop Down Select the appropriate denomination value of the stock from the drop down list If denomination is not applicable the drop down displays 0 option Select 0 in this case Mandatory Numeric 10 Type the appropriate amount of stocks required For example 50 units of banker s cheque It can be 50 leaves or booklets of banker s cheque ORACLE IV001 Stock Transactions Column Name Description Total Display This column displays the total value Total Value Denomination Quantity For example If Denomination 100 and Quantity 20 Then Adjustment Total value 2000 Only stock or inventory items which are tracked denomination wise will have an Adjustment Total value Delete y n Toggle Click the toggle status to change the value to Y if you want to delete the particular stock item from the list By default the system displays the value as N Transaction Order stocks Purchase Order No fio Request No o2is ea Date of order 15 02 2008 Supplier code RM Reference no 1 fi Reference no 2 2 Add Delete 1 02159999se 39 BARODD 300 BKI 601 300 75000 N 2 021599995 10 Passbook o s0 1 201 250 N 3 021599995 33 BDI o 200 1 2 N 4 02159999se 39 BARODD 500 300 1 300 150000 N Record Details Input By Authorized B
22. e Package f Stock Code Details p F Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized O add O O O O vo i o if ooe Description Multi Currency Package Details Multi Currency Package Code Description Module Corporate Package Mandatory Pick List Select the MCA package code for which the MCA package stock code cross reference is to be maintained Display This field displays the description of the multi currency package code Display This field displays the module to which the multi currency package belongs for example CASA TD or RD Display This field displays whether the package is for corporate or not ORACLE Column Name Stock Code Details Stock Code Stock Code Description Stock Type Stock Type Description Delete Y N IVM10 Multi Currency Package Stock Xref Description Mandatory Pick List Select the stock code which is available for link with MCA or account from the pick list If the stock code is already linked to MCA Package then system will give error message on selection TABOUT Stock code is a manually generated unique number which enables the bank to track the inventory A stock code has to be unique in the system Displays This field displays the name of the stock code Displays This field displays the stock type under which the stock code is created Displays This field displays the
23. ed Do You Want to continue Click the OK button 7 The system displays the Authorization Reason screen 8 Enter the relevant information and click the Grant button Note For information on Authorization transactions refer to the FLEXCUBE Introduction User Manual ORACLE IV001 Stock Transactions 1 2 IV001 Stock Transactions Using this option you can execute the following e Request stock from the central inventory The request can be regular or adhoc with stock inventory code denomination details and total quantity required e Keep track of stock ordered from suppliers The purchase order number date purchase and inventory details e Keep record of stock received from the suppliers The receipt date and the received inventory details e Issue stock to branches The issued date branch and the issued inventory details Definition Prerequisites Not Applicable Modes Available Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To add stock transaction details 1 Type the fast path IV001 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Inventory gt Stock Transactions 2 The system displays the Stock Transactions screen ORACLE IV001 Stock Transactions Stock Transactions Request Stocks Request No ea
24. eled on term expiry or on maturity of the deposit linked to the inventory System always consider bank calendar maintained using the option Bank Calendar Maintenance FP BA090 for computing the lost report expiry date and for running the cancellation of job during the EOD Definition Prerequisites e MCAO03 Multi Currency Account Opening e MCA04 RD Account Opening under MCA e MCAO07 TD Account Opening under MCA e PS005 Passbook Multi Currency Account Linkage e CM13 Card Muti Currency Account Linkage Modes Available Add Modify Delete Cancel Amend Authorize Inquiry For more information on the procedures of every mode refer to Standard Maintenance Procedures To maintain the inventory lost report 1 Type the fast path IV004 and click Go or navigate through the menus to Global Definitions gt Master gt Inventory Lost Report Register Maintenance 2 The system displays the Inventory Lost Report Register Maintenance screen ORACLE IV004 Inventory Lost Report Registration Maintenance Inventory Lost report Register maintenance Neen r Action Details Action Loss Report Type r Input Parameters Stock Code Inventory No Lost Report Register No Home Branch r Lost Report Details Received Channel Reporting Branch LR Register Date LR Expiry Date LR Release Term Date Telephone No Reason LR Register Status Authorized By Last Mnt
25. have any PIN PIN status will be displayed as No PIN Action Mandatory Drop Down Select the action to be done related to the PIN for the selected inventory from the drop down list The options are e Register PIN e Reset PIN e Unlock PIN e Change PIN e Assign Initial PIN Initial PIN Conditional Alphanumeric 20 Type the initial PIN for the selected inventory This field is enabled if Action is selected as Assign Initial PIN 3 Select the search criteria from the drop down list 4 Type the search string and press the lt Tab gt key The system displays a list of customer s that match the search criterion 5 Select the customer from the pick list The customer details are displayed in the screen 6 Select the action from the drop down list 7 Enter the other required information ORACLE Inventory PIN Maintenance E Search Criteria ID Full Name Action Stock Code PIN Status Initial Pin IV005 Inventory PIN Maintenance Customer Short M Search String De ie 604133 Ic 099990002171 Debamumbai Assign initial Pir 153 D InventoryNo om J 2323132367889999999 6 Click the Ok button 7 The system displays the message Transaction Successful ORACLE IV012 Sell of Inventory 1 6 IV012 Sell of Inventory Using this option user can issue inventory types to the bank customer or walk in customers These inventories may or may not be linked to the
26. his running number unique to a customer across the system is generated after the system has identified the Customer IC and Customer Category combination to be non existent in the system This ID is used for searching and tracking the customer in the system Display This field displays customer IC of the selected customer A customer IC along with customer type is a unique method of customer identification across the bank covering all branches Based on the combination the system can identify the customer as an existing customer even when the customer opens a new account in another branch A social security number passport number birth certificate or corporate registration can be used as a customer IC Display This field displays the full name of the selected customer ORACLE IV005 Inventory PIN Maintenance Field Description Name Inventory Mandatory Pick List Select the inventory number from the pick list The pick list displays all the inventories having Password Applicable attribute as true which are issued to the selected customer Stock Mandatory Pick List coda Select the stock code for the inventory being reported as lost from the pick list Stock code is a manually generated unique number which enables the bank to track the inventory A stock code has to be unique in the system PIN Display Status This field displays the PIN status of the selected inventory If the inventory selected doesn t
27. ill display all stock that is in Receive status e Issues Will display all stock that is in Issued status e Orders Will display all stock for which purchase order is placed e Requests Will display all stock for which request is placed This field is enabled only if the Stock Transactions option is selected in the Stock Inquiry drop down list Conditional Pick List dd mm yyyy Select the date from which you want to perform the inquiry from the pick list This field is enabled only if the Stock Transactions option is selected in the Stock Inquiry drop down list ORACLE Field Name Date To Indent Request Reference Purchase Order Reference Current Balance of units Denomination Balance of units IV011 Stock Inquiries Description Conditional Pick List dd mm yyyy Select the date up to which you want to perform the inquiry from the pick list This field is enabled only if the Stock Transactions option is selected in the Stock Inquiry drop down list Conditional Pick List Select the indent request reference from the pick list to view the stock status based on the indent request reference The result for indent request reference will show the supplier code the date of order placement in the Purchase Detail tab This field is enabled only if the Indent Request Status option is selected in the Stock Inquiry drop down list Conditional Pick List Select the purchase order reference
28. k Inquiries can be performed at the following levels e Central Inventory Department Branch details related to the central inventory department and the branch can be viewed e Branch Level Only branch level details can be viewed e Teller Level Only teller level details can be viewed Three types of Inquiries that aid in inventory tracking are e Indent Requests Status e Balance on hand e Stock Transactions Definition Prerequisites e V001 Stock Transactions Modes Available Not Applicable To inquire on stock 1 Type the fast path IV011 and click Go or navigate through the menus to Transaction Processing gt Internal Transactions gt Inquiries gt Stock Inquiries 2 The system displays the Stock Inquiries screen ORACLE IV011 Stock Inquiries Stock Inquiries Stock Inquiry x User ID Indent Request Reference Trans Type Purchase Order Reference Branch C N A To Branch ia ce tJ ae eee 04 10 2009 From Branch e Stock Code Current Balance of units Denomination Balance of units Denomination Details Stock Details Purchase Details Field Description Field Name Description Stock Inquiry Mandatory Drop Down Select the appropriate stock inquiry option from the drop down list The options are e Balance On Hand e Stock Transactions e Indent Request Status e Stocks in Transit Branch Conditional Pic
29. k List Select the branch code from the pick list This is the inventory bank that has placed the request on behalf of the allowed branch This field is disabled if the Stocks in Transit option is selected in the Stock Inquiry drop down list ORACLE Field Name To Branch From Branch Stock Code User ID Trans Type Date From IV011 Stock Inquiries Description Conditional Pick List Select the To branch code from the pick list It is the branch to which the stocks are being transferred This field is enabled if the Stocks in Transit option is selected in the Stock Inquiry drop down list Conditional Pick List Select the From branch code from the pick list It is the branch from which the stocks are being transferred This field is enabled if the Stocks in Transit option is selected in the Stock Inquiry drop down list Mandatory Drop Down Select the stock code if you want to perform the inquiry based on the status of a particular stock or inventory item from the drop down list Conditional Drop Down Select the user ID if you want to perform the inquiry based on the user who has placed the request from the drop down list This field is disabled if the Stocks in Transit option is selected in the Stock Inquiry drop down list Conditional Drop Down Select the transaction type from the drop down list The options are e All Will display stock transactions in all statuses e Receipts W
30. l Requesting Branch Request Type Date of Request 1 5 JEE Ad hoc Request Reason Fareronck Noud pami Reference No 2 o j Record Details Input By Field Description Field Name Description Transaction Mandatory Drop Down Select the appropriate transaction option from the drop down list The options are e Request Stock e Order Stock e Receive Stock e Issue Stock Based on the transaction type selected the tab for the respective transaction will be activated 3 Click the Add button 4 Select the appropriate transaction from the drop down list 5 The system enables the corresponding tab depending on the transaction type selected ORACLE IV001 Stock Transactions Request Stocks Transa ction k 7 Request Stocks Request No Requesting Branch HO 7 Request Type Adhoc v Date of Request 15 02 2008 EE Ad hoc Request Reason Reference No 1 1 Reference No 2 2 Add Delete sine Requestid Stockeatalog Code Denm Oyra tea 1 FERET 10 Passbook es ee 100 N Record Details Input By Field Description Field Name Description Request No Mandatory Alphanumeric 10 Type the request number which will be used to track the request status by the bank or branch and to place the purchase order with supplier by central inventory dep
31. marks of the respective companies with which they are associated 54 ORACLE
32. mber if 5 Adjustment Total value Reason For Adjustment ORACLE Field Description Field Name IV002 Stock Adjustment Description Stock Code Denomination Mandatory Drop Down Select the stock code for the stock or the inventory item you want to make adjustment to from the drop down list Conditional Pick List Select the denomination code for the stock code being transferred from the pick list The denomination needs to be selected for inventory items such as traveler s check etc which are tracked ORACLE IV002 Stock Adjustment Field Name Description Type of Mandatory Drop Down Adjustment Select the type of adjustment from the drop down list It is the status the user wants to amend the inventory item to The options are e Cancelled A teller can mark a reversed banker s cheque issue transaction as Cancelled Since the instrument has already been marked as Used the system does not update the status of the instrument e Duplicate If a customer reported a TD certificate as lost and has a duplicate issued the teller can mark it as duplicate Since the original certificate has already been marked as Used the system does not update the status of the instrument e Found If a branch is able to locate the lost inventory item itis marked as Found e Lost During the receipt if an inventory item is found lost it is marked as Lost e Returned When an inven
33. mple If Denomination 100 and Quantity 20 Then Adjustment Total value 2000 Only stock or inventory items tracked denomination wise will have adjustment total value Reason For Mandatory Alphanumeric 40 Adjustment Type the reason for adjusting the stock or the inventory item 3 Select the stock code from the drop down list 4 Enter the required information in the various fields Stock Adjustment Stock Code Bankers Cheque Type of Adjustment Cancelled From Branch Centras To Branch Adjustment Quantity Series Number 201 Start Number Adjustment Total vValue Reason For Adjustment cheque lost sij 100 150 v Denomination Adjustment Date 31 01 2008 From User API_SUPER To User 7 i End Number i Click the OK button The system displays the Authorization Required Do You Want to continue message Click the OK button ORACLE IV002 Stock Adjustment 8 The system displays the Authorization Reason screen 9 Enter the required information and click the Grant button 10 The system displays the message Stock Adjustment Completed Successful Click the OK button Note For information on Authorisation transactions refer to the FLEXCUBE Introduction User Manual ORACLE IV011 Stock Inquiries 1 4 I1V011 Stock Inquiries Using this option you can perform several inquiries to assist in tracking inventory items or stoc
34. name of the stock type Toggle If the field is marked as Y then the stock code details set for the customer will get deleted Click the Add button 4 Select the multi currency package code from the pick list The system displays the multi currency package details 5 Click the button to add the stock code details 6 Select the stock code from the pick list The system displays the stock code details ORACLE IVM10 Multi Currency Package Stock Xref Multi Currency Package Stock Xref Multi Currency Package Details Multi Currency Package Code 102 e Description Corporate TD Account Opening Module o Corporate Package Input By Authorized By Last Mnt Date Last Mnt Action Authorized 9 Click the Ok button 10 The system displays the message Record Added Authorisation Pending Click the Ok button 11 The stock code details are added once the record is authorised ORACLE IV004 Inventory Lost Report Registration Maintenance 1 8 IV004 Inventory Lost Report Registration Maintenance This screen is used to maintain the lost report User can register the new lost report and cancel the lost report or maintain the release of lost report Temporary lost for corporate inventory is registered using this option In the inventory attribute table term for expiry period for temporary lost report is maintained that will automatically gets canc
35. ock item in the list Display This column displays the stock catalogue code of the stock or the inventory item for which the request order is placed Display This column displays the denomination value of the requested stock ORACLE Column Name Qty req Series Start End Total Delete y n IV001 Stock Transactions Description Mandatory Numeric Seven Type the quantity of stocks The user can modify the quantity of stocks requested at the time of placing an order The quantity can be reduced from the original requested but cannot be increased For example 50 units of banker s cheque It can be 50 leaves or booklets of banker s cheque Conditional Numeric 10 Type the series number that has been defined for the particular stock code Conditional Numeric 10 Type the start number from which a stock item is ordered If the Auto Serial No flag is on then system automatically generates the Start No by incrementing the highest number of the current stock The user can modify the Start No or provide it when it is not already available Display This column displays the end number of the series The end number is calculated and generated by the system depending on the quantity and the start number specified For example If Quantity 100 and Start No 50 Then End No 149 Display This column displays the total value Total Value Denomination Quantity For example
36. olumn displays the denomination balance available in the inventory 9 Double click a record to enable the Stock Details tab ORACLE Stock Details IV011 Stock Inquiries Stock Inquiry Balance on Ha Branch To Branch From Branch Stock Code User ID Indent Request Reference Trans Type Purchase Order Reference a e Date Frome 04 10 2009 Date To 04 10 2009 Current Balance of units Field Description Column Name Description Denomination Value Denomination Balance Denomination Series Start No End No Display This column displays the denomination value Display This column displays the denomination balance Display This column displays the denomination in words Display This column displays the series Display This column displays the inventory start number Display This column displays the inventory end number ORACLE IV011 Stock Inquiries Column Name Description Stock Ccy Display This column displays the stock currency Current Series Display Total Value This column displays the current series total value Purchase Details Stock Inquiry 5ajsnce on Hand User ID Indent Request Reference Trans Type Purchase Order Reference Branch Pa ere L m Date rece 04 10 2009 To Branch x a 04 10 2009 From Branch Stock Code
37. ransfer option is selected in the Type of Adjustment drop down list Conditional Pick List Select the user who is performing the adjustment transaction from the pick list This field is disabled and the value is set as the logged in user if the Intra Branch Transfer option is selected in the Type of Adjustment drop down list Conditional Drop Down Select the appropriate to branch from the drop down list This field is disabled and the value is set as the home branch if the Intra Branch Transfer option is selected in the Type of Adjustment drop down list Mandatory Pick List Select the user for whom the adjustment transaction is performed from the pick list Mandatory Numeric 10 Type the inventory quantity to be adjusted Mandatory Numeric 12 Type the series number of the stock to be adjusted Mandatory Numeric 10 Type the start number in the stock series The stock has to be transferred from this number onwards Display This field displays the end number of the series The end number is calculated and generated by the system depending on the quantity and the start number specified For example If Quantity 100 and Start No 50 Then End No 149 ORACLE IV002 Stock Adjustment Field Name Description Adjustment Total Display Valls This field displays the adjustment total value based on the denomination and quantity specified Adjustment Total Value Denomination Quantity For exa
38. splay Numeric Seven Type the start number from which a stock item is received Display This column displays the end number of the series The end number is calculated and generated by the system depending on the quantity and the start number specified For example If Quantity 100 and Start No 50 Then End No 149 Display This column displays the total based on the denomination and quantity specified Total Denomination Quantity For example lf Denomination 100 and Quantity 20Then Total 2000 Only stock or inventory items tracked denomination wise will have an Adjustment Total value ORACLE Column Name IV001 Stock Transactions Description Confirm y n Delete y n Toggle Click the toggle status to change the value to Y to confirm the physical issue of stock either in full or partial By default the system displays the value as N If the stock is issued in partial the user will need to modify the quantity field to reflect the quantity actually issued The stock level will not be updated at the issue bank branch till the confirmation flag is set to Y Toggle Click the toggle status to change the value to Y if you want to delete the particular stock item from the list By default the system displays the value as N 6 Enter the required information in the various fields 7 Click the Ok button 8 The system displays the message Record Added Authorization Pending
39. st The receipt date cannot be greater than the current date ORACLE IV001 Stock Transactions Column Name Description Srl No Display This column displays the system generated serial number for each stock item in the list Request id Display Stock catalog Code Denm Qty req Series Start End This column displays the request ID for each stock item in the list Display This column displays the stock catalogue code of the stock or the inventory item for which the request order is placed Display This column displays the denomination value of the requested stock Display This column displays the quantity of stocks In case of partial receipt for the stock request the user can modify the original values to reflect the received stock values The quantity can be reduced from the original requested but cannot be increased For example 50 units of banker s cheque It can be 50 leaves or booklets of banker s cheque Conditional Numeric 10 Type the series number that has been defined for the particular stock code Conditional Numeric 10 Type the start number The stock item is ordered from this value onwards Display This column displays the end number of the series The end number is calculated and generated by the system depending on the quantity and the start number specified For example If Quantity 100 and Start No 50 Then End No 149 ORACLE Column Name
40. tem displays the message Record Added Authorisation Pending Click Ok to continue Click the Ok button ORACLE ORACLE Inventory User Manual Jan 2012 Version 4 4 0 0 0 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial_services Copyright 2012 Oracle and or its affiliates All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this document and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this document and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product names are trade
41. tory item is returned on an account that it is above the excess level it is marked as Returned For example excess inventory at branch level for stock code A is 100 units Branch Z holds 102 units Branch Z will mark 2 units of stock A as Returned e Intra Branch Transfer If this option is selected transfers between Tellers of same branch is allowed e Torn If a check book is found to be torn after receipt the teller can mark it as Torn e Used If the instrument serial number is wrongly entered during an offline transaction then the actual instrument number used can be updated with the used status e Rejected If a stock item is not issued as per the request order it can be rejected For example if the central inventory department requested USD TC of denomination 100 and the supplier issued INR TC of denomination 100 that were marked as received then these TCs can be marked as rejected Adjustment Date Mandatory Pick List dd mm yyyy Select the appropriate date of adjustment from the pick list By default this field displays the current posting date as date of adjustment ORACLE Field Name From Branch From User To Branch To User Adjustment Quantity Series Number Start Number End Number IV002 Stock Adjustment Description Conditional Drop Down Select the inventory branch from the drop down list This field is disabled and the value is set as the home branch if the Intra Branch T
42. y Last Mnt Date Last Mnt Action Authorized C add O modify O Delete O cancel O amend C rize uiry ok _ close clear_ Field Description Field Name Description ORACLE Field Name Purchase Order No Request No Date of order Supplier code Reference no 1 Reference no 2 IV001 Stock Transactions Description Mandatory Alphanumeric 10 Type the unique purchase order number which is used to track the purchase order status On receipt of the stock from supplier this purchase order number is used to indicate receipt Mandatory Pick List Select the request number for which purchase order needs to be placed from the pick list The pick list displays only those request numbers against which there are no orders placed or partial orders are placed Mandatory Pick List dd mm yyyy Select the date of request from the pick list This date must be a current or previous date and cannot be a future date Mandatory Drop Down Select the supplier code from the drop down list The drop down list displays the list of all approved suppliers Optional Alphanumeric 12 Type the first reference number Optional Alphanumeric 12 Type the second reference number Column Name Description Srl No Display This column displays the system generated serial number for each stock item Request id Display Stock catalog Code Denm This column displays the request ID for each st
Download Pdf Manuals
Related Search