INV01 - Shipping Time Weeks

Markcol
Frequent Contributor

INV01 - Shipping Time Weeks

Hi,

I am trying to add a formula for Shipping Time weeks in the INV01. I have tried these formulas but they don't work: 

 

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

 

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

 

Please guide me...

Mark

1 ACCEPTED SOLUTION

Accepted Solutions
muizzsk9890
Frequent Contributor

Hi @Markcol 

I think you must try the first formula and stick to it as it is correct one. Just check other factors like format of the line item or summary method or applies to or time settings. Try your experimental method and apply that formula. Let me know if it doesn't work and also share the blue print view if it doesn't work.

Muizz S.

View solution in original post

1 REPLY 1
muizzsk9890
Frequent Contributor

Hi @Markcol 

I think you must try the first formula and stick to it as it is correct one. Just check other factors like format of the line item or summary method or applies to or time settings. Try your experimental method and apply that formula. Let me know if it doesn't work and also share the blue print view if it doesn't work.

Muizz S.