cancel
Showing results for 
Search instead for 
Did you mean: 

Upload journal from Excel

Former Member
0 Kudos

Hi Experts,

I'm working with SAP BPC 10 and I find a problem related with journals.

Do you know a way to upload jounals directly from Excel?

Thank you.

Regards,

Gabriel

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Gabriel,

Follow these steps

1. Post at least one journal entry in the system using web admin interface.

2. Then in excel interface choose Data Manager >Organize package list

3. Right click in the yellow area → Add package Select →Business Planning and Consolidation: Other Function → BPC: Export Journal

4. Add the BPC: Export Journal package to your Model

5. Use the same process to add the BPC: Restore Journal package to your Model

6. Execute the package BPC: Export Journal to generate the flat file

7. Insert new journal IDs into the flat file

8. Execute the package BPC: Restore Journal to upload the new journals.

Regards,

Kalyan.

Former Member
0 Kudos

Thank you Kalyan for your quick answer,

Maybe that option can help me, but do I need a flat file to upload the journal using "restore journal" process, doesn' it?

Do you know another option to upload directly from Excel, and not from flat file?

Thank you very much!

Gabriel

Former Member
0 Kudos

Hi Gabriel,

You have to use both, export journal will generate the flat file that will define the structure of your journal entries, so your new journals have to follow the same structure and also you  have to insert the IDs.

I guess this is the only standard way. Unless you want to explore custom process chain and BADI.

Regards,

Kalyan.

Former Member
0 Kudos

Thank you Kalyan.

Former Member
0 Kudos

Hello Kalyan,

I follow the steps you show, but Restore Journal package failed. The message is:

The Journal table has data. Restore cannot continue

It seems that is not possible to use this way in SAP BPC 10 NW. Do you know another way?

sreenivasulup
Participant
0 Kudos

Hi Gabriel,

When the journal data is exported inta a file, the package creates the file with .jrn extension. I hope you have not changed that to xls or csv.

You can open the journal export file with notepad, make the required change for example, deleting the unwanted journals from the file and save it.

This file now should be ready to restored. It worked for me in EPM10. The journals in the file are listed as per the IDs. You would find the most recent ones at the bottom of the file.

Thanks,

Sreeni

Former Member
0 Kudos

Hello Sreeni,

Thank you for your answer. I'm trying to upload the flat file modified (.jrn extension) but the following error appear: "File extension not allowed for upload. Check your file extension."

sreenivasulup
Participant
0 Kudos

Once the journal file is exported using the export journals data manager package, please open the file with the notepad to make required deletions or any other modifications. Upload the modified file as it is into the destination environment and use the restore journals package to import.

Once the journals are restore, all of them would be in 'saved' mode. You need to select and post them in the target.

Please check the file once again.

Thanks,

Sreeni

Former Member
0 Kudos

Thank you Sreeni,

But I have the problem before, in the step "Upload the modified file". There is where BPC give the error:  "File extension not allowed for upload. Check your file extension". BPC doesn't accept the extension .jrn

Former Member
0 Kudos

I include de parameter ALLOW_EXTENSIONS and include the value JRN.

However, the Restore journal package give me this error: "The Journal table has data. Restore cannot continue"

Thank you

Answers (0)