Skip to Content
Menu
This question has been flagged

Hi, community, i want to add a column to the aged payable report on the accounting module, i made a demo DB with v17 and the column "invoice date" is there, but in my odoo that is v16 is not, i tried to add the same way using the same field and formula but i got an error.

Is this a feature that is not in previous versions of odoo?

here are some screenshots:

this is the configuration of the accounting report in Odoo 17, and the field/column i want to add:

This is the report page, as you can see the column is succesfully added:


Now this is the same configuration for the other DB with v16e:

But when i saved and try to access the report i got this error:


Avatar
Discard

Hi,
You can refer to this question, may it help to add the column in the accounting reports

https://www.odoo.com/it_IT/forum/assistenza-1/add-column-to-general-ledger-odoo16-228578

Hope it helps

Best Answer

Hi Guys, I do not see it is possible without Python code. The function  def _report_custom_engine_aged_payable calls the function def _aged_partner_report_custom_engine_common and this function built the select. However, the selection is hard coded. Then the result of the selection is converted into a dictionary and the key of the dictionary is the subformula.


Avatar
Discard
Best Answer

Hola, llevo mucho tiempo intentando hacer lo mismo, pudiste hacerlo?

Avatar
Discard
Best Answer

hola david, yo también quisiera agregar más columnas con más fechas de vencimiento. Pudiste encontrar como se agrega?

Avatar
Discard
Best Answer

Hi David:

A lot of the Accounting Reports cannot be modified through the Accounting Reports configuration since they use something known as a "custom handler" which is essentially a bunch of python and javascript code that is specific to that report. The Aged Payable report is one of them. Since the field appears in the v17 version, you may want to check with Odoo support whether there is a plan to backport it to v16 in the near future.

Avatar
Discard
Related Posts Replies Views Activity
0
Nov 23
1934
0
Nov 23
1464
1
Jul 23
3454
0
May 23
1778
4
Jun 25
8558