SPRINT 3 3.5.3 INV03 Module

jgenand
jgenand
in Academy Discussions

Dear Community 

 

I m a bit stucked with the INV03 formula for the Stock Exception 

 

My Formula : 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Distribution Center, SUM: 'SYS08 SKU Details'.Product]

 

jgenand_0-1644337253353.png

but i cannot see any amount popping up here and i have some amount in INV 01 Module

 

jgenand_1-1644337347388.png

Do you know where my issue could come from ?

 

Br

 

Julien

 

 

Tagged:

Comments

  • jgenand
    jgenand

    please also note that i put Sum in the summary of my line item

     

    jgenand_0-1644337563197.png

     

  • bhatjaved
    bhatjaved

    @jgenand You need to SUM with respect to product and supplied by and I could see you are summing with respect to distribution centre and product . reference supplied by instead of distribution , should give you correct result 

  • jgenand
    jgenand

    Thanks a lot for your answer i will try it

     

    Best regards

     

    Julien

  • Akumar94an
    Akumar94an

    Hi, I have created my formula for INV03 - stock exceptions line items as follows:

    'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Supplied By, SUM: 'SYS08 SKU Details'.Product]

    However I'm still unable to get the correct answer for Question 7 of 10 in L2 sprint 3 exam. Can you please help me understand where I'm going wrong?

Categories