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.
please make sure that the summary of your line item "Final Shipping Cost" in module INV 01 is set us SUM. This will automatically aggregate the weeks to months, so you do not need any additional formula in this case. However, remember that you need to take into account SKU to Location relation (TIP: You will probably need to use System module with details about SKU).
Good luck! Let us know if you have other questions.
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]
I think you should base your calculation in INV05 based on module INV01 which contains you Final Shipping Cost per week, not on DAT02. That is why in my previous message I indicated that the amounts will be automatically aggregated from weeks to months based on Summary settings.
in INV01 the dimension is SKU, however in INV05 you have Location, therefore make a good use of SKU system module to sum the data correctly.