Level 2 Sprint 3: 3.3.5.2 Shipping Methods Formula

Varuna
Varuna
in Academy Discussions

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!
Tagged:

Comments

  • jagadishdash
    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
    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
    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
    Mili
    edited July 2023

    Thanks for sharing.

  • Mili
    Mili
    shipping method.JPG

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

Categories