Stok Kart Update

// Lot Update – Dağıtılabilir bölünebilir SELECT * FROM LG_001_UNITSETF SELECT DIVLOTSIZE,DISTLOTUNITS,COMBLOTUNITS,CODE FROM LG_001_ITEMS WHERE UNITSETREF=5 UPDATE LG_001_ITEMS SET DIVLOTSIZE=1,DISTLOTUNITS=1,COMBLOTUNITS=1 WHERE UNITSETREF=5 // Stok Kdv update SELECT VAT,SELLVAT,RETURNVAT FROM LG_001_ITEMS…

Logo Cari Bakiye

SELECT CLCARD.CODE AS KODU, CLCARD.DEFINITION_ AS ÜNVANI, (SUM((1 – CLFLINE.SIGN) * CLFLINE.AMOUNT) – SUM(CLFLINE.SIGN * CLFLINE.AMOUNT)) AS FROM LG_001_01_CLFLINE CLFLINE INNER JOIN LG_001_CLCARD CLCARD ON CLFLINE.CLIENTREF = CLCARD.LOGICALREF AND CLFLINE.CANCELLED…