3.3.5 Shipping Method Question

Hi,

I am currently stuck on finding the formula for the shipping method. I am using the lookup function in my formula to connect SYS07 Default Shipping line item and SYS08 Distribution Center and Code line items, but I am getting an error message that says "Data type mismatch: format other than LIST or DATE being referenced as a relation". I have tried switching the dimensions and formats within the SYS07 and SYS08 modules to solve the error but I can't seem to figure it out.

If anyone knows how to fix this it would be greatly appreciated.

Thank you,

Matthew Moorehead

Comments

tanmaygupta

There is a mismatch because SYS07,SYS08 and INV do not have the same dimensions.

LOOKUP looks like x[LOOKUP:y]

x is source and y is where

Default Shipping in SYS07 is your source and Distribution Center in SYS08 is your where

Something Like Default Shipping[LOOKUP: Distribution Center]

mattmo44

That worked, thank you very much! My problem was I used lookup for both Distribution Center and Code for SYS08, when I only needed to use lookup for Distribution Center.

Quick Links

Recent release news

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…
Recording now available! October 29 platform release event
If you missed our October 29, 2025 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…