3.3.5 Shipping Time
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: