LOGO SQLINFO MALZEME SATIN ALMA VE SATIS FIYATI DOVIZ KURLARIDA DIKKATE ALINIR

Ayrıntılı Satış raporunda yapıldı...
3 adet METIN TANIMLI ALAN TANIMLANIR

1-SAFDOVIZCINSINR,
2-SAFDOVIZCINSIMETIN,
3-SAF ÇIKTI = (ÖR 111 USD)
SATIN ALMA FIYATI(SATIS FIYATI ICIN PTYPE 2 YAPILIR)
-----------------
SAFDOVIZCINSINR=_SQLINFO("CURRENCY","LG_116_PRCLIST","PTYPE=1 AND CARDREF='"+STR(R2.logicalRef)+"'")

SAFDOVIZCINSIMETIN=_SQLINFO("CURCODE","L_CURRENCYLIST","CURTYPE='"+[SAFDOVIZCINSINR]+"'")


SAF=_SQLINFO("PRICE","LG_116_PRCLIST","PTYPE=1 AND CARDREF='"+STR(R2.logicalRef)+"'") +" " + [SAFDOVIZCINSIMETIN])




DOVIZ KURU TEK CINSSE :
SATIN ALMA FIYATI
VAL(_SQLINFO("PRICE","LG_116_PRCLIST","PTYPE=1 AND ACTIVE=0 AND CARDREF='"+STR(R2.logicalRef)+"'"))


SATIS FIYATI
VAL(_SQLINFO("PRICE","LG_116_PRCLIST","PTYPE=2 AND ACTIVE=0 AND CARDREF='"+STR(R2.logicalRef)+"'"))

---------

SQLINFO GUNLUK DOVIZ KURU
SAYI :
VAL(_SQLINFO("RATES3","LG_EXCHANGE_116","CONVERT(DATE,EDATE)= CONVERT(DATE,GETDATE()) AND CRTYPE='"+[SAFDOVIZCINSINR]+"'"))
VERIDE ALANA CIFT TIKLA VE
1-TABLO KOLONLARINA EKLE
2-PARAMETRELER KISMINDAN PARASAL DEGER
3-FORMAT 12345.6789