3.3.5 Shipping Method Question
I am currently stuck on finding the formula for the shipping method. I am using the lookup function in my formula to connect SYS07 Default Shipping line item and SYS08 Distribution Center and Code line items, but I am getting an error message that says "Data type mismatch: format other than LIST or DATE being referenced as a relation". I have tried switching the dimensions and formats within the SYS07 and SYS08 modules to solve the error but I can't seem to figure it out.
If anyone knows how to fix this it would be greatly appreciated.
There is a mismatch because SYS07,SYS08 and INV do not have the same dimensions.
LOOKUP looks like x[LOOKUP:y]
x is source and y is where
Default Shipping in SYS07 is your source and Distribution Center in SYS08 is your where
Something Like Default Shipping[LOOKUP: Distribution Center]1
That worked, thank you very much! My problem was I used lookup for both Distribution Center and Code for SYS08, when I only needed to use lookup for Distribution Center.0