{"id":2136,"date":"2017-03-21T09:11:46","date_gmt":"2017-03-21T06:11:46","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=2136"},"modified":"2017-03-21T09:12:02","modified_gmt":"2017-03-21T06:12:02","slug":"erp-urunleri-2-43-00-01","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/erp-urunleri-2-43-00-01\/","title":{"rendered":"ERP \u00fcr\u00fcnleri 2.43.00.01"},"content":{"rendered":"

 <\/p>\n

 <\/p>\n\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.00 s\u00fcr\u00fcm\u00fcm\u00fczde, eklenen cari hesap fi\u015flerine de\u011fi\u015ftir ile girilip tutar de\u011fi\u015ftirildi\u011fi durumda bor\u00e7 takip penceresinde ilgili fi\u015fe ait tutar\u0131n g\u00fcncellenmedi\u011fi g\u00f6r\u00fclm\u00fc\u015ft\u00fcr.<\/div>\n
<\/div>\n
Yar\u0131n g\u00fcn i\u00e7erisinde ya\u015fanan problemin \u00e7\u00f6z\u00fcmlendi\u011fi 2.43.00.01 Ara s\u00fcr\u00fcm\u00fcm\u00fcz ftp adresimize y\u00fcklenecek olup, 2.43.00.01 Ara s\u00fcr\u00fcm\u00fcne ge\u00e7i\u015f sonras\u0131,\u00a0Cari hesap fi\u015flerini kullanan m\u00fc\u015fterilerimizde a\u015fa\u011f\u0131daki sorgu ile cari hesap fi\u015fi ile bor\u00e7 takip penceresinde tutar farkl\u0131 olan kay\u0131tlar tespit edilebilir.<\/div>\n
Bu kay\u0131tlar tespit edildikten sonra ilgili fi\u015flerde tekrar de\u011fi\u015ftir – kaydet yap\u0131lmas\u0131 tutarlar\u0131n g\u00fcncellenmesini sa\u011flayacakt\u0131r.<\/div>\n
<\/div>\n
\n
<\/div>\n
SELECT\u00a0<\/span><\/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<\/span><\/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
)<\/span><\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0PY ON CL.LOGICALREF=PY.FICHEREF AND CL.MODULENR=PY.MODULENR AND CL.TRCURR=PY.TRCURR<\/div>\n
WHERE<\/span><\/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<\/div>\n
Sayg\u0131lar\u0131m\u0131zla,<\/div>\n
\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

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

    De\u011ferli \u0130\u015f Ortaklar\u0131m\u0131z, ERP \u00fcr\u00fcnleri 2.43.00.00 s\u00fcr\u00fcm\u00fcm\u00fczde, eklenen cari hesap fi\u015flerine de\u011fi\u015ftir ile girilip tutar de\u011fi\u015ftirildi\u011fi durumda bor\u00e7 takip penceresinde ilgili fi\u015fe ait tutar\u0131n g\u00fcncellenmedi\u011fi g\u00f6r\u00fclm\u00fc\u015ft\u00fcr. Yar\u0131n g\u00fcn i\u00e7erisinde ya\u015fanan problemin \u00e7\u00f6z\u00fcmlendi\u011fi 2.43.00.01 Ara s\u00fcr\u00fcm\u00fcm\u00fcz ftp adresimize y\u00fcklenecek olup, 2.43.00.01 Ara s\u00fcr\u00fcm\u00fcne ge\u00e7i\u015f sonras\u0131,\u00a0Cari hesap fi\u015flerini kullanan m\u00fc\u015fterilerimizde a\u015fa\u011f\u0131daki sorgu ile cari hesap […]<\/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-2136","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\/2136","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=2136"}],"version-history":[{"count":2,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2136\/revisions"}],"predecessor-version":[{"id":2138,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/2136\/revisions\/2138"}],"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=2136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=2136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=2136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}