Tuesday, 16 December 2014

Reversal procedure for excess commission recovery procedure in Finacle

Reversal procedure for excess commission recovery procedure in Finacle


This scenario will be faced in real scenario in the following situations. 

  • When an account is opened with a wrong agent instead of other agent.
  • When an agent account opened with wrong deposit amount
  • When an agent account opened with wrong date of opening(value date)

         In the above cases excess commission will be credited hence we have to reverse it.In order to do reversal first identify the transaction id by inquiring the wrongly credited agent SB account in the ledger click on transaction date you can find the transaction id note it and inquire in HFTI giving the from date and to date as transaction date.In HFTI you will get three part transactions
  1.   In first transaction SOLID+0251(system account) which is a commission account in finacle which will show total commission(with out deducting TDS) this is debit transaction(D)
  2. In second transaction agent SB account credited commission (after TDS deduction) this is credit transaction(C)
  3. IN third transaction SOLID+321(system account) which is TDS amount this is also credit transaction.(C)
           For information please find the excess commission credited error screen.



         Now we have to reverse the above transaction but as said above SOLID+0251 and SOLID+0321 are system accounts so we cannot perform reversal directly so we have to verify all the transactions and should log out all the users before EOD then send the error screen to DOP IT Chennai to make the said systemm accounts to convert as Non System accounts.Once you get approval from DOP IT use HTM constumer induced and do the reversal i.e

  1. First select credit  give SOLID+0251 and then amount as you noted this should be credit transaction(C)
  2. Then click on add select debit give agent SB account and amount this should be debit transaction (D)
  3. Then again click on add select debit give SOLID+0321 and amount this should be debit transaction(D)
        Then finally click on post note the transaction id and verify the same in supervisor login.

Then finally the most important activity is intimate that reversal has been done successfully message to DOP IT Chennai again to convert the said system accounts which was perviously made as non system accounts.

     Once you get confirmation from DOP IT Chennai you can start EOD.

Courtesy : http://pofinacleguide.blogspot.in/

SANCHAY POST DATABASE UPGRADE PATCHES FROM VERSION 6.5

Sanchay Post Database Up-Gradation

Sanchay Post Patches for database up-gradation 

Download Patches For Upgrade DB Version From 6.5 To 7.5

KVP Patches And SP5 Folder

Thanks Rajesh

PRECAUTIONS TO BE FOLLOWED WHILE OPENING AN ACCOUNT IN DOP FINACLE

PRECAUTIONS TO BE FOLLOWED WHILE OPENING AN ACCOUNT

The following observations I have while opening an account in Finacle.I want to share with you which will be really handy when we are in a real scenario.The following that can't be changed after opening an account by the counter PA but even before verification by the supervisor.They are as follows:-
  • CIF id can't be changed.
  • Amount can't be changed.
  • Agent can't be selected.
  • Value date can't be changed.
  • Agent can't be modified.

CIF ID ENTERED WRONG SCENARIO

CIF id once entered at the time opening an account will not be changed even we invoke the respective modification before verification menu.
If any problem persists then we need to merge the CIF id and change the name of the account at the account level by using the menu HAALM (supervisor menu).

DEPOSIT AMOUNT WRONG SCENARIO

The deposit amount once entered will not be changed even in modification before verification menu also we can't change the deposit amount.

The only solution for this is make an error entry and close the account as "Exceptional Closure" after obtaining the approval only.

Again open the account with the correct deposit amount.

AGENT NOT SELECTED SCENARIO

When the counter PA opened an account without selecting the agent then even we invoke the menu modification before verification then the system will not allow.

The only solution for this is make an error entry and close the account as "Exceptional Closure" after obtaining the approval only.

Again open the account by selecting the agent.

WRONG AGENT SELECTED SCENARIO

When the counter PA opened an account by selecting the wrong agent and even we try modification before verification then the system will not allow to modify.

The only solution for this is make an error entry and close the account as "Exceptional Closure" after obtaining the approval only.

Also in the above closed account the counter PA selected the wrong agent so commission will be credited to wrong agent so reverse it for reversal procedure click here.

Again open the account with the correct agent.

VALUE DATE WRONG SCENARIO

When the counter PA opened an account with wrong Value date and even we try modification before verification then the system will not allow to modify.

The only solution for this is make an error entry and close the account as "Exceptional Closure" after obtaining the approval only.

If the above closed account is linked to agent the commission will be credited to agent SB account so we have to reverse it for reversing procedure click here.

Again open the account with the correct value date.

The above scenarios are very important when we are opening an account in real scenario so the counter PA should be very careful to avoid mistakes.Note that without error entry and approval don't close any account for the above said scenarios.
Thanks to http://pofinacleguide.blogspot.in

Monday, 15 December 2014

SQL DATA BASE RECOVERY TOOL FOR POST OFFICE

DB Recovery Tool By Dinesh

A handy tool to recover your corrupt database using queries!
It helps you to recover you corrupt SQL database using queries mentioned in it. A backup is obviously preferred but if that doesn't work, this tool may help you! Click here to download it or click here for latest updates.
  • Click Config Button to configure your Server details and restart the application. 
  • Then select any of the Database listed below or check "None of Below DB" to enter database name manually. 
  • First Check the status of database clicking Status and Check Button (using DBCC Check Command). 
  • Then click Recover button to recover database. All the queries have been given in About form (Click About Link). 
  • Various database status has been explained under "?" button and for SQL proficient User advance mode has also given if none of the other options in tools recover the database. 
  • Write me back if you find it useful.

Download DB Recovery Tool


Download

Developed by Dinesh Kumar Asotra, System Manager Una

DPT FIX VERSION 4.1 DOWNLOAD FROM GOOGLE DRIVE

DPT Fix V4.1 Download

Developed by Rajesh C R Version : 4.1 dated 12.12.2014

 More Options Are Added

  • RD Unpaid Default fee in DB Analyzer Discrepancies
  • RD Paid Unpaid DF in DBA.
  • RD Mismatch in month count.
  • Account Linked as agent but not having agent details.
Special Characters in name and address fields.

Download DPT Fix V4.1

NOT ABLE TO OPEN NEW ACCOUNT IN TD DATA ENTRY MODULE

Problem With TD Data Entry V7.5 Patch 8.1

After Update Patch 5 or Patch 6 or Patch 8 or Patch 8.1
  • Not able to Open New Account.
  • Could not click on Amount field.

Solution : TD Data Entry

In Sanchay Post 7.5 after service pack 1 update we are unable to access TD Data entry.

  • Use Data Entry Module alone in Sanchay Post 7.5
Note: This is only for TD Data Entry

Download