AdjustOrderQuantityToInventory

Adjust operation or order quantity based on the stock level for the material consumed by the selected operation.
If there’s a positive stock level after the operation end time and a specified horizon ahead. Adjust the qty up so all material is consumed and thus the graph goes to zero (or to safety stock level). In the horizon the minimum stock level is found in order to check that the material isn’t already consumed just after by another operation (or counting or shipment).
If the selected operation consumes too much the quantity is adjusted down.

Please notice:
This is only relevant for accesses with strategy = Per piece

Example parameter configuration

Example of use:

Before

The selected operation, which consumes raw material, leaves an amount on 83 tons of remaining stock. The initial order quantity is 260.

After

The macro has increased the order quantity to 302.5 and thus the operation consumes the remaning material also.

Parameter descriptions

(* = configuration required)

adjustQuantityDown
If the selected operation consumes too much and thus the stock level becomes negative (or below safety stock) the macro can adjust the quantity down so the stock level will end on zero, or on the minimum safety stock level.
See also parameter ThresholdInBaseUnitNegative

Default true

adjustQuantityUp
If the selected operation consumes “too little” and thus some remaining material is left, the macro can adjust the quantity up so the remaining part is also consumed.
See also parameters thresholdInBaseUnitPositive and horizonAhead

Default true

checkThresholdInHorizon
true (default) – The stock level must be below the specified threshold in the horizon specified in horizonAhead to be adjusted.
false – The stock level must be below the specified threshold on operation end to be adjusted.

horizonAhead
The horizon ahead from the end of the selected operation where the inventory of the consumed material should be examined.
See also parameter precisionInMinutes

Example:

At the end of the selected operation the inventory is 86 tons. The green rectangle represents the default horizon on 2 days. Within the horizon most of the material is already consumed by another operation (order P2018) and thus the inventory would become negative if the selected operation was adjusted up to consume the remaining material on 86 tons.

Instead the macro detects that the inventory drops to 8 tons within the horizon and thus the quantity is adjusted up to consume 8 tons more. In this case the quantity is adjusted up from 430 to 432.7. The reason why the quantity is only increased by 2.7 is that the rate of this material consumption is set to 3.

As a result the next operation (order P2018) consumes the remaining material.

Only relevant if parameter adjustQuantityUp is true

Usage

Example: 2 days + 12 hours + 30 minutes

y/year(s), m/mon/month(s), w/week(s), d/day(s), h/hour(s), min/minute(s) and s/sec/second(s).

Please notice that ‘m’ corresponds to month and NOT minute.

Default 2 days

matTypeOnConsumingToFocusOn
If an operation consumes multiple materials use this to filter out irrelevant materials.
Example:

If an operation consumes both a raw material and a semifinished material, and we only want to focus on the raw material, specify 0

Possible material types:

Raw material = 0

Resource/tool = 1

Semi finished product = 2

Finished product = 3

Recipe = 4

Please notice:

Only one material per operation will be examined. Thus if multiple consuming materials exist on an operation with same material type only the first one will get examined.

To ignore specify -1

Default -1

precisionInMinutes
When the inventory is examined in a certain horizon it’s done by calculating the inventory for each 5 minutes (default precision).
The higher value the lower precision and thus less time consumed by the macro. On long horizons it might get necesarry to lower the precision.

Only relevant if parameter adjustQuantityUp is true

Default 5

promptBeforeAdjustment
The calculated adjustment will be listed along with the option to accept or reject it.
Default false

setQuantityonOpr
Specify true if the new quantity should be set on the selected operation instead of on the order.
Default false

thresholdInBaseUnitNegative
In case of a negative inventory (or below safety stock level) the quantity will only get adjusted down if the inventory is below this threshold parameter. Use this to ignore small negative values.
The unit follows the standard unit set on the material.

Default 0

thresholdInBaseUnitPositive ^*
The quantity will only get adjusted up if the inventory is below this threshold parameter.

The unit follows the standard unit set on the material.

Default 100

useSafetyStock
If true the minimum level set for the material is respected. This is setup via “Edit->Materials” on tab “Min/max stock level”.
Default true