Production overview

Here is an example of a production overview dashboard that is created with the Template Editor.

Template editor

How is it created

The creation of the production order overview was a two-step process: there was a need to create both a custom template and a data extract.

1) Custom template

Basic settings

This example label is set up for partners and the HTML is chosen as Output type.

Production document: Basic settings

HTML document

This document template gets data from the extract Pending production orders. See row 36 in order to see how it is done.

Production overview: data from extract

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71

<html>
<head>
<title>Production orders in tracezilla</title>

<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-rbsA2VBKQhggwzxH7pPCaAqO46MgnOM80zW1RWuH61DGLwZJEdK2Kadq2F9CUG65" crossorigin="anonymous">


</head>
<body>
    <div class="container">
<!-- Headline start -->
    <div class="row">
    <div class="col">
<h1 class="text-center my-4">Pending production orders</h1>
    </div>
    </div>
<!-- Headline end -->

<!-- Table section start -->
    <div class="row">
    <div class="col">

<!-- Ordered products start -->
<table class="w-100 table">
<thead>
    <tr>
        <th>Order no.</th>
        <th>Production date</th>
        <th>To be produced</th>
        <th>Quantity</th>
        <th>Comments</th>
        <th>Status</th>
        <th>Actions</th>
    </tr>
</thead>

<tbody>
    {% for order in extracts.po_produces %}
    <tr>
        <td class="text-center">{{ order.order_number }}</td>
        <td class="text-center">{{ order.order_availability_date | date_format_document }}</td>
        <td class="text-left">{{ order.sku_sku_code }}: {{ order.sku_global_name }}</td>
        <td class="text-left">
    {% if convertibleUnits %}
  	 {{ order.quantity | times: order.uom_conversion | number_format: 3, ',', '.' }} {{ order.sku_unit_of_measure }}
    {% else %}
  	{{ order.quantity | number_format: 0, ',', '.' }} {{ order.lot_unit }}
    {% endif %}
        </td>

        <td class="text-left">
    {% if order.order_missing_lot_count > 0 %}
  <h6 style="color: red;">Missing selection of lots.</h6>
    {% endif %}</td>
<td class="text-center">{{ order.order_status | translate_order_status }}</td>
<td><a href="https://app.tracezilla.com/28-11-2019/production/orders/{{ order.order_id }}" 
       class="btn btn-primary">Go to order</a></td>
    </tr>
    {% endfor %}
</tbody>
</table>
        </div>
    </div>

<!-- Table section end -->

</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-kenU1KFdBIe4zVF0s0G1M5b4hcpxyD9F7jL+jjXkk+Q2h455rYXK/7HAuoJl+0I4" crossorigin="anonymous"></script>
</body>
</html>

2) Data extract

Data extracts can be created under Power Pack > Data Extracts.

Template editor

Basic settings

The cube Inventory Movements is used in order to fetch data from production orders.

The document template Order list HTML production is chosen in Extract available for document template. This setting links the extract with the document template and makes it possible to use fields from the extract in the template.

Update Extract