İçereği Atla
Bu soru işaretlendi
fieldsdatabasecustomize
1 Cevapla
5252 Görünümler
Avatar
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) 

​

Avatar
Vazgeç
Avatar
Niyas Raphy (Walnut Software Solutions)
En İyi Yanıt

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

Avatar
Vazgeç
Arnaud Vandecasteele
Üretici

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 ?

Arnaud Vandecasteele
Üretici

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
Üretici

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 :)

İlgili Gönderiler Cevaplar Görünümler Aktivite
delete fields from database without uninstall? Çözüldü
fields database
Avatar
Avatar
Avatar
Avatar
4
Ara 24
32278
Why in Selection Field Only Key is Store in Database Not the Value ? Çözüldü
fields database selection
Avatar
Avatar
1
Ara 24
2475
Show a field on specific stage (Recruiting app - 16.0 version)
fields customize phases
Avatar
Avatar
Avatar
3
Haz 23
3049
Add custom field on report (Recruiting app - 16.0 version)
fields customize report
Avatar
1
Haz 23
3460
Custom fields in Rental App
fields rental customize
Avatar
Avatar
2
Haz 23
2853