on 07-30-2013 9:54 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.