I cannot seem to get this formula correct for shipping time in INV01: time in weeks for the default shipping method for each SKU.
TRA01 contains shipping time in weeks, shipping method, and P2 Products.
SYS07 contains default shipping method and distribution center.
SYS08 contains distribution center, SKU by code, and P2 Products
SKU and Code (SKU by code) are both columns in P3 SKU List
So INV01 should pick the TRA01 value which matches the default shipping method and product.
The product should be looked up against the SKU in SYS08.
The distribution center should be looked up against the SKU in SYS 08.
The default shipping method should be looked up against the distribution center in SYS07
The formula is invalid, although I can't figure out why:
Solved!Go to Solution.
You are very close. I see there are a few issues here since you are trying to use all LOOKUPs in one formula. That might not work. Follow this
所以在你的情况下,您必须编写额外的LOOKUP just before your two mappings and remove third mapping from your formula. So the formula will look like -
Shipping Time Weeks[LOOKUP: Product, LOOKUP: Shipping Method]
Note: This is logically right formula but not necessarily technically.
Hope that helps
Misbah
Miz Logix
You are very close. I see there are a few issues here since you are trying to use all LOOKUPs in one formula. That might not work. Follow this
所以在你的情况下,您必须编写额外的LOOKUP just before your two mappings and remove third mapping from your formula. So the formula will look like -
Shipping Time Weeks[LOOKUP: Product, LOOKUP: Shipping Method]
Note: This is logically right formula but not necessarily technically.
Hope that helps
Misbah
Miz Logix
Thanks Misbah!
1. I had this.
2. I didn't think to use Shipping Method from the same module; I was convinced I needed to go outside.
3. Syntax got me with that second LOOKUP so the error I was trying to solve wasn't the actual problem.