Level 2 Sprint 3 Stock Exception Review Dashboard Help
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!
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?