Level 2 Sprint 3 Module INV01 : Formula for Shipping Method

Hello !!,

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.

Please guide me further.

Thanks and Regards

Comments

Misbah

@gauravj6

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

Source[LOOKUP: Mapping]

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

Hope that helps

Misbah

gauravj6

Hi @Misbah ,

Thank you for the help.

I was able to populate the values in the Line Items. I will do a detailed check on the values and reconfirm the applied formula.

Regards

Gaurav Jain

ifeldman

@Misbah

Hi there,

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!

JimMcL

I thought I was following your guidance.

The mapping I had was SYS07 to SYS08 to INV01. I thought the formula below would get it done. However I get the error - Format of mapping used for lookup doesn't match any dimension of the source.

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

I double checked the format of the source and target both are lists. Please let me know where I have missed it.

jingru

Hi Jim,

Did you have this question figured? Below is the formula I tried, but I have no results showing. If you know how to solve this, would you please help? Thank you!

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

Shashikala

Perhaps you've figured out by now, the lookup item was wrong the formula should be :

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

HongXiangChin

'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details''.Distribution Center]

afrozonline

Source[LOOKUP: Mapping]

I believe your source is correct, figure out the lookup: Mapping from SKU Details Module. Please note that it has to be Mapping has to be List of values referring distribution center.

Varuna

I'm getting an error-"Mixed Data Types Used" with the below formula:-

'SYS07 Distribution Center Details'.Default Shipping (LOOKUP: 'SYS08 SKU Details'.Supplied By)

Please help!

ami17

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

Varuna

Appreciate your help, it ended up being a silly syntax error-I was using small brackets instead of the square ones!

Thanks!

Regards

Varuna

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…