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.
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!
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!
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?
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?
Any help is appreciated!
Joe
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
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.
Thanks @Prajjwal88, that makes sense! This is now resolved
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
