{"id":959,"date":"2015-04-26T01:23:06","date_gmt":"2015-04-25T22:23:06","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=959"},"modified":"2016-04-11T16:31:00","modified_gmt":"2016-04-11T13:31:00","slug":"mikro-e-defter-sorunlar-ve-cozumler","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/mikro-e-defter-sorunlar-ve-cozumler\/","title":{"rendered":"Mikro e-Defter Sorunlar ve \u00c7\u00f6z\u00fcmler"},"content":{"rendered":"

T\u00fcm bu i\u015flemleri yapmadan \u00f6nce kesinlikle yedek al\u0131nmal\u0131d\u0131r.<\/p>\n

e-Defter olu\u015fturmada ba\u015f\u0131m\u0131za dert a\u00e7abilecek \u00fc\u00e7 temel hata t\u00fcr\u00fc vard\u0131r. Bunlar s\u0131ras\u0131 ile,<\/p>\n

Bor\u00e7\/alacak e\u015fit olmayan fi\u015fler,<\/p>\n

Bor\u00e7\/alacak decimalden dolay\u0131 e\u015fit olmayan fi\u015fler,<\/p>\n

Bor\u00e7 ya da alacak kolonlar\u0131nda s\u0131f\u0131r(0) mebla\u011f olmas\u0131\u2019 d\u0131r.<\/p>\n

a\u015fa\u011f\u0131daki\u00a0sorgular ile bor\u00e7\/alacak decimal\u2019den dolay\u0131 e\u015fit olmayan kay\u0131tlar\u0131n\u0131z\u0131 g\u00f6rebilirsiniz. Ger\u00e7ekten bor\u00e7 ve alaca\u011f\u0131nda problem olan kay\u0131tlar\u0131(decimal hari\u00e7) fi\u015f \u00f6zet Muhasebe fi\u015fleri y\u00f6netimi(081009) gibi men\u00fclerden kontrol edebilirsiniz.<\/p>\n

<\/p>\n

D\u00fczeltme y\u00f6ntemi olarak s\u0131ras\u0131 ile ,<\/p>\n

Yevmiye madde yeniden numaralama(098100),<\/p>\n

Muhasebe fi\u015flerinin kuru\u015flar\u0131n\u0131 2 haneye yuvarlama ve olu\u015fan farklar\u0131 yuvarlama hesaplar\u0131na aktarma(505045) numaral\u0131 men\u00fcleri \u00e7al\u0131\u015ft\u0131r\u0131n\u0131z.<\/p>\n

Sonras\u0131nda, fi\u015f_meblag0 kolonunda ger\u00e7ekten s\u0131f\u0131r olan kay\u0131tlar var m\u0131\/ yok mu ? durumunu a\u015fa\u011f\u0131daki sorgu ile kontrol edip ve \u00e7\u0131kan kay\u0131tlar\u0131 temizleyiniz.<\/p>\n

SELECT fis_tarih, fis_sira_no, fis_hesap_kod, fis_satir_no, fis_aciklama1, fis_meblag0 FROM MUHASEBE_FISLERI<\/p>\n

WHERE fis_tarih between ‘20140101’ and ‘20140131’ and (fis_meblag0)=0<\/p>\n

–DELETE MUHASEBE_FISLERI<\/p>\n

–WHERE fis_tarih between ‘20140101’ and ‘20140131’ and (fis_meblag0)=0<\/p>\n

Sonras\u0131nda bir kez daha Muhasebe fi\u015flerinin kuru\u015flar\u0131n\u0131 2 haneye yuvarlama ve olu\u015fan farklar\u0131 yuvarlama hesaplar\u0131na aktarma(505045) men\u00fcs\u00fcn\u00fc \u00e7al\u0131\u015ft\u0131rd\u0131m. Bu i\u015flemden sonra yine fis_meblag0 alan\u0131 s\u0131f\u0131r olan kay\u0131tlar oldu. Bu kay\u0131tlar\u0131 da yine a\u015fa\u011f\u0131daki kodla yakalay\u0131p temizledim.<\/p>\n

SELECT fis_tarih, fis_sira_no, fis_hesap_kod, fis_satir_no, fis_aciklama1, fis_meblag0 FROM MUHASEBE_FISLERI<\/p>\n

WHERE fis_tarih between ‘20140101’ and ‘20140131’ and (fis_meblag0)=0<\/p>\n

–DELETE MUHASEBE_FISLERI<\/p>\n

–WHERE fis_tarih between ‘20140101’ and ‘20140131’ and (fis_meblag0)=0<\/p>\n

Sonraki a\u015famada ise ger\u00e7ekten decimali sorunlu olan kay\u0131tlar\u0131 bulup temizledim.<\/p>\n

SELECT fis_tarih, fis_sira_no, fis_hesap_kod, fis_satir_no, fis_aciklama1, fis_meblag0 FROM MUHASEBE_FISLERI<\/p>\n

WHERE fis_tarih between ‘20140101’ and ‘20140131’ and ABS(fis_meblag0)<0.01<\/p>\n

–DELETE MUHASEBE_FISLERI<\/p>\n

–WHERE fis_tarih between ‘20140101’ and ‘20140131’ and ABS(fis_meblag0)<0.01<\/p>\n

Bu i\u015flemlerden sonra muhasebe fi\u015flerimizde bor\u00e7\/ alacak bilgisi decimalden veya ba\u015fka bir sebepten dolay\u0131 e\u015fit olmayan ve fis_meblag0 kolonunda s\u0131f\u0131r olan fi\u015fimiz kalmam\u0131\u015f olacakt\u0131r.<\/p>\n

Yevmiye madde yeniden numaralama(098100) men\u00fcs\u00fcn\u00fc yeniden \u00e7al\u0131\u015ft\u0131r\u0131n\u0131z.<\/p>\n

Sql\u2019den yap\u0131lacak toplu silme ve Muhasebe fi\u015flerinin kuru\u015flar\u0131n\u0131 2 haneye yuvarlama ve olu\u015fan farklar\u0131 yuvarlama hesaplar\u0131na aktarma(505045) men\u00fcs\u00fcn\u00fc \u00e7al\u0131\u015ft\u0131r\u0131lmadan \u00f6nce ve sonra mizan vs. gibi raporlar kontrol edilerek bakiyelerin de\u011fi\u015fmedi\u011fi teyit edilmelidir.<\/p>\n

Not: \u0130\u015flemi \u00e7al\u0131\u015fm\u0131\u015f oldu\u011funuz mikro bayisi ile yapman\u0131z\u0131 \u00f6nermekteyiz.<\/p>\n

————————————————————————————————————<\/p>\n

Mikro Programlar\u0131nda e-Defter i\u00e7in Belge D\u00fczeni<\/strong><\/p>\n

*Olu\u015facak yevmiye fi\u015finin a\u00e7\u0131klamas\u0131 ve genel bilgileri ayr\u0131 fi\u015f numaras\u0131nda raporlanmas\u0131 gere\u011fini sa\u011flamak i\u00e7in, her evrak\u0131n ayr\u0131 muhasebe fi\u015fi olu\u015fturmas\u0131 sa\u011flanmal\u0131d\u0131r<\/strong>. Bu \u015fart\u0131 sa\u011flamak i\u00e7in,<\/p>\n

Entegrasyon \u015fekil parametreleri (096113) men\u00fcs\u00fcnde, Entegrasyonda Fi\u015f Sorulsun <\/strong>ve Entegrasyonda Kategori Kullan\u0131m\u0131 Olsun<\/strong> parametrelerinin i\u015faretli olmamas\u0131n\u0131 tavsiye ediyoruz<\/p>\n

Entegrasyon \u015fekil parametreleri (096113) men\u00fcs\u00fcnde, Entegrasyonda\u00a0 Fi\u015f Sorulsun<\/strong> se\u00e7ilmi\u015fse her evrak i\u00e7in farkl\u0131 bir fi\u015f se\u00e7ilmelidir. Bu nedenle bu se\u00e7ene\u011fin kullan\u0131m amac\u0131 ortadan kalkt\u0131\u011f\u0131 i\u00e7in hi\u00e7 kullan\u0131lmayabilir.<\/p>\n

Entegrasyonda kategori kullan\u0131m\u0131 olsun se\u00e7ene\u011fi kullan\u0131lacaksa, Kategori Kullan\u0131m\u0131nda Maksimum Fi\u015f Sat\u0131r\u0131 2 olarak<\/strong> kullan\u0131lmal\u0131d\u0131r. Evraklardan olu\u015facak muhasebe fi\u015fleri birle\u015ftirilmeyece\u011finden bu se\u00e7enek hi\u00e7 kullan\u0131lmayabilir.<\/p>\n

\"Mikro<\/a><\/p>\n

* S\u0131f\u0131r de\u011ferli<\/strong> muhasebe fi\u015f sat\u0131rlar\u0131 olmamal\u0131d\u0131r.<\/p>\n

Bu duruma yol a\u00e7abilecek % 100 iskontolu sat\u0131\u015f ve al\u0131\u015f faturas\u0131 sat\u0131rlar\u0131nda en az 1 kuru\u015f de\u011fer olmas\u0131 sa\u011flanmal\u0131d\u0131r<\/strong>.<\/p>\n

Alternatif d\u00f6viz d\u00f6n\u00fc\u015f\u00fcm farklar\u0131 virman dekontu (043335) kullan\u0131lacaksa, muhasebeye entegrasyonu yap\u0131lmamal\u0131d\u0131r<\/strong>.<\/p>\n

*Kurulu\u015f program\u0131nda Entegrasyon \u015fekil parametreleri (096113) Genel ticari entegrasyon parametreleri 2 sekmesinde Muhasebe fi\u015f detaylar\u0131 otomatik olu\u015fturulsun<\/strong> parametresi onayl\u0131 olmal\u0131d\u0131r.<\/p>\n

\"Mikro<\/a><\/p>\n

*Program i\u00e7erisindeki evraklar hangi belge t\u00fcr\u00fc ile olu\u015fuyor<\/strong><\/p>\n

Evrak Ad\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Belge T\u00fcr\u00fc<\/strong><\/p>\n

Tahsilat makbuzu\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Makbuz<\/strong><\/p>\n

Tediye makbuzu\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Makbuz<\/strong><\/p>\n

Avans tahsilat makbuzu\u00a0\u00a0\u00a0 Makbuz<\/strong><\/p>\n

Avans \u00f6deme makbuzu\u00a0\u00a0\u00a0\u00a0 Makbuz<\/strong><\/p>\n

Sat\u0131\u015f Faturas\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Fatura<\/strong>(Detaylar\/Belge t\u00fcr\u00fc \/Fatura)<\/p>\n

Al\u0131\u015f Faturas\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Fatura<\/strong>(Detaylar\/Belge t\u00fcr\u00fc\/ Fatura)<\/p>\n

Al\u0131\u015f Faturas\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Navlun<\/strong>(Detaylar\/Belge t\u00fcr\u00fc\/Navlun)<\/p>\n

Al\u0131\u015f\/Sat\u0131\u015f Faturas\u0131\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Other (Di\u011fer) <\/strong>\u00a0\u00a0(Detaylar\/Belge<\/p>\n

t\u00fcr\u00fc\/Fatura ve Navlun se\u00e7imi hari\u00e7<\/p>\n

di\u011fer se\u00e7imler)<\/p>\n

\"Mikro<\/a><\/p>\n

Di\u011fer T\u00fcm evraklar\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Other (Di\u011fer)<\/strong><\/p>\n

Yuvarlama hesaplar\u0131 ile ilgili d\u00fczenlemeler yap\u0131lm\u0131\u015ft\u0131r.\u00a0<\/strong><\/p>\n

Muhasebe fi\u015flerinin kuru\u015flar\u0131n\u0131 2 haneye yuvarlama ve olu\u015fan farklar\u0131 yuvarlama hesaplar\u0131na aktarma (505045).<\/strong><\/p>\n

Bu servis yuvarlama hesab\u0131nda 1 kuru\u015ftan daha k\u00fc\u00e7\u00fck de\u011fer var ise, bu servis \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda onay ile ilgili hesaplar\u0131 fi\u015ften silmektedir.<\/p>\n

Tutar\u0131 (Ana d\u00f6viz) s\u0131f\u0131r olan muhasebe fi\u015f kay\u0131tlar\u0131n\u0131n silinmesi (505050)<\/strong><\/p>\n

Bu servis muhasebe fi\u015finde s\u0131f\u0131r de\u011ferle olu\u015fmu\u015f sat\u0131rlar\u0131 silmektedir<\/p>\n

 <\/p>\n

 <\/p>\n

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

T\u00fcm bu i\u015flemleri yapmadan \u00f6nce kesinlikle yedek al\u0131nmal\u0131d\u0131r. e-Defter olu\u015fturmada ba\u015f\u0131m\u0131za dert a\u00e7abilecek \u00fc\u00e7 temel hata t\u00fcr\u00fc vard\u0131r. Bunlar s\u0131ras\u0131 ile, Bor\u00e7\/alacak e\u015fit olmayan fi\u015fler, Bor\u00e7\/alacak decimalden dolay\u0131 e\u015fit olmayan fi\u015fler, Bor\u00e7 ya da alacak kolonlar\u0131nda s\u0131f\u0131r(0) mebla\u011f olmas\u0131\u2019 d\u0131r. a\u015fa\u011f\u0131daki\u00a0sorgular ile bor\u00e7\/alacak decimal\u2019den dolay\u0131 e\u015fit olmayan kay\u0131tlar\u0131n\u0131z\u0131 g\u00f6rebilirsiniz. Ger\u00e7ekten bor\u00e7 ve alaca\u011f\u0131nda problem olan […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-959","post","type-post","status-publish","format-standard","hentry","category-e-defter"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/959","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=959"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/959\/revisions"}],"predecessor-version":[{"id":963,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/959\/revisions\/963"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=959"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}