{"id":29720,"date":"2023-01-23T09:26:15","date_gmt":"2023-01-23T09:26:15","guid":{"rendered":"https:\/\/www.erplybooks.com\/?page_id=29720"},"modified":"2023-07-05T11:18:32","modified_gmt":"2023-07-05T11:18:32","slug":"jaatmearuanne-2","status":"publish","type":"page","link":"https:\/\/www.erplybooks.com\/et\/jaatmearuanne-2\/","title":{"rendered":"J\u00e4\u00e4tmearuanne"},"content":{"rendered":"<h2><span style=\"font-weight: 400;\">Mis on j\u00e4\u00e4tmearuanne ja millest see koosneb?<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p><strong>Antud juhend kirjeldab j\u00e4\u00e4tmearuande komponente ja nende kontrolli.\u00a0 Soovitame j\u00e4\u00e4temaruande kasutamiseks v\u00f5tta juurutuse. Vastava sooviga palun p\u00f6\u00f6rduda info@erplybooks.com.<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">J\u00e4\u00e4tmearuanne on piltlikult \u00f6eldes aruanne, mis \u00fctleb, palju oli alguses j\u00e4\u00e4tmeid, kust tuli neid juurde, kuhu nad l\u00e4ksid ja palju oli j\u00e4\u00e4tmete l\u00f5ppsaldo. J\u00e4\u00e4tmearuanne on koostatud riiklikule j\u00e4\u00e4tmearuande vormile, kuid t\u00e4nu paindlikkusele on seda v\u00f5imalik rakendada suvaliste j\u00e4\u00e4tmeanal\u00fc\u00fcside jaoks.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Riiklik j\u00e4\u00e4tmearuanne ei ole paraku \u00fcksik aruanne, vaid on kombineeritud mitme aruande kogum. K\u00f5ik v\u00e4ljundid on aruandegeneraatori p\u00f5hjal \u00fcles ehitatud ja neid saab \u00fchtse aruandena kombineeritult alla laadida.\u00a0<\/span><\/p>\n<p>Lisainfot j\u00e4\u00e4tmek\u00e4ituse kohta ERPLY Booksis vaata <a href=\"https:\/\/www.erplybooks.com\/et\/jaatmekaitlus-erply-booksis\/\">siit<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-weight: 400;\">J\u00e4\u00e4tmearuande kasutamine ERPLY Booksis<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">J\u00e4\u00e4tmearuanne on koostatud paljude eeldustega (k\u00f5ik eeldused on vastavalt seadistusele muudetavad):\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">J\u00e4\u00e4tmekoodi m\u00e4rgime artiklite all info lahtrisse (saab juurutada ka eraldi koodi lahtrisse)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ainsa dimensioonina on kasutusel osakond (saab juurutada ka projektigrupip\u00f5hiselt)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Laos\u00fcsteemina on kasutusel Erply ladu v\u00f5i laohaldus puudub (st k\u00f5ik funktsioonid on ERPLY Booksi p\u00f5hised &#8211; siis rakendub alg- ja l\u00f5ppsaldode jaoks teine aruanne)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Kontakti koodina on kasutusel kliendi omavalitsus (saab kasutada ka suvalist muud lahtrit selle jaoks)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Laohaldus on tonnides<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Aruandegeneraatorile on lisatud reegel GLOBAL_GENERATOR_ROUNDING, kuhu v\u00e4\u00e4rtuseks m\u00e4rgitud kolm komakohta<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Lao arvelev\u00f5tmised on ERPLY Booksis ostusaatelehtedena, nii et hankijaks on m\u00e4rgitud teie enda firma. Saatelehe lisainfo=REGISTRATION<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Lao mahakandmised on ERPLY Booksis m\u00fc\u00fcgisaatelehtedena, nii et kliendiks on m\u00e4rgitud teie enda firma. Saatelehe lisainfo=WRITEOFF<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ladudevahelised liikumised on ERPLY Booksis m\u00fc\u00fcgisaatelehtedena, nii et kliendiks on m\u00e4rgitud teie enda firma. Saatelehe lisainfo=TRANSFER<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">J\u00e4\u00e4tmete \u00fcmbert\u00f6\u00f6tlemine on ERPLY Booksis ostusaatelehtedena, nii et hankijaks on m\u00e4rgitud teie enda firma. Saatelehe lisainfo=RECYCLING<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">J\u00e4\u00e4tmete \u00fcmbert\u00f6\u00f6tlemine peab koguseliselt nulli minema &#8211; ehk koguseliselt peab RECYCLING tehing andma nullsummam\u00e4ngu.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">T\u00e4rniga (*) on m\u00e4rgitud ohtlikud j\u00e4\u00e4tmed.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">NB: see k\u00f5ik on \u00fcldiselt osa ringmajandusettev\u00f5tte juurutusest.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-weight: 400;\">J\u00e4\u00e4tmearuande koostamine<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Mitme aruande korraga allalaadimise jaoks avage k\u00f5ik aruanded (\u00e4rge otsige) j\u00e4rjekorras, mis j\u00e4rgnevalt v\u00e4lja toodud. Seej\u00e4rel esimeses otsige ja seej\u00e4rel Veel -&gt; Lisa: aruandegeneraator ning avatud aknas valige k\u00f5ige aruanded \u00fckshaaval samas j\u00e4rjekorras.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Esiteks lae alla sissetulekud \u00fchtse failina:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Toodete saldod (nii alg- kui l\u00f5ppsaldod)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ost: EE jur &gt; 10t (non *)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ost: EE jur &gt; 0.1t (*)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ost: non jur<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ost: non EE<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ost: reg<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ost: article-to-article<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ostud: EE jur &lt; 10t (non *)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ostud: EE jur &lt; 0.1t (*)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ost: transfer<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Seej\u00e4rel lae alla v\u00e4ljaminekud \u00fche failina:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">M\u00fc\u00fck: article-to-article<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">M\u00fc\u00fck: transfer<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">M\u00fc\u00fck: tavam\u00fc\u00fck<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">M\u00fc\u00fck: writeoff<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Seej\u00e4rel kontrolli, kas v\u00e4\u00e4rtused klapivad. See t\u00e4hendab, kas kehtib valem:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>Algsaldo + sissetulekud &#8211; v\u00e4ljaminekud &#8211; l\u00f5ppsaldo = 0.<\/strong>\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Valem peab kehtima iga j\u00e4\u00e4tmekoodi l\u00f5ikes &#8211; ehk iga j\u00e4\u00e4tmekoodi l\u00f5ikes peab vahe olema 0. Kui vahe on erinev nullist, siis on kaks v\u00f5imalust:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Mingi aruanne on valesti koostatud<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Mingil kliendil\/hankijal on puudu riik v\u00f5i muu tunnus, mis on vajalik j\u00e4\u00e4tmearuande jaoks<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Kontrolli jaoks j\u00e4ta lahti j\u00e4rgmises j\u00e4rjekorras aruanded:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Algsaldod<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sissetulekud<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">V\u00e4ljaminekud (va \u00fcmbert\u00f6\u00f6tlus)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">V\u00e4ljaminev \u00fcmbert\u00f6\u00f6tlus<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">L\u00f5ppsaldod<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Seej\u00e4rel vajuta suvalises aruanded <strong>\u201cVeel\u201d -&gt; \u201cLisa valem\u201d:<\/strong>\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Vali sinna aruanded samas j\u00e4rjekorras nagu eelnevalt kirjeldatud.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Lisa grupeeritava v\u00e4lja juurde selline v\u00e4\u00e4rtus: categoryName|ARTICLE_INFO|ARTICLE_INFO|ARTICLE_INFO|categoryName<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Summa lahtrisse j\u00e4rgmine v\u00e4\u00e4rtus: amountInStock|ARTICLE_ROW_QUANTITY|ARTICLE_ROW_QUANTITY-|ARTICLE_ROW_QUANTITY|amountInStock-<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Vajuta \u201c<strong>Tehtud\u201d<\/strong><\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00fcsteem kuvab aknas j\u00e4\u00e4tmekoodide l\u00f5ikes, kas valem klapib.\u00a0<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29739 size-full\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image4.png\" alt=\"\" width=\"594\" height=\"622\" srcset=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image4.png 594w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image4-480x503.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 594px, 100vw\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-weight: 400;\">Ost: EE jur &gt; 10t (non *)<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Aruanne kuvab juriidilistelt isikutelt tehtud ostud, kui juriidiliselt isikult on ostetud rohkem kui 10 tonni. T\u00e4rn t\u00e4histab mitteohtlikke j\u00e4\u00e4tmeid.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29745 size-full\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image5.png\" alt=\"\" width=\"1253\" height=\"557\" srcset=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image5.png 1253w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image5-980x436.png 980w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image5-480x213.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1253px, 100vw\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><b>N\u00e4ide<\/b><span style=\"font-weight: 400;\">: Otsing, mis leiab 2021 aasta ostuarved, kust mitteohtlikke j\u00e4\u00e4tmeid on Eesti juriidilistelt isikutelt ostetud rohkem kui 10 tonni eest.<\/span><\/p>\n<p><b>Tabelitena<\/b><span style=\"font-weight: 400;\"> kasutame:\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cOstu-m\u00fc\u00fcgi artiklid\u201d,\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cArved (Rows)\u201d\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cArved\u201d,<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cKontaktid\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cArve otsinguparameetrid\u201d<\/span><\/li>\n<\/ol>\n<p><b>V\u00e4ljunditena <\/b><span style=\"font-weight: 400;\">kasutame:\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cOstu-m\u00fc\u00fcgiartiklid.nimi\u201d,\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cOstu-m\u00fc\u00fcgiartiklid.info\u201d,\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cArved (Rows). Project (ID),<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cArved\u201d (Rows).Kogus,\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cKontaktid.nimi\u201d, \u201cKontaktid.Kood\u201d, \u201cKontaktid.Riik (\u00d5iguslik) ja \u201cKontaktid.Reg. nr\u201d<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">N\u00e4itame neid <\/span><b>gruppides<\/b><span style=\"font-weight: 400;\">:\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cKontaktid.Nimi\u201d,\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cOstu-m\u00fc\u00fcgiartiklid.info\u201d,\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201cArved (Rows).Project (ID)\u201d<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Lisaks tuleb kasutada kindlaid <\/span><b>filtreid<\/b><span style=\"font-weight: 400;\">:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">1. Arve otsinguparameetrid.Aasta = 2021<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kuvab ainult 2021 aasta arveid<\/span><\/p>\n<p><span style=\"font-weight: 400;\">2. Arved (Rows).T\u00fc\u00fcp v\u00f5rdub Artiklid ostuarvetel, Ostu-saateleht<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kuvab ainult ostuarved ja ostu-saatelehed<\/span><\/p>\n<p><span style=\"font-weight: 400;\">3. Arved (Rows).Kogus \u201cRohkem kui (p\u00e4rast grupeerimist)\u201d on ENTITY.REGISTRATION_CODE=9,999<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kuvab ainult arved rohkem kui 9,999 v\u00e4\u00e4rtusega<\/span><\/p>\n<p><span style=\"font-weight: 400;\">4. Kontaktid.T\u00fc\u00fcp v\u00f5rdub Juriidiline isik<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kuvab ainult juriidilised isikud<\/span><\/p>\n<p><span style=\"font-weight: 400;\">5. Kontaktid.Riik (\u00d5iguslik) v\u00f5rdub EE<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kuvab ainult Eesti Vabariigi kontaktid<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29727 size-full\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image2.png\" alt=\"\" width=\"1250\" height=\"557\" srcset=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image2.png 1250w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image2-980x437.png 980w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image2-480x214.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1250px, 100vw\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">6. Ostu-m\u00fc\u00fcgiartiklid.info \u201cEi ole t\u00fchi\u201d\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">7. Ostu-m\u00fc\u00fcgiartiklid.info \u201cLength More Than\u201d 0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kuvab ostu-m\u00fc\u00fcgiartiklid, mis ei ole t\u00fchjad.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">8. Ostu-m\u00fc\u00fcgiartiklid.info \u201cEi sisalda\u201d *<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kuvab ainult mitteohtlikud j\u00e4\u00e4tmed.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">9. Arved (Rows) Kustutamiskuup\u00e4ev \u201cOn t\u00fchi\u201d<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kuvab mittekustutatud arved.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">10. Arved.Klient\/Hankija \u201cEi v\u00f5rdu\u201d Su enda ettev\u00f5te<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kuvab ainult teiste ettev\u00f5tete ostuarved.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">11. Arved (Rows).Artikkel \u201cEi v\u00f5rdu\u201d Kogumis-, sorteerimis-, ja \u00fcmbert\u00f6\u00f6tlemisteenus <\/span><\/p>\n<p><span style=\"font-weight: 400;\">(Ei tea miks see vajalik on)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">{&#8220;tables&#8221;:&#8221;ARTICLE|ARTICLE_ROW|DOCUMENT|ENTITY|DOCUMENT_SEARCH_INDEX&#8221;,&#8221;output&#8221;:&#8221;ARTICLE.NAME|ARTICLE.INFO|ARTICLE_ROW.QUANTITY|ENTITY.REGISTRATION_CODE|ENTITY.BILLING_NAME|ENTITY.CONTACT_LEGAL_COUNTRY_ISO2|ENTITY.CODE|ARTICLE_ROW.PROJECT_ID&#8221;,&#8221;groupBy&#8221;:&#8221;ENTITY.BILLING_NAME|ARTICLE.INFO|ARTICLE_ROW.PROJECT_ID&#8221;,&#8221;parameters&#8221;:[{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;DOCUMENT_SEARCH_INDEX&#8221;,&#8221;fieldName&#8221;:&#8221;YEAR&#8221;,&#8221;referenceType&#8221;:&#8221;IN&#8221;,&#8221;value&#8221;:&#8221;2021&#8243;}],&#8221;index&#8221;:0},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE_ROW&#8221;,&#8221;fieldName&#8221;:&#8221;TYPE_CODE&#8221;,&#8221;referenceType&#8221;:&#8221;IN&#8221;,&#8221;value&#8221;:&#8221;ARTICLE_ROW_BUY|ARTICLE_ROW_PURCHASE_WAYBILL&#8221;}],&#8221;index&#8221;:1},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE_ROW&#8221;,&#8221;fieldName&#8221;:&#8221;QUANTITY&#8221;,&#8221;referenceType&#8221;:&#8221;MORE_THAN_FINAL&#8221;,&#8221;value&#8221;:&#8221;ENTITY.REGISTRATION_CODE=9.999&#8243;}],&#8221;index&#8221;:2},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ENTITY&#8221;,&#8221;fieldName&#8221;:&#8221;ENTITY_TYPE_CODE&#8221;,&#8221;referenceType&#8221;:&#8221;IN&#8221;,&#8221;value&#8221;:&#8221;ENTITY_TYPE_LEGAL&#8221;}],&#8221;index&#8221;:3},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ENTITY&#8221;,&#8221;fieldName&#8221;:&#8221;CONTACT_LEGAL_COUNTRY_ISO2&#8243;,&#8221;referenceType&#8221;:&#8221;IN&#8221;,&#8221;value&#8221;:&#8221;EE&#8221;}],&#8221;index&#8221;:4},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE&#8221;,&#8221;fieldName&#8221;:&#8221;INFO&#8221;,&#8221;referenceType&#8221;:&#8221;NOT_NULL&#8221;,&#8221;value&#8221;:&#8221;&#8221;}],&#8221;index&#8221;:5},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE&#8221;,&#8221;fieldName&#8221;:&#8221;INFO&#8221;,&#8221;referenceType&#8221;:&#8221;LENGTH_MORE_THAN&#8221;,&#8221;value&#8221;:&#8221;0&#8243;}],&#8221;index&#8221;:6},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE&#8221;,&#8221;fieldName&#8221;:&#8221;INFO&#8221;,&#8221;referenceType&#8221;:&#8221;NOT_LIKE&#8221;,&#8221;value&#8221;:&#8221;*&#8221;}],&#8221;index&#8221;:7},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE_ROW&#8221;,&#8221;fieldName&#8221;:&#8221;DEL_DATETIME&#8221;,&#8221;referenceType&#8221;:&#8221;IS_NULL&#8221;,&#8221;value&#8221;:null}],&#8221;index&#8221;:8},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;DOCUMENT&#8221;,&#8221;fieldName&#8221;:&#8221;CUSTOMER_ENTITY_ID&#8221;,&#8221;referenceType&#8221;:&#8221;NOT_IN&#8221;,&#8221;value&#8221;:&#8221;YYYYY&#8221;}],&#8221;index&#8221;:9},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE_ROW&#8221;,&#8221;fieldName&#8221;:&#8221;ARTICLE_ID&#8221;,&#8221;referenceType&#8221;:&#8221;NOT_IN&#8221;,&#8221;value&#8221;:&#8221;1027989&#8243;}],&#8221;index&#8221;:10}]}<\/span><\/p>\n<p><b>JSON<\/b><span style=\"font-weight: 400;\">i abil saate selle aruande ise kopeerida <strong>\u201c<\/strong><\/span><span style=\"font-weight: 400;\"><strong>Parameters for Report Generator Saved Reports\u201d<\/strong> moodulisse. <span style=\"text-decoration: underline;\">JSONis tuleb <\/span><\/span><span style=\"text-decoration: underline;\"><span style=\"font-weight: 400;\">YYYYY asendada\u00a0<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-weight: 400;\">Ost: EE jur &gt; 0.1t (*)<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Selle otsingu abil leiame ohtlike j\u00e4\u00e4tmete ostuarved Eesti juriidilistelt isikutelt rohkem kui 0.1 tonni eest.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29733 size-full\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image3.png\" alt=\"\" width=\"1356\" height=\"561\" srcset=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image3.png 1356w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image3-1280x530.png 1280w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image3-980x405.png 980w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image3-480x199.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) 1356px, 100vw\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><b>Tabelid<\/b><span style=\"font-weight: 400;\"> ja <\/span><b>v\u00e4ljundid<\/b><span style=\"font-weight: 400;\"> j\u00e4\u00e4vad samaks, mis esimesel n\u00e4itel.<\/span><\/p>\n<p><b>Filtritena<\/b><span style=\"font-weight: 400;\"> muudame \u201cArved (Rows).Kogus\u201d parameetrit.<\/span><\/p>\n<ol start=\"3\">\n<li><span style=\"font-weight: 400;\"> Arved (Rows).Kogus \u201cRohkem kui (p\u00e4rast grupeerimist)\u201d ENTITY.REGISTRATION_CODE=0.099<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">{&#8220;tables&#8221;:&#8221;ARTICLE|ARTICLE_ROW|DOCUMENT|ENTITY|DOCUMENT_SEARCH_INDEX&#8221;,&#8221;output&#8221;:&#8221;ARTICLE.NAME|ARTICLE.INFO|ARTICLE_ROW.QUANTITY|ENTITY.REGISTRATION_CODE|ENTITY.BILLING_NAME|ENTITY.CONTACT_LEGAL_COUNTRY_ISO2|ENTITY.CODE|ARTICLE_ROW.PROJECT_ID&#8221;,&#8221;groupBy&#8221;:&#8221;ENTITY.BILLING_NAME|ARTICLE.INFO|ARTICLE_ROW.PROJECT_ID&#8221;,&#8221;parameters&#8221;:[{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;DOCUMENT_SEARCH_INDEX&#8221;,&#8221;fieldName&#8221;:&#8221;YEAR&#8221;,&#8221;referenceType&#8221;:&#8221;IN&#8221;,&#8221;value&#8221;:&#8221;2021&#8243;}],&#8221;index&#8221;:0},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE_ROW&#8221;,&#8221;fieldName&#8221;:&#8221;TYPE_CODE&#8221;,&#8221;referenceType&#8221;:&#8221;IN&#8221;,&#8221;value&#8221;:&#8221;ARTICLE_ROW_BUY|ARTICLE_ROW_PURCHASE_WAYBILL&#8221;}],&#8221;index&#8221;:1},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE_ROW&#8221;,&#8221;fieldName&#8221;:&#8221;QUANTITY&#8221;,&#8221;referenceType&#8221;:&#8221;MORE_THAN_FINAL&#8221;,&#8221;value&#8221;:&#8221;ENTITY.REGISTRATION_CODE=0.099&#8243;}],&#8221;index&#8221;:2},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ENTITY&#8221;,&#8221;fieldName&#8221;:&#8221;ENTITY_TYPE_CODE&#8221;,&#8221;referenceType&#8221;:&#8221;IN&#8221;,&#8221;value&#8221;:&#8221;ENTITY_TYPE_LEGAL&#8221;}],&#8221;index&#8221;:3},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ENTITY&#8221;,&#8221;fieldName&#8221;:&#8221;CONTACT_LEGAL_COUNTRY_ISO2&#8243;,&#8221;referenceType&#8221;:&#8221;IN&#8221;,&#8221;value&#8221;:&#8221;EE&#8221;}],&#8221;index&#8221;:4},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE&#8221;,&#8221;fieldName&#8221;:&#8221;INFO&#8221;,&#8221;referenceType&#8221;:&#8221;NOT_NULL&#8221;,&#8221;value&#8221;:&#8221;&#8221;}],&#8221;index&#8221;:5},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE&#8221;,&#8221;fieldName&#8221;:&#8221;INFO&#8221;,&#8221;referenceType&#8221;:&#8221;LENGTH_MORE_THAN&#8221;,&#8221;value&#8221;:&#8221;0&#8243;}],&#8221;index&#8221;:6},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE&#8221;,&#8221;fieldName&#8221;:&#8221;INFO&#8221;,&#8221;referenceType&#8221;:&#8221;LIKE&#8221;,&#8221;value&#8221;:&#8221;*&#8221;}],&#8221;index&#8221;:7},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE_ROW&#8221;,&#8221;fieldName&#8221;:&#8221;DEL_DATETIME&#8221;,&#8221;referenceType&#8221;:&#8221;IS_NULL&#8221;,&#8221;value&#8221;:null}],&#8221;index&#8221;:8},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;DOCUMENT&#8221;,&#8221;fieldName&#8221;:&#8221;CUSTOMER_ENTITY_ID&#8221;,&#8221;referenceType&#8221;:&#8221;NOT_IN&#8221;,&#8221;value&#8221;:&#8221;8166690|8166691&#8243;}],&#8221;index&#8221;:9},{&#8220;rules&#8221;:[{&#8220;tableName&#8221;:&#8221;ARTICLE_ROW&#8221;,&#8221;fieldName&#8221;:&#8221;ARTICLE_ID&#8221;,&#8221;referenceType&#8221;:&#8221;NOT_IN&#8221;,&#8221;value&#8221;:&#8221;1027989&#8243;}],&#8221;index&#8221;:10}]}<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Aruande JSON, mille abil saab kasutaja \u201c<\/span><i><span style=\"font-weight: 400;\">copy-pasteda\u201d<\/span><\/i><span style=\"font-weight: 400;\"> aruande \u201c<strong>Report Generator Saved Report\u201d<\/strong> moodulisse.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-weight: 400;\">M\u00fc\u00fck: Tavam\u00fc\u00fck<\/span><\/h2>\n<p>&nbsp;<\/p>\n<h1><span style=\"font-weight: 400;\">Kuidas kasutada lisa: aruandegeneraatori funktsiooni?\u00a0<\/span><\/h1>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Oletame, et Teil on vaja teha aruanne, mis koosneb kahest v\u00f5i enamast erinevast v\u00e4ljatr\u00fckist, aga Teil on vaja see \u00fchtseks aruandeks teha. Ehk kas on v\u00f5imalik, et programm teeb 8 aruannet ja annab need mulle \u00fchtse v\u00e4ljatr\u00fckina? Jah, selle saab seadistada aruandegeneraatoris.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Lisa: Aruandegeneraatori funktsionaalsus v\u00f5imaldab kombineerida 2 v\u00f5i rohkem aruannet \u00fchte v\u00e4ljundisse.\u00a0\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29721 size-full\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image1.png\" alt=\"\" width=\"186\" height=\"285\" \/><\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Salvesta endale vajalikud aruanded \u00e4ra (aruandegeneraatorist)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ava salvestatud aruanded moodul<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Klikki lahti aruanded, mida sul on vaja<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Vajutage \u201cOtsi\u201d \u00fches v\u00e4lja v\u00f5etud aruandes<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Keri alla ja vajuta \u201cVeel\u201d ja \u201cLisa: Aruandegeneraator\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Seej\u00e4rel valige need aruanded, mida soovite kombineerida.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">PS! Esimesena valige see aruanne, kus on enim v\u00e4ljundeid.\u00a0<\/span><span style=\"font-weight: 400;\">Sellisel juhul tuleb tabel korrektne ja peale vaadates ilus.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h1><span style=\"font-weight: 400;\">Lisa: valem juhend<\/span><\/h1>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29721\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2023\/01\/image1.png\" alt=\"\" width=\"186\" height=\"285\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Lisa: valem funktsioon aitab kontrollida kas aruanne on omadega nullis.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kui Teil on aruanne, millel on 100 v\u00f5i rohkem v\u00e4\u00e4rtust (arvet, kogust jms), siis v\u00f5ib olla keeruline aru saada, kas a-b=0 ehk kas raamatupidamine klapib. Selle jaoks ongi lisa: valem funktsioon.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h1><span style=\"font-weight: 400;\">Kontrollid<\/span><\/h1>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">category Name<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mis on j\u00e4\u00e4tmearuanne ja millest see koosneb? &nbsp; Antud juhend kirjeldab j\u00e4\u00e4tmearuande komponente ja nende kontrolli.\u00a0 Soovitame j\u00e4\u00e4temaruande kasutamiseks v\u00f5tta juurutuse. Vastava sooviga palun p\u00f6\u00f6rduda info@erplybooks.com. J\u00e4\u00e4tmearuanne on piltlikult \u00f6eldes aruanne, mis \u00fctleb, palju oli alguses j\u00e4\u00e4tmeid, kust tuli neid juurde, kuhu nad l\u00e4ksid ja palju oli j\u00e4\u00e4tmete l\u00f5ppsaldo. J\u00e4\u00e4tmearuanne on koostatud riiklikule j\u00e4\u00e4tmearuande vormile, [&hellip;]<\/p>\n","protected":false},"author":22,"featured_media":0,"parent":0,"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":[818],"tags":[610,832,833],"class_list":["post-29720","page","type-page","status-publish","hentry","category-jaatmekaitlusettevote","tag-aruanne","tag-jaatmearuanne","tag-jaatmed"],"_links":{"self":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/29720","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\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/comments?post=29720"}],"version-history":[{"count":0,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/29720\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/media?parent=29720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/categories?post=29720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/tags?post=29720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}