Level 2 Sprint 3 INV02 Country Summary module

bleeds
bleeds
in Academy Discussions

I've created the INV02 Country Summary module and when comparing the "Stock exception Review Dashboard" the numbers do not reconcile.  it seems like the safety stock flag count is not counting at the Product family level or it is individually adding up the "1's" per week as opposed to per month.  I've attached my view as well as the "review" view in the training.

 

The formula I'm currently using in the safety stock flag count is : 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]

 

I've tried adding a second "sum" referencing the Product family line item in the SYS08 SKU module as well, however the results are the same.

 

I would just like to confirm that we should be matching to the pictures provided within the modules & and if so can someone point me in the right direction as to what is causing this issue?

 

Tagged:

Comments

  • filip.sypniewski
    filip.sypniewski

    Hi @bleeds,

    it seems that your formula is correct in INV02 module.

    Therefore you should review:

    - your source module - do you have all numbers aligned with screenshots provided for INV01 module? How are you calculating Safety stock exception count? 

    - SYS08 module, if your Country Made is correct

  • bleeds
    bleeds

    Hey Appreciate the quick response:

     

    My SYS08 Module Country made appears to be correct - 'SYS06 Location Details.Country[LOOKUP: Distribution Center] format is the G2 Country List.

    I also went through and did a reasonableness check - the requisite Cities and countries line up correctly.

     

    And yes my related to the INV01 screen shots/source information all appear to be correct as my product replenishment dashboard looks good.

     

    Safety Stock exception count formula = IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0

  • Kanishq17
    Kanishq17

    hi @bleeds 

     

    Can you show your safety stock exception formula? because formula is correct for both exception count and then INV02, aggregation by country 

     

  • bleeds
    bleeds

    Hello,

     

    I was able to solve my issue...utilizing the "any" function.

     

    Best,

     

    Brian

  • madhurigovankop
    madhurigovankop

    hi @bleeds 

    I am facing the same issue as you in the INV02 Country Summary Module- Safety Stock Flag Count . The safety stock flag count is not counting at the Product family level ,it is individually adding up the "1's" per week as opposed to per month. Please could you explain how exactly did you use the ANY function so to match the Prototype data?

    Thanks in advance for your help.

     

     

  • CarlosT
    CarlosT
    HI bleed I am having the same problem as you, can you please explain how you used the ANY function to match the values because I am getting the values for the Product family list?
    thank you.
  • KhumoS
    KhumoS
    edited August 1

    Hey,

    This is the formula I used for the 'Country Made in' line item in SYS08: SYS06 Location Details'.Country[LOOKUP: Supplied By]
    and then I used this formula in the INV02 saftey stock flag count line item : 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made in, SUM: 'SYS08 SKU Details'.Product Family]

Categories