Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
23329 Lượt xem

I know I can write code and create a module to add custom fields to Odoo.

I also know that custom fields can be added via the User Interface easily.  Is it possible to create a new field that gets it value automatically (by a calculation) from another set of fields?

Ảnh đại diện
Huỷ bỏ
Tác giả Câu trả lời hay nhất

1.  Enable the option to show Margins on Sales Orders:

       Sales --> Configuration --> Settings  

     


2.  Add the field via the User Interface:

      Settings --> Technical --> Database Structure --> Fields

      Create

      

The code for the Compute section is:

for record in self:
    if record['amount_total'] > 0: 
record['x_margin_percentage'] = record['margin'] / record['amount_total']


3. Add the field to the User Interface, by creating a view that inherits and overrides the Odoo Sales Order Form view that adds the margin field:

      Settings --> Technical --> User Interface --> Views

      Create

      

The XML for the Architecture field is:

<field name="margin" position="after">    
<field name="x_margin_percentage">
</field>


Finished Customization:


Ảnh đại diện
Huỷ bỏ

Note: You may also want to use amount_untaxed instead of amount_total if you don't want tax included in the margin calculation

Câu trả lời hay nhất

Hello Ray,

I saw what you did there and  I was wondering if you can provide info on how can I create a turnover average, which measures the number of each product divided by 365 days. So for every product, I can see how many units are sold per day.

Thanks in advance!

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
0
thg 5 20
6359
4
thg 10 16
4237
1
thg 6 16
11366
1
thg 5 16
5935
2
thg 3 15
8691