update TblAccounting set AcCode='10002' where type='Sales' and billtype='Bank' and AcCode is null;

update TblAccounting set AcCode='10000' where type='Sales' and billtype='Cash' and AcCode is null;

update TblAccounting set AcCode='10002' where type='Return' and billtype='Bank' and AcCode='10000';