-Shipping time weeks

Jmanaplanner46
Jmanaplanner46
in Modeling

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.  

Tagged:

Best Answer

  • Misbah
    Misbah
    Answer ✓

    @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

Comments

  • Parth1106
    Parth1106

    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]

Categories