web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Quick Journal reappears after it is deleted

(0) ShareShare
ReportReport
Posted on by

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)
  • Mahmoud Saadi Profile Picture
    32,738 on at

    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,

  • Community Member Profile Picture
    on at

    They are saved.  

    I removed records from sy00500, GL10100 & GL10101.

  • Verified answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    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,

  • Mahmoud Saadi Profile Picture
    32,738 on at

    ScottMS

    What is the status, is this resolved ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans