Logo Tiger – Sayfa 4

Logo Tiger Satılan Ürünlerin Fatura Bilgileri ve Satış Fiyatları

Posted on 17 Ocak 2017 by kemal

Logo tigerda stokların grup kodları ile satış faturasının ve satış fiyatlarının bilgileri

SELECT
INVOICE.DATE_ AS [Tarih],
TIGERDB.dbo.LG_INTTOTIME(INVOICE.TIME_) AS [Saat],
INVOICE.FICHENO [Fiş No],
RTRIM(INVOICE.GENEXP1+' '+INVOICE.GENEXP2+' '+INVOICE.GENEXP3+' '+INVOICE.GENEXP4) AS [Açıklama],
STLINE.CODE [Stok Kodu],
STLINE.AMOUNT [Adet],
STLINE.PRICE [Birim Fiyat]
FROM LG_001_03_INVOICE AS INVOICE WITH (NOLOCK)
RIGHT OUTER JOIN LV_001_03_STLINE AS STLINE ON INVOICE.LOGICALREF = STLINE.INVOICEREF
WHERE(INVOICE.TRCODE IN(8))
AND INVOICE.DATE_ >= '2016-01-01 00:00:00.000'
AND INVOICE.DATE_ <= '2016-12-31 23:59:59.999'
AND (STLINE.CODE IN
(
SELECT CODE
FROM dbo.LG_001_ITEMS
WHERE STGRPCODE = 'STOK'
))
ORDER BY INVOICE.DATE_,
INVOICE.SOURCEINDEX,
INVOICE.FICHENO

Satış Siprarişlerine göre depoda bulunan malzeme durumları

Posted on 27 Mayıs 2015 by kemal

Satış Siprarişlerine göre depoda bulunan malzeme durumları

SELECT TOP (100) PERCENT
	CLCARD.DEFINITION_ AS Müşteri,
	ITEMS.CODE AS [Mamul Kodu],
	ITEMS.NAME AS [Mamul Adı],
	LG_001_02_ORFICHE.FICHENO AS [Evrak No],
	LG_001_02_ORFICHE.DATE_ AS [Sip.Tarihi],
	ORFLINE.AMOUNT AS Miktar,
	ORFLINE.SHIPPEDAMOUNT AS [Sevk.Edilen Mikt.],
	ORFLINE.DUEDATE AS [Sevk Tarihi],
	ORFLINE.CLOSED AS [0(Açık)],
	ORFLINE.PRICE,
	(SELECT
		SUM(DEPO.ONHAND) AS MIKTAR
	FROM LV_001_02_STINVTOT AS DEPO
	INNER JOIN LG_001_ITEMS AS STOK
		ON DEPO.STOCKREF = STOK.LOGICALREF
	WHERE (DEPO.INVENNO = '0')
	AND (STOK.CODE = ITEMS.CODE))
	AS [Depoda Bulunan]
FROM LG_001_SPECODES AS SPECODES
RIGHT OUTER JOIN LG_001_02_ORFLINE AS ORFLINE
	ON SPECODES.SPECODE = ORFLINE.SPECODE
LEFT OUTER JOIN LG_001_ITEMS AS ITEMS
	ON ORFLINE.STOCKREF = ITEMS.LOGICALREF
FULL OUTER JOIN LG_001_CLCARD AS CLCARD
RIGHT OUTER JOIN LG_001_SHIPINFO
RIGHT OUTER JOIN LG_001_02_ORFICHE
	ON LG_001_SHIPINFO.LOGICALREF = LG_001_02_ORFICHE.SHIPINFOREF
	ON CLCARD.LOGICALREF = LG_001_02_ORFICHE.CLIENTREF
	ON ORFLINE.ORDFICHEREF = LG_001_02_ORFICHE.LOGICALREF
WHERE (LG_001_02_ORFICHE.TRCODE = 1)
ORDER BY [Sip.Tarihi] DESC

Kullanıcıların kesmiş oldukları aylık fatura sayıları

Posted on 26 Mayıs 2015 by kemal

Kullanıcıların kesmiş oldukları aylık fatura sayıları

SELECT     [User].NAME, MONTH( INV.DATE_) as AY, INV.TRCODE,COUNT(*) FATSAY
FROM         TIGERDB.dbo.L_CAPIUSER AS [User] INNER JOIN
                      LG_001_02_INVOICE AS INV ON [User].NR = INV.CAPIBLOCK_CREATEDBY
WHERE INV.TRCODE IN (8)
GROUP BY [User].NAME, MONTH( INV.DATE_), INV.TRCODE
ORDER by [User].NAME, MONTH( INV.DATE_)

Logo Go / Tiger Hareketsiz Carileri Kullanımdışı yapma

Posted on 2 Şubat 2015 by kemal

Logo Go / Tiger Hareketsiz Carileri Kullanımdışı yapma


with bb as (SELECT LOGICALREF,CODE, DEFINITION_,( select count (CLIENTREF) from dbo.LV_115_01_CLEKSTRE where 

CLIENTREF = aa.LOGICALREF ) as say FROM dbo.LG_115_CLCARD as aa with (nolock) where CARDTYPE = 3 )

update LG_115_CLCARD set ACTIVE = 1 where LOGICALREF in ( select LOGICALREF from bb where say = 0)

Logo Tiger Depo Bazında Malzeme/Stok Durumları

Posted on 30 Ocak 2015 by kemal

Malzemlerin listesini depo bazında almak isterseniz aşağıdaki kodu kullanabilirsiniz.

SELECT     ITEMS.CODE, ITEMS.NAME, STINVTOT.INVENNO AS DEPO, SUM(STINVTOT.ONHAND) AS MIKTAR
FROM         LV_001_02_STINVTOT AS STINVTOT LEFT OUTER JOIN
LG_001_ITEMS AS ITEMS ON STINVTOT.STOCKREF = ITEMS.LOGICALREF
WHERE     (ITEMS.CARDTYPE = 1) AND STINVTOT.INVENNO = -1 /* Tüm Depolar için -1 */
GROUP BY ITEMS.CODE, ITEMS.NAME, STINVTOT.INVENNO, ITEMS.CARDTYPE
HAVING      (SUM(STINVTOT.ONHAND) <> 0)