Sprint 3 - 3.5.3 Activity: Create Distribution Center Summary Module

akssaju

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 Exceptions

Number

Total 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

Misbah

@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

akssaju

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

cvaron

Yes! include the products, thanks

KayO

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

bogirere

 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

INV03 .png

SYS08 .png

SYS08.1.png

bogirere

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

INV03 .png

SYS08 .png

SYS08.1.png