You Asked, We Answered: Opening and Closing Inventory

Jill King

President and CEO

In our series “You Asked, We Answered” we address questions that pop up often on our Community page.

Question:
What is the best way to open and/or close inventory within Anaplan?

Answer:

It’s easy! Just reference the table below and you are good to go:

 

Line itemFormula
Initial Value(Input Value)
Opening InventoryPREVIOUS(Closing Inventory) + Initial Value
Input(Input Value)
Output(Input Value)
Closing InventoryOpening Inventory + Input – Output