INV02 - Safety Stock Flag Count line item formula - Level2

Options
spoon157085
spoon157085 Member, ALL USERS, Certified Model Builder Posts: 4 New Contributor
in Planning & Modeling

I need some pointers to tell me what went wrong.

 

1) i created SYS08 SKU Details a column Country made in-----PARENT(Supplied By)

2) In INV02 i used the formula---- 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS08 SKU Details'.Country Made In] but i came out the error below.

I have P3 aggregated to P1 in INV01, INV02 has G2 Country which i used SYS08 SKU Details to get the COUNTRY.

spoon157085_0-1609730355811.png

What did i go wrong?

Tagged:

Comments

  • spoon157085
    spoon157085 Member, ALL USERS, Certified Model Builder Posts: 4 New Contributor

    @kevin.cho  Yes i have both G2 and P1 in INVO2. below the screenshot for the error. 

     

    I am wondering if it has got to do with SYS08 source setting?

     

    spoon157085_0-1609880711748.png

     

  • spoon157085
    spoon157085 Member, ALL USERS, Certified Model Builder Posts: 4 New Contributor

    @kevin.cho 

    This is my blue print for INV02. it looks right aren't they?

    spoon157085_0-1609910598114.png

     

     

    I checked SYS08 blue print under Country made in- it is "not applicable" which i thought it makes sense setting as N/A.

     

     

  • spoon157085
    spoon157085 Member, ALL USERS, Certified Model Builder Posts: 4 New Contributor

    got it! thanks!

Categories