USE T202324



SELECT * FROM RECEIVED_DETAIL WHERE LEN(RECSRNO)=6 AND RECDATE<'2022-04-01' ORDER BY RECDATE


SELECT * FROM PURCHASE_DETAIL WHERE SuppBillDate<'2022-04-01'





select * from received_detail where len(recsrno)=10 and recdate>='2023-04-01' order by recdate
select * from received_detail where len(recsrno)=6 and recdate<'2023-04-01' order by recdate

select * from return_goods_detail where len(rtnsrno)=10 and rtndate>='2023-04-01' order by RtnDate
select * from return_goods_detail where len(rtnsrno)=6 and rtndate<'2023-04-01' order by RtnDate




----Check Fake Bill Adjusted In Payment And Return

SELECT     *
FROM         RECEIVED_DETAIL INNER JOIN
                      RECEIVED_ADDLESS_DETAIL ON RECEIVED_DETAIL.RecSrNo = RECEIVED_ADDLESS_DETAIL.RecSrNo
where (RECEIVED_DETAIL.RecCustCode = '22DH001') AND (RECEIVED_DETAIL.RecSuppCode = '22CJ004') and 
RECEIVED_DETAIL.RecCustCode+':'+ RECEIVED_DETAIL.RecSuppCode+':'+ RECEIVED_ADDLESS_DETAIL.RecBillNo not in 
(select  vouCustCode+':'+ vouSuppCode+':'+ suppBillNo from opening_purchase_detail UNION select  vouCustCode+':'+ vouSuppCode+':'+ suppBillNo from purchase_detail )

SELECT     *
FROM         RETURN_GOODS_DETAIL INNER JOIN
                      RETURN_GOODS_ADDLESS_DETAIL ON RETURN_GOODS_DETAIL.rTNSrNo = RETURN_GOODS_ADDLESS_DETAIL.RTNSrNo
where (RETURN_GOODS_DETAIL.RTNCustCode = '22DH001') AND (RETURN_GOODS_DETAIL.RTNSuppCode = '22CJ004') and 
RETURN_GOODS_DETAIL.RTNCustCode+':'+ RETURN_GOODS_DETAIL.RTNSuppCode+':'+ RETURN_GOODS_ADDLESS_DETAIL.RTNBillNo not in 
(select  vouCustCode+':'+ vouSuppCode+':'+ suppBillNo from opening_purchase_detail UNION select  vouCustCode+':'+ vouSuppCode+':'+ suppBillNo from purchase_detail )