L2 Sprint 3 INV01 formula for shipping time in weeks

krishnadbr
krishnadbr
in Modeling

Hi All,

 

I am trying to write formula for shipping time in weeks line item in INV01

krishnadbr_0-1634016112127.png

I am referencing TRA01 shipping time(weeks) as source in my lookup and SYS08 code as Mapping.

krishnadbr_1-1634016365761.png

and 

krishnadbr_2-1634016407150.png

I am seeing that TRA01 is at P2 product list  and SYS08 is at P3 sku level.

How should I connect these 2 to avoid error.

krishnadbr_3-1634016958325.pngkrishnadbr_4-1634016997046.png

Please guide me in connecting these.

 

Thanks,

Balarama Krishna

Tagged:

Best Answer

  • Misbah
    Misbah
    Answer ✓

    @krishnadbr 

     

    There should be two LOOKUPs used. One at the Product and another at Shipping Method. You already have a Shipping Method Line item created within INV01 Module

     

    Hope that helps

    Misbah

Answers

  • krishnadbr
    krishnadbr

    @Misbah

    Hi Misbah, 

    I tried upon your lines with the following formula

    krishnadbr_0-1634020083828.png

    But still getting this error.

    krishnadbr_1-1634020125165.png

    Also tried this with SYS08 Distribution center in place of SYS08 code. 

     

    Please advise.

     

    Thanks,

    Balarama Krishna

     

  • krishnadbr
    krishnadbr

    @Misbah

    Thanks, for your help. I figured out my mistake. I came up with correct formula.

    I should look up at product level and not SKU level.

    Appreciate your quick help.

     

    Thanks,

    Balarama Krishna

     

     

     

Categories