Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Share custom field between sale order to invoice

fields database customize

1 Odpowiedz

5265 Widoki

Arnaud Vandecasteele

Hi,

I've created a custom field (x_my_custom_field_description for ex) in sale_order views that allows the user to add a description of the invoice (settings -> database structure -> fields -> new field).

This works fine but I would like to display the description text (read only) in the invoice view as well. I've tried many things but nothing works. Could you please tell me if there is a way to do this directly from the interface (settings -> database -> ... / not using a custom module with python code)

Niyas Raphy (Walnut Software Solutions)

Hi,

I doubt with what exactly you are asking. If you are looking to add fields to the sale.order and to account.invoice, you have two define two fields in the corresponding models. See this video and see how a new field is added in the sale.order model from the front end as you described: How To Add custom field from UI Without Code

For adding fields to account.invoice , activate developer mode and navigate to Settings -> Technical -> Database Structures-> Models, search the account.invoice model and add the field there and later add the field to corresponding view.

If you are looking to get the value from the sale to invoice in the newly added field, you can try by adding a compute field.

Thanks

Arnaud Vandecasteele

Autor

Hi @Niyas raphy,

Thanks for your help.

I know how to create a field, modify the views, etc.... But what I'm looking for is to create a field in sale.order and add the content of this field into an invoice.

What I'm looking for is :

-> Get the content of a custom field of a sale order

-> Add the content of this cutom field to the invoice related to the sale order

I've tried many things like many2one fields, etc. but nothing was working.

Your solution of a compute field could be the solution. Could you please explain me how to do it ?

Niyas Raphy (Walnut Software Solutions)

See this video and see how to add a compute field: https://www.youtube.com/watch?v=OydOX1VH5ds

Arnaud Vandecasteele

Autor

Hi,

Unfortunately I have odoo 10 community version and the video seems to use another version. So I can't easily replicate the procedure? Would it be possible to explain how to do it ?

Thanks for your help

Arnaud Vandecasteele

Autor

Found an (ugly) way to realize what I'm looking for. i've created two fields x_my_custom_field inside my two models (sale.order and invoice). Then I manually update the field in the invoice table based on the value of sale_order field when both of them have the same origin/name. i could add a trigger to automatically do the update but I don't want to modify to much the database.

If someone have a better way to do this... I'll be more than happy to try it :)

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
delete fields from database without uninstall? Rozwiązane fields database	4 gru 24	32305
Why in Selection Field Only Key is Store in Database Not the Value ? Rozwiązane fields database selection	1 gru 24	2483
Show a field on specific stage (Recruiting app - 16.0 version) fields customize phases	3 cze 23	3068
Add custom field on report (Recruiting app - 16.0 version) fields customize report	1 cze 23	3468
Custom fields in Rental App fields rental customize	2 cze 23	2864

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!