GO
/****** Object:  StoredProcedure [dbo].[sp_MatTransferDetailsReport]    Script Date: 05-01-2025 12:15:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_MatTransferDetailsReport]
@FromDate datetime,
@ToDate varchar(50),
@BranchFrom varchar(50),
@BranchTo varchar(50) 
AS  
BEGIN 
select  MaterialTrans.voucherNo as InvNo,MaterialTrans.EntryDate,MaterialTrans.PONo,MaterialTrans.RefNo,MaterialTrans.fromstore as StoreName,MaterialTrans.tostore as StoreName1,MaterialTrans.Attended,MaterialTrans.NetAmount,
MaterialTrans.Remarks,MaterialTransDetails.SlNo,MaterialTransDetails.ItemName,MaterialTransDetails.Qty,MaterialTransDetails.Rate,MaterialTransDetails.Unit,MaterialTransDetails.Amount,MaterialTransDetails.ItemCode,
MaterialTransDetails.ItemName,MaterialTransDetails.Qty,MaterialTransDetails.Rate,
MaterialTransDetails.SalesRate
from  MaterialTrans inner join MaterialTransDetails on MaterialTrans.voucherNo=MaterialTransDetails.DocumentNo  
 where  MaterialTrans.EntryDate between @FromDate and @ToDate and (MaterialTrans.fromstore = @BranchFrom OR @BranchFrom IS NULL OR @BranchFrom = '' OR @BranchFrom='All')   and(MaterialTrans.tostore = @BranchTo OR @BranchTo IS NULL OR @BranchTo = '' OR @BranchTo='All')  
END  



GO
/****** Object:  StoredProcedure [dbo].[sp_MatTransferDetailsOutReport]    Script Date: 05-01-2025 12:15:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_MatTransferDetailsOutReport]
@FromDate datetime,
@ToDate varchar(50),
@BranchFrom varchar(50),
@BranchTo varchar(50) 
AS  
BEGIN 
select  MaterialTransOut.voucherNo as InvNo,MaterialTransOut.EntryDate,MaterialTransOut.PONo,MaterialTransOut.RefNo,MaterialTransOut.fromstore as StoreName,MaterialTransOut.tostore as StoreName1,MaterialTransOut.Attended,MaterialTransOut.NetAmount,
MaterialTransOut.Remarks,MaterialTransOutDetails.SlNo,MaterialTransOutDetails.ItemName,MaterialTransOutDetails.Qty,MaterialTransOutDetails.Rate,MaterialTransOutDetails.Unit,MaterialTransOutDetails.Amount,MaterialTransOutDetails.ItemCode,
MaterialTransOutDetails.ItemName,MaterialTransOutDetails.Qty,MaterialTransOutDetails.Rate

from  MaterialTransOut inner join MaterialTransOutDetails on MaterialTransOut.voucherNo=MaterialTransOutDetails.DocumentNo  
 where  MaterialTransOut.EntryDate between @FromDate and @ToDate and (MaterialTransOut.fromstore = @BranchFrom OR @BranchFrom IS NULL OR @BranchFrom = '' OR @BranchFrom='All')   and(MaterialTransOut.tostore = @BranchTo OR @BranchTo IS NULL OR @BranchTo = '' OR @BranchTo='All')  
END