nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Level 2 - Sprint 3 - 3.4.3 Activity: Create Country Summary Module

ismaelmaclovio

Hello all,

I'm having trouble figuring out with this error that I'm getting. Can anyone help me out?

My formula is this:

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]

Thank you

1_98427.png

Comments

JaredDolich

@ismaelmaclovio

Super, Super Close.

Your Equation:

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]

Correct Equation

'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Supplied By]

Let's break it down.

When ever you use a SUM the SOURCE module must have list formatted line item that is also a list in your TARGET module.
Since the list choices in the TARGET module are P2 Products and s G3 Location.Distribution Center we need one of those in the SOURCE
INV01 does not have that line item BUT there is a system module that relates the INV01 list to DC and that is in SYS08.
Supplied by has a line item formatted as s G3 Location.Distribution Center!

ismaelmaclovio

@JaredDolich

Thanks for your reply. I tried your equation and got this error message.

Error_98431.png

JaredDolich

@ismaelmaclovio

Gotcha. It wasn't clear what module this formula was in.

In that case your formula is correct. So you have a syntax error and need to make sure these two line items are spelled the same way as in your formula:

Go to SYS08. Is the line item spelled "Country Made In"
Go to INV01. Is the line item spelled "Safety Stock Exception Count"?

Next Steps

If both are spelled the correctly, then use the editor to create your formula rather than using cut/paste. You might have a special character in there somewhere.
Last step is that we need to make sure the modules are using the right lists and your line items have the right formats and summaries.

Let's see if that helps.

You're close. Hang in there.

ismaelmaclovio

@JaredDolich
Thank you for the help. It turns out that I was missing line item "Country Made In." I added it and then put the formula and it worked!

RaghuMulki

Do we need to pull data to Country Made in Line item to to make the safety stock exception count formula work? Plead help

RaghavendraRao

Yes, in system module put the formula to get the parent of G3 location. I have attached the screen shot for reference. then you can able to see the numbers in safety stock exception count

PARENT(Distribution Center)

Screenshot_2022-08-13_224319_144799.png

Screenshot_2022-08-13_224535_144799.png

Yogitha

In my SYS08 SKU Details, I don't find Distribution center Line item when compared to your attached screenshot

Let me know what's going wrong

2022-10-29 (8).png

hana7270

parent (Supplied By)

Quick Links

Recent release news

FCR Release 2608.3 Advisory: Notice of recent changes
Please take note of the following changes in our latest 2608 release: Multi-dimensional calculations now require valid rules. As of 2608, the multi-dimensional calculation process no longer runs when invalid rules are present - for example, a rule referencing an invalid member (one that no longer exists in the dimension).…
FCR Release 2608.2 Advisory: ADO Import Staging Table Schema Mismatch
As part of the FCR Release 2608 update, enhancements were introduced to improve data import performance and ensure correct column data typing for ADO Imports to FCR. Specifically: Schema Correction: Staging tables now properly instantiate numeric columns as float rather than defaulting to string. Performance Optimization…