3.3.5.6 Update Inventory Ordering to Calculate Shipping Costs

EJamr
EJamr
in Modeling

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]

Best Answer

  • HimanshuRaj
    HimanshuRaj
    Answer ✓

    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?

Answers

Categories