topic L2 3.5.3 INV03 Stock Exceptions formula in Academy & Training

L2 3.5.3 INV03 Stock Exceptions formula

Niraj.B — Fri, 19 Mar 2021 13:26:25 GMT

Hello,

I have come across an issue with 'Stock Exceptions' and for some reason I get blank.

If I set the Summary method as Sum, then it works but the task clearly says it should be kept None.

I am attaching INV03, INV01 (source) and SKU08 if you can think if I did anything wrong there.

Re: L2 3.5.3 INV03 Stock Exceptions formula

Misbah — Fri, 19 Mar 2021 14:47:22 GMT

< LI-USER uid = " 29450 " > < / LI-USER >, 所在sp;

Yes you are right, When you keep the Summary as SUM it will auto Aggregate SKUs into Product Level but if the ask is to keep Summary as None then you will have to use another SUM function in the formula. Your formula should look like

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Product, SUM: 'SYS08 SKU Details'.Distribution Center] - If the summary is set to None

Hope that helps

Misbah

Re: L2 3.5.3 INV03 Stock Exceptions formula

Niraj.B — Fri, 19 Mar 2021 15:06:02 GMT

Thank you but still I get blank. I am really at loss here.

Re: L2 3.5.3 INV03 Stock Exceptions formula

Misbah — Fri, 19 Mar 2021 15:11:38 GMT

< LI-USER uid = " 29450 " > < / LI-USER >, 所在sp;

No Problem. Can you please check at All Products and All Regions Level, do you see any numbers on aggregated levels?

Re: L2 3.5.3 INV03 Stock Exceptions formula

Niraj.B — Fri, 19 Mar 2021 15:15:49 GMT

On INV01 I can see numbers at All Products level. On INV03 I cannot see at All Products/All regions level

Re: L2 3.5.3 INV03 Stock Exceptions formula

Misbah — Fri, 19 Mar 2021 15:26:52 GMT

< LI-USER uid = " 29450 " > < / LI-USER >, 所在sp;

Very difficult to understand without screenshots. Please add screenshot if you could

First of all your Safety Stock Exception Count is wrong in INV01 but the Formula looks ok to me. Just rewrite it this way IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0

Second if you are not able to see the numbers in INV03 then I would certainly check SYS08 module to confirm if I have the DC mapping available there.

Re: L2 3.5.3 INV03 Stock Exceptions formula

Niraj.B — 星期五,2021年3月19日15:33:46格林尼治时间

Here is my SYS08 module

Along with my INV01,INV03

Re: L2 3.5.3 INV03 Stock Exceptions formula

Misbah — Fri, 19 Mar 2021 15:45:21 GMT

< LI-USER uid = " 29450 " > < / LI-USER >, 所在sp;

Looks good. Can you share the front end of INV03 Module for Stock Exception line at All Products Level

Re: L2 3.5.3 INV03 Stock Exceptions formula

Niraj.B — 星期五,2021年3月19日16:09:48 GMT

Here it is

Re: L2 3.5.3 INV03 Stock Exceptions formula

Misbah — 星期五,2021年3月19日16:16:51 GMT

< LI-USER uid = " 29450 " > < / LI-USER >, 所在sp;

Ah I see!

Summary is set to None in INV03, It has to be SUM. You have to set Summary as None in INV01 and not in INV03

Re: L2 3.5.3 INV03 Stock Exceptions formula

Niraj.B — Fri, 19 Mar 2021 17:32:21 GMT

But we are asked to make it None in INV03 hence my whole confusion. Let me read the instructions again.

Re: L2 3.5.3 INV03 Stock Exceptions formula

sramara — Fri, 01 Oct 2021 13:10:22 GMT

Change the context selectors to a specific SKU and a specific country.

Re: L2 3.5.3 INV03 Stock Exceptions formula

stephenwsells — Sat, 25 Dec 2021 23:58:29 GMT

I'm having the same issue - I'm beginning to believe it's just a typo in the training