Quick Journal reappears after it is deleted

(0) Share

Report

Posted on by Community Member

We have several Quick Journals from several months ago that need to be removed. I've tried deleted them from GP and from SQL. They continue to reappear within a day. Any ideas??

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!

Are they Saved or Posted quick journals ?

Which tables did you consider ? Saved quick journals can be found in GL10100 and GL10101

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

They are saved.

I removed records from sy00500, GL10100 & GL10101.

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!

Scott

You are absolutely on the right track, those are the tables which you need to hit for a saved quick journal (GL10100 and GL10101)

Once posted, you need to check [GL20000] and [PJOURNAL] tables. I believe your delete statement may have caught incorrect records, please recheck.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!

ScottMS

What is the status, is this resolved ?

Was this reply helpful? Yes No