跳至內容
選單
此問題已被標幟
2 回覆
23338 瀏覽次數

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?

頭像
捨棄
作者 最佳答案

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:


頭像
捨棄

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

最佳答案

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!

頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
0
5月 20
6359
4
10月 16
4241
1
6月 16
11367
1
5月 16
5941
2
3月 15
8695