Activity 11.3.2 Import data into P&L Actual & Budget

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.

Mapping_1.jpg

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

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
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…
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.…