Sprint 3 - 3.5.3 Activity: Create Distribution Center Summary Module

akssaju
Contributor

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

2 REPLIES 2
Misbah
Moderator

Re: Sprint 3 - 3.5.3 Activity: Create Distribution Center Summary Module

@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
Contributor

Re: Sprint 3 - 3.5.3 Activity: Create Distribution Center Summary Module

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