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

1 ACCEPTED SOLUTION

Accepted Solutions
vinayvm
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

13 REPLIES 13
harishroshan
Contributor

Re: INVO1 SHIPPING METHOD FORMULA

Time scale for SYS07 Distribution Center Details is not applicable 

time scale for SYS08 SKU Details is not applicable in my supply chain model if i change time scale in any module then result is blank too 

 

any one please help me with this 

 

vinayvm
Certified Master Anaplanner

Re: INVO1 SHIPPING METHOD FORMULA

Hi @harishroshan ,

 

The line item SYS08 SKU Details.Code or SYS08 SKU Details.Supplied By or both are not LIST formatted, which is a necessity for being able to lookup. Once you change it to LIST, it should work fine. Currently, I suspect at least the Code is text formatted.

 

Hope this helps!

harishroshan
Contributor

Re: INVO1 SHIPPING METHOD FORMULA

HI Vinay

 

when am trying to change code to list formate its not changing showing an error i have attached. supplied by is in list formate Screen Shot 2021-05-07 at 5.17.31 pm.png

vinayvm
Certified Master Anaplanner

Re: INVO1 SHIPPING METHOD FORMULA

Hi @harishroshan ,

 

Before changing the format, a few pre-requisites:

 

1. Ensure, this line item is not referenced anywhere in the model

2. If it is referenced, it is better to create a new line item which is list formatted and then use it for lookup

3. If it is not referenced, you can delete the current formula, change the format, and then write a new formula which gives you list formatted result

 

Hope this helps!

harishroshan
Contributor

Re: INVO1 SHIPPING METHOD FORMULA

Hi @vinayvm 

 

which line item should be formated or created in 

vinayvm
Certified Master Anaplanner

Re: INVO1 SHIPPING METHOD FORMULA

Hi @harishroshan ,

Sorry if I was not clear. Updated my response below:

 

Before changing the format, a few pre-requisites:

 

1. Ensure, this line item (SYS08 SKU Details.Code) is not referenced anywhere in the model

2. If it is referenced (the system will not allow you to change the format, as it is linked in other calculations), it is better to create a new line item which is list formatted and then use it for lookup

3. If it is not referenced, you can delete the current formula, change the format, and then write a new formula which gives you list formatted result

 

Hope this helps!

harishroshan
Contributor

Re: INVO1 SHIPPING METHOD FORMULA

hi @vinayvm 

 

but code should always be in text formate right ? its not allowing me to change formate 

harishroshan
Contributor

Re: INVO1 SHIPPING METHOD FORMULA

harishroshan
Contributor

Re: INVO1 SHIPPING METHOD FORMULA

Screen Shot 2021-05-07 at 6.09.35 pm.png