Solution to SB Insequence Transactions Discrepency

1. The tool developped by Shri Manoj Patel was only modifying the sequence numbers from 01.04.2015.

So another query has been developped for modifying the sequence numbers from date of opening and also it will clear the discrepancy LEDGER ENTRY PRIOR to OPEN DATE.

2. Run the attached query.

YOUR PROBLEM IS SOLVED.

NB-TAKE BACKUP BEFORE PERFORMING THE ABOVE ACTIONS. 

Use with your own risk. AIPEUPHI or individuals are not responsible.

Download

Thanks to 

Manoj V Patel

M-9913750406 for his tool
&
Bibekananda Bisoyee
PA, Phulbani for his query.