{"id":272,"date":"2014-09-16T14:39:54","date_gmt":"2014-09-16T11:39:54","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=272"},"modified":"2014-09-16T14:40:16","modified_gmt":"2014-09-16T11:40:16","slug":"mikro-muhasebe-cari-karsilastirma-raporu","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/mikro-muhasebe-cari-karsilastirma-raporu\/","title":{"rendered":"Mikro Muhasebe – Cari Kar\u015f\u0131la\u015ft\u0131rma Raporu"},"content":{"rendered":"

Mikro Muhasebe – Cari Kar\u015f\u0131la\u015ft\u0131rma Raporu i\u00e7in kullan\u0131m \u015fekli<\/p>\n

select * from dbo.CARI_MUHASEBE_KARSILASTIRMA<\/p>\n

ilgili proseduru a\u015fa\u011f\u0131daki \u015fekilde olu\u015fturabilirsiniz<\/p>\n

<\/p>\n

 <\/p>\n

CREATE VIEW dbo.CARI_MUHASEBE_KARSILASTIRMA WITH Encryption<\/p>\n

AS<\/p>\n

SELECT TOP 100 PERCENT<\/p>\n

cari_kod AS [Cari Kodu]<\/p>\n

,ISNULL(cari_unvan1,”) AS [Cari \u00dcnvan\u0131]<\/p>\n

,cari_muh_kod AS [Cari Muhasebe Kodu]<\/p>\n

,CASE WHEN muh_hesap_kod IS NULL THEN ‘Yok’ELSE ‘Var’END AS [Muhasebe Hesap Kodu]<\/p>\n

,ISNULL(muh_hesap_isim1,”) AS [Muhasebe Hesap \u00dcnvan\u0131]<\/p>\n

,ISNULL(SUM(dbo.fn_CariHesapAnaDovizBakiye(”,0,cari_kod,”,”,NULL,NULL,NULL,0)),”) AS [Cari Bakiye]<\/p>\n

,ISNULL(SUM(dbo.fn_muhbakiye(muh_hesap_kod, dbo.fn_GetAktifFirma(), dbo.fn_GetAktifMaliYil(), 0)),”) AS [Muhasebe Bakiye]<\/p>\n

FROM dbo.CARI_HESAPLAR WITH(NOLOCK)<\/p>\n

FULL OUTER JOIN dbo.MUHASEBE_HESAP_PLANI WITH(NOLOCK)<\/p>\n

ON (muh_hesap_kod=cari_muh_kod)<\/p>\n

WHERE cari_muh_kod<>”<\/p>\n

GROUP BY cari_kod, cari_unvan1, cari_muh_kod, muh_hesap_kod, muh_hesap_isim1<\/p>\n

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

Mikro Muhasebe – Cari Kar\u015f\u0131la\u015ft\u0131rma Raporu i\u00e7in kullan\u0131m \u015fekli select * from dbo.CARI_MUHASEBE_KARSILASTIRMA ilgili proseduru a\u015fa\u011f\u0131daki \u015fekilde olu\u015fturabilirsiniz<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-272","post","type-post","status-publish","format-standard","hentry","category-mikro-yazilimevi"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/272","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=272"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/272\/revisions"}],"predecessor-version":[{"id":273,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/272\/revisions\/273"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}