No data in Confirmed Purchase Order Receipt

Hello all, I'm really struggling with 3.3.6 testing the shipping cost formulas. No matter what I do I can't get the data in Confirmed Purchase Order Receipt to show a value. Even before switching it over to the POST function, no data comes up. Is this something to do with DCAs? Please see my attached screenshots and let me know if you see an issue!

Thank you all so much!

Screen Shot 2023-02-05 at 4.34.59 PM.png

Screen Shot 2023-02-05 at 4.34.25 PM.png

Accepted answers

All comments

ArnabG

Hi @JillianKelli ,

If You dig to your formula for Confirmed Purchase Order Receipt, you are offsetting when "Confirmed PO Delivery <> 0" and offsetting by "Final Shipping Time weeks" which is currently 2(Week 2 FY20). That means you are trying to offsetting Final shipping Amount of "Week 2 FY 20 - 2" i.e before Week 1 which will always give you 0.

You can observe the result/number when you will change the Override method for Week 2 FY20 to "Air" as it will offset "Week 2 FY 20 - 1" that is the value of Week 1 and you will be getting what I am trying to say.

To resolve this issue try using Post which not only just offsets the current data but also adds up.

Hope it helps!

Thanks,

Arnab

Quick Links

Can you help?

Unanswered questions

ERROR 16020 |-- Anaplan API: Invalid key path
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…