sprint 3 Country summary Module

BapinB
BapinB
in Academy Discussions

Hi Members , 

 

Tried creating the below mentioned requirement with the formula written below , but not getting it correct .

 

 

Line Item Format Purpose
Safety Stock Flag CountNumberIdentify number of Stock Exceptions by Country and Product Family
 
 
 
IF 'INV01 Inventory Ordering'.Safety Stock Exception Count =1 THEN [SUM: 'SYS08 SKU Details'.Product Family,SUM: 'SYS06 Location Details'.Country] ELSE 0
 
Can you help ?
 
Thanks 
 

Comments

  • jagadishdash
    jagadishdash

    @BapinB 

    No,

     

    the formula for Safety Stock Flag Count will be

    'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]

     

    Thanks,

     

    Jagadish Dash

  • BapinB
    BapinB

    But Country madein is not there in SYS08 SKY Detail ??

  • ChiVTK1
    ChiVTK1
    edited June 2023

    @BapinB

    I think we must to add Country made into the SYS08 SKY Detail model like the capture.

    image.png

Categories