Latest version of DPT will found the following discrepancies and it may be cleared by using the below mentioned query properly by System Administrator
Description : Discrepancies may occur due to 0 amount transaction is made in Deposit / Withdrawal not in Interest.
Solution Query
use post
delete from dcl.ledger
where amount='0' and transtype in ('DP','WP')
- Take Necessary Backup before executing the above query
- It should be executed by System Administrator.
Note : Author of Blog / Query developer is not responsible for any data losses / corruption . It should be executed by SA after taking the backup of concerned database(s).
0 comments:
Post a Comment
Click to see the code!
To insert emoticon you must added at least one space before the code.