SPRINT 3 3.5.3 INV03 Module

jgenand
New Contributor

SPRINT 3 3.5.3 INV03 Module

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

 

 

4 REPLIES 4
jgenand
New Contributor

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

 

jgenand_0-1644337563197.png

 

bhatjaved
Regular Contributor

@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
New Contributor

Thanks a lot for your answer i will try it

 

Best regards

 

Julien

Akumar94an
Occasional Contributor

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?