Display a field from the production order header when displaying the production order routing line

Display a field from the production order header when displaying the production order routing line

You are here:

Issue

For production users who are displaying production order routing lines (the process), there is one cell (rectangle/block) for each step for each production order displayed.

The Graphical Scheduler product has configurable options to display any field on the production order routing line when showing production order routing line data and can display it in the cell (the block/square/rectangle that gets rendered) or in the tooltip (appears when hovering the mouse over it).

Solution

The following solution has 2 steps:

  1. Add a FlowField onto the production order routing line.
  2. Use that FlowField in the cell template and/or tooltip template.

Example extension

Here is an example extension that has a table extension demonstrating doing this with two fields, the Firm Planned Production Order No. on the production header, and the Source No. that’s on the production order header.

FlowField code

The code to add a FlowField is simple, and not specific to graphical scheduler:

tableextension 50240 ExampleProductionHeaderFields extends “Prod. Order Routing Line”

{

    fields

    {

        field(50240; Example Firm Planned Order No.; Code[20])

        {

            Caption = ‘Example Firm Planned Order No.’;

            FieldClass = FlowField;

            CalcFormula = lookup(Production Order.Firm Planned Order No.

            where(Status = field(Status), No. = field(Prod. Order No.)));

        }

        field(50241; Example Source No.; Code[20])

        {

            Caption = ‘Example Source No.’;

            FieldClass = FlowField;

            CalcFormula = lookup(Production Order.Source No.

            where(Status = field(Status), No. = field(Prod. Order No.)));

        }

    }

}

Video

The How to display fields from the production order header on the production order routing lines video demonstrates how to display fields from the production order header on the production order routing lines using the sample code.

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Need help?

Leave A Comment

Go to Top