SB Account Opening Error in Sanchay Post...!!!

 While opening Account in Sanchay post, we will enter all details such as A/c type,  Depositor(s) name , address, introducer details, Deposit amount, passbook type  then we will click on OK button.( If it is HO we will enter  Nomination details also.)  Up to this your work will go smoothly. Finally you will click on Send buttion, then you will get a Message Box.

Error:
          Voilation of PRIMARY KEY constraint ‘PK_indexreg_25869641’. Cannot insert duplicate key in object  ‘indexreg’.

Reason:  
          Registration Number Initialization conflict.
Solution: 
           Set Proper Initialization as follows.
Login as Super visor.



Click on INITIALISATION group. Now you will get INITIALISATION FORMS List box , in that  choose   
   "SB – A/C, Nominee, AT Nos" Form and click on New-Form button.
Then you will get  “SB-A/C No, ………” window. It is  as follows.


Now click on "View" button.
 
In that window you will observe the following things
1)      How many blocks they  have allocated?
2)      What is the range ( Starting and ending values) of each block ?
3)      What is the Latest value of each block?
4)      What is the latest block (Based on Effective Date)
5)      Are all old blocks completely allocated? ( i.e., Old blocks  Latest value should be  their Ending Value itself .)
 
Coming to present scenario,
1)      We have 5 Blocks.
2)      Range of each block respectively, 700029-705900 ; 706100-707641; 201543-211764;  705901-706099;  707642-999999 .
3)      Latest value of each block respectively, 705753, 707641, 211764,706099, 707696
4)      Among all “ 707642-999999 “ is latest (i.e., Effective date 04/11/2011)
5)      Except   “700029-705900 “block remaining old blocks are completed. (Based on latest value).
Since we have 2 incomplete blocks, While generating A/c Number system will generate Conflict Error.
 
To over Come this Set the Latest value of incomplete old block as it’s ending value as  follows
Go to “SB-A/C No, ………” window, in that click on Modify Button.
Now go to required old Block and Change its Latest Value as it’s Ending value.
 
Now click on "Modify" button.
Now click on close button.
      To See the result you may use View button.
 
   Now login as Operator (i.e., Counter) , and you will successfully open an Account , without error.

 
Note:
1)If it is HO you will get Nomination Number also.
2)If your are not getting proper A/C no, Check the latest Number of Current Block and set it as most recent number.(This happens when you open A/C  through Dataentry Module).