Activity 11.3.2 Import data into P&L Actual & Budget

amangoyal
amangoyal
in Academy Discussions

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
Mapping_2.2.jpg
Mapping_2.jpg
Mapping_3.jpg
Mapping_4.jpg
Mapping_5.jpg
Import_Error_Detail.jpg
Import_Error_Summary.jpg

Tagged:

Answers

  • BrunoRodriguez
    BrunoRodriguez

    Hey!

    Are you using this mapping for time?

    image.png

    Cheers!

    Kind regards,

    Bruno Rodriguez

  • amangoyal
    amangoyal

    Hey @BrunoRodriguez

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

    Thanks in Advance!!

  • AjayM
    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
    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?

    image.png

  • amangoyal
    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.

Categories