INV05 Shipping Export Shipping Costs return 0

Joelarkins
Joelarkins
in Academy Discussions

When building module INV05 my shipping costs are returning as 0 and this is due to my INV01 needing manual intervention on 'submit purchase order request?'. Surely this needs to be automated otherwise I would have to tick every SKU. I cannot find within Level 2 where the instruction is to automate.

image.png
image.png
image.png

Best Answers

  • Prajjwal88
    Prajjwal88
    edited February 10 Answer ✓

    Hi @Joelarkins ,

    For this, there’s a file named Work+Ordering+Schedule.csv that contains TRUE/FALSE values for the line item 'Submit Purchase Order Request?'. This file is usually provided as part of the Level 2 Sprint 3 Exam.

    Once you load this file into your model, the values will be populated based on the correct mappings, and you won’t need to manually tick each SKU. After importing, you can verify the results in your module.

    Hope this helps!

  • Prajjwal88
    Prajjwal88
    Answer ✓

    Hi @Joelarkins ,

    The issue seems to be with the line item "Confirmed Purchase Order Receipt". It’s not calculating the values, which should ideally be based on the line item "Final Shipping Time Weeks".

    Please check the formula for the same. It should be:
    IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0

    Hope this solves your issue!

Answers

  • Joelarkins
    Joelarkins

    Thanks @Prajjwal88 ! I've imported the csv file and I'm happy with the results in INV05. However, I'm surprised to see the 'Beginning Inventory' dropping to negative numbers, as the screenshot shows. If my INV01 was running correctly this shouldn't happen?

    image.png
  • Joelarkins
    Joelarkins

    Hi @Prajjwal88 ,

    Thanks for the response, I've amended my Confirmed PO Receipt formula so it considers a value greater than 0 in confirmed PO delivery. My beginning inventory hasn't changed and it seems the Confirmed PO Receipt line item isn't calculating and I'm not sure why?

    image.png
    image.png

    Any help is appreciated!

    Joe

  • Prajjwal88
    Prajjwal88

    Hi @Joelarkins ,
    The issue seems with the formula for line Item Final Shipment Amount ,as it should be simply calculating shipment amount based on line Items Submit Purchase Order Request? and Override Suggested Order Amount? without any use of OFFSET(), So the correct formula should be:
    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

    Hope this helps.

  • Joelarkins
    Joelarkins

    Thanks @Prajjwal88, that makes sense! This is now resolved

Categories