odoo-addon-budget-control 18.0.1.4.3

Budget Control

This module is the main module from a set of budget control modules. This module alone will allow you to work in full cycle of budget control process. Other modules, each one are the small enhancement of this module, to fullfill additional needs. Having said that, following will describe the full cycle of budget control already provided by this module,

Budget Control Core Features:

• Budget Commitment (base.budget.move)

  Probably the most crucial part of budget_control.

  • Budget Balance = Budget Allocated - (Budget Actuals - Budget Commitments)

  Actual amount are from account.move.line from posted invoice. Commitments can be sales/purchase, expense, purchase request, etc. Document required to be budget commitment can extend base.budget.move. For example, the module budget_control_expense will create budget commitment expense.budget.move for approved expense. Note that, in this budget_control module, there is no extension for budget commitment yet.

• Budget Template (budget.template)

  A Budget Template in the budget control system serves as a framework for controlling the budget, allowing for the budget to be managed according to the pre-defined template. The budget template has a relationship with the accounting, and is used to control spending based on pre-configured accounts.

• Budget Period (budget.period)

  Budget Period is the first thing to do for new budget year, and is used to govern how budget will be controlled over the defined date range, i.e.,

  • Duration of budget year

  • Template to control (budget.template)

  • Document to do budget checking

  • Analytic account in controlled

  • Control Level

  Although not mandatory, an organization will most likely use fiscal year as budget period. In such case, there will be 1 budget period per fiscal year, and multiple budget control sheet (one per analytic).

• Budget Control Sheet (budget.control)

  Each analytic account can have one budget control sheet per budget period. The budget control is used to allocate budget amount in a simpler way. In the backend it simply create budget.control.line, nothing too fancy. Once we have budget allocations, the system is ready to perform budget check.

• Budget Checking

  By calling function – check_budget(), system will check whether the confirmation of such document can result in negative budget balance. If so, it throw error message. In this module, budget check occur during posting of invoice and journal entry. To check budget also on more documents, do install budget_control_xxx relevant to that document.

• Budget Constraint

  To make the function – check_budget() more flexible, additional rules or limitations can be added to the budget checking process. The system will perform the regular budget check and will also check the additional conditions specified in the added rules. An example of using budget constraints can be seen from the budget_allocation module.

• Budget Reports

  Currently there are 2 types of report.

  1. Budget Monitoring: combine all budget related transactions, and show them in Standard Odoo BI view.

  2. Actual Budget Moves: combine all actual commit transactions, and show them in Standard Odoo BI view.

• Budget Commitment Move Forward

  In case budget commitment is being used. Sometime user has committed budget withing this year but not ready to use it and want to move the commitment amount to next year budget. Budget Commitment Forward can be use to change the budget move’s date to the designated year.

• Budget Transfer

  This module allow transferring allocated budget from one budget control sheet to other

Extended Modules:

Following are brief explanation of what the extended module will do.

Budget Move extension

These modules extend base.budget.move for other document budget commitment.

• budget_control_expense

• budget_control_purchase

• budget_control_purchase_request

• budget_control_sale

Budget Allocation

This module is the main module for manage allocation (source of fund, analytic tag and analytic account) until set budget control. and allow create Master Data source of fund, analytic tag dimension. Users can view source of fund monitoring report

• budget_allocation

Tier Validation

Extend base_tier_validation for budget control sheet

• budget_control_tier_validation

Analytic Tag Dimension Enhancements

When 1 dimension (analytic account) is not enough, we can use dimension to create persistent dimension columns

• analytic_tag_dimension

• analytic_tag_dimension_enhanced

Following modules ensure that, analytic_tag_dimension will work with all new budget control objects. These are important for reporting purposes.

• budget_allocation

• budget_allocation_expense

• budget_allocation_purchase

Important

This is an alpha version, the data model and design can change at any time without warning. Only for development or testing purpose, do not use in production. More details on development status

Table of contents

• Usage

• Bug Tracker

• Credits

Usage

Before start using this module, following access right must be set.

• Budget User for Budget Control Sheet, Budget Report

• Budget Manager for Budget Period

Followings are sample steps to start with,

1. Create new Budget KPI

   To create budget KPI using in budget template

2. Create new Budget Template

   • Add new template for controlling Budget following kpi-account

3. Create new Budget Period

   • Choose Budget template

   • Identify date range, i.e., 1 fiscal year

   • Plan Date Range, i.e., Quarter, the slot to fill allocation in budget control will split by quarter

   • Control Budget = True (if not check = not check budget for this period)

4. Create Budget Control Sheet

   To create budget control sheet, you can either create manually one by one or by using the helper, Action > Create Budget Control Sheet

   • Choose Analytic budget_control_purchase_tag_dimension

   • Check All Analytic Account, this will list all analytic account in selected groups

   • Uncheck Initial Budget By Commitment, this is used only on following year to init budget allocation if they were committed amount carried over.

   • Click “Create Budget Control Sheet”, and then view the newly created control sheets.

5. Allocate amount in Budget Control Sheets

   Each analytic account will have its own sheet. Form Budget Period, click on the icon “Budget Control Sheets” or by Menu > Budgeting > Budget Control Sheet, to open them.

   • Based on “Plan Date Range” period, Plan table will show all KPI split by Plan Date Range

   • Allocate budget amount as appropriate.

   • Click Control button, state will change to Controlled.

   Note: Make sure the Plan Date Rang period already has date ranges that covers entire budget period. Once ready, you can click on “Reset Plan” anytime.

6. Budget Reports

   After some document transaction (i.e., invoice for actuals), you can view report anytime.

   • On Budget Control sheet, click on Monitoring for see this budget report

   • Menu Budgeting > Budget Monitoring, to show budget report in standard Odoo BI view.

7. Budget Checking

   As we have checked Control Budget = True in third step, checking will occur every time an invoice is validated. You can test by validate invoice with big amount to exceed.

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.

Do not contact contributors directly about support or help with technical issues.

Credits

Authors

• Ecosoft

Contributors

• Kitti Upariphutthiphong <[e-mail]>

• Saran Lim. <[e-mail]>

Maintainers

Current maintainers:

This module is part of the ecosoft-odoo/budgeting project on GitHub.

You are welcome to contribute.