LOGO Tiger’da Stok ve Birim Fiyatı Gösteren Query
21 Kasım 2018 / 17:44
Burak
Merhaba, Logo tiger’da stok ve birim fiyatı göstermeye yarayan query
|
1 2 3 4 |
SELECT (SELECT TOP 1 PRICE FROM LG_015_PRCLIST WHERE CARDREF=ITM.LOGICALREF AND PTYPE='2' and ENDDATE>GETDATE() AND VARIANTCODE='' ORDER BY PRIORITY ASC,CODE DESC) AS 'fiyat' , ISNULL ((SELECT SUM(ONHAND) -(CASE WHEN SUM(RESERVED) < 0 THEN 0 ELSE SUM(RESERVED) END) AS Expr1 FROM dbo.LV_015_01_STINVTOT WHERE (STOCKREF = ITM.LOGICALREF) AND (INVENNO = '001') ), 0) AS GERCEK_STOK FROM LG_015_ITEMS ITM WHERE ITM.CODE=ürün kodu |
Bu Yazılarıda Okuyabilirsiniz...
Bir yanıt yazın