You Asked, We Answered: Opening and Closing Inventory

By Jill King

December 11, 2013

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