.\u00a0<\/span><\/p>\n <\/p>\n
<\/p>\n
N\u00e4ide olemasoleva aruandega<\/b><\/h2>\n
N\u00e4itame, kuidas jagada ostu- ja m\u00fc\u00fcgilepingu ning ostu- ja m\u00fc\u00fcgiarve summad eraldi veergudeks.<\/span><\/p>\nKui soovite t\u00e4pselt sama aruannet, siis kopeerige Json siit:<\/span><\/p>\n{“parameters”:[{“rules”:[{“tableName”:”ARTICLE”,”fieldName”:”CODE”,”referenceType”:”NOT_NULL”,”value”:””}],”index”:0},{“rules”:[{“tableName”:”ARTICLE_ROW”,”fieldName”:”DEL_DATETIME”,”referenceType”:”IS_NULL”,”value”:null}],”index”:2},{“rules”:[{“tableName”:”ARTICLE_ROW”,”fieldName”:”TYPE_CODE”,”referenceType”:”IN_OR”,”value”:”ARTICLE_ROW_PURCHASE_CONTRACT_AGREED”},{“tableName”:”ARTICLE_ROW”,”fieldName”:”TYPE_CODE”,”referenceType”:”IN_OR”,”value”:”ARTICLE_ROW_SALES_CONTRACT_AGREED”},{“tableName”:”ARTICLE_ROW”,”fieldName”:”TYPE_CODE”,”referenceType”:”IN_OR”,”value”:”ARTICLE_ROW_BUY|ARTICLE_ROW_PURCHASE_WAYBILL”},{“tableName”:”ARTICLE_ROW”,”fieldName”:”TYPE_CODE”,”referenceType”:”IN_OR”,”value”:”ARTICLE_ROW_SELL|ARTICLE_ROW_WAYBILL”}],”index”:3},{“rules”:[{“tableName”:”DOCUMENT”,”fieldName”:”DOCUMENT_STATUS_TYPE_CODE”,”referenceType”:”NOT_IN”,”value”:”STATUS_UNSUCCESSFUL|STATUS_FAIL”}],”index”:4},{“rules”:[{“tableName”:”ARTICLE”,”fieldName”:”CODE”,”referenceType”:”LENGTH_MORE_THAN”,”value”:”0″}],”index”:5}],”additionalColumns”:”ARTICLE_ROW.QUANTITY=Ostuleping_SUM|ARTICLE_ROW.QUANTITY=Myygileping_SUM|ARTICLE_ROW.QUANTITY=Ostuarve_SUM|ARTICLE_ROW.QUANTITY=Myygiarve_SUM”,”storeParameters”:””,”summaryRowField”:”ARTICLE.CODE”,”groupByOnDBLevel”:true,”groupByFinal”:””,”organisationIds”:””,”tables”:”ARTICLE|ARTICLE_ROW|DOCUMENT”,”output”:”ARTICLE.CODE|ARTICLE.NAME|ARTICLE_ROW.QUANTITY”,”groupBy”:”ARTICLE.CODE”}<\/span><\/p>\nJa kleepige see moodulisse <\/span>“Parameters for Report Generator Saved Reports”<\/b> (pealehe otsingust <\/span>“Parameters for Report Generator Saved Reports”<\/b>).<\/span><\/p>\n <\/p>\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2024\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2024-08-15-\u0432-10.37.56.png\")
<\/p>\n
<\/p>\n
\n- Nimi:<\/b> kirjutage soovitud nimi<\/span><\/li>\n
- V\u00e4\u00e4rtus:<\/b> JSON\u00a0<\/span><\/li>\n
- T\u00fc\u00fcp:<\/b> kui soovite, et see oleks erinevas kaustas<\/span><\/li>\n<\/ul>\n
Kui k\u00f5ik on lisatud, salvestage muudatused. Seej\u00e4rel minge <\/span>“Aruanded”<\/b> -> <\/span>“Aruandegeneraator”<\/b> -> <\/span>“Salvestatud aruanded”<\/b>.\u00a0<\/span><\/p>\n <\/p>\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2024\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2024-08-15-\u0432-10.46.19.png\")
<\/p>\n
<\/p>\n
Seej\u00e4rel avage vajalik aruanne ja n\u00e4ete, et aruanne on valmis. K\u00f5ik, mida peate tegema, on vajutada <\/span>“Otsi”<\/b>.\u00a0<\/span><\/p>\n <\/p>\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2024\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2024-08-15-\u0432-10.49.22.png\")
<\/span><\/p>\n <\/p>\n
L\u00f5pptulemus on j\u00e4rgmine:<\/span><\/p>\n <\/p>\n
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2024\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2024-08-15-\u0432-10.50.37.png\")
<\/span><\/p>\n <\/p>\n
Ilmuvad veerud:<\/span><\/p>\n\n- Ostu-m\u00fc\u00fcgi artiklid. Kood<\/span><\/li>\n
- Ostu-m\u00fc\u00fcgi artiklid. Nimi<\/span><\/li>\n
- Ostuleping_SUM<\/span><\/li>\n
- Myygileping_SUM<\/span><\/li>\n
- Ostuarve_SUM<\/span><\/li>\n
- Myyguarve_SUM<\/span><\/li>\n<\/ul>\n
\u00a0<\/span><\/p>\nSoovi korral saate muuta olemasolevat aruannet ja nelja viimast veeru nime.\u00a0<\/span><\/p>\nKui teil on lisak\u00fcsimusi selle funktsionaalsuse kohta v\u00f5i soovite kohandatud generaatorit, v\u00f5tke palun \u00fchendust klienditoega aadressil support@erplybooks.com<\/a>.\u00a0 \u00a0<\/span><\/p>\n <\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
“V\u00f5rdub (v\u00f5i)” funktsioon Aruandegeneraatoris See funktsioon v\u00f5imaldab teil laiendada aruandegeneraatori otsinguid.\u00a0 See on kasulik n\u00e4iteks siis, kui soovite saada andmeid kahest v\u00f5i kolmest eraldi segmendist, n\u00e4iteks jaanuari, veebruari ja m\u00e4rtsi kuludest, ja need peavad olema eraldi veergudes. Kuidas seda kasutada aruandegeneraatoris? Kui soovite alustada aruannete koostamist algusest peale, siis avage “Aruanded” -> “Aruandegeneraator”. […]<\/p>\n","protected":false},"author":27,"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":[],"tags":[],"class_list":["post-35231","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/35231","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\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/comments?post=35231"}],"version-history":[{"count":0,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/35231\/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=35231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/categories?post=35231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/tags?post=35231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2024\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2024-08-15-\u0432-10.13.52.png\")
<\/p>\n![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2024\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2024-08-15-\u0432-10.15.22.png\")
<\/p>\n![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2024\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2024-08-15-\u0432-10.18.32.png\")
<\/p>\n![\"\"](\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2024\/08\/\u0421\u043d\u0438\u043c\u043e\u043a-\u044d\u043a\u0440\u0430\u043d\u0430-2024-08-15-\u0432-10.27.53.png\")
<\/p>\n