You Asked, We Answered: Opening and Closing Inventory
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 |