select sum(igstamt), sum(cgstamt), sum(sgstamt) from bill_item_detail where billno in (select billno from bill_detail where month(billdate)=1)

SELECT * FROM ACCOUNT_MASTER WHERE ACCCITYNAME NOT IN (SELECT CITYNAME FROM CITY_MASTER)

select sum(igstamt), sum(cgstamt), sum(sgstamt)  from RECEIVED_RETURN_GOODS_ITEM_DETAIL where BkSrNo in (select BkSrNo from received_return_goods_detail where month(bkgrdate)=1 and LEN(BkSrNo)=6)

SELECT     SUM(MULTI_JOURNAL_ADDLESS_DETAIL.IGSTAmt) AS Expr1, SUM(MULTI_JOURNAL_ADDLESS_DETAIL.CGSTAmt) AS Expr2, 
                      SUM(MULTI_JOURNAL_ADDLESS_DETAIL.SGSTAmt) AS Expr3, MULTI_JOURNAL_DETAIL.GSTSupplyType, MULTI_JOURNAL_DETAIL.JVType
FROM         MULTI_JOURNAL_ADDLESS_DETAIL INNER JOIN
                      MULTI_JOURNAL_DETAIL ON MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo = MULTI_JOURNAL_DETAIL.BkSrNo
WHERE     (MONTH(MULTI_JOURNAL_ADDLESS_DETAIL.JVDate) = 1) AND (LEN(MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo) = 6)
GROUP BY MULTI_JOURNAL_DETAIL.GSTSupplyType, MULTI_JOURNAL_DETAIL.JVType

SELECT * FROM COMPANY_DETAIL
SELECT     MULTI_JOURNAL_DETAIL.BkSrNo, MULTI_JOURNAL_DETAIL.BkAccCode, MULTI_JOURNAL_DETAIL.BkDrCr, MULTI_JOURNAL_DETAIL.BkCurDate, 
                      MULTI_JOURNAL_DETAIL.BkUname, MULTI_JOURNAL_DETAIL.JVType, MULTI_JOURNAL_DETAIL.GSTSupplyType
FROM         MULTI_JOURNAL_DETAIL INNER JOIN
                      ACCOUNT_MASTER ON ACCOUNT_MASTER.AccCode = MULTI_JOURNAL_DETAIL.BkAccCode INNER JOIN
                      CITY_MASTER ON CITY_MASTER.CityName = ACCOUNT_MASTER.AccCityName INNER JOIN
                      MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo = MULTI_JOURNAL_DETAIL.BkSrNo
WHERE     (CITY_MASTER.StateName = 'RAJASTHAN') AND (MULTI_JOURNAL_DETAIL.GSTSupplyType = 'UNREGISTERED') AND 
                      (MONTH(MULTI_JOURNAL_ADDLESS_DETAIL.JVDate) = 3)



SELECT    SUM(MULTI_JOURNAL_ADDLESS_DETAIL.BkBillPaidAmt)
FROM         MULTI_JOURNAL_DETAIL INNER JOIN
                      ACCOUNT_MASTER ON ACCOUNT_MASTER.AccCode = MULTI_JOURNAL_DETAIL.BkAccCode INNER JOIN
                      CITY_MASTER ON CITY_MASTER.CityName = ACCOUNT_MASTER.AccCityName INNER JOIN
                      MULTI_JOURNAL_ADDLESS_DETAIL ON MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo = MULTI_JOURNAL_DETAIL.BkSrNo
WHERE     (CITY_MASTER.StateName = 'RAJASTHAN') AND (MULTI_JOURNAL_DETAIL.GSTSupplyType = 'UNREGISTERED') AND 
                      (MONTH(MULTI_JOURNAL_ADDLESS_DETAIL.JVDate) = 3) 

select sum(igstamt), sum(cgstamt), sum(sgstamt) from bill_item_detail where billno in (select billno from bill_detail where month(billdate)=1)


SELECT * FROM OPENING_BILL_DETAIL WHERE GSTAMT<>0


SELECT * FROM BILL_ITEM_DETAIL WHERE BILLNO IN (SELECT BILL_DETAIL.BillNo FROM BILL_DETAIL INNER JOIN ACCOUNT_MASTER ON ACCOUNT_MASTER.AccCode = BILL_DETAIL.CustCode INNER JOIN CITY_MASTER ON BILL_DETAIL.TransDespStation = CITY_MASTER.CityName WHERE (CITY_MASTER.StateName = 'GUJARAT')) AND IGSTAmt<>0
SELECT * FROM BILL_ITEM_DETAIL WHERE BILLNO IN (SELECT BILL_DETAIL.BillNo FROM BILL_DETAIL INNER JOIN ACCOUNT_MASTER ON ACCOUNT_MASTER.AccCode = BILL_DETAIL.CustCode INNER JOIN CITY_MASTER ON BILL_DETAIL.TransDespStation = CITY_MASTER.CityName WHERE (CITY_MASTER.StateName <> 'GUJARAT')) AND IGSTAmt=0
SELECT * FROM RECEIVED_RETURN_GOODS_ADDLESS_DETAIL WHERE BkBillNo NOT IN (SELECT BillNo FROM BILL_DETAIL UNION SELECT BillNo FROM OPENING_BILL_DETAIL) AND BkBillNo<>'' 

SELECT * FROM multi_journal_addless_detail WHERE (IGSTAmt=0 AND CGSTAmt=0) and len(bksrno) = 6 and month(JVDate)=1
SELECT * FROM bill_item_detail WHERE (IGSTAmt=0 AND CGSTAmt=0) or cgstamt<>sgstamt

select * from RECEIVED_RETURN_GOODS_ADDLESS_DETAIL where len(bksrno)=6 and bkbillno='028454/S'


select BkBillPaidAmt,BkBillPaidAmt * 0.05,IGSTAmt  from multi_journal_addless_detail where month(jvdate)=9 and len(bksrno)=6 and hsncode = '630790'

SELECT     sum(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkBillGRAmt), sum(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkBillGRAmt*0.05), sum(RECEIVED_RETURN_GOODS_ITEM_DETAIL.igstamt)
FROM         RECEIVED_RETURN_GOODS_ITEM_DETAIL INNER JOIN
                      RECEIVED_RETURN_GOODS_DETAIL ON RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo = RECEIVED_RETURN_GOODS_DETAIL.BkSrNo
WHERE     (LEN(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo) = 6)and MONTH(BkGRDate)=9 and HSNCode='630790'


SELECT     RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo, RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkBillGRAmt - RECEIVED_RETURN_GOODS_ITEM_DETAIL.ItemDiscAmt AS Expr2, 
                      (RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkBillGRAmt - RECEIVED_RETURN_GOODS_ITEM_DETAIL.ItemDiscAmt) * 0.05 AS Expr1, RECEIVED_RETURN_GOODS_ITEM_DETAIL.IGSTAmt
FROM         RECEIVED_RETURN_GOODS_ITEM_DETAIL INNER JOIN
                      RECEIVED_RETURN_GOODS_DETAIL ON RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo = RECEIVED_RETURN_GOODS_DETAIL.BkSrNo
WHERE     (LEN(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo) = 6) AND (MONTH(RECEIVED_RETURN_GOODS_DETAIL.BkGRDate) = 9) AND 
                      (RECEIVED_RETURN_GOODS_ITEM_DETAIL.HSNCode = '630790') 
                      and (RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkBillGRAmt - RECEIVED_RETURN_GOODS_ITEM_DETAIL.ItemDiscAmt)-((RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkBillGRAmt - RECEIVED_RETURN_GOODS_ITEM_DETAIL.ItemDiscAmt) * 0.05)<>0
                      
                    





SELECT * FROM TblGSTR_KING WHERE TotalValue+TaxableValue+IGSTAmt+CGSTAmt+SGSTAmt= 0





SELECT * FROM TblGSTR_KINGDATA WHERE HSN='58071090'