{"id":1782,"date":"2016-08-27T11:12:33","date_gmt":"2016-08-27T08:12:33","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=1782"},"modified":"2016-08-27T12:43:56","modified_gmt":"2016-08-27T09:43:56","slug":"mikro-e-defter-toplamlari-uyumsuz","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/mikro-e-defter-toplamlari-uyumsuz\/","title":{"rendered":"Mikro E-Defter Toplamlar\u0131 uyumsuz"},"content":{"rendered":"<p>Mikro programlar\u0131nda e-Defter\u00a0verilirken ge\u00e7mi\u015f defter ile fark \u00e7\u0131kmas\u0131 ve program\u0131n uyar\u0131 vermesi halinde a\u015fa\u011f\u0131daki sorgu ile d\u00fczenleme yapabilirsiniz.<\/p>\n<p><span style=\"color: #800000;\">\u00d6NEML\u0130 = <\/span><\/p>\n<p><span style=\"color: #800000;\">1 &#8211; Bu hata al\u0131nmas\u0131n\u0131n sebebi defter verildikten sonra ge\u00e7mi\u015f d\u00f6neme maliyet servisi \u00e7al\u0131\u015ft\u0131rman\u0131zd\u0131r. Defter verilmi\u015f <span style=\"text-decoration: underline;\"><strong>d\u00f6neme m\u00fcdahale edilemez ve kullan\u0131c\u0131 sorumlulu\u011fundad\u0131r<\/strong><\/span>. Sorgu ile anl\u0131k \u00e7\u00f6z\u00fcm sa\u011flanmakta olup bu konuya \u00e7ok dikkat edilmesi gerekmektedir.<\/span><\/p>\n<p><span style=\"color: #800000;\">2 &#8211; Soru toplamlar\u0131 d\u00fczenlemekte olup <strong><span style=\"text-decoration: underline;\">m\u00fcteselsil numaralar\u0131nda kayma mevcut ise<\/span><\/strong> sistemde fi\u015f de\u011fi\u015fikli\u011fi yap\u0131lm\u0131\u015ft\u0131r. Bu durumda defter vermeyiniz ve fark\u0131 tespit ediniz. Fark tespit edilemiyor ise Bayiniz ile veya \u00e7\u00f6z\u00fcm bulam\u0131yor iseniz bizimle ileti\u015fime ge\u00e7ebilirsiniz.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>update E_DEFTER_HAREKETLERI<\/p>\n<p>set edefter_borc_toplam = (select SUM(CASE WHEN fis_meblag0 &gt; 0 THEN ROUND(fis_meblag0,2) ELSE 0 END)<\/p>\n<p>from dbo.MUHASEBE_FISLERI<\/p>\n<p>where fis_firmano=edefter_firmano and fis_maliyil=edefter_maliyil and<\/p>\n<p>fis_yevmiye_no between edefter_ilkyevmiye and edefter_sonyevmiye),<\/p>\n<p>edefter_alacak_toplam = (select SUM(CASE WHEN fis_meblag0 &lt; 0 THEN ROUND(abs(fis_meblag0),2) ELSE 0 END)<\/p>\n<p>from dbo.MUHASEBE_FISLERI<\/p>\n<p>where fis_firmano=edefter_firmano and fis_maliyil=edefter_maliyil and<\/p>\n<p>fis_yevmiye_no between edefter_ilkyevmiye and edefter_sonyevmiye)<\/p>\n<p>where edefter_firmano=0 and edefter_maliyil=2016 and edefter_malidonem=1<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mikro programlar\u0131nda e-Defter\u00a0verilirken ge\u00e7mi\u015f defter ile fark \u00e7\u0131kmas\u0131 ve program\u0131n uyar\u0131 vermesi halinde a\u015fa\u011f\u0131daki sorgu ile d\u00fczenleme yapabilirsiniz. \u00d6NEML\u0130 = 1 &#8211; Bu hata al\u0131nmas\u0131n\u0131n sebebi defter verildikten sonra ge\u00e7mi\u015f d\u00f6neme maliyet servisi \u00e7al\u0131\u015ft\u0131rman\u0131zd\u0131r. Defter verilmi\u015f d\u00f6neme m\u00fcdahale edilemez ve kullan\u0131c\u0131 sorumlulu\u011fundad\u0131r. Sorgu ile anl\u0131k \u00e7\u00f6z\u00fcm sa\u011flanmakta olup bu konuya \u00e7ok dikkat edilmesi gerekmektedir. 2 [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":1584,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,8],"tags":[],"class_list":["post-1782","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-e-defter","category-logo-genel-destek"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1782","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=1782"}],"version-history":[{"count":3,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1782\/revisions"}],"predecessor-version":[{"id":1786,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1782\/revisions\/1786"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/1584"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}