3.3.6 Air Override not showing correct figures for Nutzo Bar_EN

Options
akrem
akrem
in Academy Discussions

Hello,


Below are my formulas and lists I overrode with shipping method AIR. I believe its related to way my list is setup see below, any insight would be valued. Air resutls for Nutzo Bar_EN not showing correct.

Final Shipping Cost

Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

Shipping Cost Variance

IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipping Costs

image.png
image.png
image.png
image.png

image.png

Best Answer

  • Dikshant
    Dikshant
    edited December 2023 Answer ✓
    Options

    @akrem,

    Drill down to the line item Final Shipment Cost and see the values, which are 0. Looks like the final shipment costs come from the Final Shipment Amount line item, which is 0 in your model. Final Shipment line item must take Override Amount value but in your case it is not and looks like the formula for Final Shipment line item is not correct. Try this out.

    Final Shipment: IF NOT Submit Purchase Order Request? THEN 0 ELSE IF NOT Override Suggested Order Amount? THEN Suggested Order Amount for the Month ELSE Override Amount

Answers

  • akrem
    akrem
    Options

    Hi,

    Much better now thank you. How come my final shipping cost and shipping cost variance are incorrect ? Take a look below the ending part of the formula is not multiplying by 100.

    Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

    1,1214 / 1,000 = 1.214 * 100 = 121.4 Expected result but showing 1.214

    Shipping Cost

    Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

    Shows 2.428 expected 78.91

    image.png
    image.png

  • akrem
    akrem
    Options

    What about shipping costs are not calculating correctly ?

    Shipping Costs

    Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

    Final Shipping Costs:

    Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

    Shipping Cost Variance:

    IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipping Costs

    image.png

  • Dikshant
    Dikshant
    edited January 18
    Options

    @akrem, Remove the override shipping and the final shipping method should be road and not air. Once you set Final Shipping Method as Road, Final Shipping Cost will be 78.91

    image.png

  • Dikshant
    Dikshant
    Options

    @akrem, Also the formula should sum based on Final Shipping Method.

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

Categories