use t22b001
----------SALE BILL ITEM DETAIL CHECK
SELECT     BILL_ITEM_DETAIL.HSNCode, FINISHED_ITEM_MASTER.DescGST, BILL_ITEM_DETAIL.ItemPer AS UQC, SUM(BILL_ITEM_DETAIL.ItemPcs) AS Qty, 
                      SUM(BILL_ITEM_DETAIL.ItemAmount - BILL_ITEM_DETAIL.RDAmt - BILL_ITEM_DETAIL.LessAmt - BILL_ITEM_DETAIL.ItemDiscAmt + BILL_ITEM_DETAIL.ItemAddAmt +
                       BILL_ITEM_DETAIL.PackCharge + BILL_ITEM_DETAIL.TransCharge + BILL_ITEM_DETAIL.AddLess1Amt + BILL_ITEM_DETAIL.AddLess2Amt + BILL_ITEM_DETAIL.IGSTAmt
                       + BILL_ITEM_DETAIL.CGSTAmt + BILL_ITEM_DETAIL.SGSTAmt + BILL_ITEM_DETAIL.UTGSTAmt + BILL_ITEM_DETAIL.CESSAmt) AS TotalValue, 
                      FINISHED_ITEM_MASTER.ItemQuality
FROM         BILL_DETAIL INNER JOIN
                      BILL_ITEM_DETAIL ON BILL_DETAIL.BillNo = BILL_ITEM_DETAIL.BillNo INNER JOIN
                      FINISHED_ITEM_MASTER ON BILL_ITEM_DETAIL.ItemName = FINISHED_ITEM_MASTER.ItemName
WHERE     (BILL_ITEM_DETAIL.HSNCode = '5407')
GROUP BY BILL_ITEM_DETAIL.HSNCode, FINISHED_ITEM_MASTER.DescGST, BILL_ITEM_DETAIL.ItemPer, FINISHED_ITEM_MASTER.ItemQuality
HAVING      (FINISHED_ITEM_MASTER.DescGST = 'SYNTHETIC FABRIC') AND (FINISHED_ITEM_MASTER.ItemQuality = 'FINISHED')
                      

-----------RETURN DETAIL ITEM DETAIL CHECK
SELECT     FINISHED_ITEM_MASTER.DescGST, RECEIVED_RETURN_GOODS_ITEM_DETAIL.HSNCode, SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkPcs) AS ItemPcs, 
                      SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkMts) AS ItemMts, SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkMts) AS ItemMts, 
                      SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkBillGRAmt) AS ItemAmount, RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkPer, 
                      SUM(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkBillGRAmt + RECEIVED_RETURN_GOODS_ITEM_DETAIL.ItemAddAmt + RECEIVED_RETURN_GOODS_ITEM_DETAIL.AddLess1Amt
                       + RECEIVED_RETURN_GOODS_ITEM_DETAIL.AddLess2Amt - RECEIVED_RETURN_GOODS_ITEM_DETAIL.ItemDiscAmt) AS Expr1
FROM         RECEIVED_RETURN_GOODS_ITEM_DETAIL INNER JOIN
                      FINISHED_ITEM_MASTER ON FINISHED_ITEM_MASTER.ItemName = RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkItemName
WHERE     (LEN(RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkSrNo) = 6)
GROUP BY FINISHED_ITEM_MASTER.DescGST, RECEIVED_RETURN_GOODS_ITEM_DETAIL.HSNCode, RECEIVED_RETURN_GOODS_ITEM_DETAIL.BkPer
HAVING      (FINISHED_ITEM_MASTER.DescGST = 'SYNTHETIC FABRIC') AND (RECEIVED_RETURN_GOODS_ITEM_DETAIL.HSNCode = '5407')



SELECT     SUM(MULTI_JOURNAL_ADDLESS_DETAIL.BkBillPaidAmt) AS Expr2, MULTI_JOURNAL_ADDLESS_DETAIL.HSNCode, MULTI_JOURNAL_DETAIL.JVType
FROM         MULTI_JOURNAL_ADDLESS_DETAIL INNER JOIN
                      MULTI_JOURNAL_DETAIL ON MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo = MULTI_JOURNAL_DETAIL.BkSrNo INNER JOIN
                      MULTI_JOURNAL_DETAIL AS MULTI_JOURNAL_DETAIL_1 ON MULTI_JOURNAL_ADDLESS_DETAIL.BkSrNo = MULTI_JOURNAL_DETAIL_1.BkSrNo
GROUP BY MULTI_JOURNAL_ADDLESS_DETAIL.HSNCode, MULTI_JOURNAL_DETAIL.JVType
HAVING      (MULTI_JOURNAL_ADDLESS_DETAIL.HSNCode = '5407') and (MULTI_JOURNAL_DETAIL.JVType='CREDIT NOTE ON SALE' or MULTI_JOURNAL_DETAIL.JVType='DEBIT NOTE ON SALE')