I am trying to write formula for shipping time in weeks line item in INV01
I am referencing TRA01 shipping time(weeks) as source in my lookup and SYS08 code as Mapping.
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.
Please guide me in connecting these.
Go to Solution.
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
View solution in original post
I tried upon your lines with the following formula
But still getting this error.
Also tried this with SYS08 Distribution center in place of SYS08 code.
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.