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
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
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,
They are saved.
I removed records from sy00500, GL10100 & GL10101.
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,
Almas Mahfooz
3
User Group Leader