Author: |
ACSONE SA/NV, Odoo Community Association (OCA) |
License: |
AGPL-3 |
Branch: |
14.0-cdd_master |
Repository: |
acsone/mis-builder |
Dependencies: |
account,
and
mis_builder |
Languages: |
HTML (461, 11.8%),
PO File (2066, 53.0%),
Python (722, 18.5%),
XML (452, 11.6%),
and
reStructuredText (199, 5.1%) |
Other branches: |
10.0,
10.0-abi_master,
10.0-cla_master,
10.0-lih_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-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,
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: |
Albin-John/mis-builder,
Alfa-90/mis-builder,
AwesomeFoodCoops/odoo-production,
Awievdberg/mis-builder,
Bubbles-IT/mis-builder,
Change2improve/mis-builder,
Colorlessgold/mis-builder,
Comunitea/mis-builder,
DITIntl/mis-builder,
DITIntl/odoo-production,
Digital5-Odoo/mis-builder,
Dobtor-OCA/mis-builder,
ERPLibre/mis-builder,
Fitranugraha/mis-builder,
ForgeFlow/mis-builder,
Gabinete-Digital/mis-builder,
Gofekra/mis-builder,
Groupe-Informatique-LaCoopSurMer/odoo-production,
Guobower/mis-builder,
HarshalBhoir/mis-builder,
HomerDeoDatu/mis-builder,
Ingeos/mis-builder,
Jarsa/mis-builder,
Kayuulab/mis-builder,
LevelPrime/mis-builder,
Martronic-SA/account-financial-reporting,
Martronic-SA/mis-builder,
MathBenTech/mis-builder,
MaxyMoos/mis-builder,
NeatNerdPrime/mis-builder,
Nkirui/mis-builder,
Numigi/mis-builder,
OCA-MUK/mis-builder,
OCA/mis-builder,
Otsokop/odoo-production,
QubiQ/mis-builder,
SSISoftware/mis-builder,
SanteLibre/mis-builder,
SeuMarco/mis-builder,
Syci-Consulting/mis-builder,
Tecnativa/mis-builder,
Thawah/mis-builder,
VisiionSolucionesTecnologicas/mis-builder,
Werded/mis-builder,
YogendrasinhChavda/mis-builder,
YogeshMahera-SerpentCS/mis-builder,
a0c/mis-builder,
aaltinisik/mis-builder,
acsone/account-financial-reporting,
adhoc-dev/mis-builder,
algiopensource/mis-builder,
amcor/mis-builder,
anhvu-sg/mis-builder,
apachesep/mis-builder,
apetbiz/mis-builder,
aurestic/mis-builder,
azmeuk/odoo-production,
bachmanna/mis-builder,
bishalgit/mis-builder,
bmya/mis-builder,
bodedra/mis-builder,
brain-tec/mis-builder,
camptocamp/mis-builder,
chetanrdhaduk/odoo-production,
cogitoweb/mis-builder,
coopaname/mis-builder,
coopiteasy/mis-builder,
dani-xtendoo/mis-builder,
daramousk/mis-builder,
decodio-applications/mis-builder,
diagramsoftware/mis-builder,
diegobgl/mis-builder,
diggy128/mis-builder,
dmo-odoo/mis-builder,
dorsaf/mis-builder,
druidoo-dev/mis-builder,
druidoo/FoodCoops,
dzungtran89/odoo-production,
ecosoft-odoo/mis-builder,
elicoidal/mis-builder,
estevebadia/odoo-production,
etobella/mis-builder,
exosoftware/oca-mis-builder,
falconsoft3d/mis-builder,
fhferreira/mis-builder,
grindtildeath/mis-builder,
gtopba/mis-builder,
hbrunn/mis-builder,
huntergps/mis-builder,
iRichGit/mis-builder,
iamyeonhan/mis-builder,
initOS/mis-builder,
insscn/mis-builder,
isoscl/mis-builder,
italoadler/mis-builder,
izzihector/mis-builder,
jackjack82/mis-builder,
jacky82669513/mis-builder,
jbreard/mis-builder,
jjscarafia/mis-builder,
jlimasa/mis-builder,
kent7301/mis-builder,
kevin070982/mis-builder,
kittiu/mis-builder,
kmee/mis-builder,
krunal267/odoo-production,
lachouettecoop/odoo-production,
leemannd/mis-builder,
lideritjnma/mis-builder,
loyalcomps/mis-builder,
luc-demeyer/account-financial-reporting,
luistorresm/mis-builder,
magnuscolors/mis-builder,
marionumza/mis-builder,
markrobinson85/mis-builder,
mileo/mis-builder,
mivilsoft/mis-builder,
mohamedhabibchallouf/mis-builder,
mohammad0omar/mis-builder,
mpanarin/mis-builder,
mszinte/odoo-production,
multidadosti-erp/mis-builder,
njeudy/mis-builder,
nthnnl/odoo-production,
nucleoosystem/mis-builder,
odof/mis-builder,
odoo-modules/odoo-production,
odoogap/mis-builder,
omalbastin/mis-builder,
one2pret/mis-builder,
onurugur/mis-builder,
osfp-Pakistan/mis-builder,
paul1osullivan/mis-builder,
piensom/mis-builder,
popsolutions/mis-builder,
pscloud/mis-builder,
qtiplb/mis-builder,
richard-willdooit/mis-builder,
robertsvx27/mis-builder,
robinkeunen/mis-builder,
royalline1/mis-builder,
rrgaona/mis-builder,
rsullivan2704/mis-builder,
ruter-lyu/mis-builder,
sadeqamin/mis-builder,
sanube/mis-builder,
sbejaoui/mis-builder,
sebalix/mis-builder,
sewisoft/mis-builder,
shengyf1/mis-builder,
shine-it/mis-builder,
siddharth7815/odoo-production,
simahawk/mis-builder,
sisihitam/mis-builder,
steingabelgaard/mis-builder,
sunflowerit/mis-builder,
suningwz/odoo-production,
sunshineLhj/mis-builder,
supercoopbdx/odoo-production,
svalaeys/mis-builder,
takinobori/oca-mis-builder,
tdombos/mis-builder,
tirma-sa/mis-builder,
trobz/odoo-production,
unitek-solusi/OCA-mis-builder,
ursais/mis-builder,
valmarnet/mis-builder,
vdewulf/mis-builder,
vidtsin/odoo-production,
wade1990/mis-builder,
wahello/mis-builder,
westlyou/mis-builder,
xpansa/mis-builder,
and
xtjie/mis-builder |
<h1 class="title">MIS Builder Budget</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/14.0/mis_builder_budget"><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-14-0/mis-builder-14-0-mis_builder_budget"><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/14.0"><img alt="Try me on Runbot" src="https://img.shields.io/badge/runbot-Try%20me-875A7B.png" /></a></p>
<p>Create budgets for MIS reports.</p>
<p>This module lets you create budgets for any MIS report. Several budgets can be
created for a given report template (ie one budget per year). Budget figures
are provided by KPI or by GL account, with different time periods. A budget can
then be selected as a data source for a MIS report column, and the report will
show the budgeted values for each KPI, adjusted for the period of the column.</p>
<p><strong>Table of contents</strong></p>
<div class="contents local topic" id="contents">
<ul class="simple">
<li><a class="reference internal" href="#usage" id="id19">Usage</a></li>
<li><a class="reference internal" href="#known-issues-roadmap" id="id20">Known issues / Roadmap</a></li>
<li><a class="reference internal" href="#changelog" id="id21">Changelog</a><ul>
<li><a class="reference internal" href="#id1" id="id22">14.0.3.5.1 (2021-04-06)</a></li>
<li><a class="reference internal" href="#id3" id="id23">13.0.3.5.0 (2020-03-28)</a></li>
<li><a class="reference internal" href="#id5" id="id24">13.0.3.4.0 (2020-01-??)</a></li>
<li><a class="reference internal" href="#id6" id="id25">12.0.3.4.0 (2019-10-26)</a></li>
<li><a class="reference internal" href="#id8" id="id26">11.0.3.3.0 (2019-01-13)</a></li>
<li><a class="reference internal" href="#id10" id="id27">11.0.3.2.1 (2018-06-30)</a></li>
<li><a class="reference internal" href="#id12" id="id28">11.0.3.2.0 (2018-05-02)</a></li>
<li><a class="reference internal" href="#id14" id="id29">11.0.3.1.1 (2018-02-04)</a></li>
<li><a class="reference internal" href="#id16" id="id30">10.0.3.1.0 (2017-11-14)</a></li>
<li><a class="reference internal" href="#id18" id="id31">10.0.1.1.1 (2017-10-01)</a></li>
</ul>
</li>
<li><a class="reference internal" href="#bug-tracker" id="id32">Bug Tracker</a></li>
<li><a class="reference internal" href="#credits" id="id33">Credits</a><ul>
<li><a class="reference internal" href="#authors" id="id34">Authors</a></li>
<li><a class="reference internal" href="#contributors" id="id35">Contributors</a></li>
<li><a class="reference internal" href="#maintainers" id="id36">Maintainers</a></li>
</ul>
</li>
</ul>
</div>
<a name="usage"></a>
<h2><a class="toc-backref" href="#id19">Usage</a></h2>
<p>There are two ways to use this module: create budgets by KPI or budgets by
GL accounts. Currently, the two methods cannot be combined in the same budget.</p>
<p><strong>Budget by KPIs</strong></p>
<p>To use this this mode, you first need to flag at least some KPI in a MIS report
to be budgetable. You also need to configure the accumulation method on the KPI
according to their type.</p>
<p>The accumulation method determines how budgeted values spanning over a
time period are transformed to match the reporting period.</p>
<ul class="simple">
<li>Sum: values of shorter period are added, values of longest or partially overlapping
periods are adjusted pro-rata temporis (eg monetary amount such as revenue).</li>
<li>Average: values of included period are averaged with a pro-rata temporis weight.
Typically used for values that do not accumulate over time (eg a number of employees).</li>
</ul>
<p>When KPI are configured, you need to create a budget, using the MIS Budget (by
KPIs) menu, then click on the budget items button to create or import the
budgeted amounts for all your KPI and time periods.</p>
<p><strong>Budget by GL accounts</strong></p>
<p>You can also create budgets by GL accounts. In this case, the budget is
populated with one line per GL account (and optionally analytic account and/or
tags) and time period.</p>
<p><strong>Add budget columns to report instances</strong></p>
<p>Finally, a column (aka period) must be added to a MIS report instance,
selecting your newly created budget as a data source. The data will be adjusted
to the reporting period when displayed. Columns can be compared by adding a
column of type "comparison" or "sum".</p>
<a name="known-issues-roadmap"></a>
<h2><a class="toc-backref" href="#id20">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="#id21">Changelog</a></h2>
<a name="id1"></a>
<h3><a class="toc-backref" href="#id22">14.0.3.5.1 (2021-04-06)</a></h3>
<p><strong>Bugfixes</strong></p>
<ul class="simple">
<li>Fix incorrect budget by account multi company security rules. (<a class="reference external" href="https://github.com/OCA/mis-builder/issues/347">#347</a>)</li>
</ul>
<a name="id3"></a>
<h3><a class="toc-backref" href="#id23">13.0.3.5.0 (2020-03-28)</a></h3>
<p><strong>Features</strong></p>
<ul class="simple">
<li>Budget by GL account: allow budgeting by GL account in addition to the
existing mechanism to budget by KPI. Budget items have a begin and end
date, and when reporting a pro-rata temporis adjustment is made to match
the reporting period. (<a class="reference external" href="https://github.com/OCA/mis-builder/issues/259">#259</a>)</li>
</ul>
<a name="id5"></a>
<h3><a class="toc-backref" href="#id24">13.0.3.4.0 (2020-01-??)</a></h3>
<p>Migration to odoo 13.0.</p>
<a name="id6"></a>
<h3><a class="toc-backref" href="#id25">12.0.3.4.0 (2019-10-26)</a></h3>
<p><strong>Bugfixes</strong></p>
<ul class="simple">
<li>Consider analytic tags too when detecting overlapping budget items.
Previously only analytic account was considered, and this overlap detection
mechanism was overlooked when analytic tags were added to budget items. (<a class="reference external" href="https://github.com/oca/mis-builder/issues/241">#241</a>)</li>
</ul>
<a name="id8"></a>
<h3><a class="toc-backref" href="#id26">11.0.3.3.0 (2019-01-13)</a></h3>
<p><strong>Features</strong></p>
<ul class="simple">
<li>Support analytic filters. (<a class="reference external" href="https://github.com/oca/mis-builder/issues/15">#15</a>)</li>
</ul>
<a name="id10"></a>
<h3><a class="toc-backref" href="#id27">11.0.3.2.1 (2018-06-30)</a></h3>
<ul class="simple">
<li>[IMP] Support analytic tags in budget items
(<a class="reference external" href="https://github.com/OCA/mis-builder/pull/100">#100</a>)</li>
</ul>
<a name="id12"></a>
<h3><a class="toc-backref" href="#id28">11.0.3.2.0 (2018-05-02)</a></h3>
<ul class="simple">
<li>[FIX] #NAME error in out-of-order computation of non
budgetable items in budget columns
(<a class="reference external" href="https://github.com/OCA/mis-builder/pull/69">#68</a>)</li>
</ul>
<a name="id14"></a>
<h3><a class="toc-backref" href="#id29">11.0.3.1.1 (2018-02-04)</a></h3>
<p>Migration to Odoo 11. No new feature.
(<a class="reference external" href="https://github.com/OCA/mis-builder/pull/67">#67</a>)</p>
<a name="id16"></a>
<h3><a class="toc-backref" href="#id30">10.0.3.1.0 (2017-11-14)</a></h3>
<p>New features:</p>
<ul class="simple">
<li>[ADD] multi-company record rule for MIS Budgets
(<a class="reference external" href="https://github.com/OCA/mis-builder/issues/27">#27</a>)</li>
</ul>
<a name="id18"></a>
<h3><a class="toc-backref" href="#id31">10.0.1.1.1 (2017-10-01)</a></h3>
<p>First version.</p>
<a name="bug-tracker"></a>
<h2><a class="toc-backref" href="#id32">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_budget%0Aversion:%2014.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="#id33">Credits</a></h2>
<a name="authors"></a>
<h3><a class="toc-backref" href="#id34">Authors</a></h3>
<ul class="simple">
<li>ACSONE SA/NV</li>
</ul>
<a name="contributors"></a>
<h3><a class="toc-backref" href="#id35">Contributors</a></h3>
<ul class="simple">
<li>Stéphane Bidoul <<a class="reference external" href="mailto:stephane.bidoul@acsone.eu">stephane.bidoul@acsone.eu</a>></li>
<li>Adrien Peiffer <<a class="reference external" href="mailto:adrien.peiffer@acsone.eu">adrien.peiffer@acsone.eu</a>></li>
<li>Benjamin Willig <<a class="reference external" href="mailto:benjamin.willig@acsone.eu">benjamin.willig@acsone.eu</a>></li>
<li>Artem Kostyuk <<a class="reference external" href="mailto:a.kostyuk@mobilunity.com">a.kostyuk@mobilunity.com</a>></li>
</ul>
<a name="maintainers"></a>
<h3><a class="toc-backref" href="#id36">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/14.0/mis_builder_budget">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>