As part of enabling and using the Instruments Inventory Tracking (IV) module of Oracle FLEXCUBE, there are several maintenances to be performed. These maintenances have been elaborated upon in the sections given below.
Note
Unless specified otherwise, all maintenances specified below allow all standard maintenance functions – Add, Modify, Delete, Authorize, Close, Re-open, Inquiry. The maintenance functions also log all maintenances in the Audit Trail.
This chapter contains the following sections:
In the Bank Parameters Maintenances screen, under the ‘Preferences’ screen you need to specify whether inventory management and tracking should be enabled or not.
To invoke the Bank Parameters Maintenances screen, enter ‘STDBNKPM’ in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button.
Allow Inventory Tracking
You can use this check box to allow/disallow inventory management and tracking. To use inventory management module, check this box.
Note
If inventory tracking is allowed then ‘Cheque Numbering Scheme’ should be left blank/null.
For more details on Bank Parameters Maintenance, refer the corresponding section in the Core Services manual.
This section contains the following topics:
Use the ‘Issuer Code -Detailed’ screen for maintaining instrument issuer details. This maintenance is found under the Core module.
To invoke the ‘Issuer Code Maintenance’ screen, enter ‘CSDISSCD’ in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button.
The details which you need to specify in the above screen are detailed below.
Issuer Code
Specifies the Issuer Code. An issuer code is an internal alphanumeric code used within the system to track stock of financial instruments. The Issuer Code, for instrument types other than passbook and cheque book, has to be in accordance with the routing mask as defined in the bank level parameters.
Issuer Description
Provide a description of the Issuer Code maintained.
Use the ‘Issuer Code – Summary’ screen to query for Issuer Code Maintenance records, by specifying the following parameters:
To invoke the ‘Issuer Code - Summary’ screen, enter ‘CSSISSCD’ in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button.
This section contains the following topics:
You can use the ‘Denomination Details’ screen for specifying various denominations supported for cash and traveller’s cheque for each currency. This function will be available under Core module maintenances.
To invoke the ‘Denomination Details’ screen, type ‘CSDDEMAN’ in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button.
The details to be maintained in the above screen are explained below.
Denomination Type
Specify the Denomination Type here by selecting the appropriate option from the drop-down list. The following options are available for selection:
Note
For denominated deposit only ‘Note’ denomination type can be used.
Currency Code
Select from the adjoining list of options the currency code for which the denomination maintenance is being performed. Depending on the currency code specified, a brief currency description is displayed.
Issuer Code
Select the issuer code, for which the denomination maintenance is being performed, from the adjoining list of options. Depending on the issuer code specified, the issuer’s description is displayed.
Note
Issuer code needs to be maintained for both cash and TC denomination type.
Under the Denomination Details section, you can specify the following details for every record added.
Denomination ID
Specify here the ID for each denomination. For every currency, the various denominations are assigned separate denomination IDs.
Denomination Description
Provide a full-length description of denomination.
Denomination Value
Specify the value of denomination.
Sequence No.
Specify here the preferred sequence of denomination.
Type
Specify whether the denominated cash is in currency notes or coins. For Traveller’s cheque, this field can accept only the ‘Note’ option.
Note
Denomination type ‘Millionaire Certificate’ is used to facilitate MC/LMC transactions. For MC/LMC (Millionaire Certificate) transactions, you can have only one denomination with denomination type as ‘Notes’ and the currency code should be the ‘LCY code’.
Use the ‘Denomination Summary’ screen to query for Denomination Maintenance records using the following parameters:
To invoke the ‘Denomination Summary’ screen, enter ‘CSSDEMAN’ in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button.
This section contains the following topics:
You can use the ‘Stock Catalog Definition’ screen for definition of the stock catalog for different types of financial instruments.
To invoke the ‘Stock Catalog Definition’ screen, enter ‘IVDSTKCD’ in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button.
As part of the Stock Catalog Definition, you need to specify certain details which are explained below.
Stock Catalog Code
A Stock Catalog Code identifies a particular financial instrument that is used within the bank (For example Demand Drafts drawn on the same bank in local currency). It is an internal alphanumeric code used within the system to track stock of financial instruments. This code is used internally within the software for tracking stock.
Instrument Type
You need to attach an instrument type to each stock catalog that identifies the internal type of the instrument. In the ‘Instrument Type’ field, indicate the type of Stock Catalog code that is being defined.
Certain basic instrument types are identified by Oracle FLEXCUBE and are used internally to manage the inventory. Instrument type will have the below mentioned options:
Note
Stock Short Name
Specify here a short name to be attached to the Stock Code for easier identification.
Stock Catalog Description
This is a full-length description of the Stock Code.
Currency Code
Specify here the currency code of the instrument. The currency code specified will be a valid entry as specified in the currency master maintenance.
Issuer
Specify here a valid issuer code from Oracle FLEXCUBE.
Denomination Tracking
The denomination tracking option indicates whether or not denomination details are maintained for the particular type of stock catalog. Denomination tracking is allowed only for Traveller’s Cheques.
If Denomination Tracking is set as ‘Yes’, then the denomination details for the catalog need to be defined during the catalog definition.
If the Denomination Tracking is set as ‘No’, then the denomination value will be defaulted to zero.
Note
For Denominated Deposit, denomination tracking is set as ‘Yes’. There is a validation available at CSDDEMAN screen to allow the Type as ‘Note’ only. If the validation fails system displays the error ‘Only ‘Note’ type can be used for Denominated Deposit Certificate’.
Stock Details Section
Under the Stock Details Section, you can specify the stock details for several denomination.
Auto Serial Number
To have the system automatically set the next FROM and TO serial numbers for a specified catalog stock during the purchase order transaction, set ‘Auto Serial No’ as Yes.
If Auto Serial No is set as ‘No’, then the numbers will be blank and you will need to input the numbers manually.
Note
Stock Type
Indicate here, where the stock is identified - at leaf level or booklet level?
Note
For MC/LMC (Millionaire Certificate) transactions, you can have only ‘Leaves’ as stock type and denomination tracking should be set to yes. Currency code should be the LCY.
Note
Two certificates under a the same denominated deposit cannot have the same certificate number even if the series number and stock catalogue code are different.
Following standard maintenance operations are possible in the ‘Stock Catalog Definition’ screen:
You can use the ‘Stock Catalog Summary’ screen to query for stock catalog records based on the following parameters:
To invoke the ‘Stock Catalog Summary’ screen, enter ‘IVSSTKCD’ in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button.
This section contains the following topics:
You can use the ‘Stockflow Master Definition’ screen to define and maintain the inventory stock flow. This maintenance must be done for each inventory branch. The stock flow master definition allows the following:
The bank may have different hierarchies, which can be defined using this inventory-branch cross-reference maintenance.
For each inventory branch, the maintenance needs to be done for all the allowed branches/operations (of which the inventory maintenances can be done from this branch). However, irrespective of this maintenance, all branches can initiate stock requests for their own branch.
For any given branch:
To invoke the ‘Stock Flow Master Definition’ screen, enter ‘IVDSTFMN’ in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button.
You may need to specify the following details in the above screen.
Inventory Branch
Specify here the Inventory branch, i.e. the branch which will be maintaining the inventory for the allowed branch codes.
Branch Name
The system displays the Branch Name for the selected inventory branch.
Remarks
It’s an optional field for specifying additional remarks for this maintenance which can be used to indicate the logical group name for the inventory branch.
You can use the ‘Allowed Branches’ tab to maintain the list of inventory operations which the inventory branch can initiate on behalf of the allowed branches.
Here you can add Branch Code – Branch Name records and maintain the following details for each.
Branch Code
Specify the Branch Code for which the inventory operations need to be maintained. The Branch Name is displayed as per your selection.
Use the following fields to define (specify by selecting Yes/No) the inventory transactions which the Inventory branch can initiate on behalf of the Allowed Branch codes.
The ‘Stock Details’ tab section allows for maintaining the reorder level, excess level and reorder quantity of the different catalog stocks (at the inventory branch level).
The above maintenance is optional and applies only to the specified inventory branch. The maintenances done here supersedes the Reorder Level, Excess Level and Reorder Quantity Maintained at the Stock Catalog Definition.
You may specify the following details for each added record in the Stock Details section:
Stock Catalog Code
Select from the adjoining list of options, the Stock Catalog whose stock details you wish to maintain/modify for the specified inventory branch.
Based on your selection the following values are populated. You may modify certain values as per your requirements:
You can use the Stockflow Summary) screen to query for Stockflow definition records by specifying the following parameters:
To invoke the ‘Stock Flow Summary’ screen, enter ‘IVSSTFMN’ in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button.
You may enter into contracts with a standard set of vendors who are inventory suppliers. Therefore, you need to specify the details of the vendor every time you enter into a perform a maintenance. To ease this, you can maintain the details of all the vendors with whom you deal in the ‘Vendor Maintenance’ screen. Then, when performing maintenance, you only need to indicate the Vendor ID and all the details maintained for the Vendor will automatically be picked up.
To invoke the ‘Vendor Maintenance’ screen, enter ‘XPDVNMNT’ in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button.
Under the ‘Stock Details’ section, you can specify whether the vendor is an inventory supplier or not. If the vendor is an inventory supplier then you can record the list of stocks that can be serviced by the vendor.
Is Vendor an Inventory Supplier
If the maintained vendor is an inventory supplier then check this box. You can then proceed to capture the stock codes which can be serviced by this vendor.
Stock Details
Here you can maintain a list of stocks which can be serviced by this vendor/supplier. You may also include all the stocks using the single select check box.
The Stock Catalog Codes displayed will be valid codes as maintained in the stock catalog master maintenance.
Note
The Request Stock function, explained in the Operations chapter, checks for the valid supplier code. The valid supplier codes are the codes maintained through this supplier codes maintenance. The Order Stock function (explained later) checks if the requested stock can be supplied by this supplier.
For more details on Vendor Maintenance, refer the Core Entities user manual.
You need to maintain the ‘IVBEODFN’ batch process in the Mandatory Batch Program Maintenance screen, so as to get the excess stock and shortage report to be recorded during EOD.
You can invoke the ‘Mandatory Batch Program Maintenance’ screen by typing ‘EIDMANPE’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.