跳至内容
菜单
此问题已终结
2 回复
23131 查看

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
6207
4
10月 16
4074
1
6月 16
11225
1
5月 16
5775
2
3月 15
8553