3.4.3 Activity: Create Country Summary Module

RaghuMulki
Contributor

3.4.3 Activity: Create Country Summary Module

Hi All,

 

I am stuck in this exercise almost 2 hour, not able to proceed further. Can anyone please help?

 

I have added line item "Country Made in"  SYS08 SKU details module. Now i know that the formula in Safety stock flag count would be 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In] but to this formula work do i need to pull the data into Country Made in Line item in SYS08 module. If yes how? and from which module i can get this? trying it from 3 hour almost but dont see any progress. Appreciate your help.

1 ACCEPTED SOLUTION

Accepted Solutions
Sahitya
Contributor

Hi @RaghuMulki 

 

Your safety stock flag count formula is correct. To that formula to work correctly "country made in" line item needs to be populated which can be done through SYS06 Location details. You can use lookup to populate from SYS06 Location details' line item supplied by.

 

Hope this helps!

 

Cheers,

Sahitya

 

View solution in original post

4 REPLIES 4
Sahitya
Contributor

Hi @RaghuMulki 

 

Your safety stock flag count formula is correct. To that formula to work correctly "country made in" line item needs to be populated which can be done through SYS06 Location details. You can use lookup to populate from SYS06 Location details' line item supplied by.

 

Hope this helps!

 

Cheers,

Sahitya

 

RaghuMulki
Contributor

Thanks for you help. Formula is worked for me.

MAwude2010
New Contributor

Thanks ever so much for the tip. I used the function ---PARENT(Distribution Center)---

This has been a lifeline. Thanks to all who have taken their time to support aspirants like me

 

Michael 

Ankur.Sonthalia
Contributor

Hi @RaghuMulki
You have to populate the Country Made line item. Country is nothing but the parent of Distribution Center. So just use PARENT function to find country in that line item
Parent(distribution center)