Sprint 3 - 3.5.3 Activity: Create Distribution Center Summary Module

Hi,

 

Can somebody please tell the formula for this line item in this activity?

 

In the Supply Chain model, create a new module: 

  • Module Name: INV03 Distribution Center Summary
  • Dimensions: P2 Products list, s G3 Location: Distribution Centers? list, Time (month)
  • Category: Inventory 
  • Functional Area: Inventory 
  • Summary Method: None 
 
Line Item Format Purpose
Stock ExceptionsNumberTotal number of Stock Exceptions by Distribution Center and Product per month
 

Build the formula for the line item to show the total number of Safety Stock Exceptions by Distribution Center and Product on a monthly time scale. 

 

Thank You very much

Tagged:

Answers

  • @akssaju 

     

    You will have to use SUM function on both of these dimensions and pull the stock exception count from INV01 module

     

    SUM: Product, SUM: DC

     

    Misbah

  • Hi,

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

     

    Can you please check whether the formula is correct and I'm attaching the screenshot of result as well

  • Yes! include the products, thanks

  • KayO
    edited February 2023

    Hi,

    In which activity did you add the Supplied by to SYS08 since there is no such thing in my module?

    Did I miss some part of activities?

    Anyone could help me out with this, thank you

  •  Activity: Create Distribution Center Summary Module

    Hi Guys,

    I don't know what's wrong in the in sys08 and inv03 I am not able to see the date in INV03 PFA below

    Jreddy

  • @Misbah Please help me to complete this activity I Didn't understand what is wrong in this activity

    Jreddy