use E19A002

SELECT * FROM SCAN_BALANCE_SHEET WHERE DEBITACC=''


USE E22K001


UPDATE RECEIVED_RETURN_GOODS_DETAIL SET SaleRtnType ='21LO001'

SELECT * FROM SCAN_BALANCE_SHEET WHERE CREDITACC='' OR DEBITACC=''+




use E25S003
update account_master set accopenbal = 0 where accopenbal  is null
update account_master set accopenbalcrdr= 'Cr' where accopenbalcrdr is null
update account_master set accshareperc= 0 where accshareperc is null