Journal List after restore has only one line

[former_member372]

10.1 NW  Consolidations

After a copy/restore from QA to Dev the restore went without issues. UJBR

The number of journals is 334 in both systems but on the Journal List only 1 line - one journal displays.  We've checked the Journal Parameters and it is set to 0 to show all journals.  We've tried changing it to 200 still only 1 line shows.  We've changed it back to 0 - still only one line shows.

Also the one journal that does show is empty.  The content of the journal is not there anymore. 

Thank you

[former_member372]

[former_member186338]

Instead of Show Journals: Context can you try filter with an empty criteria?

[former_member186338]

I am talking about:

[former_member372]

Still only one line and when I create an Advanced Query it only shows one line

[former_member186338]

Advanced Query without any fields?

[former_member186338]

Then in SAP GUI using transaction SE16 please check tables UJJ_*

[Former Member]

Hi Joyce Butler,

Below URL provides you to export the journal only.

https://www.column5.com/blog/journal-import-and-export-setup-steps-part-1

Hope this helps to resolve the issue.

Regards,

Raj

[former_member372]

Thank you Raj.  From the documentation of the UJBR the Journal List should not copied with the restore.  What you provided is a way to get around the problem which is helpful.  We want to understand why the restore did not do what it was suppose to do.  What did we need to add to our activities during the restore process or do I need to put in a support message. 

[former_member186338]

Do you have the same core BPC SP level on QA and Dev?

If not sometimes strange things can happen...

[former_member372]

The two systems were in sync for SP levels at the time of the copy from QA to restore to Dev.  After the restore two weeks later we started the upgrade activities for Dev.  That's when we noticed the Journal List of blank except for one line item.  So we don't know if the restore had an issue or if the upgrade to 10/1 has the issue.  When you look at the count of Journals you still get 334 in both systems.  It is just the Journal List only shows one line in Dev

[former_member186338]

Sorry, but where do you see this 334 number?

May be some screenshots?

[former_member372]

I've attached two screen prints.

Doing research I've seen issues with lists when you change the model but I don't see a note or anything on SCN with this issue.  The Model defaults to the delivered model Consolidation out of the box.  You have to change the model to the Legal Consolidations for Nexeo Solutions.  That is the we use and where the journal entries are created.