Check if shelf life is exceeded. This macro will show a list of operations consuming a material which is too old. Pegging must be done first in order to check for shelf life (shelflife). Suborder links are also supported.

Example parameter configuration


  1. Pegging must have been performed in order to check shelf life. See Pegging. Alternatively suborder links can be used.
  2. Shelf life (shelflife) value in hours must be specified on the materials in order for the check to work correctly. This value can be overridden on the BOM lines on each operation. If the field is not visible – add it to the table by the field chooser.


  1. It is possible per material to set how the shelf life should be calculated (Shelf life settings). If “From first contribution” is selected the shelf life is calculated from operation start. If “From last contribution” is selected it is calculated from operation end.
  2. Shelflife broken can be illustrated in two ways:
    1. Choose the color scheme “Shelf life” which will highlight producing and consuming operations where the shelf life is exceeded on the materials used. Producing operations will get yellow and consuming operations will get red
    2. Run the above macro to list all orders that consume a material which is too old.

Parameter descriptions

(* = configuration required)

A comma separated list of operation status values. An operation with one of these statuses will not be checked.

Default 40, 50, 60, 70
Possible operation status values:

10 = Incomplete
15 = Reserved
20 = Planned
30 = Start possible
40 = Started
50 = Paused
60 = Cancelled
70 = Completed

The parameters “horizonBackwardFromNow” and “horizonForwardFromNow” decides the period where the operations are checked

Default 0

The parameters “horizonBackwardFromNow” and “horizonForwardFromNow” decides the period where the operations are checked

Default 90

Only relevant if “onlyCheckSelectedOperations” is true.
If true all operations in the route will be checked – even though only one of them is selected.

Default false

If true only the selected operations will be checked.

Default false


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment