3.3.5 Shipping Method Question

Options
mattmo44
mattmo44 Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor
in Anaplan Community

Hi,

 

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

Comments

  • mattmo44
    mattmo44 Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    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.

  • tanmaygupta
    tanmaygupta Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    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]

     

Categories