SELECT OfficeCode AS MAGAZA,CurrAccCode AS MUSTERIKODU,InvoiceNumber AS FATURA, InvoiceDate FATURATARIHI,Price AS TUTAR,Doc_LDiscountVITotal AS INDIRIM,Doc_NetAmount SATISTUTARI ,IsReturn AS IADE FROM AllInvoices WHERE OfficeCode IN('KBM','RCAP') AND InvoiceDate BETWEEN '20180920'AND '20180920' ORDER BY OfficeCode,InvoiceNumber
-- Fatura karsilastirma. KDV dahil topla satis tutari