3.3.5.6 Update Inventory Ordering to Calculate Shipping Costs

EJamr

Hi all,

I'm having difficulties with the Shipping Cost line item. I am getting an error on the formula below…Can someone kindly point me in the right direction

Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: Shipping Methods]

HimanshuRaj

Hi @EJamr

Try this formula: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units' [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

Hope, this resloves your issue. If not, then can you share the screenshot of what specific error are you facing?

EJamr

Thank you.. I missed out the lookup piece…

dpong8898

Sorry, I think you made a mistake here!

I believe the formula should be as follows,