You can use the following special operators to record a macro:

The operator L0 Stock balance calculates stock levels. As the basis for this calculation, you specify goods receipts, goods issues, and (if required) an opening stock level.

For every period (i):

stock level (i) = receipts (i) + stock level (i - 1) - issues (i)

where stock level (i - 1) is the closing stock from the previous period

The operator L1 Target stock/receipts calculates goods receipts and stock levels. You specify target stock levels, goods issues, and (if required) an opening stock level as the basis for this calculation.

For every period (i):

receipts (i) = target stock (i) + issues (i) - stock (i - 1)

if receipts (i) < 0, then receipts (i) = 0

stock (i) = receipts (i) + stock (i - 1) - issues (i)

The operator L2 Receipts calculates goods receipts. You specify goods issues, stock levels, and (if required) an opening stock level as the basis for this calculation.

For every period (i):

receipts (i) = stock (i) + issues (i) - stock (i - 1)

The operator L3 Issues calculates goods issues. You specify goods receipts, stock levels, and (if required) an opening stock level as the basis for this calculation.

For every period (i):

issues (i) = receipts (i) + stock (i - 1) - stock (i)

The operator L4 Target stock/issues calculates goods issues and stock levels. You specify target stock levels, goods receipts, and (if required) an opening stock level as the basis for this calculation.

For every period (i):

issues (i) = receipts (i) + stock (i - 1) - target stock (i)

if issues (i) < 0, then issues (i) = 0

stock (i) = receipts (i) + stock (i - 1) - issues (i)

The operator PR Target supply/production calculates goods receipts. As the basis for this calculation, you specify goods issues, target days’ supply, and (if required) an opening stock level. In the macro, you record which lines represent goods issues and goods receipts; typically, you define the sales line as goods issues and the production line as goods receipts. The system works out for each period the quantity that will need to be received (that is, produced) in order to cover both sales and target days’ supply in the current period, where one day’s supply is the quantity sold in the next period divided by the number of workdays in that period.

This is what happens when target days’ supply exceeds the number of workdays in the month.

The operator RW Days’ supply calculates days’ supply. As the basis for this calculation, you specify stock levels and goods issues. Typically, you define the sales line as goods issues. The system works out the days’ supply in a period according to the closing stock level and goods issues (that is, sales) in that period.

The operator ZS Historical total calculates the sum of all the historical values of a chosen key figure, and displays the result in the first future period of either the same or a different key figure. You use this operator to calculate a backlog such as open orders.