INVO1 SHIPPING METHOD FORMULA

harishroshan
Contributor

INVO1 SHIPPING METHOD FORMULA

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 Screen Shot 2021-05-07 at 4.36.51 pm.pngScreen Shot 2021-05-07 at 4.37.06 pm.png

13 REPLIES 13
Vinay VaradarajM
Certified Master Anaplanner

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

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

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
Contributor

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