Opening and Closing Inventory

Hi, A quite usual topic easy to solve with Anaplan is the Opening / closing inventory formula. Here is my proposal. Feel free to share yours.

Line item	Formula
Initial Value
Opening Inventory	PREVIOUS(Closing Inventory) + Initial Value
Input
Output
Closing Inventory	Opening Inventory + Input - Output
Alternative solution
Opening Inventory with POST	POST(Closing Inventory, 1) + Initial Value.

Kind regards. Michel.

Accepted answers

Great set-up Michel. Very simple and very clean. This is how I would set it up as well.

Great set-up Michel. Very simple and very clean. This is how I would set it up as well.

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
ADO - S3 incremental load vs. full replace
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create a…