ALTER procedure sp_SaveInvoice
(
 @InvNo varchar(50), @BranchCode varchar(10)
 )
AS
begin
SELECT Invoice.DELDate,Invoice.Branch,Invoice.CreditPeriod,Invoice.Bank1,Invoice.Bank2,Invoice.Bank3,Invoice.Bank4,
Invoice.Del1,Invoice.Del2,Invoice.Del3,Invoice.Del4,Invoice.PODate,Invoice.Freight,Invoice.Retention,Invoice.BillType,
Invoice.InvNo,Invoice.EntryDate,Invoice.PONo,Invoice.DnNo,Invoice.RefNo,Invoice.CustomerCode,Invoice.CustomerName,
Invoice.Address,Invoice.Phone,Invoice.Fax,Invoice.Attended,Invoice.Narration,Invoice.GrossAmount,Invoice.NetAmount,
Invoice.LessAmount  AS less,InvoiceItem.SlNo,InvoiceItem.ItemCode,InvoiceItem.ItemName,
InvoiceItem.PartNo,InvoiceItem.Rate,InvoiceItem.Unit,InvoiceItem.Qty,InvoiceItem.Amount,
CONVERT(nchar, isnull(HijriDate,'01/01/1900'), 131) as HijriDate,isnull(invoice.QuotNo,'') as QuotNo
,ISNULL(INVOICEITEM.VATPER,0) AS VATPER,ISNULL(INVOICEITEM.VATAMT,0)AS VATAMT,ISNULL(INVOICE.VATTOTAL,0)AS VATTOTAL
,ISNULL(INVOICE.Vatno,'')AS Vatno,isnull(invoiceitem.rateafterdisc,0) as Rateafterdisc,ISNULL(INVOICE.REMARKS1,'') AS REMARKSS,INVOICE.MOBILE
,ISNULL(CONVERT(VARCHAR(25),D.ENTRYDATE,103),CONVERT(VARCHAR(25),INVOICE.ENTRYDATE,103)) AS DNDATE,ISNULL(C.namear,'') as Arabicname,isnull(C.address1ar,'') as ArabicAddress 
 ,CONVERT(VARCHAR(25),Invoice.EntryDate,103) 'DATE' ,
 dbo.currency_conversion(Invoice.NetAmount) as ARABICNETAMOUNT,isnull(pinvno,'')as pinvno,isnull(bankcode,'')as bankcode,isnull(bankname,'')as bankname,isnull(bankamount,'')as bankamount 
 ,isnull(vat,0)As vat,isnull(EINVOICE.qrcode,'')as qrcode

 ,isnull(C.ContactArabic,'')as ContactArabic,isnull(C.phoneArabic,'')as phoneArabic,isnull(C.FaxArabic,'')as FaxArabic,isnull(C.emailArabic,'')as emailArabic,isnull(C.mobArabic,'')as mobArabic,
 isnull(C.vatnoArabic,'')as vatnoArabic,isnull(C.BuildingNo,'')as BuildingNo,isnull(C.StreetName,'')as StreetName,isnull(C.District,'')as District,isnull(C.City,'')as City,isnull(C.Country,'')as Country,
 isnull(C.PostalCode,'')as PostalCode,isnull(C.AdditionalNo,'')as AdditionalNo,isnull(C.OtherSellerNo,'')as OtherSellerNo,isnull(C.BuildingNoArabic,'')as BuildingNoArabic,isnull(C.StreetNameArabic,'')as StreetNameArabic,
 isnull(C.DistrictArabic,'')as DistrictArabic,isnull(C.CityArabic,'')as CityArabic,isnull(C.CountryArabic,'')as CountryArabic,isnull(C.PostalCodeArabic,'')as PostalCodeArabic,isnull(C.AdditionalNoArabic,'')as AdditionalNoArabic 
 ,isnull(C.OtherSellerNoArabic,'')as OtherSellerNoArabic,isnull(cd.vatno,'')as cdvatno
  ,ISNULL(CD.Name,'')AS CDNAME,ISNULL(CD.ADDRESS1,'')AS CDADDRESS,ISNULL(CD.namear,'') as CDArabicname,isnull(CD.address1ar,'') as CDArabicAddress ,isnull(CD.ContactArabic,'')as CDContactArabic,isnull(CD.phoneArabic,'')as CDphoneArabic
 ,isnull(CD.FaxArabic,'')as CDFaxArabic,isnull(CD.emailArabic,'')as CDemailArabic,isnull(CD.mobArabic,'')as CDmobArabic,
 isnull(CD.vatnoArabic,'')as CDvatnoArabic,isnull(CD.BuildingNo,'')as CDBuildingNo,isnull(CD.StreetName,'')as CDStreetName,isnull(CD.District,'')as CDDistrict,isnull(CD.City,'')as CDCity,isnull(CD.Country,'')as CDCountry,
 isnull(CD.PostalCode,'')as CDPostalCode,isnull(CD.AdditionalNo,'')as CDAdditionalNo,isnull(CD.OtherSellerNo,'')as CDOtherSellerNo,isnull(CD.BuildingNoArabic,'')as CDBuildingNoArabic,isnull(CD.StreetNameArabic,'')as CDStreetNameArabic,
 isnull(CD.DistrictArabic,'')as CDDistrictArabic,isnull(CD.CityArabic,'')as CDCityArabic,isnull(CD.CountryArabic,'')as CDCountryArabic,isnull(CD.PostalCodeArabic,'')as CDPostalCodeArabic,isnull(CD.AdditionalNoArabic,'')as CDAdditionalNoArabic 
 ,isnull(CD.OtherSellerNoArabic,'')as CDOtherSellerNoArabic,isnull(CD.VATNO,'')as CDVATNO
 ,isnull(logoimage,'')as logoimage,isnull(signatureimage,'')as signatureimage,isnull(sealimage,'')as sealimage,isnull(footerimage,'')as footerimage,isnull(headderimage,'')as headderimage
 FROM Invoice INNER JOIN InvoiceItem ON Invoice.InvNo = InvoiceItem.InvNo AND Invoice.SR = 'Sales'and  InvoiceItem.SR = 'Sales' 
LEFT JOIN DELIVERYNOTE D ON D.DNNO=INVOICEITEM.DNNO LEFT JOIN CUSTOMER C ON C.CODE=INVOICE.CUSTOMERCODE 
LEFT JOIN EINVOICE ON EINVOICE.EINVNO=INVOICE.INVNO

JOIN Companydetails CD ON ISNULL(CD.BranchCode,@BranchCode)=@BranchCode
where Invoice.InvNo=@InvNo



end
go


 ALTER procedure sp_SaveInvoiceReturn
(
@InvoiceRetNo varchar(50),
@BranchCode varchar(10)
)
AS
begin

SELECT InvoiceReturn.InvoiceRetNo,InvoiceReturn.DELDate,InvoiceReturn.Branch,InvoiceReturn.CreditPeriod,InvoiceReturn.Bank1,InvoiceReturn.Bank2,InvoiceReturn.Bank3,InvoiceReturn.Bank4,
InvoiceReturn.Del1,InvoiceReturn.Del2,InvoiceReturn.Del3,InvoiceReturn.Del4,InvoiceReturn.PODate,InvoiceReturn.Freight,InvoiceReturn.Retention,InvoiceReturn.BillType,
InvoiceReturn.InvNo,InvoiceReturn.EntryDate,InvoiceReturn.PONo,InvoiceReturn.DnNo,InvoiceReturn.RefNo,InvoiceReturn.CustomerCode,InvoiceReturn.CustomerName,
InvoiceReturn.Address,InvoiceReturn.Phone,InvoiceReturn.Fax,InvoiceReturn.Attended,InvoiceReturn.Narration,InvoiceReturn.GrossAmount,InvoiceReturn.NetAmount,
InvoiceReturn.LessAmount  AS less,InvoiceReturnItem.SlNo,InvoiceReturnItem.ItemCode,InvoiceReturnItem.ItemName,
InvoiceReturnItem.PartNo,InvoiceReturnItem.Rate,InvoiceReturnItem.Unit,InvoiceReturnItem.Qty,InvoiceReturnItem.Amount,
CONVERT(nchar, isnull(HijriDate,'01/01/1900'), 131) as HijriDate,isnull(InvoiceReturn.QuotNo,'') as QuotNo
,ISNULL(InvoiceReturnItem.VATPER,0) AS VATPER,ISNULL(InvoiceReturnItem.VATAMT,0)AS VATAMT,ISNULL(InvoiceReturn.VATTOTAL,0)AS VATTOTAL
,ISNULL(InvoiceReturn.Vatno,'')AS Vatno,isnull(InvoiceReturnItem.rateafterdisc,0) as Rateafterdisc,ISNULL(InvoiceReturn.REMARKS1,'') AS REMARKSS,InvoiceReturn.MOBILE
,ISNULL(CONVERT(VARCHAR(25),D.ENTRYDATE,103),CONVERT(VARCHAR(25),InvoiceReturn.ENTRYDATE,103)) AS DNDATE,ISNULL(C.namear,'') as Arabicname,isnull(C.address1ar,'') as ArabicAddress 
 ,CONVERT(VARCHAR(25),InvoiceReturn.EntryDate,103) 'DATE' ,
 dbo.currency_conversion(InvoiceReturn.NetAmount) as ARABICNETAMOUNT,isnull(pinvno,'')as pinvno,isnull(bankcode,'')as bankcode,isnull(bankname,'')as bankname,isnull(bankamount,'')as bankamount 
 ,isnull(vat,0)As vat,isnull(EInvoiceReturn.qrcode,'')as qrcode

 ,isnull(C.ContactArabic,'')as ContactArabic,isnull(C.phoneArabic,'')as phoneArabic,isnull(C.FaxArabic,'')as FaxArabic,isnull(C.emailArabic,'')as emailArabic,isnull(C.mobArabic,'')as mobArabic,
 isnull(C.vatnoArabic,'')as vatnoArabic,isnull(C.BuildingNo,'')as BuildingNo,isnull(C.StreetName,'')as StreetName,isnull(C.District,'')as District,isnull(C.City,'')as City,isnull(C.Country,'')as Country,
 isnull(C.PostalCode,'')as PostalCode,isnull(C.AdditionalNo,'')as AdditionalNo,isnull(C.OtherSellerNo,'')as OtherSellerNo,isnull(C.BuildingNoArabic,'')as BuildingNoArabic,isnull(C.StreetNameArabic,'')as StreetNameArabic,
 isnull(C.DistrictArabic,'')as DistrictArabic,isnull(C.CityArabic,'')as CityArabic,isnull(C.CountryArabic,'')as CountryArabic,isnull(C.PostalCodeArabic,'')as PostalCodeArabic,isnull(C.AdditionalNoArabic,'')as AdditionalNoArabic 
 ,isnull(C.OtherSellerNoArabic,'')as OtherSellerNoArabic
  ,ISNULL(CD.Name,'')AS CDNAME,ISNULL(CD.ADDRESS1,'')AS CDADDRESS,ISNULL(CD.namear,'') as CDArabicname,isnull(CD.address1ar,'') as CDArabicAddress ,isnull(CD.ContactArabic,'')as CDContactArabic,isnull(CD.phoneArabic,'')as CDphoneArabic
 ,isnull(CD.FaxArabic,'')as CDFaxArabic,isnull(CD.emailArabic,'')as CDemailArabic,isnull(CD.mobArabic,'')as CDmobArabic,
 isnull(CD.vatnoArabic,'')as CDvatnoArabic,isnull(CD.BuildingNo,'')as CDBuildingNo,isnull(CD.StreetName,'')as CDStreetName,isnull(CD.District,'')as CDDistrict,isnull(CD.City,'')as CDCity,isnull(CD.Country,'')as CDCountry,
 isnull(CD.PostalCode,'')as CDPostalCode,isnull(CD.AdditionalNo,'')as CDAdditionalNo,isnull(CD.OtherSellerNo,'')as CDOtherSellerNo,isnull(CD.BuildingNoArabic,'')as CDBuildingNoArabic,isnull(CD.StreetNameArabic,'')as CDStreetNameArabic,
 isnull(CD.DistrictArabic,'')as CDDistrictArabic,isnull(CD.CityArabic,'')as CDCityArabic,isnull(CD.CountryArabic,'')as CDCountryArabic,isnull(CD.PostalCodeArabic,'')as CDPostalCodeArabic,isnull(CD.AdditionalNoArabic,'')as CDAdditionalNoArabic 
 ,isnull(CD.OtherSellerNoArabic,'')as CDOtherSellerNoArabic,isnull(CD.VATNO,'')as CDVATNO
 ,isnull(logoimage,'')as logoimage,isnull(signatureimage,'')as signatureimage,isnull(sealimage,'')as sealimage,isnull(footerimage,'')as footerimage,isnull(headderimage,'')as headderimage
 FROM InvoiceReturn INNER JOIN InvoiceReturnItem ON  InvoiceReturn.InvoiceRetNo = InvoiceReturnItem.InvoiceRetNo AND  InvoiceReturn.SR = 'Returns' 
LEFT JOIN DELIVERYNOTE D ON D.DNNO=InvoiceReturnItem.DNNO LEFT JOIN CUSTOMER C ON C.CODE=InvoiceReturn.CUSTOMERCODE 
LEFT JOIN EInvoiceReturn ON EInvoiceReturn.EInvRetNO=InvoiceReturn.InvoiceRetNo AND  InvoiceReturn.SR = 'Returns'  

JOIN Companydetails CD ON ISNULL(CD.BranchCode,@BranchCode)=@BranchCode
where InvoiceReturn.InvoiceRetNo=@InvoiceRetNo


 
end


SET ANSI_NULLS ON
go


 ALTER procedure sp_SavePurchase
(
@DocNo varchar(50),
@BranchCode varchar(10)
)
AS  
BEGIN 
select  Purchase.DocumentNo,Purchase.EntryDate,Purchase.PONo,Purchase.RefNo,Purchase.SupplierName,Purchase.Address,Purchase.Attended,Purchase.NetAmount,
purchase.supinvno as  invoiceno,PurchaseItem.SlNo,PurchaseItem.ItemName,PurchaseItem.Qty,PurchaseItem.Rate,PurchaseItem.Unit,PurchaseItem.Amount,PurchaseItem.ItemCode,
PurchaseItem.SalesRate,ISNULL(PurchaseItem.VATPER,0) AS VATPER,ISNULL(PurchaseItem.VATAMT,0)AS VATAMT,ISNULL(Purchase.VATTOTAL,0)AS VATTOTAL,
ISNULL(Purchase.Vatno,'') AS Vatno,ISNULL(C.namear,'') as Arabicname,isnull(C.address1ar,'') as ArabicAddress 
,isnull(fRate,0) as Frate,isnull(pcrate,0)as pcrate,isnull(Purchase.GrossAmount,0) as  Grossamount,isnull(Purchase.LESS,0) as  less,currency,exchangerate,purtype
,isnull(logoimage,'')as logoimage,isnull(signatureimage,'')as signatureimage,isnull(sealimage,'')as sealimage,isnull(footerimage,'')as footerimage,isnull(headderimage,'')as headderimage
from  Purchase 
inner join PurchaseItem on Purchase.DocumentNo=PurchaseItem.DocumentNo  
LEFT JOIN SUPPLIER C ON C.CODE=Purchase.SUPPLIERCODE 

JOIN Companydetails CD ON ISNULL(CD.BranchCode,@BranchCode)=@BranchCode

 where PurchaseItem.PR='Purchase' and Purchase.DocumentNo=@DocNo  
END

go

 ALTER PROCEDURE SP_CUSOTMELEDGER
(
@CUSTGROUP NVARCHAR(500),
@CustCode NVARCHAR(500),
@FROM DATETIME,
@TO DATETIME,
@Branchcode nvarchar(500) 
)
AS
BEGIN
SELECT ISNULL(CUSTOMER.CUSTGROUP,'')AS CUSTGROUP, dbo.Customer.Code,dbo.Customer.Name,
((SELECT ISNULL(SUM(ISNULL(Balance,0)),0) FROM CustomerOPEntryUpdated WHERE CustomerCode=Customer.Code AND  (@BranchCode IS NULL OR @BranchCode = '' OR @BranchCode = '1' OR ISNULL(CustomerOPEntryUpdated.BranchCode, '') = @BranchCode))
+isnull(dbo.udf_GenOpening(@FROM,Customer.Code,@Branchcode),0)) AS opening
,'' AS VoucherNo,0 AS Amount,'OPENING' AS Type,'' AS Narration,'01/01/2000' AS ENTRYDATE ,'' AS PONO
  , '' as   Branchname
  ,isnull(logoimage,'')as logoimage,isnull(signatureimage,'')as signatureimage,isnull(sealimage,'')as sealimage,isnull(footerimage,'')as footerimage,isnull(headderimage,'')as headderimage

FROM dbo.customer
JOIN Companydetails CD ON ISNULL(CD.BranchCode,@BranchCode)=@BranchCode
 WHERE ISNULL(Customer.CUSTGROUP,0)=ISNULL(@CUSTGROUP,ISNULL(Customer.CUSTGROUP,0)) AND ISNULL(dbo.Customer.Code,0)=ISNULL(@CustCode,ISNULL(Customer.Code,0))

 UNION ALL
SELECT ISNULL(CUSTOMER.CUSTGROUP,'')AS CUSTGROUP, dbo.Customer.Code,dbo.Customer.Name,
((SELECT ISNULL(SUM(ISNULL(Balance,0)),0) FROM CustomerOPEntryUpdated WHERE CustomerCode=Customer.Code AND (@BranchCode IS NULL OR @BranchCode = '' OR @BranchCode = '1' OR ISNULL(CustomerOPEntryUpdated.BranchCode, '') = @BranchCode))
+isnull(dbo.udf_GenOpening(@FROM,Customer.Code,@Branchcode),0)) AS opening
,dbo.TBLACCOUNTING.VoucherNo,Amount,dbo.TBLACCOUNTING.Type,dbo.TBLACCOUNTING.Narration,TBLACCOUNTING.ENTRYDATE,(CASE WHEN TYPE='Sales' then (SELECT TOP 1 ISNULL(PONO,'') FROM INVOICE WHERE INVNO=TBLACCOUNTING.VOUCHERNO) else '' end)  AS PONO
    ,(select top 1 [name] from branchmaster where code=TBLACCOUNTING.branchname) as Branchname 
	  ,isnull(logoimage,'')as logoimage,isnull(signatureimage,'')as signatureimage,isnull(sealimage,'')as sealimage,isnull(footerimage,'')as footerimage,isnull(headderimage,'')as headderimage

FROM dbo.CUSTOMER
LEFT  JOIN TBLACCOUNTING ON dbo.Customer.Code=dbo.TBLACCOUNTING.AcCode 
JOIN Companydetails CD ON ISNULL(CD.BranchCode,@BranchCode)=@BranchCode

 WHERE ISNULL(CUSTOMER.CUSTGROUP,0)=ISNULL(@CUSTGROUP,ISNULL(CUSTOMER.CUSTGROUP,0)) AND ISNULL(dbo.Customer.Code,0)=ISNULL(@CustCode,ISNULL(CUSTOMER.Code,0))
and TBLACCOUNTING.EntryDate between @FROM and @TO
AND (@BranchCode IS NULL OR @BranchCode = '' OR @BranchCode = '1' OR ISNULL(TBLACCOUNTING.BranchCode, '') = @BranchCode) ;
END;
go


 ALTER PROCEDURE sp_SaveDeliveryNote
(
@DnNo nvarchar(50),
@BranchCode varchar(10)
)
AS  
begin  
select DeliveryNote.InvoiceDate as InVDate,DeliveryNote.PoDate,DeliveryNote.Del1,DeliveryNote.Del2,DeliveryNote.Del3,DeliveryNote.Del4,DeliveryNote. InvoiceNo ,
DeliveryNote.Attention,DeliveryNote.mobAttention,DeliveryNote.emailAttention,DeliveryNote.QuotationNo,DeliveryNote.DNNo,DeliveryNote.EntryDate,
DeliveryNote.PONo,DeliveryNote.RefNo,DeliveryNote.CustomerName,DeliveryNote.CustomerCode,DeliveryNote.Address,DeliveryNote.Telephone,DeliveryNote.Fax,
DeliveryNote.Attended,DeliveryNoteItem.SlNo,DeliveryNoteItem.ItemCode,DeliveryNoteItem.ItemName,DeliveryNoteItem.Unit,DeliveryNoteItem.Qty,
DeliveryNoteItem.Amount,ISNULL(DeliveryNoteItem.PartNo,'') AS PartNo,ISNULL(DeliveryNote.VATNO,'') AS VATNO,ISNULL(VATPER,0) AS VATPER,ISNULL(VATAMT,0) AS VATAMT 
,ISNULL(C.namear,'') as Arabicname,isnull(C.address1ar,'') as ArabicAddress 
, dbo.currency_conversion(DeliveryNote.NetAmount) as ARABICNETAMOUNT
  ,isnull(logoimage,'')as logoimage,isnull(signatureimage,'')as signatureimage,isnull(sealimage,'')as sealimage,isnull(footerimage,'')as footerimage,isnull(headderimage,'')as headderimage
from DeliveryNote 
JOIN Companydetails CD ON ISNULL(CD.BranchCode,@BranchCode)=@BranchCode
inner join DeliveryNoteItem on DeliveryNote.DnNo=DeliveryNoteItem.DnNo
 LEFT JOIN CUSTOMER C ON C.CODE=DeliveryNote.CUSTOMERCODE
 where DeliveryNote.DnNo=@DnNo ORDER BY DeliveryNoteItem.SlNo  
end  


go


 ALTER PROCEDURE sp_SavePO
(
@PONO nvarchar(50),
@BranchCode varchar(10)
)
AS
begin
select Freight,TransPort,PurchaseOrder.QuotDate,PurchaseOrder.Del1,PurchaseOrder.Del2,PurchaseOrder.Del3,PurchaseOrder.Del4,PurchaseOrder.PONo,
PurchaseOrder.RefNo,PurchaseOrder.EntryDate,PurchaseOrder.SupplierRefNo,PurchaseOrder.SupplierName,PurchaseOrder.Address,PurchaseOrder.Attention,
PurchaseOrder.Telephone,PurchaseOrder.Fax,PurchaseOrder.Attended,PurchaseOrder.PaymentsTerms,PurchaseOrder.DeliveryTime,PurchaseOrder.GrossAmount,
PurchaseOrder.NetAmount,(PurchaseOrder.Discount+PurchaseOrder.Less)as Discount,PurchaseOrderItem.ItemCode,PurchaseOrderItem.ItemName,PurchaseOrderItem.Unit,
PurchaseOrderItem.Qty,PurchaseOrderItem.Rate,PurchaseOrderItem.Amount,PurchaseOrderItem.SlNo,ISNULL(PurchaseOrder.Vatno,'') AS VATNO ,ISNULL(VATTOTAL,0) AS VATTOTAL,
ISNULL(VATPER,0) AS VATPER,ISNULL(VATAMT,0) AS VATAMT,ISNULL(PurchaseOrderItem.PARTNO,'') AS PARTNO
  ,isnull(logoimage,'')as logoimage,isnull(signatureimage,'')as signatureimage,isnull(sealimage,'')as sealimage,isnull(footerimage,'')as footerimage,isnull(headderimage,'')as headderimage

from PurchaseOrder 
JOIN Companydetails CD ON ISNULL(CD.BranchCode,@BranchCode)=@BranchCode
inner join PurchaseOrderItem on 
PurchaseOrder.PONo=PurchaseOrderItem.PONo where PurchaseOrder.PONo=@PONO
end


go

 ALTER PROCEDURE sp_SavePO
(
@PONO nvarchar(50),
@BranchCode varchar(10)
)
AS
begin
select Freight,TransPort,PurchaseOrder.QuotDate,PurchaseOrder.Del1,PurchaseOrder.Del2,PurchaseOrder.Del3,PurchaseOrder.Del4,PurchaseOrder.PONo,
PurchaseOrder.RefNo,PurchaseOrder.EntryDate,PurchaseOrder.SupplierRefNo,PurchaseOrder.SupplierName,PurchaseOrder.Address,PurchaseOrder.Attention,
PurchaseOrder.Telephone,PurchaseOrder.Fax,PurchaseOrder.Attended,PurchaseOrder.PaymentsTerms,PurchaseOrder.DeliveryTime,PurchaseOrder.GrossAmount,
PurchaseOrder.NetAmount,(PurchaseOrder.Discount+PurchaseOrder.Less)as Discount,PurchaseOrderItem.ItemCode,PurchaseOrderItem.ItemName,PurchaseOrderItem.Unit,
PurchaseOrderItem.Qty,PurchaseOrderItem.Rate,PurchaseOrderItem.Amount,PurchaseOrderItem.SlNo,ISNULL(PurchaseOrder.Vatno,'') AS VATNO ,ISNULL(VATTOTAL,0) AS VATTOTAL,
ISNULL(VATPER,0) AS VATPER,ISNULL(VATAMT,0) AS VATAMT,ISNULL(PurchaseOrderItem.PARTNO,'') AS PARTNO
  ,isnull(logoimage,'')as logoimage,isnull(signatureimage,'')as signatureimage,isnull(sealimage,'')as sealimage,isnull(footerimage,'')as footerimage,isnull(headderimage,'')as headderimage

from PurchaseOrder 
JOIN Companydetails CD ON ISNULL(CD.BranchCode,@BranchCode)=@BranchCode
inner join PurchaseOrderItem on 
PurchaseOrder.PONo=PurchaseOrderItem.PONo where PurchaseOrder.PONo=@PONO
end

go

 Alter PROCEDURE sp_SaveRFQReg
(
@RFQNo nvarchar(50),
@BranchCode varchar(10)
)
AS
begin


SELECT PayTerms,RFQDate,RFQToSupplier.Del1,RFQToSupplier.Del2,RFQToSupplier.Del3,RFQToSupplier.Del4,RFQToSupplier.RFQNo,RFQToSupplier.RefNo,RFQToSupplier.EntryDate,
RFQToSupplier.SupplierName,RFQToSupplier.Address,RFQToSupplier.Telephone,RFQToSupplier.Fax,RFQToSupplier.Attention,
RFQToSupplierDetails.ItemName,RFQToSupplierDetails.ItemCode,RFQToSupplierDetails.Qty,RFQToSupplierDetails.Unit,
RFQToSupplierDetails.Slno,ISNULL(RFQToSupplier.VATNO,'') AS VATNO 
  ,isnull(logoimage,'')as logoimage,isnull(signatureimage,'')as signatureimage,isnull(sealimage,'')as sealimage,isnull(footerimage,'')as footerimage,isnull(headderimage,'')as headderimage
FROM RFQToSupplier 
INNER JOIN RFQToSupplierDetails ON RFQToSupplier.rfqno = RFQToSupplierDetails.rfqno 
 JOIN Companydetails CD ON ISNULL(CD.BranchCode,@BranchCode)=@BranchCode
where RFQToSupplier.rfqno=@RFQNo

end


go

 ALTER PROCEDURE sp_SavePurchaseReturn
(
 @PurchaseRet varchar(50),
 @BranchCode varchar(10)
 )
AS
begin
SELECT PurchaseReturn.DocumentNo as PurchaseRet,
PurchaseReturn.InvoiceNo,PurchaseReturn.EntryDate, 
PurchaseReturn.RefNo,PurchaseReturn.SupplierName,PurchaseReturn.Address,
PurchaseReturn.Attended,PurchaseReturn.NetAmount,PurchaseReturnItem.SlNo,
PurchaseReturnItem.ItemName,PurchaseReturnItem.Unit,PurchaseReturnItem.Qty,PurchaseReturnItem.Rate,
PurchaseReturnItem.Amount,isnull(PurchaseReturn.vattotal,0)as vattotal,ISNULL(PurchaseReturn.Vatno,'') AS VATNO 
  ,isnull(logoimage,'')as logoimage,isnull(signatureimage,'')as signatureimage,isnull(sealimage,'')as sealimage,isnull(footerimage,'')as footerimage,isnull(headderimage,'')as headderimage
FROM PurchaseReturn 
INNER JOIN PurchaseReturnItem 
ON PurchaseReturn.DocumentNo = PurchaseReturnItem.DocumentNo 
JOIN Companydetails CD ON ISNULL(CD.BranchCode,@BranchCode)=@BranchCode
WHERE  
PurchaseReturn.PR = 'Returns' and PurchaseReturnItem.DocumentNo=@PurchaseRet 
end