{"id":2144,"date":"2017-03-23T11:11:58","date_gmt":"2017-03-23T08:11:58","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=2144"},"modified":"2017-03-23T11:13:01","modified_gmt":"2017-03-23T08:13:01","slug":"erp-urunleri-2-43-00-01-surumu-kullanima-sunulmustur","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/erp-urunleri-2-43-00-01-surumu-kullanima-sunulmustur\/","title":{"rendered":"ERP \u00fcr\u00fcnleri 2.43.00.01 S\u00fcr\u00fcm\u00fc kullan\u0131ma sunulmu\u015ftur"},"content":{"rendered":"

 <\/p>\n

 <\/p>\n\n\n\n\n
<\/td>\n<\/tr>\n
\n
De\u011ferli \u0130\u015f Ortaklar\u0131m\u0131z,<\/div>\n
<\/div>\n
ERP \u00fcr\u00fcnleri 2.43.00.01 S\u00fcr\u00fcm\u00fc kullan\u0131ma sunulmu\u015ftur. Bu s\u00fcr\u00fcmde yap\u0131lan d\u00fczeltme ve geli\u015ftirmeler a\u015fa\u011f\u0131da yer almakta olup s\u00fcr\u00fcm dosyalar\u0131na ftp sitemizden eri\u015febilirsiniz.<\/div>\n
<\/div>\n
\u00d6nemli Uyar\u0131 :<\/strong><\/div>\n
Haz\u0131rlanan s\u00fcr\u00fcm dosyalar\u0131 setup dosyas\u0131 \u015feklinde olup tekrar \u00fcr\u00fcn kurulumunun\u00a0yap\u0131lmas\u0131 gerekmektedir.<\/div>\n
<\/div>\n
2.43.00.00 S\u00fcr\u00fcm kullanan m\u00fc\u015fterilerimiz Firma \u00fczerinde “Tablolar\u0131 S\u00fcr\u00fcme G\u00f6re G\u00fcncelle” i\u015flemi ve D\u00f6nem \u00fczerinde “Veritaban\u0131 Ara\u00e7lar\u0131n\u0131 Olu\u015ftur” i\u015flemi yap\u0131lmas\u0131na gerek olmay\u0131p \u00f6nceki s\u00fcr\u00fcmlerden\u00a0ge\u00e7i\u015f yapacak\u00a0m\u00fc\u015fterilerimiz firma ve d\u00f6nem \u00fczerinde g\u00fcncelleme i\u015flemlerini yapmas\u0131 gerekecektir.<\/div>\n
<\/div>\n
\n
S\u00fcr\u00fcm ge\u00e7i\u015fi sonras\u0131nda, cari hesap fi\u015flerini kullanan m\u00fc\u015fterilerimizde a\u015fa\u011f\u0131daki sorgu ile cari hesap fi\u015fi ile bor\u00e7 takip penceresinde tutar farkl\u0131l\u0131\u011f\u0131\u00a0olan kay\u0131tlar tespit edilebilir.<\/div>\n
Bu kay\u0131tlar tespit edildikten sonra ilgili fi\u015flere\u00a0de\u011fi\u015ftir se\u00e7ene\u011fi ile girilip tekrar\u00a0kaydedillmesi\u00a0tutarlar\u0131n g\u00fcncellenmesini sa\u011flayacakt\u0131r.<\/div>\n
<\/div>\n
SELECT<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0C.LOGICALREF AS ‘Cari_Ref’,<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0C.CODE AS ‘Cari_Kodu’,<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0C.DEFINITION_ AS ‘Cari_\u00dcnvan\u0131’,<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0CL.LOGICALREF AS ‘LineREF’,<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0CASE WHEN CL.MODULENR=5 THEN ‘CAR\u0130’ END AS ‘Mod\u00fcl’,<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0CL.TRCODE AS ‘Fi\u015f_T\u00fcr\u00fc’,<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0CL.TRANNO AS ‘Fi\u015fNo’,<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0CASE WHEN CL.TRCURR=0 THEN ‘YerelParaBirimi’ WHEN CL.TRCURR=1 THEN ‘USD’ WHEN<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0CL.TRCURR=20 THEN ‘EURO’ WHEN CL.TRCURR=160 THEN ‘TL’ ELSE ‘Di\u011fer’ END AS ‘D\u00f6viz_T\u00fcr\u00fc’,<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0CASE WHEN CL.TRCURR=0 THEN CL.AMOUNT ELSE CL.TRNET END AS ‘Line_Tutar’,<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0PY.FICHEREF AS ‘Payt_Ficheref’,<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0PY.TRCURR AS ‘Payt_D\u00f6viz_T\u00fcr\u00fc’,<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0PY.P_TOTAL AS ‘Payt_Tutar (Hatal\u0131)’<\/div>\n
FROM<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0LG_FFF_DD_CLFLINE CL WITH(NOLOCK)<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0LEFT OUTER JOIN LG_FFF_CLCARD C WITH(NOLOCK) ON CL.CLIENTREF=C.LOGICALREF<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0INNER JOIN<\/div>\n
(<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0SELECT<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0CARDREF, MODULENR, FICHEREF, TRCURR, SUM(TOTAL) AS P_TOTAL<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0FROM<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0LG_FFF_DD_PAYTRANS WITH(NOLOCK)<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0WHERE<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0MODULENR=5<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0GROUP BY<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0CARDREF, MODULENR, FICHEREF, TRCURR<\/div>\n
)<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0PY ON CL.LOGICALREF=PY.FICHEREF AND CL.MODULENR=PY.MODULENR AND CL.TRCURR=PY.TRCURR<\/div>\n
WHERE<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0PY.MODULENR=5<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0AND ABS(CASE WHEN CL.TRCURR=0 THEN CL.AMOUNT ELSE CL.TRNET END – \u00a0PY.P_TOTAL)>0.01<\/div>\n
<\/div>\n
FFF : firma numaras\u0131 (001,002 gibi); DD : d\u00f6nem numaras\u0131 (01, 02, 03 gibi)<\/div>\n
<\/div>\n
2.43.00.01 S\u00fcr\u00fcm \u0130\u00e7eri\u011fi:<\/strong><\/div>\n<\/div>\n
<\/div>\n
\n

\"\"\u00a0<\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
<\/td>\nKay\u0131t Nr<\/b><\/span><\/td>\n\u00dcr\u00fcn<\/b><\/span><\/td>\nTan\u0131m ve A\u00e7\u0131klama<\/b><\/span><\/td>\n<\/tr>\n<\/tbody>\n
1<\/td>\nWINERP-63708<\/span><\/a><\/td>\n\n
GoPlus<\/div>\n
GO3<\/div>\n
TigerPlus<\/div>\n
Tiger3<\/div>\n
TigerEnterprise<\/div>\n
Tiger3Enterprise<\/div>\n<\/td>\n
Finans<\/span>
\n\"\"\u00a0\"\"\u00a0Ana Kay\u0131tlar – Banka Kredileri<\/td>\n<\/tr>\n
Banka Kredileri Taksit Hareketleri Ekran\u0131nda Veri Giri\u015fi Yap\u0131lam\u0131yor.<\/td>\n<\/tr>\n
Banka kredi tan\u0131m\u0131 i\u00e7erisindeki F9- Taksit hareketleri ekran\u0131na veri giri\u015fi yap\u0131lam\u0131yordu, d\u00fczeltildi.<\/td>\n<\/tr>\n
2<\/td>\nWINERP-63600<\/span><\/a><\/td>\n\n
GoPlus<\/div>\n
GO3<\/div>\n
TigerPlus<\/div>\n
Tiger3<\/div>\n
TigerEnterprise<\/div>\n
Tiger3Enterprise<\/div>\n<\/td>\n
Finans<\/span>
\n\"\"\u00a0\"\"\u00a0Hareketler – Cari Hesap Fi\u015fleri<\/td>\n<\/tr>\n
2.43.00 S\u00fcr\u00fcmde, Eklenen Cari Hesap Fi\u015flerine De\u011fi\u015ftir Se\u00e7ene\u011fi \u0130le Girilip Tutar De\u011fi\u015ftirildi\u011finde Bor\u00e7 Takip Ekran\u0131ndaki Tutarlar G\u00fcncellenmiyor.<\/td>\n<\/tr>\n
Eklenen cari hesap fi\u015flerine de\u011fi\u015ftir se\u00e7ene\u011fi ile girilip tutar de\u011fi\u015ftirildi\u011fi durumda bor\u00e7 takip penceresinde ilgili fi\u015fe ait tutar g\u00fcncellenmiyordu, d\u00fczeltildi.<\/td>\n<\/tr>\n
3<\/td>\nWINERP-63524<\/span><\/a><\/td>\n\n
TigerEnterprise<\/div>\n
Tiger3Enterprise<\/div>\n<\/td>\n
USYS<\/span>
\n\"\"\u00a0\"\"\u00a0Kurulu\u015f Bilgileri – Adres Bilgileri<\/td>\n<\/tr>\n
Oracle Veritaban\u0131nda SYS’ e girip Kurulu\u015f Bilgileri alt\u0131nda yer alan Adres Bilgileri ve Banka Bilgileri gibi alanlara geldi\u011fimiz zaman bo\u015f geliyor.<\/td>\n<\/tr>\n
Oracle veritaban\u0131nda sistem i\u015fletmeni (SYS) Kurulu\u015f bilgileri alt\u0131nda yer alan adres ve banka bilgileri alanlar\u0131n\u0131n d\u00fczg\u00fcn listelenmesi sa\u011fland\u0131.<\/td>\n<\/tr>\n
4<\/td>\nWINTLS-5740<\/span><\/a><\/td>\n\n
GoPlus<\/div>\n
GO3<\/div>\n
TigerPlus<\/div>\n
Tiger3<\/div>\n
TigerEnterprise<\/div>\n
Tiger3Enterprise<\/div>\n<\/td>\n<\/tr>\n
Herhangi Bir Fi\u015f \u0130\u00e7erisinden Kart Browserlar\u0131na Ula\u015f\u0131l\u0131p Kartlar \u00dczerinden F9 Men\u00fcden Herhangi Bir Rapor Al\u0131nmak \u0130stendi\u011finde Program Kilitleniyor.<\/td>\n<\/tr>\n
Herhangi bir fi\u015f i\u00e7erisinden kart browserlar\u0131na ula\u015f\u0131l\u0131p rapor al\u0131nmak istendi\u011finde hata al\u0131n\u0131yordu, d\u00fczeltildi.<\/td>\n<\/tr>\n
5<\/td>\nWINERP-63453<\/span><\/a><\/td>\n\n
GoPlus<\/div>\n
GO3<\/div>\n
TigerPlus<\/div>\n
Tiger3<\/div>\n
TigerEnterprise<\/div>\n
Tiger3Enterprise<\/div>\n<\/td>\n
Sat\u0131\u015f ve Da\u011f\u0131t\u0131m<\/span>
\n\"\"\u00a0\"\"\u00a0Hareketler – Sat\u0131\u015f Faturalar\u0131<\/td>\n<\/tr>\n
Muhasebe Parametrelerinde “Muhasebele\u015fen Fi\u015f De\u011fi\u015ftirildi\u011finde\/\u0130ptal Edildi\u011finde Mahsup Fi\u015fi” Silinecek Olarak Se\u00e7ilmi\u015f Ve Muhasebe \u0130\u00e7in Kay\u0131t Revizyon Takibi Yap\u0131lmamas\u0131 Durumda Muhasebele\u015fen Fi\u015f De\u011fi\u015ftirilip Kaydedilmek \u0130stendi\u011finde Access Violation Hatas\u0131 Al\u0131n\u0131yor.<\/td>\n<\/tr>\n
Mahasebe parametrelerinde “Muhasebele\u015fen Fi\u015f De\u011fi\u015ftirildi\u011finde\/\u0130ptal Edildi\u011finde Mahsup Fi\u015fi” silinecek olarak se\u00e7ili oldu\u011fu durumda, Muhasebele\u015fen fi\u015f de\u011fi\u015ftirilip kaydedilmek istendi\u011finde hata al\u0131n\u0131yordu, d\u00fczeltildi.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
<\/div>\n
\n
Sayg\u0131lar\u0131m\u0131zla,<\/div>\n
Logo Yaz\u0131l\u0131m<\/div>\n<\/div>\n<\/td>\n<\/tr>\n
\"\"<\/a>\"\"<\/a>\"\"<\/a>\"\"<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

    De\u011ferli \u0130\u015f Ortaklar\u0131m\u0131z, ERP \u00fcr\u00fcnleri 2.43.00.01 S\u00fcr\u00fcm\u00fc kullan\u0131ma sunulmu\u015ftur. Bu s\u00fcr\u00fcmde yap\u0131lan d\u00fczeltme ve geli\u015ftirmeler a\u015fa\u011f\u0131da yer almakta olup s\u00fcr\u00fcm dosyalar\u0131na ftp sitemizden eri\u015febilirsiniz. \u00d6nemli Uyar\u0131 : Haz\u0131rlanan s\u00fcr\u00fcm dosyalar\u0131 setup dosyas\u0131 \u015feklinde olup tekrar \u00fcr\u00fcn kurulumunun\u00a0yap\u0131lmas\u0131 gerekmektedir. 2.43.00.00 S\u00fcr\u00fcm kullanan m\u00fc\u015fterilerimiz Firma \u00fczerinde “Tablolar\u0131 S\u00fcr\u00fcme G\u00f6re G\u00fcncelle” i\u015flemi ve D\u00f6nem \u00fczerinde “Veritaban\u0131 […]<\/p>\n","protected":false},"author":4,"featured_media":1629,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-2144","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-logo-genel-destek"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=2144"}],"version-history":[{"count":2,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2144\/revisions"}],"predecessor-version":[{"id":2146,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2144\/revisions\/2146"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/1629"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=2144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=2144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=2144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}