Margins by Products (product_margin)

Adds a reporting menu in products that computes sales, purchases, margins and other interesting indicators based on invoices.
=============================================================================================================================

The wizard to launch the report has several options to help you get the data you need.

Code Analysis ⓘ

Views touched (4)

XML ID	Name	Model	Type	Status
`product_margin_form_view`	product.margin.form	product.margin	form	New
`view_product_margin_form`	product.margin.form.inherit	product.product	form	New
`view_product_margin_graph`	product.margin.graph	product.product	graph	New
`view_product_margin_tree`	product.margin.list	product.product	list	New

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (2)

New fields (3)

from_date Date
default=time.strftime('%Y-01-01') args: 'From'
invoice_state Selection
default='open_paid' required=True args: [('paid', 'Paid'), ('open_paid', 'Open and Paid'), ('draft_open_paid', 'Draft, Open and Paid')], 'Invoice State'
to_date Date
default=time.strftime('%Y-12-31') args: 'To'

Public methods (1)

action_open_window(self)

New fields (17)

date_from Date
compute='_compute_product_margin_fields_values' string='Margin Date From'
date_to Date
compute='_compute_product_margin_fields_values' string='Margin Date To'
expected_margin Float
compute='_compute_product_margin_fields_values' help='Expected Sale - Normal Cost' string='Expected Margin'
expected_margin_rate Float
compute='_compute_product_margin_fields_values' help='Expected margin * 100 / Expected Sale' string='Expected Margin (%)'
invoice_state Selection
compute='_compute_product_margin_fields_values' readonly=True selection=[('paid', 'Paid'), ('open_paid', 'Open and Paid'), ('draft_open_paid', 'Draft, Open and Paid')] string='Invoice State'
normal_cost Float
compute='_compute_product_margin_fields_values' help='Sum of Multiplication of Cost price and quantity of Vendor Bills' string='Normal Cost'
purchase_avg_price Float
compute='_compute_product_margin_fields_values' help='Avg. Price in Vendor Bills' string='Avg. Purchase Unit Price'
purchase_gap Float
compute='_compute_product_margin_fields_values' help='Normal Cost - Total Cost' string='Purchase Gap'
purchase_num_invoiced Float
compute='_compute_product_margin_fields_values' help='Sum of Quantity in Vendor Bills' string='# Invoiced in Purchase'
sale_avg_price Float
compute='_compute_product_margin_fields_values' help='Avg. Price in Customer Invoices.' string='Avg. Sale Unit Price'
sale_expected Float
compute='_compute_product_margin_fields_values' help='Sum of Multiplication of Sale Catalog price and quantity of Customer Invoices' string='Expected Sale'
sale_num_invoiced Float
compute='_compute_product_margin_fields_values' help='Sum of Quantity in Customer Invoices' string='# Invoiced in Sale'
sales_gap Float
compute='_compute_product_margin_fields_values' help='Expected Sale - Turn Over' string='Sales Gap'
total_cost Float
compute='_compute_product_margin_fields_values' help='Sum of Multiplication of Invoice price and quantity of Vendor Bills ' string='Total Cost'
total_margin Float
compute='_compute_product_margin_fields_values' help='Turnover - Total cost' string='Total Margin'
total_margin_rate Float
compute='_compute_product_margin_fields_values' help='Total margin * 100 / Turnover' string='Total Margin Rate(%)'
turnover Float
compute='_compute_product_margin_fields_values' help='Sum of Multiplication of Invoice price and quantity of Customer Invoices' string='Turnover'

Public methods (0)

No public methods.

Loading…

Code Analysis ⓘ

Views touched (4)

HTTP endpoints (0)

Models touched (2)

product.margin New model TransientModel 3 fields 1 method ProductMargin · Product Margin

product.product Extends Model 17 fields 0 methods ProductProduct · inherits product.product