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?
Go to Solution.
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"
Now carefully check your formula.
inv01 inventory ordering'.'safety stock exceptions count'[sum: 'sys08 sku details'.'distribution center', sum: sys08 sku details.'product']
is this correct now
@Donna Marie - All The Best, You are in Right Track 🙂
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.