INVO1 SHIPPING METHOD FORMULA

Vinay VaradarajM
Certified Master Anaplanner

Re: INVO1 SHIPPING METHOD FORMULA

Hi @harishroshan ,

 

Try this formula in the code 2 line item : item('P3 SKU').

You might also want to rename this line item (to SKU List may be) just to avoid confusion.

 

FYI
The earlier formula Code(item('P3 SKU')) is not working because this formula results in a text format, whereas what you need is a LIST format.

harishroshan
Contributor

Re: INVO1 SHIPPING METHOD FORMULA

Hi @Vinay VaradarajM 

 

But still am receiving an error Screen Shot 2021-05-07 at 7.18.05 pm.pngScreen Shot 2021-05-07 at 7.18.14 pm.png

Vinay VaradarajM
Certified Master Anaplanner

Re: INVO1 SHIPPING METHOD FORMULA

Hi @harishroshan ,

 

I believe the shipping mode should just depend on Location, and not SKU. Hence, you do not need to lookup the SKU. Your formula should be: 'SYS07 Distribution Center Details'.Default Shipping[Lookup: 'SYS08 SKU Details'.Supplied By]

 

This should have been my first response, rather than looking at pre-requisites to get the formula working : )

 

Hope this helps!

View solution in original post

harishroshan
Contributor

Re: INVO1 SHIPPING METHOD FORMULA

Thank you @Vinay VaradarajM I got stuck here for 5 hrs.