The summary methods in INV01 Inventory Ordering line items didn't match

NadiaSafarah

 

 

In '3.3.5.3 Check Your Work' Level 2 Model Building : Sprint 3, I succeeded on comparing the INV01 module that I've made with the first and second example above (on SKU level) without changing the summary method. Then, I change the summary methods (in the picture below).

 

I also succeeded on comparing it to the third example (SKU level Nutzo Bar_EN) but failed on comparing it with the last example (All Products).

 

Here's the gridview of INV01 Inventory Ordering in My Model that didn't match the last example on all products level (The Beginning Inventory and Ending Inventory from Week 3 FY20 and all Safety Stock Exception Count, It's all in the red box).

 

and Here's the blueprint of all the formulas, formats and summary methods of the module.

 

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

Ending Inventory = Beginning Inventory + Confirm Purchase Order Receipt - Forecast Demand

Safety Stock Exception Count = IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0

 

Is there something wrong with the formulas, summary methods or something else I need to check? I need my INV01 module to match the example ASAP. Please, help!

 

 

 

BrunoRodriguez

Hello @NadiaSafarah ,

 

First of all, good job getting everything correct. The entire module and formulas seem to be on point.

 

The current issue you are facing is in "Safety Stock Target". You want to see the summary in "All Products", but you have defined it as "None/Average". If you change this to "SUM", it should be resolved.

 

Hope that helped!