Mart 2015

Logo Finansal Hatırlatıcı

SELECT CL.CODE,CL.DEFINITION_,PY.CARDREF,PY.CLOSINGRATE,PY.DATE_,PY.PAYNO,PY.MODULENR,PY.TRCODE,PY.TOTAL, CASE when PY.TRCODE =1 and PY.MODULENR=10 then ‘Nakit Tahsilat’ when PY.TRCODE =2 and PY.MODULENR=10 then ‘Nakit Ödeme’ when PY.TRCODE =11 and PY.MODULENR=10 then ‘Cari Hesap Tahsilat’

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…