Ending Inventory

[gomathiv1411]

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.

[rob_marshall]

@gomathiv1411

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

[gomathiv1411]

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

[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 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.

[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.

[mburdak · Accepted solution]

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.

[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