GO
/****** Object:  StoredProcedure [dbo].[sp_SelectReceiptEntryPrint]    Script Date: 13-04-2025 12:23:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[sp_SelectReceiptEntryPrint]      
(      
@VoucherNo varchar(100)     
)      
as      
begin      
      
SELECT      CustomerReceipt.VoucherNo,CustomerReceipt.PaidDate,CustomerReceipt.TotAmount as NetAmt,CustomerReceipt.CustomerCode, CustomerReceipt.CustomerName,  
            CustomerReceipt.Account,CustomerReceipt.AccountCode,CustomerReceipt.ChequeNo,CustomerReceipt.ChequeDate,  
            CustomerReceiptDetail.InvoiceNo,CustomerReceiptDetail.InvoiceAmount,CustomerReceiptDetail.ReceivedAmount,  
            CustomerReceiptDetail.BalanceAmount,CustomerReceiptDetail.PaidDate as CustPaidDate,  
            CustomerReceiptDetail.Narration,CustomerReceipt.bank,isnull(rvno,'')as Rvno,CASE WHEN isnull(Advance,'')='1' THEN 'Y' ELSE 'N' END AS Advance,CustomerReceipt.narration as finalNarration
			,CustomerReceipt.PayMode
            FROM         CustomerReceipt  
LEFT JOIN    CustomerReceiptDetail on CustomerReceipt.VoucherNo=CustomerReceiptDetail.VoucherNo  
where     CustomerReceipt.VoucherNo=@VoucherNo     AND ReceivedAmount <>0
order by CustomerReceipt.VoucherNo    
end