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
Solved! Go to Solution.
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.
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!