L2 Sprint 3 INV01 formula for shipping time in weeks

krishnadbr
Contributor

L2 Sprint 3 INV01 formula for shipping time in weeks

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

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: L2 Sprint 3 INV01 formula for shipping time in weeks

@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

View solution in original post

3 REPLIES 3
Misbah
Moderator

Re: L2 Sprint 3 INV01 formula for shipping time in weeks

@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

View solution in original post

krishnadbr
Contributor

Re: L2 Sprint 3 INV01 formula for shipping time in weeks

@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
Contributor

Re: L2 Sprint 3 INV01 formula for shipping time in weeks

@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