use t23m001

select * from finished_purchase_return_goods_addless_detail where bkitemamt=0 and (igstamt+cgstamt+sgstamt+utgstamt+CESSAmt<>0)



USE T24B001

select * from finished_purchase_return_goods_addless_detail where bkitemamt=0 and (igstamt+cgstamt+sgstamt+utgstamt+CESSAmt<>0)


select * from finished_purchase_return_goods_addless_detail WHERE CGSTAMT<>SGSTAMT
select * from MULTI_JOURNAL_ADDLESS_DETAIL WHERE CGSTAMT<>SGSTAMT
select * from FINISHED_PURCHASE_ITEM_DETAIL WHERE CGSTAMT<>SGSTAMT

SELECT SUM(t1.f1), t1.f2 from (
SELECT SUM(FLDAMOUNT) as f1,FormSrNo as f2 FROM FIRM_ADDLESS_DETAIL WHERE (FLDNAME = 'CGST') AND FORMNAME = 'FINISHED PURCHASE' GROUP BY FormSrNo 
UNION
SELECT -SUM(FLDAMOUNT) as f1,FormSrNo as f2 FROM FIRM_ADDLESS_DETAIL WHERE (FLDNAME = 'SGST') AND FORMNAME = 'FINISHED PURCHASE' GROUP BY FormSrNo
) as t1 group by f2 having sum(t1.f1)<>0