//EFATURA SORGU
SELECT Count(*) FROM VE_INVOICE WHERE  COMPANYID = '11' AND TRANSTYPE = '101' AND SUBSTRING(RECEIPTNO, 4, 16) < ' 2023000000154' AND  ((((ISNULL(EINVGUID,'')='' AND ISNULL(EARCHGUID,'')='') AND EINVSTATUS = '') OR ISNULL(EINVSTATUS, '') = 'OFFL') AND STATUS = '2') AND SUBSTRING(RECEIPTNO, 1, 3)=' SRE ' AND LEN(RECEIPTNO) ='16' AND TRANSDATE < CONVERT(DATE,'07.06.2023', 104)


//ARŞİV SORGU
(SELECT Count(*) FROM VE_INVOICE WHERE  COMPANYID = '9' AND TRANSTYPE = '101' AND SUBSTRING(RECEIPTNO, 4, 16) < '2023000000016' AND  ((((ISNULL(EARCHGUID,'')='' AND ISNULL(EINVGUID,'')='') AND EINVSTATUS = '') OR ISNULL(EINVSTATUS, '') = 'OFFL') AND STATUS = '2') AND SUBSTRING(RECEIPTNO, 1, 3)=' DOM ' AND LEN(RECEIPTNO) ='16' AND TRANSDATE < CONVERT(DATE,'07.06.2023', 104)

(CAMPANYID FİŞNO TARİH SERİ BAŞLANGIÇ DEĞİŞTİREREK GİTMEYEN FATURALAR SORGULANIR