Technical Blog Post
Abstract
Annual YTD Rollover for Inventory Escalation
Body
It is possible to run escalation to rollover annual YTD for Inventory items.
In the example below, all the items have the same quantity to make it easy to see the result.
ISSUEYTD = 84
ISSUE1YRAGO = 66
ISSUE2YRAGO = 120
ISSUE3YRAGO = 100
Create an escalation to change the quantities
Create some actions, and these actions must be in the order created below:
Seq 10: INVMOVE2YRTO3YR: MOVE THE 2-YEAR TOTAL TO THE 3-YEAR SPOT
Seq 20: MOVE1YRTO2YR: MOVE THE 1-YEAR TOTAL TO THE 2-YEAR SPOT
Seq 30: MOVEYTDTO1YTD: MOVE THE CURRENT-YEAR TO THE 1-YEAR SPOT
Seq 40: INVZEROYTD: ZERO OUT THE CURRENT-YEAR TOTAL
Seq 10:
Seq 20:
Seq 30:
Seq 40:
After the escalation has been run, the quantities are changed accordingly:
ISSUEYTD = 0
ISSUE1YRAGO = 84
ISSUE2YRAGO = 66
ISSUE3YRAGO = 120
UID
ibm11131501