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.


Thank you,

Matthew Moorehead


  • 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]


  • 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.