Merhaba,
Koray arkadaşımızın dediği gibi invenno yapıyorsanız bu ambardır,
ama sorguda invenno gibi bir şey görmedim
firma diye işyerini diyorsanız buda branch alanında tutulur
sorguyu şu şekilde kullanabilirsiniz.
SELECT TOP (15000) FATURA.LOGICALREF AS REF, FATURA.FICHENO AS [FATURA NO], CARI.CODE AS [CARİ KODU], CARI.DEFINITION_ AS [CARİ ADI],
FATURA.DATE_ AS [FATURA TARİHİ], SUM(SATIR.AMOUNT) AS [SATILAN ADET], ROUND(SUM(SATIR.OUTCOST * SATIR.AMOUNT), 2) AS MALİYET,
ROUND(SUM(SATIR.LINENET), 2) AS NETSATIS, ROUND(SUM(SATIR.LINENET) - SUM(SATIR.OUTCOST * SATIR.AMOUNT), 2) AS KAR,
ROUND((ROUND(SUM(SATIR.LINENET), 2) / ROUND(SUM(CASE WHEN SATIR.OUTCOST > 0 THEN SATIR.OUTCOST * SATIR.AMOUNT ELSE 1 END), 2) - 1) * 100, 2)
AS YÜZDE
FROM dbo.LG_014_01_INVOICE AS FATURA INNER JOIN
dbo.LG_014_01_STLINE AS SATIR ON SATIR.INVOICEREF = FATURA.LOGICALREF INNER JOIN
dbo.LG_014_CLCARD AS CARI ON CARI.LOGICALREF = FATURA.CLIENTREF
WHERE (FATURA.TRCODE=
AND
(FATURA.DATE_ BETWEEN '2012-03-01' AND '2012-03-31')
AND (SATIR.STOCKREF > 0)
AND (FATURA.CANCELLED = 0)
AND FATURA.BRANCH=1 -- İŞTE BURADAN İŞYERİ AYRIMI YAPABİLRSİNİZ.
GROUP BY FATURA.LOGICALREF, FATURA.FICHENO, CARI.CODE, CARI.DEFINITION_, FATURA.DATE_
kolay gelsin.