Procedure to Inquire the pending amount in Sanchypost to be paid for TDA accounts after migration in DOP Finalce

• For suppose if we want to find the due installments which are to be paid to the customer for TDA accounts(MIS/SCCS/TD) after migration then there is a special menu in DOP Finacle.
• The menu option is HIOT (Inquiry on Transactions)
• This menu HIOT is used to know the due installments which are yet to be paid to the customer after migration in Finacle.
• The step by step procedure is mentioned below

HIOT ( Inquiry on Transactions) 

• Invoke the menu HIOT then the system will show the below mentioned screen as shown below

Then in the above screen enter the following details as menitoned below

1. Enter the SOL ID  ___________________
2. Enter the A/c Id as _____________________  (Sundry account i..e., 0335 or 0337 or 0338 )
3. Remove the Start date
4. Enter the END date
5. Enter the Ref. NO ______________( Account number of the customer)  as shown in the below screen

Then finally click in Submit then the system will show the below screen

• From the above screen it is clear that an amount of Rs 24000/- which was not paid in the Sanchypost is shown by the system.
• From the above screen also observe the Reversed amount i..e, if the Reversed amount is '0' it means the amount is pending for payment.
• If the Reversed amount and Transaction amount are same then it means already paid(Reversed) to the customer.
• If we want to know the details of payment if Reversed then click on the Contra Details icon which is available in the left most corner then the system will display the tran id and date of payment.

Solution for RD loan Payoff error-The unscheduled payment or demand satisfaction is done after the value date. Reverse them before doing Payoff in DOP Finacle

• Generally we will do HPAYOFF for RD loan account when the customer wishes to pay the last installment for the loan amount or during the loan account closure.
• Sometimes when we do HPAYOFF we will get the error "The unscheduled payment or demand satisfaction is done after the value date. Reverse them before doing Payoff".
• For error screen find the below screen shot.

Root Cause of the above Problem 

• The said error occurs when the loan repayment done after the value date i..e, after 1st date of the month.
• For suppose if a loan account has 1000 balance and the customer repaid the amount on 04th date of the month which means after 1st date of the month and the customer approached for closure in another day i..e., after 04th day in the same month then above error occurs during HPAYOFF.
• In short we can say that if the loan repayment date in a month and HPAYOFF date are different in a same month then the above error situation arise in DOP Finacle.

Solution for the above Problem

Step 1 :- Reversal of transaction done in HLAUPAY menu for RD loan account.

• First we have to reverse the last loan repayment transaction by using the menu HLAUPAY i..e., select the function as Reversal then click on Go the system will show below screen shot

 

 Then in the above screen enter the following details

1. By default value date will be current date then change the value date of 1st date of the  month(Ex:- 01/01/2016) 
2.  Enter the loan account number number __________________
3. Then click on the searcher beside the Reversal ID column as shown in the below figure.

Then the system will display the transaction which was done on the same month as shown in the below screen

 

Then click on the flow id "COLL" then the system will display the transaction date and transaction details as mentioned in the below screen shot

Then click on Submit system will generate the tran id note down the tran id.

• In the next step verify the tran id by using the same menu HLAUPAY in the supervisor login as shown in the below screen shot.

Then click on submit the system will display the confirmation message

Step 2 :-  Clear the RD loan amount and loan interest by using the menu HPAYOFF

• In counter PA invoke the menu HPAYOFF enter the loan account number and submit the transaction.
• In Supervisor verify the transaction done in HPAYOFF menu.

Step 3 :- Close the RD loan account using the menu CAACLA

• In counter PA invoke the menu CAACLA enter the loan account number and submit the transaction.
• In Supervisor verify the transaction done in CAACLA menu.

Step 4 :- Close the RD account using the menu CRDCAAC

• In counter PA invoke the menu CRDCAAC enter the loan account number and submit the transaction.
• In Supervisor verify the transaction done in CRDCAAC menu.

Step by Step procedure of RD account closure having loan in DOP Finacle

• When an RD account having loan approached for closure then there will be 2 cases they are mentioned below

1. RD account having loan account approaches for before maturity period (Premature closure).
2. RD account having loan approaches after maturity period (Mature closure).

Case 1:- 

RD account closure having loan before maturity period (Premature Closure) 

• If the customer approaches  for RD account closure having loan before maturity period (Premature closure) then as per the POSB norms we will not collect the loan interest from the customer
•  In Counter PA login invoke the account closure menu CRDCAAC and close the account.
• Then the system will auto calculates the Net amount i..e, it will deduct loan amount and net balance to be paid to the customer will displayed by the system.
• Supervisor has to verify the account closure using the menu CRDCAAC.

Case 2:- 

RD account having loan approaches after maturity period (Mature closure).

• Counter PA has to invoke loan repayment using HLAUPAY menu.
• Supervisor has to verify the transaction done in HLAUPAY menu.
• Counter PA has to invoke the menu HPAYOFF to make the loan amount '0'(zero) and system will calculates the loan interest.
• Supervisor has to verify the transaction done in HPAYOFF.
• Counter PA has to invoke the menu CAACLA to close the loan account.
• Supervisor has to verify the transaction done in CAACLA. Now the loan account is closed we have to proceed for account closure in the next step.
• Counter PA has to invoke the menu CRDCAAC to close the account.
• Supervisor has to verify the transaction done in CRDCAAC. Then the system will calculates the net amount to be paid to the customer after deducting the loan amount and interest on loan amount.

RD deposit error -- "Credit account is invalid status or Total Frozen"

• When we try to deposit the RD account using the menu CRDP sometimes we will face the error "Credit account is invalid status or Total Frozen".
• Please find the error screen shot

ROOT CAUSE OF THE ABOVE PROBLEM

• The root cause of the above problem is that RD account might be frozen.
• In Finacle terminology  Frozen account means discontinued account..
• IN DOP when an RD account is not having 6 defaults i..e, if there are 6 pending deposits then the account is said to be Discontinued account.
• For Example in our case account number 919956**** account shown in the error screen shot is Frozen account.
• We can inquire using the menu HPLIST menu.
• For our example I have inquired the menu HPLIST and the screen shot is as shown in the below image for your reference.

• From the above screen shot it is clear that there are 6 pending installments from 13-11-2015 to 13-04-2016 hence the system will mark the said account automatically to Frozen account.

SOLUTION FOR THE ABOVE PROBLEM:- 

• If the account is discontinued only solution is to left to the customer i..e., he/she may wish to continue the account till maturity period or close immediately.
• If the account is having the missing credits and it is frozen then follow the missing credit procedure by taking the approval from the Divisional head.

Process of accepting RD Transactions of MPKBY and PRSS Agents Using BCP in DOP Finacle

In case Agent Portal is not working or any MPKBY Agent give in writing that she is not knowing operation of Internet or Finacle is slow or not working, following procedure may be followed for accepting agent schedules in MS EXCEL:-

Ø  Macro enabled excel sheet (format attached) has to be shared with the Agents.

Ø  For Cash Deposits, RD_Cash_Txn sheet is to be used, for deposit through POSB Cheque, RD_DC_Txn sheet is to be used and for deposit through other Bank Cheque, RD_NDC_Txn file sheet is to be used by agents.

Ø  Below are the details which agent has to fill:-

·         Agent ID

·         Payment Mode

·         RD Account No.

·         RD Installment Amount

·         No. of Installments

·         Bank Name (If the payment mode is other bank cheque {NDC})

·         Cheque Number (If the payment mode is POSB Cheque (DC) or Other Bank Cheque NDC)

·         SB Account Number (If the repayment mode is POSB Cheque {DC}

Ø  Agent can enter max. RD accounts upto 1000 records in Cash sheet but total of one sheet should not exceed Rs.20,000/-.

Ø  For POSB Cheque (DC) and Other Bank Cheque (NDC), the limit of number of record is 50 but there is no lmit of amount.

Ø  RD Account No, RD Installment Amount and No of Installments are mandatory.

Ø  If the Payment mode is POSB Cheque (DC), then the cheque number and SB account number are mandatory.

Ø  If the Payment mode is Other Bank Cheque(NDC), then the Bank Name, cheque number and SB account number are mandatory

Ø  Bank Name should be selected from the Drop Down.

Ø  Agent will present the file at Post Office Counter.

Ø  Counter PA should generate the txt file using the Generate File option provided in the first sheet named Home.

Ø  On click of Generate button, below specified validations are taken care.

o  If the Payment mode is cash, for the complete excel sheet, the total amount should not exceed Rs 20000/-.

o  If the payment mode is POSB Cheque (DC), then Cheque # and SB account number mandatory check alert message will be displayed, if the values are blank.

o  If the payment mode is other Bank Cheque (NDC), Bank Name, Cheque # and SB account number mandatory check alert message will be displayed, if the values are blank.

o  Also, all the records are sorted in ascending order. The order of Column is Bank Name, Cheque No and RD Account Number.

Ø  The file will get saved in the Counter PA’s local desktop.

Ø  Counter PA has to invoke CAGTU menu to upload the txt file in Finacle core

(A)            HOW TO OPERATE CAGTU?

CAGTU – Criteria Page

Ø  There will be 1 field in the criteria page. Viz., File Name and it is provided with Browse button.

Ø  User can browse the file from local desktop and on click of upload.

Ø  From there the file will be read and the details will be inserted into the required custom table.

Ø  See screenshot for the criteria page.

 

 

(B) CAGTU – Results Page

Ø  On click of upload, results page will be displayed with the File Name and the result message.

Ø  See screenshot for the Results Page.

(C)      CAGTI – Criteria Page

Ø  User has to then go to CAGTI – Custom Agent RD Bulk Transaction Inquiry Menu for inquiring the transactional details uploaded thru CAGTU menu.

Ø  There will be only one criteria and one results page available for this menu.

Ø  In Criteria Page, the fields displayed as Agent ID, Date, File Name and E-Banking Ref No.

Ø  Agent ID, Date and File Name are mandatory fields.

Ø  E-Banking Ref No is an optional field and when entered, it will display all the details at RD account level.

Ø  To find out E Banking reference number, user will enter file name uploaded in the file name field and then click on searcher of E Banking Ref. No. which will display E Banking reference number. User has to select E banking reference number from searcher.

 

(D)      CAGTI – Details Page

Ø  Based on the input criteria like Agent ID, Date and File Name, the results will be displayed in the Details Page.

Ø  RD Installment Amount, No of installments, Rebate, default fee and Total RD Deposit Amount displayed will be the total of the entire RD accounts available in that Reference Number.

Ø  In the status field, the total success records uploaded versus the total RD accounts available in that Reference Number will be displayed.

Ø  If the E-Banking Ref No field is also entered along with other mandatory inputs, then in the details page, all the RD account details w.r.t each account will be displayed.

Ø  In the status field, if the message is success, then that record is successfully uploaded. If the status field is failure, then that record insertion is failed for any reason.

Ø     Counter PA has to then follow the same procedure as followed when Agent is presenting RD Schedule generated from Agent Portal and coming with E Banking Reference number. This e- Banking reference number is to be then processed in HAGTXP menu.

(E)       Handling of Emergency Cases when Finacle is slow or not working

Ø     When Finacle is slow or down and Post office is not able to accept all the agent schedules either prepared through Agent Portal or through BCP Excel Sheet in HAGTXP, Counter PA with the permission of Postmaster/APM/DPM/SPM in writing in the ERROR BOOK, can accept all agent schedules/Excel Sheets and accept cash/POSB Cheques/Other Bank Cheques and give receipt to agent prepared manually. Cash of those schedules which cannot be accepted in HAGTXP can be kept out of account and these schedules can be posted in HAGTXP by putting Value Date as the date of acceptance of cash/POSB Cheque and Cheque Clearing date (in case of other Bank Cheque so that depositors or agent is not forced to pay penalty.

Ø     However, Counter PA(s)/SPM should maintain a register and enter Agent ID/E Banking Reference No./Date of preparation of schedule by agent/Total Amount/Value Date entered by Counter PA and Supervisor will sign against each entry in the register.

Inventory menus in DOP Finacle

What is an Inventory?

• The word "Inventory" means one of the most important assets or valuables that most businesses possess.
• Here in DOP the important assets means cheques,certificates(i..e, NSC or KVP in DOP) etc.,
• Inventory will be maintained generally in a safe custody(i.e., in Treasury or in Postmaster custody)
• Inventory movement in DOP Finacle will be done by using the menu HIMC for detailed procedureclick here.
• Some of the important inventory menus generally we use in DOP Fiancle are mentioned below which are very handy in inventory operations they are menitoned below

1. HISRA ( Inventory Status Report of any Employee or different location)
2. HISR ( Inventory Status Report at that Employee or same location )  
3. HIMR ( Inventory movement report )
4. HIMI ( Inventory movement inquiry )
5. HIIA ( Inventory inquiry All )

HISRA Inventory Status Report

• This menu is used to view the inventory status of any employee or location which is very useful menu for inquiring the inventory position for supervisors.
• The operating procedure of this menu is explained below in step by step manner i..e, invoke the menu HISRA then the system will show th following below  mentioned screen
• This menu is to be invoked individually for each denomination.

 In the above screen one can observe the location code by default will be the logged in user code

 we can edit the location code and select the user location code by selecting from the searcher as shown

 

Then selet the particular location code ( employee code ) from the list of users as shown

Then click on submit and view the report in HPR as shown.

HISR means Inventory Status Report -EM

• Thie menu is used to view the status of the inventory position of that particular employee only or same location.
• This menu is used to view the inventory status report of the same location or same user in which the user logged in.
• This menu is to be invoked individually for each denomination.
• Invoke the menu HISR then the system will display the screen as shown

Then clik on the searcher and select the inventory type from the list as shown

Then clcik on Submit and view the report in HPR.

HIMR means Inventory Movement Report

• This menu is used to view the inventory movement report i.e, movement of inventory from one location to another location from a particular period.
• This is a very hand menu to know how  much we have transferred from supervisor to counter and from DL to supervisor etc.
• This menu is to be invoked individually for each denomination.
• Invoke the menu HIMR then the system will display the screen as shown

Then eneter the followin details

1. Enter the From Transaction Date ____________
2. Select the Inventory class/type   ___________________
3. Select the from location class/code  ___________________
4. Select the To lacation class/code   ________________   as shown in the below figure

Then click on Submit and view the report in HPR as shown.

HIMI Inventory Movement Inquiry

• This menu is used to inquire the inventory movement between two locations where as in order to view the report and take print use HIMR as mentioned above.
• This is only inquiry menu we can't take the print for this menu.
• This menu is to be invoked individually for each denomination.
• Invoke the menu HIMI and enter the following details

1. Enter the Start  Date ____________
2. Select the Inventory class/type   ___________________
3. Select the from location class/code  ___________________
4. Select the To lacation class/code   ________________   as shown in the below figure

Then click on Go  then the system will show the movement between the given locations as shown

HIIA means Inventory Inquiry All

• This menu is inquiry the total inventory available at a particular location i..e, the system will display all the denominations
• The report can be viewed in same source location as well as different location i.e., we can view the report for any employee of that particular SOL.
• Invoke the menu HIIA then the system will display the screen as shown

Then click on the searcher and select the employee code you are trying to view the report and click on Go then the system will display the total inventory available at that user as shown in the below figure

Signature viewing menu in DOP Finacle

• n DOP Finacle we can check the signature and photograph of the customer for an account.
• Signature and photograph can be viewed by using the menu IES 
• The detailed procedure for viewing the signature and photograph is diplayed below.

IES means Inquire on Signatures

• Invoke the menu IES and the system will show the following screen shot

Then the system will show the number of fields as explained below in detailed

Click	To
Go	View the details in the Signature Inquiry Result screen.
Clear	Clear the data specified.

      

Field	Details
A/c. Type	Mandatory Drop-down Select or type the type of account. Valid Values: N-Normal A/c. W-WMS A/c. M-Master A/c.
A/c. ID	Optional Account Number Select or type the account number.
CIF ID	Optional Alphanumeric / 6 List Select or type the Customer Information File ID.
Employee ID	Optional Alphanumeric / 4 List Select or type the employee ID.
Bank Code	Optional Alphanumeric Type the bank code.
SOL ID	Optional Alphanumeric Type the Sol ID.
Image Access Code	Optional Alphanumeric / 17 List Select or type the image access code.
Signature Power No.	Optional Alphanumeric Type the signature power number.
Keyword	Optional Alphanumeric Type the keyword.
Signature Group Name	Optional Alphanumeric / 15 List Select or type the signature group name.
Signature Effective Form	Optional Date Select or type the date from which the signature is effective.
Signature Expires On	Optional Date Select or type the date up to which the signature is effective.
Transaction Sub Type	Optional Drop-down Select or type the transaction sub type. Valid Values: Normal Payment Normal Receipt Cash Transfer ECS Outward Transaction ECS Inward Transaction Inward Clearing Outward Clearing Customer Included Bank Included
Transaction Type Indicator	Optional Drop-down Select or type the transaction type indicator. Valid Values: D-Debit C-Credit
Transaction Type	Optional Drop-down Select or type the type of transaction Valid Values: C-Cash L-Clearing T-Transfer
Transaction Amt.	Optional Amount Type the transaction amount.

• Enter the account number and CIF ID as shown in the below figure

Then click on Go then the system display the following screen as mentioned below

Then click on Signature and photograph then the system will show the below screen

• There is also another menu option VSPH means View SIgnature and Photograoh but this menu is at present not working as desired So kindly opt for IES menu for signature and photograph of the customer.