update TblAccounting set billtype='Credit' where (AcCode='116' or AcCode='95100' or AcCode='95300') and VoucherNo='1101' and Type='Sales' update TblAccounting set billtype='Credit' where (AcCode='118' or AcCode='95100' or AcCode='95300') and VoucherNo='1040' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='118' or AcCode='95100' or AcCode='95300')and VoucherNo='1041' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='115' or AcCode='95100' or AcCode='95300') and VoucherNo='1045' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='105' or AcCode='95100' or AcCode='95300')and VoucherNo='1052' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='108' or AcCode='95100' or AcCode='95300') and VoucherNo='1057' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='108' or AcCode='95100' or AcCode='95300') and VoucherNo='1056' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='110' or AcCode='95100' or AcCode='95300') and VoucherNo='1055' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='117' or AcCode='95100' or AcCode='95300') and VoucherNo='1059' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='115' or AcCode='95100' or AcCode='95300') and VoucherNo='1065' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='129' or AcCode='95100' or AcCode='95300') and VoucherNo='1067' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='108' or AcCode='95100' or AcCode='95300') and VoucherNo='1084' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='108' or AcCode='95100' or AcCode='95300') and VoucherNo='1083' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='103' or AcCode='95100' or AcCode='95300') and VoucherNo='1078' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='102' or AcCode='95100' or AcCode='95300') and VoucherNo='1011' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='118' or AcCode='95100' or AcCode='95300') and VoucherNo='1091' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='119' or AcCode='95100' or AcCode='95300') and VoucherNo='1099' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='116' or AcCode='95100' or AcCode='95300') and VoucherNo='1050' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='108' or AcCode='95100' or AcCode='95300') and VoucherNo='1042' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='102' or AcCode='95100' or AcCode='95300') and VoucherNo='1082' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='102' or AcCode='95100' or AcCode='95300') and VoucherNo='1111' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='129' or AcCode='95100' or AcCode='95300') and VoucherNo='1114' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='126' or AcCode='95100' or AcCode='95300') and VoucherNo='1116' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='129' or AcCode='95100' or AcCode='95300') and VoucherNo='1118' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='134' or AcCode='95100' or AcCode='95300') and VoucherNo='1112' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='134' or AcCode='95100' or AcCode='95300') and VoucherNo='1141' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='103' or AcCode='95100' or AcCode='95300') and VoucherNo='1140' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='103' or AcCode='95100' or AcCode='95300') and VoucherNo='1143' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='103' or AcCode='95100' or AcCode='95300') and VoucherNo='1142' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='103' or AcCode='95100' or AcCode='95300') and VoucherNo='1125' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='108' or AcCode='95100' or AcCode='95300') and VoucherNo='1161' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='131' or AcCode='95100' or AcCode='95300') and VoucherNo='1117' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='131' or AcCode='95100' or AcCode='95300') and VoucherNo='1137' and Type='Sales'; update TblAccounting set billtype='Credit' where (AcCode='138' or AcCode='95100' or AcCode='95300') and VoucherNo='1146' and Type='Sales';