AIFA AKADEMI · Kurumsal Wiki
4.310 makale
Ana sayfa › Kurumsal Wiki › Destek › Processes › PROC-171

v1.0.7.2 Güncelleme Süreci

SUPPORT_PROCESSMOD-SISTEMERPGOLD_COREACTIVEHIGHDOCUMENTED
Kanonik kaynak: markdown · bu sayfa üretilmiş görünümdür

Kaynak: KB-v1 08_SupportPlaybooks/Processes/PROC-171.md ← Surecler/*.doc (destek süreç dokümanı; parola/IP/terminal maskelenmiş). Gerçeklik: DOCUMENTED — kodla doğrulanmış değil.

v1.0.7.2 Güncelleme Süreci

Kimlik: PROC-171 · Ürün: ERPGOLDV2 · Kategori: Kurulum, bağlantı ve sunucu · Katalog: v1.0.7.2 Güncelleme Süreci

Kaynak: AifaSoft destek süreç dokümanı (Word). Şifre, kullanıcı adı, terminal no ve IP bilgileri kaynak aşamasında maskelenmiştir; görseller resimli süreç kitabındadır.

ERPGOLDV2

E-DÖVİZ GÜNCELLEMESİ

ERPGOLDV2 v1.0.7.2

Dijital Fatura v1.0.0.22

Doküman TipiERPGOLDV2 EDOVIZ GÜNCELLEMELERİDoküman NoHazırlayanMünür SEZERYayın Tarihi19.01.2022Revize YapanMünür SEZERRevizyon Tarihi18.02.2022Revize YapanEmrecan KARAMANRevizyon Tarihi21.02.2022Revize YapanRevizyon TarihiRevize YapanRevizyon Tarihi

  1. Cari.IslemDetaylari

(görsel — süreç kitabında)

Resim 1

Resim 1: Cari.IslemDetaylari tablosuna "Durum" alanını eklemek için aşağıdaki kodu çalıştırınız.

Alter Table Cari.IslemDetaylari Add

Durum nvarchar(MAX) NULL;

  1. Sistem.Subeler

(görsel — süreç kitabında)

Resim 2

Resim 2: Sistem.Subeler tablosuna "EBelgeTcknControl" ve "EBelgeUsdLimit" alanlarını eklemek için aşağıdaki kodu çalıştırınız.

Alter Table Sistem.Subeler Add

EBelgeTcknControl bit NULL,

EBelgeUsdLimit int null;

DİKKAT: Table klasörüne Refresh atınız ve ardından "Sistem.Subeler" tablosuna sağ tıklayıp "Edit Top 200 Row" seçiniz. Yeni eklemiş olduğunuz alanlara Resim 2' deki bilgileri giriniz.

BİLGİ: Bu düzenleme 100,00 USD ve üzerine TCNo zorunluluğu getirmek amacıyla yapılmaktadır.

Revize: Sistem.Subeler'de SubeTipi'nin 'NULL' olmaması gerekiyor. Tercihen 'NULL' yerine 'DOVIZ' yazılabilir.

  1. Sistem.SubeStatus

Boş query açınız ve aşağıdaki kodu çalıştırınız.

Create Function Sistem.SubeStatus(@SubeId int)

returns bit

as

BEGIN

return convert(bit,(Select COUNT(*) from sistem.Subeler Where Id=@SubeId And SubeTipi<>'DOVIZ'))

END

BİLGİ: Aşağıdaki kod, raporların içerisinde bulunan "Where" alanına eklendiğinde belge uyum işaretli (resmi) kasaya geçildiğinde belgesi düzenlenmemiş işlem satırları süzülmektedir.

KOD: (S.SubeTipi ='DOVIZ' And IsNull(D.FaturaNo,0) \<>0) Or S.SubeTipi \<>'DOVIZ')

  1. Reports.GetPozisyonDetay (Revizesi Sonda)

(görsel — süreç kitabında)

Resim 3

Resim 3: Programmability – Function – Table-Valued Functions - Reports.GetPozisyonDetay - Modify Parametre alanına @SubeId int ekleyiniz.

Eklenecek Alan:

@SubeId int

(görsel — süreç kitabında)

Resim 4

Resim 4: Where alanının sonuna resimdeki alanı ekleyiniz.

Eklenecek Alan:

(S.SubeTipi ='DOVIZ' And IsNull(D.FaturaNo,0) <>0) Or S.SubeTipi <>'DOVIZ')
  1. Pozisyon.GetPozisyon
ALTER Function [Pozisyon].[GetPozisyon] (@SubeId int)

returns Table

as

return

Select top 1000 H.Birim,H.Bakiye,BK.Alis as Kur1,PK.Alis as Kur2,CONVERT(Decimal(18,2), Fn.Bol( (H.Bakiye * Bk.Alis),Pk.Alis)) as Pozisyon, B.Kodu as BBirim from

(

Select SubeId,Birim,Sum(Bakiye) as Bakiye From

(

Select K.SubeId, BK.AnaBirim as Birim,(B.Bakiye * bK.Carpan) as Bakiye

from

(

Select KasaId,BirimId,Bakiye as Bakiye from Cari.BakiyeIslem Where BirimId <>-1

) B

Left Join Sistem.Kasalar K on K.Id =B.KasaId

Left Join Cari.BakiyeKodlari Bk on Bk.Id =B.BirimId

where K.SubeId =@SubeId

UNION ALL

---NAKIT STOKLARI

Select SubeId, AnaBirim ,Miktar From Stok.GetNakitStoklari (@SubeId,0,null)

UNION ALL

---MADEN STOKLARI

Select SubeId,AnaBirim,Sum(Miktar * StabilMilyem) as Has From Stok.GetMadenStoklari (@SubeId,0,null,'False') group by SubeId,AnaBirim

UNION ALL

---TAKOZ STOKLARI

SELECT t.* FROM Stok.GetTakozSirketStoklari (0,0,null)

CROSS APPLY (VALUES(SubeId,'HAS',Case When R='False' Then Miktar * 0 Else AuHas end), (SubeId, 'GUM', AgHas ), (SubeId, 'PLT', PltHas ), (SubeId, 'PLD', PldHas )) t(SubeId,Birim, Has) Where Adet \<>0 And T.SubeId=@SubeId

) a

Group by SubeId,Birim having Sum(Bakiye)<>0

) H

Left Join Sistem.Subeler S on S.Id =H.SubeId

Left Join Sistem.Birimler B on B.Id =S.BilancoBirimId

Left Join Sistem.GetKurListesi(GETDATE()) PK on PK.Birim=B.Kodu

Left Join Sistem.GetKurListesi(GETDATE()) BK on BK.Birim=H.Birim

Left Join Sistem.Birimler rB on rB.Kodu =h.Birim

Where (SubeId=@SubeId) And S.SubeTipi <>'DOVIZ'

order by rb.SiraNo

UNION ALL

Select top 1000 H.Birim,H.Bakiye,BK.Alis as Kur1,PK.Alis as Kur2,CONVERT(Decimal(18,2), Fn.Bol( (H.Bakiye * Bk.Alis),Pk.Alis)) as Pozisyon, B.Kodu as BBirim from

(

Select SubeId,Birim,Sum(Bakiye) as Bakiye From

(

Select @SubeId as SubeId, Kodu as Birim,Miktar as Bakiye From Muhasebe.Stoklar (@SubeId,0,GETDATE())

) a

Group by SubeId,Birim having Sum(Bakiye)<>0

) H

Left Join Sistem.Subeler S on S.Id =H.SubeId

Left Join Sistem.Birimler B on B.Id =S.BilancoBirimId

Left Join Sistem.GetKurListesi(GETDATE()) PK on PK.Birim=B.Kodu

Left Join Sistem.GetKurListesi(GETDATE()) BK on BK.Birim=H.Birim

Left Join Sistem.Birimler rB on rB.Kodu =h.Birim

Where (SubeId=@SubeId) And S.SubeTipi ='DOVIZ'
  1. Cari.UpdateTransaction

(görsel — süreç kitabında)

Resim 5

Resim 5: Table – Cari.Islemler – Triggers – UpdateTransaction – Modify tıklayınız ve query’ yi açınız.

------------------------------------------------------------------------------------------------------------------------

(görsel — süreç kitabında)

Resim 6

Resim 6: Resim 6' de işaretli alandaki "Delete from" ile başlayan satırı tamamen siliniz (yoksa ekleyiniz) ve aşağıdaki kodu yapıştırınız.

Eklenecek Alan:

Declare @Ettn nvarchar(Max)=''

Declare @IslemId int=0

Declare @IsDeleted bit=0

Select @IsDeleted =I.IsDeleted, @IslemId =D.IslemId , @Ettn =D.ETTN from inserted I Left Join Cari.IslemDetaylari D on D.IslemId =I.Id

if @IsDeleted= 'True'

BEGIN

if (IsNull(@ETTN,'')='')

BEGIN

Delete from Cari.IslemDetaylari where IslemId =@IslemId and IsNull(ETTN,'')=''

END

ELSE

BEGIN

Update Cari.IslemDetaylari Set Durum ='EIPTAL' where IslemId = @IslemId

END

END
  1. Cari.AcceptTransaction

(görsel — süreç kitabında)

Resim 7

Resim 7: Table – Cari.Islemler – Triggers – AcceptTransaction – Modify tıklayınız ve query’ yi açınız.

------------------------------------------------------------------------------------------------------------------------

(görsel — süreç kitabında)

Resim 8

Resim 8: Resimde görmüş olduğunuz (tek satırlık) alanı ekleyin ve F5’ e basınız.

Eklenecek Alan:

Declare @ETTN nvarchar(Max)=''

------------------------------------------------------------------------------------------------------------------------

(görsel — süreç kitabında)

Resim 9

Resim 9: Resim 8’ deki alanı ekledikten sonra bir kaç satır hemen altında DECLARE IslemCursor içinde en sonuna resimdeki 1 numaralı alanı (D.ETTN) ekleyin. Hemen altına 2 numaralı alanı (Left Join Cari.ISlemDetaylari) ekleyin. Son olarak 3 numaralı alanı (@ETTN) ekleyin.

Eklenecek Alanlar:

  1. D.ETTN

  2. Left Join Cari.IslemDetaylari D on D.IslemId=I.Id

  3. @ETTN

------------------------------------------------------------------------------------------------------------------------

(görsel — süreç kitabında)

Resim 10

Resim 10: Resim 9’ daki alanı ekledikten sonra bir kaç satır hemen altına aşağıdaki kodu ekleyiniz.

Eklenecek Alan:

if NOT UPDATE (IsDeleted) AND @ETTN \<>''

BEGIN

RAISERROR('E-DOVIZ FATURASI GONDERILMIS ISLEMLER DUZELTILEMEZ ... ',16,1)

Set @IsError=1

ROLLBACK

RETURN

END

(görsel — süreç kitabında)

Resim 11

Resim 11: Query’ nin en altında FETCH NEXT FROM içerisinde en sonuna resimdeki alanı ekleyiniz.

Eklenecek Alan:

@ETTN
  1. Cari.GetEFaturaBilgileri

EDoviz fatura termal çıktısının son güncel querysi aşağıdaki gibidir. Aşağıdaki kodu çalıştırdıktan sonra yeni tasarımları var olan tasarımların üzerine yükleyiniz.

(AlimBelgeTermal.repx / SatimBelgeTermal.repx)

Fatura Dizaynı Yüklemek İçin;

(görsel — süreç kitabında)

Resim 12

Resim 12: AIFA DEVELOPER STUDIO sekmesinden Fatura Dizaynı seçiniz ve açılan yeni ekranda değiştirmek istediğiniz tasarımı seçtikten sonra ekranın sağ tarafında bulunan “göz” logosuna tıklayınız.

(görsel — süreç kitabında)

Resim 13

Resim 13: Açılan ekranın sol üst köşesinde bulunan “Open” dosyasına tıklayınız ve yeni tasarımı içeri yükleyiniz ve kaydetmek için “Save From DB” butonuna tıklayınız.

Cari.GetEFaturaBilgileri Query;

ALTER Function [Cari].[GetEFaturaBilgileri](@RecordId int)

returns table

as

return

-----------------------------------

----SAAT SÜTUNUNA DİKKAT EDİNİZ----

-----------------------------------

Select

S.Unvan,S.Adres,S.Ilce,S.Sehir ,

'' as Telefon,

'' as Email,

'' as Web,

S.VergiDairesi,S.VergiNo as VergiNo,

S.RSBKodu,S.TicaretSicilNo,S.YetkiliMuesseseNo,

D.DocNo,

I.Tarih,

D.IstatistikKodu,D.GeldigiUlke,D.GeldigiUlkeKodu,D.GelisNedeni,

D.FaturaAdres ,

D.FaturaUnvan as FaturaUnvan,

FaturaAdi+' '+FaturaSoyadi as FaturaAdSoyad,

D.FaturaIl,D.FaturaIlce,

D.FaturaTelefon,D.FaturaEmail,

D.FaturaVergiDairesi ,

D.FaturaVergiNo,

D.KimlikTipi ,

D.KimlikNo ,

D.MusteriTipi as MusteriTipi,

Case when MusteriTipi=0 then 'GERÇEK KİŞİ'

when MusteriTipi=1 then 'TUZEL KİŞİ'

when MusteriTipi=2 then 'BANKA'

when MusteriTipi=3 then 'YETKİLİ MÜESSESE' end as MusteriTip,

upper(D.ETTN) as ETTN ,

D.DovizKodu ,

D.DovizMiktar ,

D.DovizTLKuru ,

D.VergiDahilTutar ,

D.VergiHaricTutar ,

D.VergiOrani ,

D.VergiTutari ,

Case when D.DovizKodu='USD' then Miktar else I.USDTutar end as DovizTutari,

dbo.YaziIle (D.VergiDahilTutar,1) as YaziIle,

D.GumrukBeyannameTarihi,D.GumrukBeyannameNo,

D.DovizBeyanTutanakNo,D.DovizBeyanTutanakTarihi,

D.GumrukTeyitYazisiTarihi,D.GumrukTeyitYazisiNo,

D.GumrukFaturaNo,

ErrorText ,

Format(I.InsertDate,'HH:mm') as Saat --2008'de çalışmıyor siliniz.

From Cari.Islemler I

Left Join Cari.IslemDetaylari D on D.IslemId =I.Id

Left Join Sistem.Subeler S on S.Id =I.SubeId

Where (I.Id =@RecordId or @RecordId =0)
  1. Muhasebe.EDovizKontrolRaporu

Yeni Fatura Kontrol Raporu eklemek için aşağıdaki kodu çalıştırınız. Çalıştırdıktan sonra rapor ve tasarımı otomatik olarak oluşturulacaktır. Ribbon Designer’ dan raporu ekleyiniz.

Create Function [Muhasebe].[EDovizKontrolRaporu] (@SubeId int,@HesapId int, @BasTarih Date,@SonTarih Date)

returns Table

as

return

Select

I.Id,I.Tarih,

Case When IsSended=0 then 'BEKLİYOR' When ETTN is not null and D.Durum is null then 'GÖNDERİLDİ' When D.Durum='EIPTAL' Then 'IPTAL 'else D.Durum end as Durum ,

Case when D.FaturaUnvan is null or D.FaturaUnvan='' Then D.FaturaAdi + ' ' + D.FaturaSoyadi else IsNull(D.FaturaUnvan,D.FaturaAdi+' '+D.FaturaSoyadi) end as HesapAdi,

Sistem.GetIslemKodu (I.IslemKodu,I.IslemTuru,I.IslemTipi ) as Islem,

Case When LEN(ISNULL(D.FaturaVergiNo,H.VergiNo))=10 then ISNULL(D.FaturaVergiNo,H.VergiNo) Else '' End as VergiNo,

Case When D.KimlikTipi=0 and IsNull(D.KimlikNo,'')<>'' Then D.KimlikNo Else Case When D.KimlikTipi=1 Then '22222222222' Else Case When LEN(IsNull(D.FaturaVergiNo,H.TCNo))=11 Then IsNull(D.FaturaVergiNo,H.TCNo) Else D.KimlikNo end end end as TCNo,

Case When D.KimlikTipi in (1,2) Then D.KimlikNo Else IsNull(H.PassaportNo,'') end as PassaportNo,

Case When I.Yon='+' Then 'A' Else 'S' End as Yon,

D.DovizKodu as Kodu,

D.DovizMiktar as Miktar,

D.DovizTLKuru as Fiyat,

D.VergiDahilTutar as NetTutar,

I.Birim,

D.SiraNo,

D.IstatistikKodu as Istatistik,

H.HesapAdi as Hesap,I.Vade,I.Aciklama,I.InsertDate as Kayıt,

S.Kodu as Sube,K.Kodu as Kasa,U.UserName as Kullanıcı,

D.ETTN,

D.DocNo as FaturaNo,

D.VergiHaricTutar as BSMVsiz,

D.VergiTutari as BSMV ,

D.VergiDahilTutar as TLTutar,

(Case when Left(I.Kodu,3)='USD' then Miktar when Birim='USD' then Tutar else Case when isnull([UsdKur],(0))<>(0) AND isnull([Tutar],(0))<>(0) AND isnull([BirimKur],(0))<>(0) then CONVERT([decimal](18,2),Fn.Bol(([Tutar]*[BirimKur]),isnull([UsdKur],[USDkur])),(0)) end end) as USDTutar

from Cari.IslemDetaylari D

Left Join Cari.Islemler I on D.IslemId =I.Id

Left Join Cari.Hesaplar H on H.Id =I.HesapId

Left Join Sistem.Users U on U.Id =I.UserId

Left Join Sistem.Subeler S on S.Id =I.SubeId

Left Join Sistem.Kasalar K on K.Id =I.KasaId

Where (I.SubeId =@SubeId) and I.IsDeleted='False' and

(I.Tarih>=@BasTarih And I.Tarih<=@SonTarih) and

I.SubeId=@SubeId And

(I.HesapId=@HesapId or @HesapId=0) And

(D.FaturaNo >0 or I.IslemTipi =12) And IslemKodu not in (1,2)

GO

INSERT INTO AifaDev.Reports(RefNo,CreatedDate,ReportName,[Description],Developer,[SQL],[Password],[IsGrid],[IsPivot],[IsReport],[GroupId]) Values('C9150F4FAE5544D8A3F8F5C14953D95F','2022-02-17','EDovizKontrolRaporu','','MS','select * from [Muhasebe].[EDovizKontrolRaporu] (@SubeId,@HesapId,@BasTarih,@SonTarih)','','True','False','False','0')

Declare @ReportId int =(SELECT SCOPE_IDENTITY())

Insert Into AifaDev.ReportLayouts(ReportId,LayoutType,LayoutName,Layout) Values(@ReportId,'0','1-Genel Görünüm','<XtraSerializer version="1.0" application="View">

\<property name="#LayoutVersion" />

\<property name="VertScrollTipFieldName" />

\<property name="PreviewFieldName" />

\<property name="GroupPanelText">Gruplandırmak Istediğiniz Sutunu Buraya Taşıyınız....\</property>

\<property name="NewItemRowText" />

\<property name="LevelIndent">-1\</property>

\<property name="PreviewIndent">-1\</property>

\<property name="PreviewLineCount">-1\</property>

\<property name="ScrollStyle">LiveVertScroll, LiveHorzScroll\</property>

\<property name="FocusRectStyle">CellFocus\</property>

\<property name="HorzScrollStep">3\</property>

\<property name="ActiveFilterEnabled">true\</property>

\<property name="ViewCaptionHeight">-1\</property>

\<property name="Columns" iskey="true" value="29">

\<property name="Item1" isnull="true" iskey="true">

\<property name="Width">60\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">0\</property>

\<property name="Name">colId\</property>

\<property name="FieldName">Id\</property>

\</property>

\<property name="Item2" isnull="true" iskey="true">

\<property name="Width">65\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">1\</property>

\<property name="Name">colTarih\</property>

\<property name="FieldName">Tarih\</property>

\</property>

\<property name="Item3" isnull="true" iskey="true">

\<property name="Width">71\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">26\</property>

\<property name="Name">colDurum\</property>

\<property name="FieldName">Durum\</property>

\</property>

\<property name="Item4" isnull="true" iskey="true">

\<property name="Width">280\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">3\</property>

\<property name="Name">colHesapAdi\</property>

\<property name="FieldName">HesapAdi\</property>

\</property>

\<property name="Item5" isnull="true" iskey="true">

\<property name="Width">45\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">2\</property>

\<property name="Name">colIslem\</property>

\<property name="FieldName">Islem\</property>

\</property>

\<property name="Item6" isnull="true" iskey="true">

\<property name="Width">80\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">9\</property>

\<property name="Name">colVergiNo\</property>

\<property name="FieldName">VergiNo\</property>

\</property>

\<property name="Item7" isnull="true" iskey="true">

\<property name="Width">82\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">10\</property>

\<property name="Name">colTCNo\</property>

\<property name="FieldName">TCNo\</property>

\</property>

\<property name="Item8" isnull="true" iskey="true">

\<property name="Width">94\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">11\</property>

\<property name="Name">colPassaportNo\</property>

\<property name="FieldName">PassaportNo\</property>

\</property>

\<property name="Item9" isnull="true" iskey="true">

\<property name="Width">38\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">4\</property>

\<property name="Name">colYon\</property>

\<property name="FieldName">Yon\</property>

\<property name="Summary" iskey="true" value="1">

\<property name="Item1" isnull="true" iskey="true">

\<property name="FieldName">Yon\</property>

\<property name="Tag" isnull="true" />

\<property name="DisplayFormat">{0}\</property>

\<property name="SummaryType">Count\</property>

\</property>

\</property>

\</property>

\<property name="Item10" isnull="true" iskey="true">

\<property name="Width">45\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">12\</property>

\<property name="Name">colKodu\</property>

\<property name="FieldName">Kodu\</property>

\</property>

\<property name="Item11" isnull="true" iskey="true">

\<property name="DisplayFormat" isnull="true" iskey="true">

\<property name="FormatString">n2\</property>

\<property name="FormatType">Numeric\</property>

\</property>

\<property name="Width">88\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">13\</property>

\<property name="Name">colMiktar\</property>

\<property name="FieldName">Miktar\</property>

\<property name="Summary" iskey="true" value="1">

\<property name="Item1" isnull="true" iskey="true">

\<property name="FieldName">Miktar\</property>

\<property name="Tag" isnull="true" />

\<property name="DisplayFormat">{0:n2}\</property>

\<property name="SummaryType">Sum\</property>

\</property>

\</property>

\</property>

\<property name="Item12" isnull="true" iskey="true">

\<property name="DisplayFormat" isnull="true" iskey="true">

\<property name="FormatString">n5\</property>

\<property name="FormatType">Numeric\</property>

\</property>

\<property name="Width">82\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">14\</property>

\<property name="Name">colFiyat\</property>

\<property name="FieldName">Fiyat\</property>

\</property>

\<property name="Item13" isnull="true" iskey="true">

\<property name="Width">273\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">25\</property>

\<property name="Name">colHesap\</property>

\<property name="FieldName">Hesap\</property>

\</property>

\<property name="Item14" isnull="true" iskey="true">

\<property name="DisplayFormat" isnull="true" iskey="true">

\<property name="FormatString">n2\</property>

\<property name="FormatType">Numeric\</property>

\</property>

\<property name="Width">114\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">17\</property>

\<property name="Name">colNetTutar\</property>

\<property name="FieldName">NetTutar\</property>

\<property name="Summary" iskey="true" value="1">

\<property name="Item1" isnull="true" iskey="true">

\<property name="FieldName">NetTutar\</property>

\<property name="Tag" isnull="true" />

\<property name="DisplayFormat">{0:n2}\</property>

\<property name="SummaryType">Sum\</property>

\</property>

\</property>

\</property>

\<property name="Item15" isnull="true" iskey="true">

\<property name="Width">42\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">18\</property>

\<property name="Name">colBirim\</property>

\<property name="FieldName">Birim\</property>

\</property>

\<property name="Item16" isnull="true" iskey="true">

\<property name="Width">54\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">6\</property>

\<property name="Name">colSiraNo\</property>

\<property name="FieldName">SiraNo\</property>

\</property>

\<property name="Item17" isnull="true" iskey="true">

\<property name="Width">61\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">5\</property>

\<property name="Name">colIstatistik\</property>

\<property name="FieldName">Istatistik\</property>

\</property>

\<property name="Item18" isnull="true" iskey="true">

\<property name="Width">65\</property>

\<property name="ColumnEditName" />

\<property name="Name">colVade\</property>

\<property name="FieldName">Vade\</property>

\</property>

\<property name="Item19" isnull="true" iskey="true">

\<property name="Width">253\</property>

\<property name="ColumnEditName" />

\<property name="Name">colAciklama\</property>

\<property name="FieldName">Aciklama\</property>

\</property>

\<property name="Item20" isnull="true" iskey="true">

\<property name="DisplayFormat" isnull="true" iskey="true">

\<property name="FormatString">g\</property>

\<property name="FormatType">DateTime\</property>

\</property>

\<property name="Width">105\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">24\</property>

\<property name="Name">colKayıt\</property>

\<property name="FieldName">Kayıt\</property>

\</property>

\<property name="Item21" isnull="true" iskey="true">

\<property name="Width">98\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">23\</property>

\<property name="Name">colSube\</property>

\<property name="FieldName">Sube\</property>

\</property>

\<property name="Item22" isnull="true" iskey="true">

\<property name="Width">86\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">21\</property>

\<property name="Name">colKasa\</property>

\<property name="FieldName">Kasa\</property>

\</property>

\<property name="Item23" isnull="true" iskey="true">

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">22\</property>

\<property name="Name">colKullanıcı\</property>

\<property name="FieldName">Kullanıcı\</property>

\</property>

\<property name="Item24" isnull="true" iskey="true">

\<property name="Width">231\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">8\</property>

\<property name="Name">colETTN\</property>

\<property name="FieldName">ETTN\</property>

\</property>

\<property name="Item25" isnull="true" iskey="true">

\<property name="Width">108\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">7\</property>

\<property name="Name">colFaturaNo\</property>

\<property name="FieldName">FaturaNo\</property>

\</property>

\<property name="Item26" isnull="true" iskey="true">

\<property name="DisplayFormat" isnull="true" iskey="true">

\<property name="FormatString">n2\</property>

\<property name="FormatType">Numeric\</property>

\</property>

\<property name="Width">114\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">15\</property>

\<property name="Name">colBSMVsiz\</property>

\<property name="FieldName">BSMVsiz\</property>

\<property name="Summary" iskey="true" value="1">

\<property name="Item1" isnull="true" iskey="true">

\<property name="FieldName">BSMVsiz\</property>

\<property name="Tag" isnull="true" />

\<property name="DisplayFormat">{0:n2}\</property>

\<property name="SummaryType">Sum\</property>

\</property>

\</property>

\</property>

\<property name="Item27" isnull="true" iskey="true">

\<property name="DisplayFormat" isnull="true" iskey="true">

\<property name="FormatString">n2\</property>

\<property name="FormatType">Numeric\</property>

\</property>

\<property name="Width">70\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">16\</property>

\<property name="Name">colBSMV\</property>

\<property name="FieldName">BSMV\</property>

\<property name="Summary" iskey="true" value="1">

\<property name="Item1" isnull="true" iskey="true">

\<property name="FieldName">BSMV\</property>

\<property name="Tag" isnull="true" />

\<property name="DisplayFormat">{0:n2}\</property>

\<property name="SummaryType">Sum\</property>

\</property>

\</property>

\</property>

\<property name="Item28" isnull="true" iskey="true">

\<property name="DisplayFormat" isnull="true" iskey="true">

\<property name="FormatString">n2\</property>

\<property name="FormatType">Numeric\</property>

\</property>

\<property name="Width">90\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">19\</property>

\<property name="Name">colTLTutar\</property>

\<property name="FieldName">TLTutar\</property>

\</property>

\<property name="Item29" isnull="true" iskey="true">

\<property name="DisplayFormat" isnull="true" iskey="true">

\<property name="FormatString">n2\</property>

\<property name="FormatType">Numeric\</property>

\</property>

\<property name="Width">80\</property>

\<property name="Visible">true\</property>

\<property name="ColumnEditName" />

\<property name="VisibleIndex">20\</property>

\<property name="Name">colUSDTutar\</property>

\<property name="FieldName">USDTutar\</property>

\</property>

\</property>

\<property name="ViewCaption"> \</property>

\<property name="BorderStyle">Simple\</property>

\<property name="SynchronizeClones">true\</property>

\<property name="DetailTabHeaderLocation">Top\</property>

\<property name="Name">GrdView\</property>

\<property name="DetailHeight">350\</property>

\<property name="ChildGridLevelName" />

\<property name="GroupFormat">{1}\</property>

\<property name="GroupRowHeight">-1\</property>

\<property name="OptionsBehavior" isnull="true" iskey="true">

\<property name="Editable">false\</property>

\<property name="AllowIncrementalSearch">true\</property>

\</property>

\<property name="OptionsSelection" isnull="true" iskey="true">

\<property name="EnableAppearanceFocusedCell">false\</property>

\</property>

\<property name="Appearance" isnull="true" iskey="true">

\<property name="ViewCaption" iskey="true" value="ViewCaption">

\<property name="Options" isnull="true" iskey="true">

\<property name="UseTextOptions">true\</property>

\</property>

\<property name="TextOptions" isnull="true" iskey="true">

\<property name="HAlignment">Near\</property>

\</property>

\</property>

\</property>

\<property name="OptionsPrint" isnull="true" iskey="true">

\<property name="ExpandAllDetails">true\</property>

\</property>

\<property name="OptionsView" isnull="true" iskey="true">

\<property name="ShowFooter">true\</property>

\<property name="ShowGroupPanel">false\</property>

\<property name="EnableAppearanceOddRow">true\</property>

\<property name="EnableAppearanceEvenRow">true\</property>

\<property name="ShowIndicator">false\</property>

\<property name="ShowAutoFilterRow">true\</property>

\<property name="ColumnAutoWidth">false\</property>

\</property>

\<property name="RowSeparatorHeight">0\</property>

\<property name="RowHeight">-1\</property>

\<property name="VertScrollVisibility">Auto\</property>

\<property name="HorzScrollVisibility">Auto\</property>

\<property name="FixedLineWidth">2\</property>

\<property name="FooterPanelHeight">-1\</property>

\<property name="IndicatorWidth">-1\</property>

\<property name="ColumnPanelRowHeight">-1\</property>

\<property name="SortInfo">~Xtra#Base64AAEAAAD/////AQAAAAAAAAAMAgAAAF5EZXZFeHByZXNzLlh0cmFHcmlkLnYxNC4xLCBWZXJzaW9uPTE0LjEuMTAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj1iODhkMTc1NGQ3MDBlNDlhBQEAAAA4RGV2RXhwcmVzcy5YdHJhR3JpZC5Db2x1bW5zLkdyaWRDb2x1bW5Tb3J0SW5mb0NvbGxlY3Rpb24EAAAACmdyb3VwQ291bnQFY2xvbmUPY2xvbmVHcm91cENvdW50E0NvbGxlY3Rpb25CYXNlK2xpc3QAAwADCLMBU3lzdGVtLkNvbGxlY3Rpb25zLkdlbmVyaWMuTGlzdGAxW1tEZXZFeHByZXNzLlh0cmFHcmlkLkNvbHVtbnMuR3JpZENvbHVtblNvcnRJbmZvLCBEZXZFeHByZXNzLlh0cmFHcmlkLnYxNC4xLCBWZXJzaW9uPTE0LjEuMTAuMCwgQ3VsdHVyZT1uZXV0cmFsLCBQdWJsaWNLZXlUb2tlbj1iODhkMTc1NGQ3MDBlNDlhXV0IHFN5c3RlbS5Db2xsZWN0aW9ucy5BcnJheUxpc3QCAAAAAAAAAAkDAAAAAAAAAAkEAAAABAMAAACzAVN5c3RlbS5Db2xsZWN0aW9ucy5HZW5lcmljLkxpc3RgMVtbRGV2RXhwcmVzcy5YdHJhR3JpZC5Db2x1bW5zLkdyaWRDb2x1bW5Tb3J0SW5mbywgRGV2RXhwcmVzcy5YdHJhR3JpZC52MTQuMSwgVmVyc2lvbj0xNC4xLjEwLjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49Yjg4ZDE3NTRkNzAwZTQ5YV1dAwAAAAZfaXRlbXMFX3NpemUIX3ZlcnNpb24EAAAwRGV2RXhwcmVzcy5YdHJhR3JpZC5Db2x1bW5zLkdyaWRDb2x1bW5Tb3J0SW5mb1tdAgAAAAgICQUAAAAAAAAAAAAAAAQEAAAAHFN5c3RlbS5Db2xsZWN0aW9ucy5BcnJheUxpc3QDAAAABl9pdGVtcwVfc2l6ZQhfdmVyc2lvbgUAAAgICQYAAAABAAAABAAAAAcFAAAAAAEAAAAAAAAABC5EZXZFeHByZXNzLlh0cmFHcmlkLkNvbHVtbnMuR3JpZENvbHVtblNvcnRJbmZvAgAAABAGAAAABAAAAAkHAAAADQMMCAAAABlEZXZFeHByZXNzLlh0cmFHcmlkLnYxNC4xBQcAAAAuRGV2RXhwcmVzcy5YdHJhR3JpZC5Db2x1bW5zLkdyaWRDb2x1bW5Tb3J0SW5mbwIAAAAJU29ydE9yZGVyCkNvbHVtbk5hbWUAAQgIAAAAAQAAAAYJAAAABWNvbElkCw==\</property>

\<property name="ActiveFilterString" />

\<property name="GroupSummary" iskey="true" value="0" />

\<property name="FormatConditions" iskey="true" value="2">

\<property name="Item1" isnull="true" iskey="true">

\<property name="ColumnName" />

\<property name="Appearance" isnull="true" iskey="true">

\<property name="Options" isnull="true" iskey="true">

\<property name="UseForeColor">true\</property>

\<property name="UseBackColor">true\</property>

\</property>

\<property name="ForeColor">White\</property>

\<property name="BackColor">Red\</property>

\</property>

\<property name="Condition">Expression\</property>

\<property name="Expression">[Durum] == ''İPTAL''\</property>

\</property>

\<property name="Item2" isnull="true" iskey="true">

\<property name="ColumnName" />

\<property name="Appearance" isnull="true" iskey="true">

\<property name="Options" isnull="true" iskey="true">

\<property name="UseBackColor">true\</property>

\</property>

\<property name="BackColor">Yellow\</property>

\</property>

\<property name="Condition">Expression\</property>

\<property name="Expression">[Durum] == ''BEKLİYOR''\</property>

\</property>

\</property>

\<property name="GroupSummarySortInfoState" />

\<property name="FindFilterText" />

\<property name="FindPanelVisible">false\</property>

\</XtraSerializer>')

Reports.GetPozisyonDetay

ALTER Function [Reports].[GetPozisyonDetay] (@SubeId int,@BasTarih as Date,@SonTarih as Date)

returns table

as

return

Select top 1000000

KODU,

ALIS,

AFIYAT,

ALISTUTAR,

SATIS,

SFIYAT,

SATISTUTAR,

--SATISTUTAR - (SATIS * AFIYAT) AS KZ,--KZ GÖRMESİNLER DİYE BOZDUM,DÜZELMESİ İÇİN KZ OLARAK YAZ--

ALIS -SATIS AS POZISYON,

CASE WHEN (ALIS -SATIS)<0 THEN SFIYAT WHEN ALIS -SATIS >0 THEN AFIYAT END AS PMALIYET

From

(

Select

Br.SiraNo ,

Left(B.Kodu,3) AS KODU ,

SUM(ALIS) AS ALIS,

fn.Bol (SUM(ALISMALIYET),

SUM(ALIS)) AS AFIYAT,

SUM(ALISMALIYET) AS ALISTUTAR,

SUM(SATIS) AS SATIS,

fn.Bol (SUM(SATISMALIYET),

SUM(SATIS)) AS SFIYAT,SUM(SATISMALIYET)AS SATISTUTAR

From

(

Select

TARIH,

HESAPADI,

KODU,

Sum(ALIS) as ALIS, SUM(ALISMALIYET ) AS ALISMALIYET ,

ABS( Sum(SATIS)) as SATIS ,SUM(SATISMALIYET) AS SATISMALIYET

From

(

Select

Tarih AS TARIH,

HesapAdi AS HESAPADI,

Left(Kodu,3) as KODU,

Case When Miktar>0 Then Miktar else 0 End as ALIS,

Case When Miktar>0 Then Tutar else 0 End as ALISMALIYET,

Case When Miktar <0 Then Miktar else 0 End as SATIS,

Case When Miktar <0 Then Tutar else 0 End as SATISMALIYET

From

(

select

Tarih,

H.HesapAdi ,

Case When I.Kodu='TL' Then Birim Else I.Kodu End as Kodu,

Case When Birim='TL'Then Case When IslemYonu ='ALIS' Then Miktar Else Miktar *-1 End When I.Kodu='TL' Then Case When IslemYonu ='ALIS' Then Tutar*-1 Else Tutar End end as Miktar,

Fiyat,

Case When I.Kodu ='TL' Then Miktar Else Tutar * BirimKur End as Tutar

from Cari.Islemler I

Left Join Cari.IslemDetaylari D on D.IslemId =I.Id

Left Join Cari.Hesaplar H on H.Id =I.HesapId

Left Join Sistem.Subeler S on S.Id =I.SubeId

Where I.IslemKodu in (2,3,4,6) And I.IslemTipi <>11 and I.IslemTipi <>12 And I.IsDeleted ='False' And (I.Tarih>=@BasTarih And I.Tarih <=@SonTarih) And

((S.SubeTipi ='DOVIZ' And IsNull(D.FaturaNo,0) <>0) Or S.SubeTipi <>'DOVIZ')

)

Islemler

)

Hacim --WHERE KODU \<>'TL'

GROUP BY TARIH,HESAPADI,KODU

)

B Left Join Sistem.Birimler Br on B.Kodu=br.Kodu

GROUP BY B.KODU ,br.SiraNo

)

x ORDER BY SiraNo

Kaynaklar

  • SRC-PROC-DOC — süreç dokümanı #171
← ÖncekiDestekERPGOLDV2 Versiyon GüncellemeleriKimlik: PROC-170 · Ürün: ERPGOLDV2 · Kategori: Kurulum, bağlantı ve sunucu · Katalog: ERPGOLDV2 Versiyon GünceSonraki →DestekFiyat Akışının DurmasıKimlik: PROC-172 · Ürün: FXTRADERV2 · Kategori: FX Trader ve EDS · Katalog: Fiyat Akışının Durması