Blog Of Sem: September 2018

ncr tena live aktarım tamsayı hatası

V0100000000000202830000000000000004160000000001099560000000015166TM12690208011
V0610000000000281688000000002560800000000000000000000000000000000TM12690208011 -OLMAYAN TAMSAYI HATASI
V0610000000000281688000000000560800000000000000000000000000000000TM12690208011 -OLAN


TAMSAYI 3 KARAKTERDEN ONDALIK SAYI 8 KARAKTERDEN FAZLA YAZILAMAZ

kobit route shopmanager vade hizli sentez

cari_list

SELECT
case when VadeOp.fisTermDate <= GETDATE() then 1 else 0 end as Vade,'aaa' as GroupCode,1 as guns,
ca.RecId, ca.TradeName, ca.CurrentAccountCode, ca.GroupId, ca.CurrentAccountName, ca.PriceGroupCode, t.Name + ' - ' + ca.TaxNo as TaxLine
FROM Erp_CurrentAccount ca
left join Meta_TaxOffice t on ca.TaxOfficeId=t.RecId
left join VadeOp on ca.CurrentAccountCode = (select top 1 [Cari Hesap Kodu] from VadeOp where   Kalan>1 and Tipi != '' )
where ca.CompanyId = 1
order by ca.RecId;