use T24S001

use T23S001

select * from FINISHED_ITEM_MASTER


SELECT FINISHED_ITEM_MASTER.DescGST, FINISHED_ITEM_MASTER.ItemName, SUM(BILL_ITEM_DETAIL.ItemPcs) AS ItemPcs, SUM(BILL_ITEM_DETAIL.ItemMts) AS ItemMts, MONTH(BILL_DETAIL.BillDate) AS Expr1 FROM BILL_ITEM_DETAIL INNER JOIN FINISHED_ITEM_MASTER ON FINISHED_ITEM_MASTER.ItemName = BILL_ITEM_DETAIL.ItemName INNER JOIN BILL_DETAIL ON BILL_ITEM_DETAIL.BillNo = BILL_DETAIL.BillNo GROUP BY FINISHED_ITEM_MASTER.DescGST, FINISHED_ITEM_MASTER.ItemName, MONTH(BILL_DETAIL.BillDate) HAVING (FINISHED_ITEM_MASTER.DescGST = 'SYNTHETIC SAREE') AND (MONTH(BILL_DETAIL.BillDate) <>0)


SELECT     FINISHED_ITEM_MASTER.DescGST, FINISHED_ITEM_MASTER.ItemName, SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkPcs) AS ItemPcs, 
                      SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkMts) AS ItemMts, SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkBillGRAmt) AS ITEMAMT, 
                      RECEIVED_RETURN_GOODS_DETAIL.BkGRDate, RECEIVED_RETURN_GOODS_DETAIL.BkSrNo
FROM         FINISHED_ITEM_MASTER INNER JOIN
                      RECEIVED_RETURN_GOODS_ITEM_DETAIL ON FINISHED_ITEM_MASTER.ItemName = RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkItemName INNER JOIN
                      RECEIVED_RETURN_GOODS_DETAIL ON RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo = RECEIVED_RETURN_GOODS_DETAIL.BkSrNo
GROUP BY FINISHED_ITEM_MASTER.DescGST, FINISHED_ITEM_MASTER.ItemName, RECEIVED_RETURN_GOODS_DETAIL.BkGRDate, 
                      RECEIVED_RETURN_GOODS_ITEM_DETAIL.HSNCode, RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkPer, 
                      RECEIVED_RETURN_GOODS_ITEM_DETAIL.IGSTAmt + RECEIVED_RETURN_GOODS_ITEM_DETAIL.CGSTAmt, RECEIVED_RETURN_GOODS_DETAIL.BkSrNo
HAVING      (FINISHED_ITEM_MASTER.DescGST = 'SYNTHETIC SAREE') AND (RECEIVED_RETURN_GOODS_DETAIL.BkGRDate <> 0) AND 
                      (RECEIVED_RETURN_GOODS_ITEM_DETAIL.HSNCode = '540752') AND (RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkPer = 'P') AND 
                      (RECEIVED_RETURN_GOODS_ITEM_DETAIL.IGSTAmt + RECEIVED_RETURN_GOODS_ITEM_DETAIL.CGSTAmt = 0)
SELECT * FROM RECEIVED_RETURN_GOODS_ITEM_DETAIL

SELECT     RECEIVED_RETURN_GOODS_DETAIL.BkSrNo, RECEIVED_RETURN_GOODS_DETAIL.BkAccCode, SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkPcs) AS Expr2, 
                      MONTH(RECEIVED_RETURN_GOODS_DETAIL.BkGRDate) AS Expr1, RECEIVED_RETURN_GOODS_ITEM_DETAIL.HSNCode
FROM         RECEIVED_RETURN_GOODS_DETAIL INNER JOIN
                      RECEIVED_RETURN_GOODS_ITEM_DETAIL ON RECEIVED_RETURN_GOODS_DETAIL.BkSrNo = RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo
GROUP BY RECEIVED_RETURN_GOODS_DETAIL.BkSrNo, RECEIVED_RETURN_GOODS_DETAIL.BkAccCode, MONTH(RECEIVED_RETURN_GOODS_DETAIL.BkGRDate), 
                      RECEIVED_RETURN_GOODS_ITEM_DETAIL.HSNCode
HAVING      (MONTH(RECEIVED_RETURN_GOODS_DETAIL.BkGRDate) <>0)

SELECT     SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkMts) AS Expr1
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     (RECEIVED_RETURN_GOODS_ITEM_DETAIL.HSNCode = '540752') AND (LEN(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo) = 6) AND 
                      (RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkPer = 'P')
GROUP BY MONTH(RECEIVED_RETURN_GOODS_DETAIL.BkGRDate)
HAVING      (MONTH(RECEIVED_RETURN_GOODS_DETAIL.BkGRDate) <>0)




-------------tally hsn item detail wise qury



SELECT        SUM(BILL_ITEM_DETAIL.Itempcs) AS Expr3, SUM(BILL_ITEM_DETAIL.ItemAmount) AS Expr1, SUM(BILL_ITEM_DETAIL.IGSTAmt + BILL_ITEM_DETAIL.CGSTAmt + BILL_ITEM_DETAIL.SGSTAmt) AS Expr2
FROM            BILL_ITEM_DETAIL INNER JOIN
                         FINISHED_ITEM_MASTER ON BILL_ITEM_DETAIL.ItemName = FINISHED_ITEM_MASTER.ItemName
WHERE        (BILL_ITEM_DETAIL.BillNo IN
                             (SELECT        BillNo
                               FROM            BILL_DETAIL
                               WHERE        (MONTH(BillDate) = 11) AND (GSTSupplyType = 'UNREGISTERED'))) AND (FINISHED_ITEM_MASTER.DescGST = '')



SELECT        *
FROM            BILL_ITEM_DETAIL INNER JOIN
                         FINISHED_ITEM_MASTER ON BILL_ITEM_DETAIL.ItemName = FINISHED_ITEM_MASTER.ItemName
WHERE        (BILL_ITEM_DETAIL.BillNo IN
                             (SELECT        BillNo
                               FROM            BILL_DETAIL
                               WHERE        (MONTH(BillDate) = 11) AND (GSTSupplyType = 'UNREGISTERED'))) AND (FINISHED_ITEM_MASTER.DescGST = '')

SELECT        sum(igstamt)
FROM            BILL_ITEM_DETAIL INNER JOIN
                         FINISHED_ITEM_MASTER ON BILL_ITEM_DETAIL.ItemName = FINISHED_ITEM_MASTER.ItemName
WHERE        (BILL_ITEM_DETAIL.BillNo IN
                             (SELECT        BillNo
                               FROM            BILL_DETAIL
                               WHERE        (MONTH(BillDate) = 11) AND (GSTSupplyType = 'UNREGISTERED'))) AND (FINISHED_ITEM_MASTER.DescGST = '')



------------------------------------------------------------------------------------------------------------------------------------------------

SELECT     MONTH(MULTI_JOURNAL_ADDLESS_DETAIL.JVDate) AS Expr1, MULTI_JOURNAL_ADDLESS_DETAIL.HSNCode
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) <>0) AND (MULTI_JOURNAL_ADDLESS_DETAIL.HSNCode = '580137')