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
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
