{"id":5573,"date":"2017-10-10T15:13:36","date_gmt":"2017-10-10T15:13:36","guid":{"rendered":"http:\/\/www.erplybooks.com\/?page_id=5573\/"},"modified":"2023-07-04T11:21:58","modified_gmt":"2023-07-04T11:21:58","slug":"koondaruanne","status":"publish","type":"page","link":"https:\/\/www.erplybooks.com\/et\/juhendid\/koondaruanne\/","title":{"rendered":"Koondaruanne"},"content":{"rendered":"<h1>Koondaruanne<\/h1>\n<p><span style=\"font-weight: 400;\">Koondaruanne on finantsaruanne, kus koondatakse samade v\u00e4ljade andmed. N\u00e4iteks kui Sul on kaks kannet, millel samad projektid, k\u00e4ibemaks, kontod jne, siis need liidetakse koondaruandes kokku. <\/span><\/p>\n<p>Koondaruanne sisaldab andmemassiivi t\u00e4pselt sellises j\u00e4rjestuses ja ulatuses nagu Sul tarvis on.<\/p>\n<p>Seda saab alla laadida <strong>CSV failina.<\/strong><\/p>\n<p>Koondaruannete saamiseks v\u00f5id kasutada ERPLY Books&#8217;i t\u00e4ies mahus v\u00f5i siis olla ainult m\u00f5ndade funktsioonide aktiivne kasutaja.<\/p>\n<p><strong>Koondkanne<\/strong> on kannete koond dimensioonide l\u00f5ikes m\u00e4\u00e4ratud perioodis, arvestades, et koondkandes on k\u00f5ik erinevad dimensioonide grupid. Dimensioonid on k\u00e4ibemaksud, projektid, kontod. Koondaruanne n\u00e4itab v\u00e4himat dimensioonide gruppi.<\/p>\n<h2><strong>Koondaruandesse saab lisada j\u00e4rgmised v\u00e4ljad<\/strong><\/h2>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Projektigrupid<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u00e4ibemaksud<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kliendi andmed (nimi, kood (nt: tehingupartneri kood v\u00f5etakse kliendikoodi lahtrist), registrikood)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kontod (number, nimi)<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><strong>Koondaruanne: veergude t\u00e4hendused<\/strong><\/h2>\n<p>Tr\u00fcki pealehe otsingusse <strong>\u201cKoondaruande vorm\u201d<\/strong>.<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>Nimi<\/strong> &#8211; enda poolt valitud nimi, mida soovid Excelis n\u00e4ha<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>Projektigrupp<\/strong> (2. veerg) &#8211; projektigrupp (vajadusel)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>T\u00fc\u00fcp<\/strong> &#8211; kui pole projektigrupp<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>J\u00e4rjekord<\/strong> &#8211; j\u00e4rjekord Excelis, n\u00e4itab mitmendas veerus antud ettev\u00f5tte andmed asuvad<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Kui soovid enda kontolt koondaruannet alla laadida, siis v\u00f5ta \u00fchendust <\/span><a href=\"mailto:support@erplybooks.com\"><span style=\"font-weight: 400;\">support@erplybooks.com<\/span><\/a><span style=\"font-weight: 400;\">. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Saad alla laadida CSV faili, kus annab kindlas kuup\u00e4evavahemikus need parameetrid, mis on dimensioonides valitud. N\u00e4itab dimensioone eri ridades ja j\u00e4rjekorra numbri alusel ettev\u00f5tte kaupa.<\/span><\/p>\n<p><strong>NB! <\/strong>Kui soovid koondaruandes pealdise v\u00e4lja j\u00e4tta, siis kasuta globaalset attribuuti: <strong>&#8220;GLOBAL_EXCLUDE_SUMMARY_REPORT_HEADER&#8221;<\/strong>. Tr\u00fcki pealehe otsingusse <strong>&#8220;Globaalsed attribuudid&#8221;<\/strong>, lisa uus rida ja sisesta attribuut.<\/p>\n<p>Lisaks saad lisada koondaruandesse kinnitatud v\u00e4\u00e4rtusi. T\u00fc\u00fcp peaks olema FIXED_VALUE ja Alt. Value2 peaks olema fikseeritud v\u00e4\u00e4rtus.<\/p>\n<p><strong>N\u00e4iteks:<\/strong> Valuuta veerus peab olema alati v\u00e4\u00e4rtus EUR.<\/p>\n<h2><strong>Projektide ID kirjeldus allalaetud failis \u00a0<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">ID kirjelduse saab m\u00e4\u00e4rata minnes <strong>\u201cS\u00e4tted\u201d &gt; \u201cAlgandmed\u201d &gt; \u201cProjektid\u201d &gt;<\/strong> veerg <strong>\u201cKirjeldus\/ID\u201d<\/strong>.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23213 size-full\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2021\/08\/Screenshot-2021-08-11-at-14.28.30.png\" alt=\"koondaruanne\" width=\"2880\" height=\"866\" srcset=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2021\/08\/Screenshot-2021-08-11-at-14.28.30.png 2880w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2021\/08\/Screenshot-2021-08-11-at-14.28.30-1280x385.png 1280w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2021\/08\/Screenshot-2021-08-11-at-14.28.30-980x295.png 980w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2021\/08\/Screenshot-2021-08-11-at-14.28.30-480x144.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) and (max-width: 1280px) 1280px, (min-width: 1281px) 2880px, 100vw\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Koondaruanne Koondaruanne on finantsaruanne, kus koondatakse samade v\u00e4ljade andmed. N\u00e4iteks kui Sul on kaks kannet, millel samad projektid, k\u00e4ibemaks, kontod jne, siis need liidetakse koondaruandes kokku. Koondaruanne sisaldab andmemassiivi t\u00e4pselt sellises j\u00e4rjestuses ja ulatuses nagu Sul tarvis on. Seda saab alla laadida CSV failina. Koondaruannete saamiseks v\u00f5id kasutada ERPLY Books&#8217;i t\u00e4ies mahus v\u00f5i siis olla [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":3312,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[451],"tags":[610,622],"class_list":["post-5573","page","type-page","status-publish","hentry","category-aruandlus","tag-aruanne","tag-koondaruanne"],"_links":{"self":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/5573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/comments?post=5573"}],"version-history":[{"count":0,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/5573\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/3312"}],"wp:attachment":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/media?parent=5573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/categories?post=5573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/tags?post=5573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}