INVO1 SHIPPING METHOD FORMULA

[harishroshan]

HI 

I got stuck in the shipping methods where am trying to using all sort of formula but shipping methods showing different error 

my formula:

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

error :

Data type mismatch: format other than LIST or DATE being referenced as a relation

Any one please help me out with formula 

[Vinay VaradarajM]

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]

Hi @Vinay VaradarajM 

But still am receiving an error 

[Vinay VaradarajM · Accepted solution]

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!

[harishroshan]

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