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

Tagged:

Comments

  • 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.

    Regards,

    Muizz S.