Activity: Prepare Data Exports - comparing results to INV01 Inventory Ordering.csv

kristinball · 2024-01-18T07:32:15+00:00

There was an error rendering this rich post.

In the Level 2 Conclusion, Activity: Prepare Data Exports, Anaplan gives a csv to download and compare our results to.

Is anyone else having issues with their numbers tying out? After a lot of analysis, it seems the Weekly Order Schedule that I uploaded from the Level 2 Sprint 3 exam is not what should actually be loaded. Did I miss a step of downloading fresh data from Anaplan?

I also noticed there were a couple other variances randomly throughout the page but most notably for weeks 6 - 9 for both FY20 and FY21. Did I miss steps for override amounts? I have no override amounts currently for INV01 Inventory Ordering

Accepted answers

All comments

EboneeS

Hello - can you clarify your question? Is your issue with the exam download or the export that's completed as part of the Prepare Data Exports activity?

kristinball

Hi Ebonee,

Thank you for your response. I guess my question is where did I go wrong or has anyone else seen this issue when completing Level 2 recently?

At the end of the Prepare Data Exports activity, I downloaded the file they provide to compare my results from INV01. When I compare them, I noticed there was a major difference in my Weekly Order Schedule that I uploaded from Level 2 Sprint 3 exam. I had to do a lot of boolean corrections for "Submit Purchase Order Request?". After I updated that information to the closest I could get to the file they provided, I'm still off with the deltas showing in the picture above. I can't figure out if I missed a step or file to download. Do I really need to do all of this manually to try to get the right answer or is there a file from Level 2 that I missed uploading? I don't want to type in "Override Amount" in INV01 to tie out to the file they provided if I'm not supposed to do that.

EboneeS

The confusion for me is that these are 2 different actions. The Prepare Data Exports activity as part of the Level 2 Conclusion is an export of the Beginning Inventory and should match the screenshot provided in that activity or the download that's also linked there. The Weekly Order Schedule is an import of the Sumbit Purchase Order line-item clearing what checked Booleans you have there, and importing new True/False data for the Submit Purchase Order so you can answer the next question.

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…