INV01 Inventory Ordering module - Shipping Method formula issue

[mohanjmb]

Getting error when i am using below formal for Shipping Method in "INV01 Inventory Ordering" module , Tried so many ways but no luck can some one help me some thing is i am missed

'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS07 Distribution Center Details'.Default Shipping]

Scrrenshot

Updating Media

-Mohan J

[ifeldman]

I am having the same exact issues, but with both Shipping Method and Shipping Time Weeks line items. Im getting errors for both formulas below:

Shipping Method:

'SYS07 Distribution Center Details'.Distribution Center? [LOOKUP: 'SYS08 SKU Details'.Product]

Shipping Time Weeks:

'TRA01 Shipping Metrics by Week’.’Shipping Time (Weeks)’ [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS07 Distribution Center Details'.Default Shipping]

[AleksandraShariy]

Dear All,

I faced with the same issue for Shipping Method formula

When use following LOOKUP function

'SYS07 Distribution Center Details'.Default Shipping[lookup:'SYS08 SKU Details'.Distribution Center, lookup:'SYS08 SKU Details'.Code]

I face with the issue:

Data type mismatch: format other than LIST or DATE being referenced as a relation

Could you please suggest what is the reason?

[AleksandraShariy]

it seems that issue according to erroe msg is in data format... though format in module INV01 "Shipping method" and in SYS07 "Distribution center details" are the same - list Shipping Methods

[JaredDolich]

@mohanjmb@AleksandraShariy@ifeldman

You all are so, so close. Try this instead:

'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: Final Shipping Method, LOOKUP: 'SYS08 SKU Details'.Product]

Let's break that down:

• We want the Shipping time (Week) line item from the TRA01. We note that the TRA01 is dimensioned by P2 Products and Shipping Methods.
• In order to get that line item we need to have list formatted line items that are related to those lists.
• Where can we find those list formatted line items?
• To get Shipping method, we already have it in our INV01 module. So let's use that.
• To get product we need to reference our system module, or SYS08.

[AleksandraShariy]

Hi@JaredDolich

many thanks for your reply

I faced with the issue not in行项目“航运时间周”,但在“Shipping Method". As was mantioned in courseformula should reference the Shipping Method information by product SKU based on the Distribution Center location that holds the inventory for each specific product SKU. As I understand it should be "air", "rail" etc

I tried to use LOOKUP function, but failed

'SYS07 Distribution Center Details'.Default Shipping[lookup:'SYS08 SKU Details'.Distribution Center, lookup:'SYS08 SKU Details'.Code]

Error msg is the following:

Data type mismatch: format other than LIST or DATE being referenced as a relation

Could you please suggest what is the reason?

[AleksandraShariy]

it seems that issue according to erroe msg is in data format... though format in module INV01 "Shipping method" and in SYS07 "Distribution center details" are the same - list Shipping Methods

[JaredDolich]

@AleksandraShariy

Try this. You're a lot closer than you may think.

Shipping Method = 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Supplied By]

Breakdown:

• You are correct to use SYS07
• But SYS07 uses a list subset of G3, so your LOOKUP has to return the relationship of shipping method and G3.
• And we find that in SYS08. So you had that right too.
• Take a look at "supplied by" format. It uses the same list subset as what you need in your module. That's why that is the correct line item to use.

[AleksandraShariy]

@JaredDolichThanks a lot for your reply,

Im a bit cobfused, because we dont have line item "Supplied By" inSYS08 SKU Details.

We have just Distribution Center, Code, Product and Product Family in this list.

Is it additional line item to be build? Thank you

[JaredDolich]

@AleksandraShariy

Good question. Yes, you will need that line item in order for this to work.

Try going back to when you were asked to build SYS08.Sometimes it's easy to miss it because it's hard to find in the text.

You might have missed it. It's a list formatted line item that uses the list subset in G3. If you don't see, then go ahead and add it.

The overall point of this lesson is that you LOOKUP a line item that has a relationship to the TARGET's line item format and the SOURCE's list.

Hope that helps, if not, let's keep going. I want you to get to the finish line on this.