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 item Formula
Initial Value (Input Value)
Opening Inventory PREVIOUS(Closing Inventory) + Initial Value
Input (Input Value)
Output (Input Value)
Closing Inventory Opening Inventory + Input – Output