I have been doing Level 2 Sprint 3 - INV01 Module and stuck on formula for Shipping Method as i am getting multiple type of errors while doing LOOKUPs.
In order to populate values for Shipping Method Line Item, I need to look into SYS07 Module(Distribution Center Details) for Default Shipping Line item looking up SYS08 SKU Details'.Code and SYS08 SKU Details'.Supplied By
Is my understanding of the flow is correct ? because i am getting error while trying to use this formula as below.
Let's try to understand how does LOOKUPs work. When you construct a formula intending to use LOOKUP there are few things that you need to consider
What are the Dimensions of Source Module?
What are the Dimensions of Target Module?
What is the format of the Mapping used in the Formula?
What is the format of the Source and Target Line items ?
In your Case
Dimensions of Source Module SYS07 Distribution Center Details is sG3 Location:Distributon Center
Dimensions of Target Module is INV01 Inventory Ordering is P3 SKU
Format of the mapping has to be List or Time Period/Date
Format of Source & Target Line items has to be same
So here is a dimension mismatch. Now In order to pull values from Source Module to Target Module you want to find a connection that
you can use to pull the values - Here comes the SYS08 SKU Details module which is dimensioned by P3 SKU which has a line item called Distribution Center. Remember Format of this line item is very important, it has to be formatted as sG3 Location: Distribution Center and not TEXT or anything else. One last piece is about the format of the source line item, In our case it has to List format -Shipping Method and your Target Line item in INV01 module also should be formatted as List format- Shipping Method
Your formula construct should be
Here mapping has to be List formatted only. If you look at the error that you are receiving it clearly says that format other than List or Date being referenced. Hence the error
I am having the same issue of not knowing how to correctly format the lookup items. I know I need to use Distribution Center and SKY modules, however I keep getting an error. Any help would be great, thanks!