INV01 Inventory Ordering module - Shipping Method formula issue

Options
mohanjmb
mohanjmb Member, ALL USERS, Community Member, Certified Model Builder Posts: 4 Occasional Contributor
in Planning & Modeling

Getting error when i am using below  formal for Shipping Method in "INV01 Inventory Ordering" module , Tried so many ways but no luck can some one help me some thing is i am missed 

 

'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS07 Distribution Center Details'.Default Shipping]

 

Scrrenshot 


 
Updating Media

 

 

 

-Mohan J

Tagged:

Comments

  • ifeldman
    ifeldman Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    I am having the same exact issues, but with both Shipping Method and Shipping Time Weeks line items. Im getting errors for both formulas below:

     

    Shipping Method: 

     

    'SYS07 Distribution Center Details'.Distribution Center? [LOOKUP: 'SYS08 SKU Details'.Product]

     

    Shipping Time Weeks:

     

    'TRA01 Shipping Metrics by Week’.’Shipping Time (Weeks)’ [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS07 Distribution Center Details'.Default Shipping]

     

     

  • AleksandraShariy
    AleksandraShariy Member, ALL USERS Posts: 5 Occasional Contributor

    Dear All,

    I faced with the same issue for Shipping Method formula

     

    When use following LOOKUP function 

     

    'SYS07 Distribution Center Details'.Default Shipping[lookup:'SYS08 SKU Details'.Distribution Center, lookup:'SYS08 SKU Details'.Code]

     

    I face with the issue:

    Data type mismatch: format other than LIST or DATE being referenced as a relation

     

    Could you please suggest what is the reason?

  • AleksandraShariy
    AleksandraShariy Member, ALL USERS Posts: 5 Occasional Contributor

    Hi @JaredDolich 

    many thanks for your reply

    I faced with the issue not in  Line Item "Shipping Time Weeks", but in "Shipping Method". As was mantioned in course formula should reference the Shipping Method information by product SKU based on the Distribution Center location that holds the inventory for each specific product SKU. As I understand it should be "air", "rail" etc

    I tried to use LOOKUP function, but failed

    'SYS07 Distribution Center Details'.Default Shipping[lookup:'SYS08 SKU Details'.Distribution Center, lookup:'SYS08 SKU Details'.Code]

    Error msg is the following:

    Data type mismatch: format other than LIST or DATE being referenced as a relation

    Could you please suggest what is the reason?

     

     

     

  • AleksandraShariy
    AleksandraShariy Member, ALL USERS Posts: 5 Occasional Contributor

    it seems that issue according to erroe msg is in data format... though format in module INV01 "Shipping method" and in SYS07 "Distribution center details" are the same - list Shipping Methods

  • AleksandraShariy
    AleksandraShariy Member, ALL USERS Posts: 5 Occasional Contributor

    it seems that issue according to erroe msg is in data format... though format in module INV01 "Shipping method" and in SYS07 "Distribution center details" are the same - list Shipping Methods

  • AleksandraShariy
    AleksandraShariy Member, ALL USERS Posts: 5 Occasional Contributor

    @JaredDolich Thanks a lot for your reply, 

    Im a bit cobfused, because we dont have line item "Supplied By" in SYS08 SKU Details. 

    We have just Distribution Center, Code, Product and Product Family in this list.

    Is it additional line item to be build? Thank you

  • AlexCao
    AlexCao Member, ALL USERS, Partner Posts: 1 New Contributor

    @Dpsullivan1 you might found your answer.

    Just re check all the data columns, line items in SYS08 module, and the line item 'Supplies by' should be there if you comply with guidelines accordingly, then above suggested formula will work for sure.

  • achumak86
    achumak86 Member, ALL USERS Posts: 1 New Contributor

    I am looking everywhere and do not see a line item "supplied by" in what learning portion are the instructions to build that?

Categories