Ürün Miktar Fiyat Listesi
Logo Yazılım dan Sql Managent tarafından Ürün Miktar Fiyat Listesi için gerekli yerleri düzenledikten sonra aşağıdaki kodu çalıştırmanız yeterlidir.
| SELECT URUN.CODE 'Ürün Kodu', URUN.NAME 'Ürün Adı', URUN.STGRPCODE 'Grup Kodu', ISNULL(AMBARM.MIKTAR,0) 'Stok Adedi', ISNULL(ALIS.FIYAT,0) 'Alış Fiyatı', ISNULL(SATIS.TFIYAT,0) 'Satış Fiyatı', (SELECT CODE FROM LG_001_UNITSETL WHERE UNITSETREF=URUN.UNITSETREF AND LINENR=1) 'Birim',(SELECT TOP 1 BARCODE FROM LG_001_UNITBARCODE WHERE ITEMREF=URUN.LOGICALREF ) 'Barkod' FROM LG_001_ITEMS URUN LEFT JOIN (SELECT SUM(ONHAND) MIKTAR,STOCKREF FROM LV_001_01_STINVTOT WHERE INVENNO=-1 GROUP BY STOCKREF) AMBARM ON URUN.LOGICALREF = AMBARM.STOCKREF LEFT JOIN ((SELECT MAX(PRICE) AS 'FIYAT',CARDREF FROM LG_001_PRCLIST WHERE PTYPE=1 GROUP BY CARDREF)) ALIS ON URUN.LOGICALREF = ALIS.CARDREF LEFT JOIN ((SELECT MAX(PRICE) AS 'TFIYAT',CARDREF FROM LG_001_PRCLIST WHERE PTYPE=2 AND CLTRADINGGRP<>'TOPTAN' AND CLTRADINGGRP<>'PERAKENDE' GROUP BY CARDREF)) SATIS ON URUN.LOGICALREF = SATIS.CARDREF WHERE URUN.CARDTYPE<>'22' AND URUN.ACTIVE = '0' AND URUN.CODE LIKE '%' AND URUN.GTIPCODE LIKE '%' ORDER BY URUN.CODE |
Paylaş:
