Peaaegu igal aruandel on 2 versiooni (v.a. mediaanil, m\u00fc\u00fcgimahul, hilinemisel):<\/span><\/p>\n Peamiste veergude selgitus:<\/span><\/p>\n Lisaks on igal aruandel ka omad <\/span>spetsiifilised veerud<\/b>, mis selgitatakse iga aruande juures eraldi. Igal aruandel on ka oma JSONi<\/strong> kood, mis on vajalik aruande lisamisel (vt. Aruannete lisamise<\/strong> alapeat\u00fckki )<\/span><\/p>\n <\/p>\n Antud aruannetes arvutatakse keskmiselt (esimene) v\u00f5i arve p\u00f5hjal (teine) laekumise aega:<\/span><\/p>\n Kliendi keskmine laekumiste p\u00e4evade arv<\/b><\/p>\n JSON:<\/p>\n Kliendi laekumiste p\u00e4evade arv (arvete kaupa)<\/b><\/p>\n Antud aruandes on loogika samasugune kui eelneval, kuid iga arve v\u00f5etakse eraldi reana ning lisaks saab vaadata iga arve ID-d (kl\u00f5psates peale avaneb antud arve), kuup\u00e4eva ja t\u00e4htp\u00e4eva.\u00a0<\/span><\/p>\n JSON:<\/p>\n <\/p>\n <\/p>\n Kliendi mediaan laekumiste p\u00e4evade arv<\/b><\/p>\n Antud aruandes kuvatakse kliendi mediaanne laekumisaeg:<\/span><\/p>\n <\/p>\n JSON:<\/p>\n V\u00f5rdleb kokkulepitud makset\u00e4htaega tegeliku laekumisajaga.<\/span><\/p>\n Antud aruandes arvutatakse keskmiselt (esimene) v\u00f5i arve p\u00f5hjal (teine):<\/span><\/p>\n <\/p>\n Kliendi arvete makset\u00e4htaeg vs tegelik laekumisaeg<\/b><\/p>\n <\/p>\n JSON:<\/p>\n <\/p>\n Kliendi arvete makset\u00e4htaeg vs tegelik laekumisaeg (arvete kaupa)<\/b><\/p>\n <\/p>\n JSON:<\/p>\n <\/p>\n Antud aruandes arvutatakse <\/span>ainult <\/b>hilinenud arvete keskmist hilinemist (esimene) v\u00f5i hilinemist arve p\u00f5hjal (teine):<\/span><\/p>\n <\/p>\n Kliendi keskmine makseviivitus p\u00e4evades<\/b><\/p>\n JSON:<\/p>\n <\/p>\n Kliendi makseviivitus (arve kaupa)<\/b><\/p>\n <\/p>\n JSON:<\/p>\n Antud aruandes kuvatakse iga kliendi hilinenud arvete (%) koguarvetest :<\/p>\n Viies veerg<\/strong> n\u00e4itab, mitu arvet on tasutud makset\u00e4htajast hiljemalt<\/p>\n<\/li>\n Eelviimane veerg<\/strong> n\u00e4itab, kliendi m\u00fc\u00fcgimahtu<\/p>\n<\/li>\n Viimane veerg<\/strong> n\u00e4itab, kui suur protsent kliendi k\u00f5ikidest arvetest on tasutud hiljem kui makset\u00e4htaeg.<\/p>\n<\/li>\n<\/ul>\n Aruande nimi: <\/b>Kliendi hilinenud arvete protsent<\/strong><\/p>\n JSON:<\/p>\n <\/p>\n <\/p>\n Antud aruandes arvutatakse keskmiselt (esimene) v\u00f5i arve p\u00f5hjal (teine) kui suur on viivitus hankijatele (v\u00f5etakse arvesse ainult hilinenud arved):<\/span><\/p>\n <\/p>\n Keskmine makseviivitus hankijatele<\/b><\/p>\n <\/p>\n JSON:<\/p>\n <\/p>\n Makseviivitus hankijatele (arve kaupa)<\/b><\/p>\n <\/p>\n JSON:<\/p>\n <\/p>\n Antud aruandes arvutatakse keskmiselt (esimene) v\u00f5i arve p\u00f5hjal (teine) tegelikku laekumisaega:<\/span><\/p>\n <\/p>\n Arvete makset\u00e4htaeg vs tegelik laekumisaeg hankijatele<\/b><\/p>\n <\/p>\n JSON:<\/p>\n <\/p>\n Arvete makset\u00e4htaeg vs tegelik laekumisaeg hankijatele (arvete kaupa)<\/b><\/p>\n <\/p>\n JSON:<\/p>\n <\/p>\n Antud aruandes arvutatakse keskmiselt (esimene) v\u00f5i arve p\u00f5hjal (teine) mitu p\u00e4eva makstakse hankijatele enneaegselt:<\/span><\/p>\n <\/p>\n Hankijad kellele maksame enneaegselt<\/b><\/p>\n JSON:<\/p>\n <\/p>\n Hankijad kellele maksame enneaegselt (arve kaupa)<\/b><\/p>\n <\/p>\n JSON:<\/p>\n <\/p>\n Kui soovite lisada aruande(d) teie ERPLY Booksi, siis tuleb:<\/p>\n Kui aruanne on salvestatud , siis uuendage leht (refresh<\/i>) ja seej\u00e4rel avage\u00a0\u201cAruanded\u201d<\/b>\u00a0->\u00a0\u201cAruandegenraator\u201d<\/b>\u00a0->\u00a0\u201cSalvestatud aruanded\u201d<\/b>.<\/p>\n <\/p>\n Aruannete lisamisel saate vajadusel muuta ka aruande fitreid. Praegu kasutavad k\u00f5ik aruanded 2026 a. andmeid (mida saab samuti vajadusel muuta). Uue filtri lisamiseks vajutage “Lisa filter”<\/strong> nuppu.<\/p>\n <\/p>\n Muudetud aruannete salvestamisel on teil kaks v\u00f5imalust:<\/p>\n \u00c4rianal\u00fc\u00fctika aruanded Selles juhendis kirjeldatakse ERPLY Booksi salvestatud aruandeid aruandegeneraatoris, mis aitavad anal\u00fc\u00fcsida ettev\u00f5tte ostu- ja m\u00fc\u00fcgiarvete laekumisi, makseviivitusi ja DSO-d.\u00a0 Peaaegu igal aruandel on 2 versiooni (v.a. mediaanil, m\u00fc\u00fcgimahul, hilinemisel): Kliendi\/hankija keskmine \u2013 n\u00e4itab keskmist v\u00e4\u00e4rtust kogu partneri l\u00f5ikes Arve kaupa \u2013 n\u00e4itab igat arvet eraldi reana (kuhu tavaliselt lisatakse arve ID, kuup\u00e4ev […]<\/p>\n","protected":false},"author":28,"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":[449],"tags":[1381,610],"class_list":["post-37685","page","type-page","status-publish","hentry","category-juhendid","tag-arianaluutika-2","tag-aruanne"],"_links":{"self":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/37685","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\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/comments?post=37685"}],"version-history":[{"count":0,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/37685\/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=37685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/categories?post=37685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/tags?post=37685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
\n
<\/h2>\n
Kliendi laekumised<\/b><\/h2>\n
1.1 Keskmine kliendi laekumise aeg<\/b><\/h3>\n
\n
\n<\/span>Negatiivne v\u00e4\u00e4rtus t\u00e4hendab, et maksed toimusid enne t\u00e4htp\u00e4eva (nii mitu p\u00e4eva), positiivne v\u00e4\u00e4rtus t\u00e4hendab, et maksed toimus p\u00e4rast t\u00e4htp\u00e4eva.<\/span><\/li>\n![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/Keskmine-kliendi-laekumise-aeg.png\")
<\/b><\/h3>\n {\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_SELL|DOCUMENT_POS_SELL\",\"filterName\":\"\"}],\"index\":2},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":3}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByOnDBLevel\":true,\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"DOCUMENT|PAYMENT|ENTITY|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.CONTACT_MOBILE|ENTITY.CONTACT_PHONE|ENTITY.CONTACT_EMAIL|DOCUMENT.SUM_WITH_VAT|PAYMENT.AVERAGE_PAYMENT_DAYS_AFTER_DEADLINE|PAYMENT.AVERAGE_PAYMENT_DAYS_AFTER_INVOICE_CREATED\",\"groupBy\":\"DOCUMENT.CUSTOMER_ENTITY_ID\"}\u00a0<\/code><\/p>\n![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/Kliendi-laekumiste-paevade-arv-2.png\")
<\/p>\n{\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_SELL|DOCUMENT_POS_SELL\",\"filterName\":\"\"}],\"index\":1},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":2}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"DOCUMENT|PAYMENT|ENTITY|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.CONTACT_MOBILE|ENTITY.CONTACT_PHONE|ENTITY.CONTACT_EMAIL|DOCUMENT.ID|DOCUMENT.DATETIME|DOCUMENT.DEADLINE_DATE|DOCUMENT.SUM_WITH_VAT|PAYMENT.PAYMENT_DAYS_AFTER_DEADLINE|PAYMENT.PAYMENT_DAYS_AFTER_INVOICE_CREATED\",\"groupBy\":\"\"}\u00a0<\/code><\/p>\n1.2 Mediaan laekumise aeg<\/b><\/h3>\n
\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/Kliendi-mediaan-laekumiste-paevade-arv.png\")
<\/p>\n{\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_SELL|DOCUMENT_POS_SELL\",\"filterName\":\"\"}],\"index\":2},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":3}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"DOCUMENT|ENTITY|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.CONTACT_MOBILE|ENTITY.CONTACT_PHONE|ENTITY.CONTACT_EMAIL|DOCUMENT.SUM_WITH_VAT|DOCUMENT.ID|DOCUMENT.DATETIME|DOCUMENT.DEADLINE_DATE|DOCUMENT.DOCUMENT_MEDIAN_PAYMENT_DAYS|DOCUMENT.DOCUMENT_DEADLINE_MEDIAN_PAYMENT_DAYS\",\"groupBy\":\"DOCUMENT.CUSTOMER_ENTITY_ID\"}\u00a0<\/code><\/p>\n1.3 Lepingutej\u00e4rgne makset\u00e4htaeg vs tegelik laekumise aeg<\/b><\/h3>\n
\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/4-5.png\")
<\/p>\n{\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":1},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_POS_SELL|DOCUMENT_SELL\",\"filterName\":\"\"}],\"index\":2}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"ENTITY|DOCUMENT|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.DEADLINE_DAYS|DOCUMENT.ID|DOCUMENT.DATETIME|DOCUMENT.DEADLINE_DATE|DOCUMENT.SUM_WITH_VAT|DOCUMENT.DOCUMENT_FIRST_PAYMENT_DAYS_AVERAGE\",\"groupBy\":\"DOCUMENT.CUSTOMER_ENTITY_ID\"}\u00a0<\/code><\/p>\n![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/5-4.png\")
<\/p>\n{\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":1},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_POS_SELL|DOCUMENT_SELL\",\"filterName\":\"\"}],\"index\":2}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"ENTITY|DOCUMENT|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.DEADLINE_DAYS|DOCUMENT.ID|DOCUMENT.DATETIME|DOCUMENT.DEADLINE_DATE|DOCUMENT.SUM_WITH_VAT|DOCUMENT.DOCUMENT_FIRST_PAYMENT_DAYS_AVERAGE\",\"groupBy\":\"\"}\u00a0<\/code><\/p>\n1.4 Keskmine makse hilinemise p\u00e4evade arv<\/b><\/h3>\n
\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/6.png\")
<\/p>\n{\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_SELL|DOCUMENT_POS_SELL\",\"filterName\":\"\"}],\"index\":1},{\"rules\":[{\"tableName\":\"PAYMENT\",\"fieldName\":\"PAYMENT_DAYS_AFTER_DEADLINE\",\"referenceType\":\"MORE_THAN\",\"value\":0,\"filterName\":\"\"}],\"index\":2},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":3}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByOnDBLevel\":true,\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"DOCUMENT|PAYMENT|ENTITY|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.CONTACT_MOBILE|ENTITY.CONTACT_PHONE|ENTITY.CONTACT_EMAIL|DOCUMENT.SUM_WITH_VAT|PAYMENT.AVERAGE_PAYMENT_DAYS_AFTER_DEADLINE|PAYMENT.AVERAGE_PAYMENT_DAYS_AFTER_INVOICE_CREATED\",\"groupBy\":\"DOCUMENT.CUSTOMER_ENTITY_ID\"}\u00a0<\/code><\/p>\n![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/7.png\")
<\/p>\n{\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_SELL|DOCUMENT_POS_SELL\",\"filterName\":\"\"}],\"index\":2},{\"rules\":[{\"tableName\":\"PAYMENT\",\"fieldName\":\"PAYMENT_DAYS_AFTER_DEADLINE\",\"referenceType\":\"MORE_THAN\",\"value\":0,\"filterName\":\"\"}],\"index\":3},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":4}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"DOCUMENT|PAYMENT|ENTITY|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.CONTACT_MOBILE|ENTITY.CONTACT_PHONE|ENTITY.CONTACT_EMAIL|DOCUMENT.ID|DOCUMENT.DATETIME|DOCUMENT.DEADLINE_DATE|DOCUMENT.SUM_WITH_VAT|PAYMENT.PAYMENT_DAYS_AFTER_DEADLINE|PAYMENT.PAYMENT_DAYS_AFTER_INVOICE_CREATED\",\"groupBy\":\"\"}
\n<\/code><\/p>\n1.5 Kliendi hilinenud arvete protsent<\/b><\/h3>\n
\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/16_kliendiHilinenudArveteProtsent.png\")
<\/p>\n{ \"parameters\": [ { \"rules\": [ { \"tableName\": \"DOCUMENT\", \"fieldName\": \"TYPE_CODE\", \"referenceType\": \"IN\", \"value\": \"DOCUMENT_SELL|DOCUMENT_POS_SELL\", \"filterName\": \"\" } ], \"index\": 0 }, { \"rules\": [ { \"tableName\": \"DOCUMENT\", \"fieldName\": \"DEL_DATETIME\", \"referenceType\": \"IS_NULL\", \"value\": null, \"filterName\": \"\" } ], \"index\": 1 }, { \"rules\": [ { \"tableName\": \"DOCUMENT_SEARCH_INDEX\", \"fieldName\": \"YEAR\", \"referenceType\": \"IN\", \"value\": \"2026\", \"filterName\": \"\" } ], \"index\": 2 } ], \"additionalColumns\": \"\", \"storeParameters\": \"\", \"outputLayout\": \"\", \"limit\": \"\", \"start\": \"\", \"summaryRowField\": \"\", \"groupByFinal\": \"\", \"orderBy\": \"\", \"orderByField\": \"\", \"comparisonColumns\": \"\", \"renderers\": \"\", \"headerMapper\": \"\", \"organisationIds\": \"\", \"tables\": \"DOCUMENT|ENTITY|DOCUMENT_SEARCH_INDEX\", \"output\": \"ENTITY.BILLING_NAME|DOCUMENT.CUSTOMER_ENTITY_ID|DOCUMENT.DATETIME|DOCUMENT.DEADLINE_DATE|DOCUMENT.DOCUMENT_COUNT_FIRST_PAYMENT_AFTER_DEADLINE_ONLY_OVERDUE|DOCUMENT.ID|DOCUMENT.SUM_WITH_VAT|DOCUMENT.DOCUMENT_OVERDUE_INVOICES_PERCENT\", \"groupBy\": \"DOCUMENT.CUSTOMER_ENTITY_ID\" }\u00a0<\/code><\/p>\nHankijatele tehtavad maksed<\/b><\/h2>\n
2.1 Keskmine makseviivitus hankijatele<\/b><\/h3>\n
\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/8.png\")
<\/p>\n{\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_BUY|DOCUMENT_POS_BUY\",\"filterName\":\"\"}],\"index\":1},{\"rules\":[{\"tableName\":\"PAYMENT\",\"fieldName\":\"PAYMENT_DAYS_AFTER_DEADLINE\",\"referenceType\":\"MORE_THAN\",\"value\":0,\"filterName\":\"\"}],\"index\":2},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":3}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByOnDBLevel\":true,\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"DOCUMENT|PAYMENT|ENTITY|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.CONTACT_MOBILE|ENTITY.CONTACT_PHONE|ENTITY.CONTACT_EMAIL|DOCUMENT.SUM_WITH_VAT|PAYMENT.AVERAGE_PAYMENT_DAYS_AFTER_DEADLINE|PAYMENT.AVERAGE_PAYMENT_DAYS_AFTER_INVOICE_CREATED\",\"groupBy\":\"DOCUMENT.CUSTOMER_ENTITY_ID\"}<\/code><\/p>\n![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/9.png\")
<\/p>\n{\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_BUY|DOCUMENT_POS_BUY\",\"filterName\":\"\"}],\"index\":1},{\"rules\":[{\"tableName\":\"PAYMENT\",\"fieldName\":\"PAYMENT_DAYS_AFTER_DEADLINE\",\"referenceType\":\"MORE_THAN\",\"value\":0,\"filterName\":\"\"}],\"index\":2},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":3}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"DOCUMENT|PAYMENT|ENTITY|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.CONTACT_MOBILE|ENTITY.CONTACT_PHONE|ENTITY.CONTACT_EMAIL|DOCUMENT.ID|DOCUMENT.DATETIME|DOCUMENT.DEADLINE_DATE|DOCUMENT.SUM_WITH_VAT|PAYMENT.PAYMENT_DAYS_AFTER_DEADLINE|PAYMENT.PAYMENT_DAYS_AFTER_INVOICE_CREATED\",\"groupBy\":\"\"}\u00a0<\/code><\/p>\n2.2 Lepinguj\u00e4rgne makset\u00e4htaeg vs tegelik makseaeg<\/b><\/h3>\n
\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/10.png\")
<\/p>\n{\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":1},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_POS_BUY|DOCUMENT_BUY\",\"filterName\":\"\"}],\"index\":2}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"ENTITY|DOCUMENT|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.DEADLINE_DAYS|DOCUMENT.ID|DOCUMENT.DATETIME|DOCUMENT.DEADLINE_DATE|DOCUMENT.SUM_WITH_VAT|DOCUMENT.DOCUMENT_FIRST_PAYMENT_DAYS_AVERAGE\",\"groupBy\":\"DOCUMENT.CUSTOMER_ENTITY_ID\"} <\/code><\/p>\n![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/11.png\")
<\/p>\n{\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":1},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_POS_BUY|DOCUMENT_BUY\",\"filterName\":\"\"}],\"index\":2}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"ENTITY|DOCUMENT|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.DEADLINE_DAYS|DOCUMENT.ID|DOCUMENT.DATETIME|DOCUMENT.DEADLINE_DATE|DOCUMENT.SUM_WITH_VAT|DOCUMENT.DOCUMENT_FIRST_PAYMENT_DAYS_AVERAGE\",\"groupBy\":\"\"}\u00a0<\/code><\/p>\n2.3 Hankijad, kellele maksame enneaegselt<\/b><\/h3>\n
\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/12.png\")
<\/p>\n{\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_BUY|DOCUMENT_POS_BUY\",\"filterName\":\"\"}],\"index\":1},{\"rules\":[{\"tableName\":\"PAYMENT\",\"fieldName\":\"PAYMENT_DAYS_AFTER_DEADLINE\",\"referenceType\":\"LESS_THAN\",\"value\":0,\"filterName\":\"\"}],\"index\":2},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":3}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByOnDBLevel\":true,\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"DOCUMENT|PAYMENT|ENTITY|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.CONTACT_MOBILE|ENTITY.CONTACT_PHONE|ENTITY.CONTACT_EMAIL|DOCUMENT.SUM_WITH_VAT|PAYMENT.AVERAGE_PAYMENT_DAYS_AFTER_DEADLINE|PAYMENT.AVERAGE_PAYMENT_DAYS_AFTER_INVOICE_CREATED\",\"groupBy\":\"DOCUMENT.CUSTOMER_ENTITY_ID\"}<\/code><\/p>\n![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/13.png\")
<\/p>\n{\"parameters\":[{\"rules\":[{\"tableName\":\"DOCUMENT_SEARCH_INDEX\",\"fieldName\":\"YEAR\",\"referenceType\":\"IN\",\"value\":\"2026\",\"filterName\":\"\"}],\"index\":0},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"TYPE_CODE\",\"referenceType\":\"IN\",\"value\":\"DOCUMENT_BUY|DOCUMENT_POS_BUY\",\"filterName\":\"\"}],\"index\":1},{\"rules\":[{\"tableName\":\"PAYMENT\",\"fieldName\":\"PAYMENT_DAYS_AFTER_DEADLINE\",\"referenceType\":\"LESS_THAN\",\"value\":0,\"filterName\":\"\"}],\"index\":2},{\"rules\":[{\"tableName\":\"DOCUMENT\",\"fieldName\":\"DEL_DATETIME\",\"referenceType\":\"IS_NULL\",\"value\":null,\"filterName\":\"\"}],\"index\":3}],\"additionalColumns\":\"\",\"storeParameters\":\"\",\"outputLayout\":\"\",\"limit\":\"\",\"start\":\"\",\"summaryRowField\":\"\",\"groupByFinal\":\"\",\"orderBy\":\"\",\"orderByField\":\"\",\"comparisonColumns\":\"\",\"renderers\":\"\",\"headerMapper\":\"\",\"organisationIds\":\"\",\"tables\":\"DOCUMENT|PAYMENT|ENTITY|DOCUMENT_SEARCH_INDEX\",\"output\":\"DOCUMENT.CUSTOMER_ENTITY_ID|ENTITY.CONTACT_MOBILE|ENTITY.CONTACT_PHONE|ENTITY.CONTACT_EMAIL|DOCUMENT.ID|DOCUMENT.DATETIME|DOCUMENT.DEADLINE_DATE|DOCUMENT.SUM_WITH_VAT|PAYMENT.PAYMENT_DAYS_AFTER_DEADLINE|PAYMENT.PAYMENT_DAYS_AFTER_INVOICE_CREATED\",\"groupBy\":\"\"} <\/code><\/p>\nAruannete lisamine<\/strong><\/h2>\n
\n
\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/14.png\")
<\/p>\nAruannete muutmine<\/strong><\/h3>\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/04\/17_.png\")
<\/p>\n\n