{{ title }}
Esta pantalla muestra qué órdenes están preparadas para cálculo de margen y qué datos lo bloquean. No calcula margen real si falta coste de materia prima.
| Orden | Pedido venta | Cliente | Producto | Máquina | Ingreso neto | Kg materia prima | Score | Estado | Bloqueo / acción | Informe |
|---|---|---|---|---|---|---|---|---|---|---|
| {{ order.odoo_order_ref }} | {{ order.sale_order_ref or "" }} | {{ order.customer_name or "" }} |
{{ order.product_default_code or "" }} {{ order.product_name or "" }} |
{{ order.machine_id }} | {{ order.revenue_net_eur|num(2) if order.revenue_net_eur is not none else "" }} € | {{ order.raw_total_consumed_qty|num(3) if order.raw_total_consumed_qty is not none else "" }} | {% if order.cost_readiness_score >= 80 %} {{ order.cost_readiness_score }} {% elif order.cost_readiness_score >= 50 %} {{ order.cost_readiness_score }} {% else %} {{ order.cost_readiness_score }} {% endif %} | {% if order.cost_readiness_status == 'LISTO_PARA_MARGEN' %} Listo para margen {% elif order.cost_readiness_status == 'BLOQUEADO_FALTA_COSTE_MATERIA_PRIMA' %} Falta coste materia prima {% elif order.cost_readiness_status == 'BLOQUEADO_SIN_INGRESO' %} Sin ingreso {% elif order.cost_readiness_status == 'BLOQUEADO_DATOS_TECNICOS' %} Datos técnicos débiles {% else %} {{ order.cost_readiness_status }} {% endif %} | {{ order.cost_readiness_description }} | HTML | PDF |
| No hay órdenes disponibles. | ||||||||||
| Código | Materia prima | UdM | Órdenes afectadas | Pedidos venta | Clientes | Cantidad consumida | Coste €/kg actual | Estado | Acción recomendada |
|---|---|---|---|---|---|---|---|---|---|
| {{ raw.raw_product_default_code or "" }} | {{ raw.raw_product_name or "" }} | {{ raw.raw_uom or "" }} |
{{ raw.affected_order_count }} {{ raw.affected_orders }} |
{{ raw.affected_sale_orders }} | {{ raw.affected_customers }} | {{ raw.total_consumed_qty|num(3) }} | {{ raw.current_material_cost_eur_per_kg|num(4) if raw.current_material_cost_eur_per_kg is not none else "" }} | {% if raw.raw_material_readiness_status == 'COSTE_DISPONIBLE' %} Coste disponible {% else %} Pendiente coste {% endif %} | {{ raw.recommended_action }} |
| No hay materias primas detectadas. | |||||||||