Level 2 Sprint 3: 3.3.5.2 Shipping Methods Formula

Varuna

In the Inventory Ordering Module, I'm trying to use the below formula for Shipping Method:-

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

But I'm getting an "Invalid Formula" error.

'SYS07 Distribution Center Details'.Default Shipping is list formatted to "Shipping Methods"

'SYS08 SKU Details'.Supplied By is list formatted to "s G3 Location:Distribution Center?"

Please help!

Comments

jagadishdash

@Varuna

For shipping method, 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Distribution Center]

The formula is correct only. But check the sys07 default shipping and sys08 distribution center(supplied by) Data is there or not.

Both are imported data, If data is not there import the data.

If everything above is correct, Then please share the screenshot of three module's line item for reference to check and with error screenshot.

Glad to be help you further.

Hope it helpful for you. If it is please accept my answer as solution.

Thanks,

Varuna

I was making a silly mistake with the syntax of LOOKUP-using circular brackets instead of square ones! Everything fell in place on correcting the syntax.

Thanks for your help!

Regards,

Varuna

jagadishdash

@Varuna Glad to know that you got it. Happy learning ahead. If my solution worked, You can accept my answer as solution.

Thanks,

Jagadish dash

Mili

Thanks for sharing.

Mili

Please help. Not sure where I did wrong, but it gave me a different result.

Quick Links

Recent release news

August 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our August 2025 official release notes. The information below offers supplemental information to that post. Planning experience Multi-browser tab syncing When changing context or data on a UX page, you can now view real-time data updates across up to five…
July 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our July 2025 official release notes. The information below offers supplemental information to that post. Planning experience External URL navigation button Page builders can configure navigation action buttons to link to external URLs, including non-Anaplan…