-Shipping time weeks

Highlighted
Occasional Contributor

-Shipping time weeks

Hi guys

I am trying to figure out how to populate the shipping time weeks line item from shipping method and the shipping metircs module.  I know there is a level mismatch and so I created a staging item PARENT(ITEM(P3 SKU) and attempted to do a lookup on that as well as the shipping method line item.  

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: INV01-Shipping time weeks Level 2

@Jmanaplanner46 

 

We are not supposed to discuss certification related queries here on Community but let me try to help you by giving you an additional hint. You will have to use 2 Looks ups. One you figured out and there has to be another one. Think and apply.

 

Happy Planning

Misbah

Highlighted
Occasional Contributor

Re: INV01-Shipping time weeks Level 2

I have figured out one of the lookups formula I believe but I cant think about the second one. This is the formula I am using currently: 

 

'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks) '[LOOKUP: 'SYS08 SKU Details'.Product]