Level 2 Sprint 3

Highlighted
Contributor

Level 2 Sprint 3

for Inv03 distribution center summary, line item 'stock exceptions' to show total number by Distribution center

 

I use this formula:

Inv01 inventory ordering.safety stock exceptions count[Sum: 'sys08 Sku details'.'Distribution center]

 

is this correct?

 

 

4 REPLIES 4
Highlighted
Super Contributor

Re: Level 2 Sprint 3

Hi @Donna Marie,

 

I won't this is right or wrong,

but i can explain you what is the purpose of this line item.

 

The purpose of this line item is to

                      Calculate number of safety stock exception count by Distribution Center and "Product"

 

Capture.JPG

 

Now carefully check your formula.

Sorna Raja Prabhu
Highlighted
Contributor

Re: Level 2 Sprint 3

inv01 inventory ordering'.'safety stock exceptions count'[sum: 'sys08 sku details'.'distribution center', sum: sys08 sku details.'product']

 

is this correct  now

Highlighted
Super Contributor

Re: Level 2 Sprint 3

@Donna Marie - All The Best, You are in Right Track  🙂

 

 

Sorna Raja Prabhu
Highlighted
Contributor

Re: Level 2 Sprint 3

I think your formula is correct. The system does the agregation to sum the stock exception count on SKU and get them on product because of the hierarchy. I think your first formula is correct.

Younes