Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
accountingfinanceformulacalculations
2 Vastaukset
4904 Näkymät
Avatar
Bruno Gianezi Gomes

We are struggling to better handle the following issue:

1. Our client constantly update / change the requirements for formulas used to calculate values inside Odoo.
For instance: insurance was calculate as (price of the product * 10%), now it is calculated as (price of the product * 10% + Tax). Of course this is a very basic example, but the issue in general it's this: updating the formulas accordingly to the business requirements.

2. For every time the client changes the formulas, we have to manually update the code through a developer.3. We were wondering if any plug-in or add on could help us to better manage this issue. How? Updating the formulas direct in backend, without any development. This would bring much more flexibility and agility to the process.

3. Currently we use Oddo v8

We are looking forward for ideas.
Kind Regards
Bruno Gomes

Avatar
Hylkää
Avatar
Bruno Gianezi Gomes
Tekijä Paras vastaus

Thanks for your collaboration Khashayar.

The idea in general could be user from the payroll salary rules model of odoo, however the formulas are kind of complex with a lot of "if" conditions and "vlookup". I would rather use the excel template for that. It would give me more flexibility to perform the formulas in a easy way.

After some research, we found a library which interpreter the excel formulas:
http://ewbi.blogs.com/develops/popular/excelformulaparsing.html

I post an update as soon as we have more results. :)

Avatar
Hylkää
Avatar
Khashayar Dadashzadeh
Paras vastaus

I think if this is recurring for you, it would be better to write a seprate module in which you can define the formula of isurance calculation for each of your customers outside code.

I would think of a parametric formula module in which you can just write the fields you want to do the calculation.

Something like the payroll salary rules model.

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Error on Brazilian NFC-e issuance (Odoo online v18)
accounting finance
Avatar
0
lokak. 25
1318
How to fix The move is not balanced error. Ratkaistu
accounting finance
Avatar
Avatar
2
heinäk. 25
2100
Analytic Budget vs Financial Budget
accounting finance
Avatar
Avatar
1
kesäk. 25
1787
How to Skip "In Progress" and Set Payment Directly to "Paid" in Odoo 18? Ratkaistu
accounting finance
Avatar
Avatar
Avatar
3
kesäk. 25
5082
Formula Usage Within Report Definitions?
accounting formula
Avatar
0
toukok. 25
969