{"id":3837,"date":"2023-11-30T11:37:38","date_gmt":"2023-11-30T08:37:38","guid":{"rendered":"https:\/\/www.ozgurguler.net\/blog\/?p=3837"},"modified":"2023-11-30T17:09:29","modified_gmt":"2023-11-30T14:09:29","slug":"mikro-edefter-sonrasi-gecmis-degisiklik-tespitleri","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/mikro-edefter-sonrasi-gecmis-degisiklik-tespitleri\/","title":{"rendered":"Mikro eDefter Sonras\u0131 ge\u00e7mi\u015f de\u011fi\u015fiklik tespitleri"},"content":{"rendered":"

Mikro eDefter Sonras\u0131 ge\u00e7mi\u015f de\u011fi\u015fiklikler veya sistemde bozulmalar ya\u015fand\u0131 ise bu durumlar\u0131n tespitleri ve denetim raporlar\u0131n\u0131 a\u015fa\u011f\u0131da sizler i\u00e7in yazd\u0131m umar\u0131m faydal\u0131 olacakt\u0131r.\u00a0<\/p>\n

— SON EDEFTER VER\u0130LME B\u0130LG\u0130LER\u0130 —<\/strong><\/span>
SELECT edefter_create_date “Son Defter Verilme Tarihi”,edefter_malidonem “Son Defter D\u00f6nemi”
FROM E_DEFTER_HAREKETLERI where edefter_maliyil=2023 and edefter_malidonem=(SELECT max(edefter_malidonem) FROM E_DEFTER_HAREKETLERI where edefter_maliyil=2023)<\/p>\n

— SON EDEFTERDEN SONRA GE\u00c7M\u0130\u015eE DE\u011e\u0130\u015e\u0130KL\u0130K YAPILAN F\u0130\u015eLER–<\/span><\/strong>
select fis_tarih “Fi\u015f Tarihi”,fis_yevmiye_no “Yevmiye”,fis_lastup_date “De\u011fi\u015fiklik Yap\u0131lma Tarihi”,
fis_lastup_user “De\u011fi\u015ftiren Kullan\u0131c\u0131 No” ,
(SELECT User_LongName FROM [MikroDB_V16]..KULLANICILAR WHERE User_no=fis_lastup_user) “De\u011fi\u015ftiren Kullan\u0131c\u0131 Ad\u0131”<\/p>\n

from MUHASEBE_FISLERI
where fis_tarih<‘2023-08-29’ and fis_maliyil=2023
and fis_lastup_date>’2023-06-30′
group by fis_tarih,fis_yevmiye_no,fis_lastup_date,fis_lastup_user
order by fis_tarih,fis_yevmiye_no,fis_lastup_date,fis_lastup_user<\/p>\n

— DEFTER \u0130LE VER\u0130 KONTROL\u00dc —<\/span><\/strong>
SELECT edefter_create_date “Son Defter Verilme Tarihi”,
edefter_maliyil “Y\u0131l”,
edefter_malidonem “Son Defter D\u00f6nemi” ,
edefter_borc_toplam “Defter Bor\u00e7”,
edefter_alacak_toplam “Defter Alacak”,
edefter_ilkyevmiye “Defter \u0130lk Madde”,
(select MIN(fis_yevmiye_no)
from MUHASEBE_FISLERI where MONTH(fis_tarih)=edefter_malidonem AND YEAR(fis_tarih)=2023) “Mikro \u0130lk Madde”,
edefter_sonyevmiye “Defter Son Madde”,
(select MAX(fis_yevmiye_no)
from MUHASEBE_FISLERI where MONTH(fis_tarih)=edefter_malidonem AND YEAR(fis_tarih)=2023) “Mikro SonMadde”<\/p>\n

FROM E_DEFTER_HAREKETLERI
where edefter_maliyil=2023<\/p>\n

— DEFTER \u0130LE VER\u0130 KONTROL\u00dc VE TOPLAMLAR KONTROL\u00dc–<\/span><\/strong><\/p>\n

SELECT edefter_create_date “Son Defter Verilme Tarihi”,
edefter_maliyil “Y\u0131l”,
edefter_malidonem “Son Defter D\u00f6nemi” ,<\/p>\n

edefter_borc_toplam “Defter Bor\u00e7”,
(select SUM(CASE WHEN fis_meblag0 > 0 THEN ROUND(fis_meblag0,2) ELSE 0 END)
from MUHASEBE_FISLERI where MONTH(fis_tarih)=edefter_malidonem AND YEAR(fis_tarih)=2023) “Mikro Bor\u00e7”,
(
edefter_borc_toplam –
(select SUM(CASE WHEN fis_meblag0 > 0 THEN ROUND(fis_meblag0,2) ELSE 0 END)
from MUHASEBE_FISLERI where MONTH(fis_tarih)=edefter_malidonem AND YEAR(fis_tarih)=2023)
) “Bro\u00e7 Toplam Fark\u0131”,<\/p>\n

edefter_alacak_toplam “Defter Alacak”,
(select SUM(CASE WHEN fis_meblag0 < 0 THEN ROUND(abs(fis_meblag0),2) ELSE 0 end)
from MUHASEBE_FISLERI where MONTH(fis_tarih)=edefter_malidonem AND YEAR(fis_tarih)=2023) “Mikro Alacak”,<\/p>\n

(edefter_alacak_toplam –
(select SUM(CASE WHEN fis_meblag0 < 0 THEN ROUND(abs(fis_meblag0),2) ELSE 0 end)
from MUHASEBE_FISLERI where MONTH(fis_tarih)=edefter_malidonem AND YEAR(fis_tarih)=2023)) “Alacak Fark\u0131”,<\/p>\n

edefter_ilkyevmiye “Defter \u0130lk Madde”,
(select MIN(fis_yevmiye_no)
from MUHASEBE_FISLERI where MONTH(fis_tarih)=edefter_malidonem AND YEAR(fis_tarih)=2023) “Mikro \u0130lk Madde”,
edefter_sonyevmiye “Defter Son Madde”,
(select MAX(fis_yevmiye_no)
from MUHASEBE_FISLERI where MONTH(fis_tarih)=edefter_malidonem AND YEAR(fis_tarih)=2023) “Mikro SonMadde”<\/p>\n

FROM E_DEFTER_HAREKETLERI
where edefter_maliyil=2023<\/p>\n\n\n

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

Not : Defter datalar\u0131 d\u00fczeltilemeyecek kadar kar\u0131\u015fm\u0131\u015f ise irtibata ge\u00e7ebilirsiniz.<\/p>\n\n\n\n

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

Mikro eDefter Sonras\u0131 ge\u00e7mi\u015f de\u011fi\u015fiklikler veya sistemde bozulmalar ya\u015fand\u0131 ise bu durumlar\u0131n tespitleri ve denetim raporlar\u0131n\u0131 a\u015fa\u011f\u0131da sizler i\u00e7in yazd\u0131m umar\u0131m faydal\u0131 olacakt\u0131r.\u00a0 — SON EDEFTER VER\u0130LME B\u0130LG\u0130LER\u0130 —SELECT edefter_create_date “Son Defter Verilme Tarihi”,edefter_malidonem “Son Defter D\u00f6nemi” FROM E_DEFTER_HAREKETLERI where edefter_maliyil=2023 and edefter_malidonem=(SELECT max(edefter_malidonem) FROM E_DEFTER_HAREKETLERI where edefter_maliyil=2023) — SON EDEFTERDEN SONRA GE\u00c7M\u0130\u015eE DE\u011e\u0130\u015e\u0130KL\u0130K YAPILAN […]<\/p>\n","protected":false},"author":4,"featured_media":1637,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,9,10],"tags":[36,35,40],"class_list":["post-3837","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-e-defter","category-mikro-yazilimevi","category-sql-server-tsql","tag-e-defter","tag-edefter","tag-mikro"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/3837","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=3837"}],"version-history":[{"count":3,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/3837\/revisions"}],"predecessor-version":[{"id":3841,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/3837\/revisions\/3841"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/1637"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=3837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=3837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=3837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}