MBL2: Conclusion INV05 Shipping Export

Options
Olli
Olli Member, ALL USERS, Community Member Posts: 4 New Contributor
in Planning & Modeling

Hello!

I would appreciate some help with the 'calculate shipping costs by location' formula in the INV05 Shipping Export -module.

 

It seems like basic LOOKUP-function, but I can't get it right. The problem seems to be here the different time scales when I use values of DAT02 Shipping Metrics -module (month vs year) and time functions don't seem to work together with LOOKUP (?). Screenshot of the module attached.

Tagged:

Comments

  • Olli
    Olli Member, ALL USERS, Community Member Posts: 4 New Contributor

    Hi,

    In 'INV05 Shipping Export' -modules 'Shipping Costs'-line item. The function below works if the target time setting is the same as in the source (time: years) but the target time setting needs to be in months and it seems that you can't use time-functions (yearvalue or so) combined with lookup-function. Or am I wrong? Do I need different approach? 

     

    'DAT02 Shipping Metrics'.'Cost per 1000 Units'[LOOKUP: 'SYS07 Distribution Center Details'.Default Shipping]

     

     

  • Olli
    Olli Member, ALL USERS, Community Member Posts: 4 New Contributor
    Thank you very much!

Categories