Ending Inventory

My formula for Ending Inventory = Beginning Inventory - Forecast Demand + Confirmed Purchase Order Receipt

On the SKU level the ending inventory values are matching with the values shown in the activity picture, but when i change it to all products then the values are not matching up.

Please help.

END1_anaplan_138203.jpg

ending_inventory1_138203.PNG

Comments

rob_marshall

@gomathiv1411

What does the blueprint look like, especially the Summary setting?

mburdak

Hi @gomathiv1411

If you are talking about the monthly numbers then, that is due to summary settings of the Opening Inventory and Closing Inventory lineitems. You have the summary as SUM, you should change the time summary to Closing Balance.

Click here:

and change it to:

Other than that your forecasted demand is also 60 higher than expected in the first week, you would have to look into that also.

Regards,

Mandeep

gomathiv1411

I changed the summary setting to closing balance for ending inventory, there is no change in the values.

blueprint_INV01_138233.PNG

gomathiv1411

I checked the DEM03 module from where it is being referenced there the values are correct. It is matching with the values shown in the activity picture.

I changed the summary for ending inventory to closing balance, still there is no change in the values. Kindly help.

DEM03_activity_pic_138234.PNG

my_DEM03_module_138234.PNG

blueprint_INV01_138234.PNG

mburdak

Change the summary for Beginning Inventory also, after that show where the values are not matching.

gomathiv1411

I changed the summary for beginning inventory as well. At the all products level the values are still the same, forecast demand for the first week is more by 60 values.

Blueprint1_INV01_138237.PNG

INV01_All_products_138237.PNG

END1_anaplan_138237.jpg

mburdak

Go to your DEM03 Module, Pivot it as:

Set the time selector to Week 1 FY20

After that apply a filter as :

And then uncheck the 'Override?' boolean for all rows that are visible.

gomathiv1411

I followed the steps and unchecked the override and now the values are matching in the INV01 module.

Thank you very much.

INV01_Values_138241.PNG

mburdak

Glad to help.

Can you click on Accept as Solution for my comment, for the one that helped you solve your issue.

Regards,

Mandeep

gomathiv1411

I have accepted it as solution, thank you very much for the help.

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…