3.3.5.1 Create Inventory Ordering Module Beginning inventory

My beginning inventory is in Negative. Why is this happening? Is there anything wrong with Beginning inventory or ending inventory formula? I have attached screenshots.

Screenshot_(67)_100351.png

Screenshot_(66)_100351.png

Accepted answers

JaredDolich

@saranshsaini

@MarkWarren is correct but there's a little more to the story.

This is called an inventory balance set. Ending Inventory = Beginning Inventory + Receipts - Sales. If you have Sales set, but no Receipts then your inventory will keep going down, even negative. This obviously can't happen in the real world because sales would stop if you run out of inventory (stock outs). Once you start loading your receipts this will fix itself.

In short, your formula is correct but this model is "simplified" for learning purposes.

All comments

MarkWarren

This looks correct, the formulas look right.
The negative Beginning Inventory happens because of the Forecast Demand.
You have some overrides set?

JaredDolich

@saranshsaini

@MarkWarren is correct but there's a little more to the story.

In short, your formula is correct but this model is "simplified" for learning purposes.

saranshsaini

Yes! During sprint 3 exam i have imported data in"Submit Purchase Order Receipt" and now all values look good!

Quick Links

Can you help?

Unanswered questions

Daily Date Format
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
1.5.2 activity: import data into beginning inventory
Kindly assist me to load data into the model.
Support error
Hello , Facing an error in looging in support portal , can anyone assist