Cost Readiness Cockpit

{{ title }}

Abrir Data Quality Contract

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.

Órdenes totales
{{ summary.total_orders or 0 }}
Con ingreso
{{ summary.orders_with_revenue or 0 }}
Sin ingreso
{{ summary.orders_without_revenue or 0 }}
Sin coste material
{{ summary.orders_missing_raw_material_cost or 0 }}
Listas para margen
{{ summary.orders_ready_for_margin or 0 }}
Score medio
{{ summary.avg_cost_readiness_score|num(2) if summary.avg_cost_readiness_score is not none else "0.00" }}

1. Estado por orden

{% for order in orders %} {% else %} {% endfor %}
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.

2. Materias primas pendientes de coste

{% for raw in raw_materials %} {% else %} {% endfor %}
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.