-------------SALE BILL
SELECT BillNo, ItemAmount + ItemAddAmt + PackCharge + TransCharge + AddLess1Amt + AddLess2Amt - RDAmt - LessAmt - ItemDiscAmt AS TAXABLE, IGSTPerc, ROUND((ItemAmount + ItemAddAmt + PackCharge + TransCharge + AddLess1Amt + AddLess2Amt - RDAmt - LessAmt - ItemDiscAmt) * IGSTPerc / 100, 2) AS CALCGST, IGSTAmt FROM BILL_ITEM_DETAIL WHERE (ROUND((ItemAmount + ItemAddAmt + PackCharge + TransCharge + AddLess1Amt + AddLess2Amt - RDAmt - LessAmt - ItemDiscAmt) * IGSTPerc / 100, 2) <> IGSTAmt) AND (IGSTPerc <> 0)
SELECT BillNo, ItemAmount + ItemAddAmt + PackCharge + TransCharge + AddLess1Amt + AddLess2Amt - RDAmt - LessAmt - ItemDiscAmt AS TAXABLE, CGSTPerc, ROUND((ItemAmount + ItemAddAmt + PackCharge + TransCharge + AddLess1Amt + AddLess2Amt - RDAmt - LessAmt - ItemDiscAmt) * CGSTPerc / 100, 2) AS CALCGST, CGSTAmt FROM BILL_ITEM_DETAIL WHERE (ROUND((ItemAmount + ItemAddAmt + PackCharge + TransCharge + AddLess1Amt + AddLess2Amt - RDAmt - LessAmt - ItemDiscAmt) * CGSTPerc / 100, 2) <> CGSTAmt) AND (CGSTPerc <> 0)
SELECT BillNo, ItemAmount + ItemAddAmt + PackCharge + TransCharge + AddLess1Amt + AddLess2Amt - RDAmt - LessAmt - ItemDiscAmt AS TAXABLE, SGSTPerc, ROUND((ItemAmount + ItemAddAmt + PackCharge + TransCharge + AddLess1Amt + AddLess2Amt - RDAmt - LessAmt - ItemDiscAmt) * SGSTPerc / 100, 2) AS CALSGST, SGSTAmt FROM BILL_ITEM_DETAIL WHERE (ROUND((ItemAmount + ItemAddAmt + PackCharge + TransCharge + AddLess1Amt + AddLess2Amt - RDAmt - LessAmt - ItemDiscAmt) * SGSTPerc / 100, 2) <> SGSTAmt) AND (SGSTPerc <> 0)

-------------GREY PURCHASE
SELECT SrNo, ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt AS TAXABLE, IGSTPerc, ROUND((ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt) * IGSTPerc / 100, 2) AS CALCGST, IGSTAmt FROM GREY_PURCHASE_ITEM_DETAIL WHERE (ROUND((ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt) * IGSTPerc / 100, 2) <> IGSTAmt) AND (IGSTPerc <> 0)
SELECT SrNo, ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt AS TAXABLE, CGSTPerc, ROUND((ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt) * CGSTPerc / 100, 2) AS CALCGST, CGSTAmt FROM GREY_PURCHASE_ITEM_DETAIL WHERE (ROUND((ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt) * CGSTPerc / 100, 2) <> CGSTAmt) AND (CGSTPerc <> 0)
SELECT SrNo, ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt AS TAXABLE, SGSTPerc, ROUND((ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt) * SGSTPerc / 100, 2) AS CALSGST, SGSTAmt FROM GREY_PURCHASE_ITEM_DETAIL WHERE (ROUND((ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt) * SGSTPerc / 100, 2) <> SGSTAmt) AND (SGSTPerc <> 0)

-------------FINISHED PURCHASE
SELECT SrNo, ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt AS TAXABLE, IGSTPerc, ROUND((ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt) * IGSTPerc / 100, 2) AS CALCGST, IGSTAmt FROM FINISHED_PURCHASE_ITEM_DETAIL WHERE (ROUND((ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt- ItemDiscAmt) * IGSTPerc / 100, 2) <> IGSTAmt) AND (IGSTPerc <> 0)
SELECT SrNo, ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt AS TAXABLE, CGSTPerc, ROUND((ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt) * CGSTPerc / 100, 2) AS CALCGST, CGSTAmt FROM FINISHED_PURCHASE_ITEM_DETAIL WHERE (ROUND((ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt- ItemDiscAmt) * CGSTPerc / 100, 2) <> CGSTAmt) AND (CGSTPerc <> 0)
SELECT SrNo, ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt AS TAXABLE, SGSTPerc, ROUND((ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt - ItemDiscAmt) * SGSTPerc / 100, 2) AS CALSGST, SGSTAmt FROM FINISHED_PURCHASE_ITEM_DETAIL WHERE (ROUND((ItemAmount + ItemAddAmt + AddLess1Amt + AddLess2Amt- ItemDiscAmt) * SGSTPerc / 100, 2) <> SGSTAmt) AND (SGSTPerc <> 0)

-------------GENERAL PURCHASE
SELECT SrNo, ItemAmount + ItemAddAmt - ItemDiscAmt AS TAXABLE, IGSTPerc, ROUND((ItemAmount + ItemAddAmt - ItemDiscAmt) * IGSTPerc / 100, 2) AS CALCGST, IGSTAmt FROM GENERAL_PURCHASE_ITEM_DETAIL WHERE (ROUND((ItemAmount + ItemAddAmt- ItemDiscAmt) * IGSTPerc / 100, 2) <> IGSTAmt) AND (IGSTPerc <> 0)
SELECT SrNo, ItemAmount + ItemAddAmt - ItemDiscAmt AS TAXABLE, CGSTPerc, ROUND((ItemAmount + ItemAddAmt - ItemDiscAmt) * CGSTPerc / 100, 2) AS CALCGST, CGSTAmt FROM GENERAL_PURCHASE_ITEM_DETAIL WHERE (ROUND((ItemAmount + ItemAddAmt- ItemDiscAmt) * CGSTPerc / 100, 2) <> CGSTAmt) AND (CGSTPerc <> 0)
SELECT SrNo, ItemAmount + ItemAddAmt - ItemDiscAmt AS TAXABLE, SGSTPerc, ROUND((ItemAmount + ItemAddAmt - ItemDiscAmt) * SGSTPerc / 100, 2) AS CALSGST, SGSTAmt FROM GENERAL_PURCHASE_ITEM_DETAIL WHERE (ROUND((ItemAmount + ItemAddAmt- ItemDiscAmt) * SGSTPerc / 100, 2) <> SGSTAmt) AND (SGSTPerc <> 0)