Level 2 Sprint 3 Stock Exception Review Dashboard Help

[nsherman]

Hey! I've been trying to figure out how to create the 3rd grid for the Stock Exception Review Dashboard. This is the view with creating a grid that shows Safety Stock Flag Count by period at the SKU level.

I was thinking I need to create a new line item with a lookup, but thinking I'm over complicating things!

Any hints/tips appreciated to guide me in the right direction! 

[einas.ibrahim · Accepted solution]

Hi @nsherman 

I will be happy to help you think through this.

My general guideline is always to start with the requirement, find out where I can find the information I need - or parts of it - and then think about how to get from A to B

Let's start with the requirement...

You already have the guidance that tells you the data will come from INV01. But even if you don't have that information, you can easily arrive at that conclusion since we are calculating the Stock Exception in the IN01.
I believe you already figured this part out.

Let's look at the dimensions of INV01, It's P3 SKU and Time (weeks) and Stock Exception is a line item.

What's the dimension of the requirement? "SKU Level and periods within a year"
The periods in this dashboard are months.
So it seems like you have all the information you need, right?

What are you going to lookup in the new line item you are thinking of adding? 
 

[nsherman]

And that's when you realize you were looking at the wrong module to add. I was looking at INV02 and trying to build a look up there. No wonder I was struggling.

Thanks @einas.ibrahim!

[einas.ibrahim]

no worries 🙂