3.3.5.2 Inventory Ordering Module Formulas

Globe Trotter

Good evening

the final answer is not correct. I cannot get 4 weeks in my module.

and the formulas

'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Distribution Center]

'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product]

I do not understand why it does not work.

can you please help?

Thank you :)

Prajjwal88

Hi @Globe Trotter,

The Issue seems with the formula for Line Item Shipping Time Weeks as you're pulling these value from module TRA01 Shipping Metrics by Week which contains dimension of P2 Products and Shipping method. You've defined Lookup for Product to SKU mapping but you'll have to further define an Lookup for Shipping Method as well (for which you can simply use the line item you've created above Shipping Method) as the Target module does not contains the same dimensions.

Hence the correct formula for Line Item Shipping Time Weeks will look like:
'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

Hope this helps!