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