Issue while Saving Journals from Flat File in SAP BPC 10.0

[former_member623548]

Hi Folks,

I am trying to save my upload of Journals through Flat File. I am uploading the below file and running the /CPMB/RESTORE_JOURNALS CHAIN. I have downloaded the file format from import journals chain.

My debit values are not loaded correctly in the saved Journals.

capture.jpg

After running the chain , below is journal which is saved in BPC Web Journals.

capture1.jpg

The values of the debit values are getting changed . It is taking the value of first row in all my rows.

Please help me here. How can i save correct values directly from flat file

Regards,

Happy

[former_member186338]

If you want an answer - please correct your question: never use "Insert File" instead of correct "Insert Image" for screenshots. Version info is also missing...

[former_member623548]

Inserting the images

My journal text file-

After running the Packages data in Web Journals

[former_member186338 · Accepted solution]

/CPMB/RESTORE_JOURNALS chain is not used to load journals. It's only used for complete journals restore! You can export all journals, remove all journals then restore.

To load new journals from text file you need to develop your own badi.

[former_member623548]

HI Vadim,

Thanks for your quick respones.I have corrected the images.

Can you help me with any note/ link on how can we can use badi for uploading journals via flat file for mass upload.

Regards,

Happy

[former_member186338]

There is no document or link for this particular development. In general you can create a custom logic badi that will read text file and post journals in this text file.

Look on class: CL_UJJ_JRN_MGR

Not very easy job!

[former_member623548]

I am also using the file exported from the journals using the Export journal package. After that i am changing the values imported from the Journals and restoring it again using the restore Journals.

I have one more question here, do we need to always remove all the journals and then restore?

Regards,

Happy

[former_member186338]

"do we need to always remove all the journals and then restore" - Yes! And that's why restore can't be used for loading new journals.

I have written about it number of times, but nobody want to search.

"To load new journals from text file you need to develop your own badi."

P.S. Please accept the correct answer.

[former_member186338]

P.P.S. And images in the question not corrected...