version 6 depo bazlı stoklar ve cari bakiyeleri

depo bazlı ürünler

select DEPO.ADI WarehouseName,SKART.KOD URUN_KODU,SKART.ADI URUN_ADI,SUM((TGIRIS-TCIKIS)) Quantity
from SKARTK
LEFT JOIN SKART ON SKARTK.KOD = SKART.KOD
left join  DEPO ON SKARTK.DEPO = DEPO.KOD
 where (SKARTK.SIRKET='08' AND SKART.SIRKET='08' AND DEPO.SIRKET = '08')
 where (SKARTK.SIRKET='_ActiveCompanyId_' AND SKART.SIRKET='_ActiveCompanyId_' AND DEPO.SIRKET = '_ActiveCompanyId_')
GROUP BY DEPO.ADI,SKART.ADI,SKART.KOD

cari bakiyeleri
select CKART.KOD,CKART.ADI,ISNULL(sum(cast(CARID.BORC AS DECIMAL(10,2)) - cast(CARID.ALACAK AS DECIMAL(10,2))),0) BAKIYE from CKART left join CARID on (CKART.SIRKET=CARID.SIRKET and CKART.KOD=CARID.CKOD) where
 --CKART.SIRKET='08' AND
CKART.SIRKET='_ActiveCompanyId_' AND
 CKART.SAYI1 >= 0 and CKART.SAYI1 <= 999999999999999 and
 CKART.SAYI2 >= 0 and CKART.SAYI2 <= 999999999999999 and
 CKART.SAYI3 >= 0 and CKART.SAYI3 <= 999999999999999 and
 CKART.SAYI4 >= 0 and CKART.SAYI4 <= 999999999999999 and
 CKART.SAYI5 >= 0 and CKART.SAYI5 <= 999999999999999 and INUSE=1
 GROUP BY CKART.KOD,CKART.ADI
 ORDER BY CKART.ADI

Sentez Live Şifre sormadan direk başlasın

"D:\DATALAR\LIVE\LIVE.exe" /u:Sentez /p:111234 /c:01

u kullanıcı kodu
p parola
c şirket company

windows mobile el terminali windows 10 çalıştır

https://www.youtube.com/watch?v=VBKlFYQktV4
indir : https://www.microsoft.com/en-us/download/details.aspx?id=3182
services.msc
Windows Mobile-2003-based device connectivity
logondan locala ve altındakini tikle

sonra cmdye yaz
REG ADD HKLM\SYSTEM\CurrentControlSet\Services\RapiMgr /v SvcHostSplitDisable /t REG_DWORD /d 1 /f

REG ADD HKLM\SYSTEM\CurrentControlSet\Services\WcesComm /v SvcHostSplitDisable /t REG_DWORD /d 1 /f

sonra pcye restart at

Sentez Live web ayarı

/Live/WebApp/LiveWebReport_3004.zip indir

liveweb denetim masasından windows özellik yükleden internet information service>world wide web services>application development features .netler aspleri seç ve yükle


daha sonra Internet Information Services (IIS) Manager aç Add Website ye bas LiveWebReport_3004.zip  nereye cıkarttıysan orayı göster ve o klasore everyone yetkisi ver, Daha sonra yine iisden application poolsdan ekledğin siteye çift tıkla .net clr version v4 olsun ve classic olsun ok de ve recyclea bas, LiveServer.exeyi çalıştır ve siteye gir