Search 1.9 billion lines of Odoo code on GitHub

mis_builder

Author: ACSONE SA/NV, Odoo Community Association (OCA)
License: AGPL-3
Branch: 10.0-lih_master
Repository: acsone/mis-builder
Dependencies: account, board, date_range, report, report_xlsx, web, and web_widget_color
Languages: CSS (72, 0.6%), Cucumber (24, 0.2%), HTML (665, 5.7%), JavaScript (224, 1.9%), PO File (4928, 42.5%), Python (4460, 38.4%), TOML (7, 0.1%), XML (707, 6.1%), and reStructuredText (521, 4.5%)
Other branches: 10.0, 10.0-abi_master, 10.0-cla_master, 10.0-liser_master, 10.0-lns_master, 11.0, 11.0-300-port, 11.0-active_test-false-sbi, 11.0-gha-sbi, 12.0, 12.0-gha-sbi, 12.0-pep517-test-sbi, 13.0, 13.0-4.0-staging, 13.0-417-port, 13.0-421-port, 13.0-add_mis_analytic_account_group_filter-bwi, 13.0-apply-copier-template, 13.0-eri_master, 13.0-fix-pdf-sbi, 13.0-wpu_master, 14.0, 14.0-abi_master, 14.0-allow_overlap-sbj, 14.0-cdd_master, 14.0-mig-sbi, 15.0, 15.0-421-port, 15.0-black-sbi, 15.0-fix-sudo-sbi, 15.0-git-test-sbi, 15.0-update-dotfiles, 16.0, 16.0-init, 16.0-mig-mis_builder-ape, 7.0, 8.0, 9.0, 9.0-cla_master, 9.0-fix-mis_builder_default_company_id-dro, cogitoweb/10.0, github-action-lint-sbi, and test
Other repositories: AlainVanUtterbeeck/account-financial-reporting, Albin-John/account-financial-reporting, Albin-John/mis-builder, Alfa-90/mis-builder, Antiun/account-financial-reporting, AwesomeFoodCoops/odoo-production, Awievdberg/mis-builder, Bubbles-IT/mis-builder, Change2improve/mis-builder, CharlineDumontet/account-financial-reporting, CiroBoxHub/account-financial-reporting, ClearCorp/oca-account-financial-reporting, Cloudxtreme/account-financial-reporting, Colorlessgold/mis-builder, Comunitea/account-financial-reporting, Comunitea/mis-builder, DITIntl/mis-builder, DITIntl/odoo-production, Digital5-Odoo/mis-builder, Dobtor-OCA/mis-builder, Domatix/account-financial-reporting, ERPLibre/mis-builder, Ehtaga/account-financial-reporting, ElvenStudio/account-financial-reporting, Endika/account-financial-reporting, EssentNovaTeam/account-financial-reporting, FedericoLaTorre/patches, Fitranugraha/mis-builder, ForgeFlow/account-financial-reporting, ForgeFlow/mis-builder, Gabinete-Digital/mis-builder, Gofekra/mis-builder, Groupe-Informatique-LaCoopSurMer/odoo-production, Guobower/mis-builder, HarshalBhoir/mis-builder, Hasnur/account-financial-reporting, HomerDeoDatu/mis-builder, Idealisconsulting/account-financial-reporting, Ingeos/mis-builder, Jagdish-Panchal/account-financial-reporting, Jarsa/account-financial-reporting, Jarsa/mis-builder, JayVora-SerpentCS/account-financial-reporting, Kayuulab/mis-builder, LasLabs/account-financial-reporting, LevelPrime/mis-builder, Martronic-SA/account-financial-reporting, Martronic-SA/mis-builder, MathBenTech/mis-builder, MaxyMoos/mis-builder, NL66278/account-financial-reporting, NeatNerdPrime/mis-builder, Nkirui/mis-builder, Numigi/mis-builder, OCA-MUK/mis-builder, OCA/mis-builder, OpenCode/account-financial-reporting, OpenPymeMx/account-financial-reporting, OpusVL/account-financial-reporting, Otsokop/odoo-production, OutillageStEtienne/account-financial-reporting, Pravithavarghese1/account-financial-reporting, QANSEE/account-financial-reporting, QubiQ/mis-builder, RL-OtherApps/patches, SHEFFIELDAFRICA/account-financial-reporting, SSISoftware/mis-builder, SanteLibre/mis-builder, SeuMarco/account-financial-reporting, SeuMarco/mis-builder, SportPursuit/account-financial-reporting, StefanRijnhart/account-financial-reporting, Syci-Consulting/mis-builder, TRESCLOUD/account-financial-reporting, Tecnativa/account-financial-reporting, Tecnativa/mis-builder, Thawah/mis-builder, ThomasBinsfeld/account-financial-reporting, Trust-Code/account-financial-reporting, VbossEkat/account-financial-reporting, VisiionSolucionesTecnologicas/mis-builder, VitalPet/account-financial-reporting, Werded/mis-builder, YogendrasinhChavda/mis-builder, YogeshMahera-SerpentCS/mis-builder, a0c/mis-builder, aaltinisik/mis-builder, abgfbr/account-financial-reporting, abstract-open-solutions/account-financial-reporting, acsone/account-financial-reporting, adhoc-dev/account-financial-reporting, adhoc-dev/mis-builder, adolfoeliazat/account-financial-reporting, adrienpeiffer/account-financial-reporting, akretion/account-financial-reporting, alessandrocamilli/account-financial-reporting, alexlafalce/account-financial-reporting, algiopensource/account-financial-reporting, algiopensource/mis-builder, amcor/mis-builder, andhit-r/account-financial-reporting, andrea4ever/account-financial-reporting, anhvu-sg/mis-builder, apachesep/account-financial-reporting, apachesep/mis-builder, apertoso/account-financial-reporting, apetbiz/mis-builder, artapon/account-financial-reporting, aurestic/account-financial-reporting, aurestic/mis-builder, ayushin/account-financial-reporting, azmeuk/odoo-production, babatoko/odoo-production, bachmanna/mis-builder, beloeuvre/odoo-production, bishalgit/mis-builder, bmya/mis-builder, bodedra/mis-builder, bodi000/account-financial-reporting, bolsystem/account-financial-reporting, brain-tec/account-financial-reporting, brain-tec/mis-builder, budiiskandar11/account-financial-reporting, camptocamp/account-financial-reporting, camptocamp/mis-builder, chermed/account-financial-reporting, chetanrdhaduk/odoo-production, chjbbs/account-financial-reporting, codewr/account-financial-reporting, cogitoweb/mis-builder, coopaname/mis-builder, coopiteasy/mis-builder, credativUK/account-financial-reporting, damdam-s/account-financial-reporting, dani-xtendoo/mis-builder, daramousk/mis-builder, decodio-applications/mis-builder, demain-supermarche/odoo-production, diagramsoftware/account-financial-reporting, diagramsoftware/mis-builder, diegobgl/mis-builder, diggy128/mis-builder, digitalwow/account-financial-reporting, dmo-odoo/mis-builder, dorsaf/mis-builder, druidoo-dev/mis-builder, druidoo/FoodCoops, dynapps/account-financial-reporting, dzungtran89/odoo-production, eLBati/account-financial-reporting, ecosoft-odoo/mis-builder, ecosoft-odoo/rjc, eezee-it/account-financial-reporting, elicoidal/mis-builder, elmonitor/account-financial-reporting, eneldoserrata/account-financial-reporting, ernesto-medina/account-financial-reporting, estevebadia/odoo-production, etobella/mis-builder, exosoftware/oca-mis-builder, falconsoft3d/mis-builder, fanzalika/account-financial-reporting, fedexin40/account-financial-reporting, fengzoo2018/patches, fhferreira/mis-builder, fjouatte/odoo-production, fmdl/account-financial-reporting, glopzvega/account-financial-reporting, grindtildeath/account-financial-reporting, grindtildeath/mis-builder, gtopba/mis-builder, gurneyalex/account-financial-reporting, halgandd/odoo-production, haryoran04/account-financial-reporting, hbrunn/account-financial-reporting, hbrunn/mis-builder, hilarak/odoo-production, huntergps/mis-builder, iRichGit/mis-builder, iamyeonhan/mis-builder, ingadhoc/patches, initOS/account-financial-reporting, initOS/mis-builder, insscn/mis-builder, isoscl/mis-builder, isoscl/patches, italoadler/mis-builder, izzihector/mis-builder, jackjack82/mis-builder, jacky82669513/mis-builder, jbreard/mis-builder, jcoux/account-financial-reporting, jjscarafia/mis-builder, jlimasa/mis-builder, jweste/odoo-production, kent7301/mis-builder, kevin070982/mis-builder, khl2007/account-financial-reporting, kittiu/mis-builder, kmee/account-financial-reporting, kmee/mis-builder, krunal267/odoo-production, lachouettecoop/odoo-production, landyorlando/account-financial-reporting, leemannd/account-financial-reporting, leemannd/mis-builder, legalsylvain/odoo-production, lideritjnma/mis-builder, linkitspa/account-financial-reporting, loctv/patches, lonelyleaves/account-financial-reporting, loyalcomps/mis-builder, lubonbvba/account-financial-reporting, luc-demeyer/account-financial-reporting, ludogre/account-financial-reporting, luistorresm/mis-builder, magnuscolors/mis-builder, marionumza/account-financial-reporting, marionumza/mis-builder, markrobinson85/account-financial-reporting, markrobinson85/mis-builder, mathieuvatel/odoo-production, mazenalasali/account-financial-reporting, mdietrichc2c/account-financial-reporting, mfzoutsource/account-financial-reporting, mikevhe18/account-financial-reporting, mileo/account-financial-reporting, mileo/mis-builder, minhhq09/account-financial-reporting, mivilsoft/mis-builder, mohamedhabibchallouf/mis-builder, mohamedhagag/account-financial-reporting, mohammad0omar/mis-builder, mpanarin/mis-builder, mquandalle/account-financial-reporting, msegeya/account-financial-reporting, mszinte/odoo-production, mulaudzicalvin/odoo-production, multidadosti-erp/mis-builder, njeudy/mis-builder, nmoturi/account-financial-reporting, nthnnl/odoo-production, nucleoosystem/mis-builder, oca-sorrento/account-financial-reporting, odof/account-financial-reporting, odof/mis-builder, odoo-modules/odoo-production, odoobgorg/OCA-account-financial-reporting, odoofans/patches, odoogap/mis-builder, omalbastin/mis-builder, omalbastin/patches, one2pret/mis-builder, onurugur/mis-builder, osfp-Pakistan/mis-builder, osiell/account-financial-reporting, ovalor/account-financial-reporting, ovnicraft/account-financial-reporting, pankk/account-financial-reporting, paul1osullivan/mis-builder, pedrobaeza/account-financial-reporting, petrus-v/odoo-foodcoops, petypi/account-financial-reporting, phuctranerp/odoo-production, piensom/mis-builder, popsolutions/mis-builder, praxya/account-financial-reporting, pscloud/mis-builder, qtiplb/mis-builder, ramsam5/account-financial-reporting, raycarnes/account-financial-reporting, richard-willdooit/account-financial-reporting, richard-willdooit/mis-builder, rihene-abdelwahed/odoo-production, robertsvx27/mis-builder, robinkeunen/mis-builder, rossasa/account-financial-reporting, roussel2nis/account-financial-reporting, royalline1/mis-builder, royalline1/patches, rrgaona/mis-builder, rschnapka/account-financial-reporting, rsullivan2704/mis-builder, ruter-lyu/mis-builder, s2d4theworld/account-financial-reporting, sadeqamin/mis-builder, sagar-developer-92/account-financial-reporting, sanube/mis-builder, savoirfairelinux/account-financial-reporting, sbejaoui/mis-builder, sc4you/odoo-production, sebalix/mis-builder, sebastiken/account-financial-reporting, sergiocorato/account-financial-reporting, sewisoft/mis-builder, shengyf1/mis-builder, shine-it/mis-builder, shuhaida6704/account-financial-reporting, siddharth7815/odoo-production, simahawk/mis-builder, simplifysolutions/account-financial-reporting, sisihitam/mis-builder, southasia/account-financial-reporting, sprevot44/odoo-production, steingabelgaard/mis-builder, stephanamann/account-financial-reporting, ston380/account-financial-reporting, sunflowerit/mis-builder, suningwz/odoo-production, sunshineLhj/mis-builder, supercoopbdx/odoo-production, superquinquin/odoo-production, svalaeys/mis-builder, tafaRU/account-financial-reporting, takinobori/oca-mis-builder, tdombos/mis-builder, tirma-sa/mis-builder, tremlin/account-financial-reporting, trobz/odoo-production, ttpphuctran/odoo-production, unitek-solusi/OCA-mis-builder, ursais/mis-builder, valmarnet/mis-builder, vdewulf/mis-builder, vertelab/odoo-account-financial-reporting, vidtsin/odoo-production, vidtsin/patches, vrenaville/account-financial-reporting, wade1990/mis-builder, wahello/mis-builder, westlyou/mis-builder, xpansa/account-financial-reporting, xpansa/mis-builder, xtjie/mis-builder, yelizariev/account-financial-reporting, yostashiro/account-financial-reporting, yuntux/odoo-production, yvaucher/account-financial-reporting, zakiuu/account-financial-reporting, and zeroincombenze/account-financial-reporting

<h1 class="title">MIS Builder</h1> <p><a class="reference external" href="https://odoo-community.org/page/development-status"><img alt="Production/Stable" src="https://img.shields.io/badge/maturity-Production%2FStable-green.png" /></a> <a class="reference external" href="http://www.gnu.org/licenses/agpl-3.0-standalone.html"><img alt="License: AGPL-3" src="https://img.shields.io/badge/licence-AGPL--3-blue.png" /></a> <a class="reference external" href="https://github.com/OCA/mis-builder/tree/10.0/mis_builder"><img alt="OCA/mis-builder" src="https://img.shields.io/badge/github-OCA%2Fmis--builder-lightgray.png?logo=github" /></a> <a class="reference external" href="https://translation.odoo-community.org/projects/mis-builder-10-0/mis-builder-10-0-mis_builder"><img alt="Translate me on Weblate" src="https://img.shields.io/badge/weblate-Translate%20me-F47D42.png" /></a> <a class="reference external" href="https://runbot.odoo-community.org/runbot/248/10.0"><img alt="Try me on Runbot" src="https://img.shields.io/badge/runbot-Try%20me-875A7B.png" /></a></p> <p>This module allows you to build Management Information Systems dashboards. Such style of reports presents KPI in rows and time periods in columns. Reports mainly fetch data from account moves, but can also combine data coming from arbitrary Odoo models. Reports can be exported to PDF, Excel and they can be added to Odoo dashboards.</p> <p><strong>Table of contents</strong></p> <div class="contents local topic" id="contents"> <ul class="simple"> <li><a class="reference internal" href="#installation" id="id29">Installation</a></li> <li><a class="reference internal" href="#usage" id="id30">Usage</a></li> <li><a class="reference internal" href="#development" id="id31">Development</a></li> <li><a class="reference internal" href="#known-issues-roadmap" id="id32">Known issues / Roadmap</a></li> <li><a class="reference internal" href="#changelog" id="id33">Changelog</a><ul> <li><a class="reference internal" href="#id1" id="id34">10.0.3.2.2 (2018-06-30)</a></li> <li><a class="reference internal" href="#id4" id="id35">10.0.3.2.1 (2018-05-29)</a></li> <li><a class="reference internal" href="#id6" id="id36">10.0.3.2.0 (2018-05-02)</a></li> <li><a class="reference internal" href="#id10" id="id37">10.0.3.1.1 (2017-11-14)</a></li> <li><a class="reference internal" href="#id19" id="id38">10.0.3.0.4 (2017-10-14)</a></li> <li><a class="reference internal" href="#id21" id="id39">10.0.3.0.3 (2017-10-03)</a></li> <li><a class="reference internal" href="#id23" id="id40">10.0.3.0.2 (2017-10-01)</a></li> <li><a class="reference internal" href="#unreleased" id="id41">10.0.2.0.3 (unreleased)</a></li> <li><a class="reference internal" href="#id24" id="id42">9.0.2.0.2 (2016-09-27)</a></li> <li><a class="reference internal" href="#id25" id="id43">9.0.2.0.1 (2016-05-26)</a></li> <li><a class="reference internal" href="#id26" id="id44">9.0.2.0.0 (2016-05-24)</a></li> <li><a class="reference internal" href="#id27" id="id45">8.0.1.0.0 (2016-04-27)</a></li> <li><a class="reference internal" href="#id28" id="id46">8.0.0.2.0</a></li> </ul> </li> <li><a class="reference internal" href="#bug-tracker" id="id47">Bug Tracker</a></li> <li><a class="reference internal" href="#credits" id="id48">Credits</a><ul> <li><a class="reference internal" href="#authors" id="id49">Authors</a></li> <li><a class="reference internal" href="#contributors" id="id50">Contributors</a></li> <li><a class="reference internal" href="#maintainers" id="id51">Maintainers</a></li> </ul> </li> </ul> </div> <a name="installation"></a> <h2><a class="toc-backref" href="#id29">Installation</a></h2> <p>Your preferred way to install addons will work with MIS Builder.</p> <p>An easy way to install it with all its dependencies is using pip:</p> <ul class="simple"> <li><code>pip install --pre odoo10-addon-mis_builder odoo-autodiscover</code></li> <li>then restart Odoo, update the addons list in your database, and install the MIS Builder application.</li> </ul> <a name="usage"></a> <h2><a class="toc-backref" href="#id30">Usage</a></h2> <p>To configure this module, you need to:</p> <ul class="simple"> <li>Go to Accounting &gt; Configuration &gt; MIS Reporting &gt; MIS Report Templates where you can create report templates by defining KPI's. KPI's constitute the rows of your reports. Such report templates are time independent.</li> </ul> <div class="figure align-center"> <img alt="Sample report template" src="https://raw.githubusercontent.com/OCA/mis-builder/10.0/mis_builder/static/description/ex_report_template.png" style="width: 80%;" /> </div> <ul class="simple"> <li>Then in Accounting &gt; Reports &gt; MIS Reporting &gt; MIS Reports you can create report instance by binding the templates to time periods, hence defining the columns of your reports.</li> </ul> <div class="figure align-center"> <img alt="Sample report configuration" src="https://raw.githubusercontent.com/OCA/mis-builder/10.0/mis_builder/static/description/ex_report_settings.png" style="width: 80%;" /> </div> <ul class="simple"> <li>From the MIS Reports view, you can preview the report, add it to and Odoo dashboard, and export it to PDF or Excel.</li> </ul> <div class="figure align-center"> <img alt="Sample preview" src="https://raw.githubusercontent.com/OCA/mis-builder/10.0/mis_builder/static/description/ex_report_preview.png" style="width: 80%;" /> </div> <a name="development"></a> <h2><a class="toc-backref" href="#id31">Development</a></h2> <p>A typical extension is to provide a mechanism to filter reports on analytic dimensions or operational units. To implement this, you can override _get_additional_move_line_filter and _get_additional_filter to further filter move lines or queries based on a user selection. A typical use case could be to add an analytic account field on mis.report.instance, or even on mis.report.instance.period if you want different columns to show different analytic accounts.</p> <a name="known-issues-roadmap"></a> <h2><a class="toc-backref" href="#id32">Known issues / Roadmap</a></h2> <p>The mis_builder <a class="reference external" href="https://github.com/OCA/mis-builder/issues?q=is%3Aopen+is%3Aissue+label%3Aenhancement">roadmap</a> and <a class="reference external" href="https://github.com/OCA/mis-builder/issues?q=is%3Aopen+is%3Aissue+label%3Abug">known issues</a> can be found on GitHub.</p> <a name="changelog"></a> <h2><a class="toc-backref" href="#id33">Changelog</a></h2> <a name="id1"></a> <h3><a class="toc-backref" href="#id34">10.0.3.2.2 (2018-06-30)</a></h3> <ul class="simple"> <li>[FIX] Fix bug in company_default_get call returning id instead of recordset (<a class="reference external" href="https://github.com/OCA/mis-builder/pull/103">#103</a>)</li> <li>[IMP] add &quot;hide always&quot; style property to make hidden KPI's (for KPI that serve as basis for other formulas, but do not need to be displayed). (<a class="reference external" href="https://github.com/OCA/mis-builder/issues/46">#46</a>)</li> </ul> <a name="id4"></a> <h3><a class="toc-backref" href="#id35">10.0.3.2.1 (2018-05-29)</a></h3> <ul class="simple"> <li>[FIX] Missing comparison operator for AccountingNone leading to errors in pbal computations (<a class="reference external" href="https://github.com/OCA/mis-builder/issue/93">#93</a>)</li> </ul> <a name="id6"></a> <h3><a class="toc-backref" href="#id36">10.0.3.2.0 (2018-05-02)</a></h3> <ul class="simple"> <li>[FIX] make subkpi ordering deterministic (<a class="reference external" href="https://github.com/OCA/mis-builder/issues/71">#71</a>)</li> <li>[ADD] report instance level option to disable account expansion, enabling the creation of detailed templates while deferring the decision of rendering the details or not to the report instance (<a class="reference external" href="https://github.com/OCA/mis-builder/issues/74">#74</a>)</li> <li>[ADD] pbal and nbal accounting expressions, to sum positive and negative balances respectively (ie ignoring accounts with negative, resp positive balances) (<a class="reference external" href="https://github.com/OCA/mis-builder/issues/86">#86</a>)</li> </ul> <a name="id10"></a> <h3><a class="toc-backref" href="#id37">10.0.3.1.1 (2017-11-14)</a></h3> <p>New features:</p> <ul class="simple"> <li>[ADD] month and year relative periods, easier to use than date ranges for the most common case. (<a class="reference external" href="https://github.com/OCA/mis-builder/issues/2">#2</a>)</li> <li>[ADD] multi-company consolidation support, with currency conversion (the conversion rate date is the end of the reporting period) (<a class="reference external" href="https://github.com/OCA/mis-builder/issues/7">#7</a>, <a class="reference external" href="https://github.com/OCA/mis-builder/issues/3">#3</a>)</li> <li>[ADD] provide ref, datetime, dateutil, time, user in the evaluation context of move line domains; among other things, this allows using references to xml ids (such as account types or tax tags) when querying move lines (<a class="reference external" href="https://github.com/OCA/mis-builder/issues/26">#26</a>).</li> <li>[ADD] extended account selectors: you can now select accounts using any domain on account.account, not only account codes <code>balp[('user_type_id', '=', ref('account.data_account_type_receivable').id)]</code> (<a class="reference external" href="https://github.com/OCA/mis-builder/issues/4">#4</a>).</li> <li>[IMP] in the report instance configuration form, the filters are now grouped in a notebook page, this improves readability and extensibility (<a class="reference external" href="https://github.com/OCA/mis-builder/issues/39">#39</a>).</li> </ul> <p>Bug fixes:</p> <ul class="simple"> <li>[FIX] fix error when saving periods in comparison mode on newly created (not yet saved) report instances. <a class="reference external" href="https://github.com/OCA/mis-builder/pull/50">#50</a></li> <li>[FIX] improve display of Base Date report instance view. <a class="reference external" href="https://github.com/OCA/mis-builder/pull/51">#51</a></li> </ul> <p>Upgrading from 3.0 (breaking changes):</p> <ul class="simple"> <li>Alternative move line data sources must have a company_id field.</li> </ul> <a name="id19"></a> <h3><a class="toc-backref" href="#id38">10.0.3.0.4 (2017-10-14)</a></h3> <p>Bug fix:</p> <ul class="simple"> <li>[FIX] issue with initial balance rounding. <a class="reference external" href="https://github.com/OCA/mis-builder/issues/30">#30</a></li> </ul> <a name="id21"></a> <h3><a class="toc-backref" href="#id39">10.0.3.0.3 (2017-10-03)</a></h3> <p>Bug fix:</p> <ul class="simple"> <li>[FIX] fix error saving KPI on newly created reports. <a class="reference external" href="https://github.com/OCA/mis-builder/issues/18">#18</a></li> </ul> <a name="id23"></a> <h3><a class="toc-backref" href="#id40">10.0.3.0.2 (2017-10-01)</a></h3> <p>New features:</p> <ul class="simple"> <li>[ADD] Alternative move line source per report column. This makes mis buidler accounting expressions work on any model that has debit, credit, account_id and date fields. Provided you can expose, say, committed purchases, or your budget as a view with debit, credit and account_id, this opens up a lot of possibilities</li> <li>[ADD] Comparison column source (more flexible than the previous, now deprecated, comparison mechanism). CAVEAT: there is no automated migration to the new mechanism.</li> <li>[ADD] Sum column source, to create columns that add/subtract other columns.</li> <li>[ADD] mis.kpi.data abstract model as a basis for manual KPI values supporting automatic ajustment to the reporting time period (the basis for budget item, but could also server other purposes, such as manually entering some KPI values, such as number of employee)</li> <li>[ADD] mis_builder_budget module providing a new budget data source</li> <li>[ADD] new &quot;hide empty&quot; style property</li> <li>[IMP] new AEP method to get accounts involved in an expression (this is useful to find which KPI relate to a given P&amp;L acount, to implement budget control)</li> <li>[IMP] many UI improvements</li> <li>[IMP] many code style improvements and some refactoring</li> <li>[IMP] add the column date_from, date_to in expression evaluation context, as well as time, datetime and dateutil modules</li> </ul> <p>Main bug fixes:</p> <ul class="simple"> <li>[FIX] deletion of templates and reports (cascade and retricts) (<a class="reference external" href="https://github.com/OCA/account-financial-reporting/issues/281">https://github.com/OCA/account-financial-reporting/issues/281</a>)</li> <li>[FIX] copy of reports (<a class="reference external" href="https://github.com/OCA/account-financial-reporting/issues/282">https://github.com/OCA/account-financial-reporting/issues/282</a>)</li> <li>[FIX] better error message when periods have wrong/missing dates (<a class="reference external" href="https://github.com/OCA/account-financial-reporting/issues/283">https://github.com/OCA/account-financial-reporting/issues/283</a>)</li> <li>[FIX] xlsx export of string types KPI (<a class="reference external" href="https://github.com/OCA/account-financial-reporting/issues/285">https://github.com/OCA/account-financial-reporting/issues/285</a>)</li> <li>[FIX] sorting of detail by account</li> <li>[FIX] computation bug in detail by account when multiple accounting expressions were used in a KPI</li> <li>[FIX] permission issue when adding report to dashboard with non admin user</li> </ul> <a name="unreleased"></a> <h3><a class="toc-backref" href="#id41">10.0.2.0.3 (unreleased)</a></h3> <ul class="simple"> <li>[IMP] more robust behaviour in presence of missing expressions</li> <li>[FIX] indent style</li> <li>[FIX] local variable 'ctx' referenced before assignment when generating reports with no objects</li> <li>[IMP] use fontawesome icons</li> <li>[MIG] migrate to 10.0</li> <li>[FIX] unicode error when exporting to Excel</li> <li>[IMP] provide full access to mis builder style for group Adviser.</li> </ul> <a name="id24"></a> <h3><a class="toc-backref" href="#id42">9.0.2.0.2 (2016-09-27)</a></h3> <ul class="simple"> <li>[IMP] Add refresh button in mis report preview.</li> <li>[IMP] Widget code changes to allow to add fields in the widget more easily.</li> </ul> <a name="id25"></a> <h3><a class="toc-backref" href="#id43">9.0.2.0.1 (2016-05-26)</a></h3> <ul class="simple"> <li>[IMP] remove unused argument in declare_and_compute_period() for a cleaner API. This is a breaking API changing merged in urgency before it is used by other modules.</li> </ul> <a name="id26"></a> <h3><a class="toc-backref" href="#id44">9.0.2.0.0 (2016-05-24)</a></h3> <p>Part of the work for this release has been done at the Sorrento sprint April 26-29, 2016. The rest (ie a major refactoring) has been done in the weeks after.</p> <ul class="simple"> <li>[IMP] hide button box in edit mode on the report instance settings form</li> <li>[FIX] Fix sum aggregation of non-stored fields (<a class="reference external" href="https://github.com/OCA/account-financial-reporting/issues/178">https://github.com/OCA/account-financial-reporting/issues/178</a>)</li> <li>[IMP] There is now a default style at the report level</li> <li>[CHG] Number display properties (rounding, prefix, suffix, factor) are now defined in styles</li> <li>[CHG] Percentage difference are rounded to 1 digit instead of the kpi's rounding, as the KPI rounding does not make sense in this case</li> <li>[CHG] The divider suffix (k, M, etc) is not inserted automatically anymore because it is inconsistent when working with prefixes; you need to add it manually in the suffix</li> <li>[IMP] AccountingExpressionProcessor now supports 'balu' expressions to obtain the unallocated profit/loss of previous fiscal years; get_unallocated_pl is the corresponding convenience method</li> <li>[IMP] AccountingExpressionProcessor now has easy methods to obtain balances by account: get_balances_initial, get_balances_end, get_balances_variation</li> <li>[IMP] there is now an auto-expand feature to automatically display a detail by account for selected kpis</li> <li>[IMP] the kpi and period lists are now manipulated through forms instead of directly in the tree views</li> <li>[IMP] it is now possible to create a report through a wizard, such reports are deemed temporary and available through a &quot;Last Reports Generated&quot; menu, they are garbaged collected automatically, unless saved permanently, which can be done using a Save button</li> <li>[IMP] there is now a beginner mode to configure simple reports with only one period</li> <li>[IMP] it is now easier to configure periods with fixed start/end dates</li> <li>[IMP] the new sub-kpi mechanism allows the creation of columns with multiple values, or columns with different values</li> <li>[IMP] thanks to the new style model, the Excel export is now styled</li> <li>[IMP] a new style model is now used to centralize style configuration</li> <li>[FIX] use =like instead of like to search for accounts, because the % are added by the user in the expressions</li> <li>[FIX] Correctly compute the initial balance of income and expense account based on the start of the fiscal year</li> <li>[IMP] Support date ranges (from OCA/server-tools/date_range) as a more flexible alternative to fiscal periods</li> <li>v9 migration: fiscal periods are removed, account charts are removed, consolidation accounts have been removed</li> </ul> <a name="id27"></a> <h3><a class="toc-backref" href="#id45">8.0.1.0.0 (2016-04-27)</a></h3> <ul class="simple"> <li>The copy of a MIS Report Instance now copies period. <a class="reference external" href="https://github.com/OCA/account-financial-reporting/pull/181">https://github.com/OCA/account-financial-reporting/pull/181</a></li> <li>The copy of a MIS Report Template now copies KPIs and queries. <a class="reference external" href="https://github.com/OCA/account-financial-reporting/pull/177">https://github.com/OCA/account-financial-reporting/pull/177</a></li> <li>Usability: the default view for MIS Report instances is now the rendered preview, and the settings are accessible through a gear icon in the list view and a button in the preview. <a class="reference external" href="https://github.com/OCA/account-financial-reporting/pull/170">https://github.com/OCA/account-financial-reporting/pull/170</a></li> <li>Display blank cells instead of 0.0 when there is no data. <a class="reference external" href="https://github.com/OCA/account-financial-reporting/pull/169">https://github.com/OCA/account-financial-reporting/pull/169</a></li> <li>Usability: better layout of the MIS Report periods settings on small screens. <a class="reference external" href="https://github.com/OCA/account-financial-reporting/pull/167">https://github.com/OCA/account-financial-reporting/pull/167</a></li> <li>Include the download buttons inside the MIS Builder widget, and refactor the widget to open the door to analytic filtering in the previews. <a class="reference external" href="https://github.com/OCA/account-financial-reporting/pull/151">https://github.com/OCA/account-financial-reporting/pull/151</a></li> <li>Add KPI rendering prefixes (so you can print $ in front of the value). <a class="reference external" href="https://github.com/OCA/account-financial-reporting/pull/158">https://github.com/OCA/account-financial-reporting/pull/158</a></li> <li>Add hooks for analytic filtering. <a class="reference external" href="https://github.com/OCA/account-financial-reporting/pull/128">https://github.com/OCA/account-financial-reporting/pull/128</a> <a class="reference external" href="https://github.com/OCA/account-financial-reporting/pull/131">https://github.com/OCA/account-financial-reporting/pull/131</a></li> </ul> <a name="id28"></a> <h3><a class="toc-backref" href="#id46">8.0.0.2.0</a></h3> <p>Pre-history. Or rather, you need to look at the git log.</p> <a name="bug-tracker"></a> <h2><a class="toc-backref" href="#id47">Bug Tracker</a></h2> <p>Bugs are tracked on <a class="reference external" href="https://github.com/OCA/mis-builder/issues">GitHub Issues</a>. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smashing it by providing a detailed and welcomed <a class="reference external" href="https://github.com/OCA/mis-builder/issues/new?body=module:%20mis_builder%0Aversion:%2010.0%0A%0A**Steps%20to%20reproduce**%0A-%20...%0A%0A**Current%20behavior**%0A%0A**Expected%20behavior**">feedback</a>.</p> <p>Do not contact contributors directly about support or help with technical issues.</p> <a name="credits"></a> <h2><a class="toc-backref" href="#id48">Credits</a></h2> <a name="authors"></a> <h3><a class="toc-backref" href="#id49">Authors</a></h3> <ul class="simple"> <li>ACSONE SA/NV</li> </ul> <a name="contributors"></a> <h3><a class="toc-backref" href="#id50">Contributors</a></h3> <ul class="simple"> <li>Stéphane Bidoul &lt;<a class="reference external" href="mailto:stephane.bidoul&#64;acsone.eu">stephane.bidoul&#64;acsone.eu</a>&gt;</li> <li>Laetitia Gangloff &lt;<a class="reference external" href="mailto:laetitia.gangloff&#64;acsone.eu">laetitia.gangloff&#64;acsone.eu</a>&gt;</li> <li>Adrien Peiffer &lt;<a class="reference external" href="mailto:adrien.peiffer&#64;acsone.eu">adrien.peiffer&#64;acsone.eu</a>&gt;</li> <li>Alexis de Lattre &lt;<a class="reference external" href="mailto:alexis.delattre&#64;akretion.com">alexis.delattre&#64;akretion.com</a>&gt;</li> <li>Alexandre Fayolle &lt;<a class="reference external" href="mailto:alexandre.fayolle&#64;camptocamp.com">alexandre.fayolle&#64;camptocamp.com</a>&gt;</li> <li>Jordi Ballester &lt;<a class="reference external" href="mailto:jordi.ballester&#64;eficent.com">jordi.ballester&#64;eficent.com</a>&gt;</li> <li>Thomas Binsfeld &lt;<a class="reference external" href="mailto:thomas.binsfeld&#64;gmail.com">thomas.binsfeld&#64;gmail.com</a>&gt;</li> <li>Giovanni Capalbo &lt;<a class="reference external" href="mailto:giovanni&#64;therp.nl">giovanni&#64;therp.nl</a>&gt;</li> <li>Marco Calcagni &lt;<a class="reference external" href="mailto:mcalcagni&#64;dinamicheaziendali.it">mcalcagni&#64;dinamicheaziendali.it</a>&gt;</li> <li>Sébastien Beau &lt;<a class="reference external" href="mailto:sebastien.beau&#64;akretion.com">sebastien.beau&#64;akretion.com</a>&gt;</li> <li>Laurent Mignon &lt;<a class="reference external" href="mailto:laurent.mignon&#64;acsone.eu">laurent.mignon&#64;acsone.eu</a>&gt;</li> <li>Luc De Meyer &lt;<a class="reference external" href="mailto:luc.demeyer&#64;noviat.com">luc.demeyer&#64;noviat.com</a>&gt;</li> <li>Benjamin Willig &lt;<a class="reference external" href="mailto:benjamin.willig&#64;acsone.eu">benjamin.willig&#64;acsone.eu</a>&gt;</li> <li>Martronic SA &lt;<a class="reference external" href="mailto:info&#64;martronic.ch">info&#64;martronic.ch</a>&gt;</li> <li>nicomacr &lt;<a class="reference external" href="mailto:nmr&#64;adhoc.com.ar">nmr&#64;adhoc.com.ar</a>&gt;</li> <li>Juan Jose Scarafia &lt;<a class="reference external" href="mailto:jjs&#64;adhoc.com.ar">jjs&#64;adhoc.com.ar</a>&gt;</li> <li>Richard deMeester &lt;<a class="reference external" href="mailto:richard&#64;willowit.com.au">richard&#64;willowit.com.au</a>&gt;</li> <li>Eric Caudal &lt;<a class="reference external" href="mailto:eric.caudal&#64;elico-corp.com">eric.caudal&#64;elico-corp.com</a>&gt;</li> <li>Andrea Stirpe &lt;<a class="reference external" href="mailto:a.stirpe&#64;onestein.nl">a.stirpe&#64;onestein.nl</a>&gt;</li> </ul> <a name="maintainers"></a> <h3><a class="toc-backref" href="#id51">Maintainers</a></h3> <p>This module is maintained by the OCA.</p> <a class="reference external image-reference" href="https://odoo-community.org"><img alt="Odoo Community Association" src="https://odoo-community.org/logo.png" /></a> <p>OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.</p> <p>Current <a class="reference external" href="https://odoo-community.org/page/maintainer-role">maintainer</a>:</p> <p><a class="reference external" href="https://github.com/sbidoul"><img alt="sbidoul" src="https://github.com/sbidoul.png?size=40px" /></a></p> <p>This module is part of the <a class="reference external" href="https://github.com/OCA/mis-builder/tree/10.0/mis_builder">OCA/mis-builder</a> project on GitHub.</p> <p>You are welcome to contribute. To learn how please visit <a class="reference external" href="https://odoo-community.org/page/Contribute">https://odoo-community.org/page/Contribute</a>.</p>