

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!