Activity 11.3.2 Import data into P&L Actual & Budget

amangoyal · 2023-04-20T09:56:24+00:00

There was an error rendering this rich post.

Hi Community Members,

I have been trying to import data into the DATA01 P&L Actual & Budget Module but getting an error. Same error for activity 8.5.3 (Invalid format YYYYMM)

I have also checked the Example and follow the same but no success.

Please see my mapping screenshots, errors and suggest me the best solution.

Import_Error_Detail.jpg

Import_Error_Summary.jpg

Accepted answers

All comments

BrunoRodriguez

Hey!

Are you using this mapping for time?

Cheers!

amangoyal

Hey @BrunoRodriguez

I am using the same Mapping for time. Still issue is coming, Can you please help?

Thanks in Advance!!

AjayM

Hi @amangoyal ,

Though the format YYYYMM should work just fine, for the given csv file, I got curious with the first image. Why do you have 2023 in your model calendar for level 1 course? Can you please correct the time calendar, and retry?

Cheers!

amangoyal

Hello @AjayM,

Thanks for the help!!.

It is working. But only for FY2019 data has been updated.For future years it is not showing and error is coming as Invalid format YYYYMM. Will it load only FY2019 data, Is it correct?

amangoyal

Hello @AjayM,

Thanks for the help!!.

It is workingfine. In the time setting we need to set future years as 2, it did it 0 by mistake so it takes only FY2019. Now I have changes it is working fine.

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385