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

Accepted answers

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

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

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

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…