I am getting negative values in Beginning Inventory and Ending Inventory. Can anyone help

Ankit7

Accepted answers

All comments

BrunoRodriguez

Hello @Ankit7 ,

Without checking it in too much detail, it seems like "Beginning Inventory" may be incorrect. Is your formula similar to this one?

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

Cheers!

laurendusse

Hi Bruno, my formula is correct for beginning inventory and my dat01 information is correct but I am still getting the negative values

lindascott

It doesn't look to me like this is wrong, at least conceptually. In the screenshot of your model, you are not showing any additions to inventory over time (e.g. Confirmed Purchase Order Receipt), but you are continuing to "satisfy" the forecasted demand, so your inventory keeps getting lower and lower. This is the same thing that would happen if you started with a much larger beginning inventory; you just wouldn't see it show up as negative in the 2nd week.

In the screenshot from @laurendusse, you can see that adding inventory in week 7 makes the total less negative. You're on the right track.

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
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.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…