News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... PJOURNAL not being del...

Finance | Project Operations, Human Resources, ...

Unanswered

PJOURNAL not being deleted

(0) Share

Report

Report

Posted on by howieb

50

I have one company whose PJOURNAL is not being dumped. It has remained with 260K records for a long time. Only realizing this because in searching the web for slowness in GP, one of the points is to look at the PJOURNAL table. I can see in the proc that if the REPORT column is TRUE(or 1) the record will be deleted. These 260K records show REPORT = 0.

What does REPORT = 0 mean? Is it bad? I plan to dump the table with the 260K records, but sort of hesitant until I see why those records show that value.

Thanks

All responses Img

All responses (1)

Answers Img

Answers (0)

Jeff Grant on at

Like (0)

Report

RE: PJOURNAL not being deleted

Hello,

As the PJOURNAL content is only needed during the post/print it can be cleared out at any time if it is affecting posting performance. If it is not being cleared out automatically in your environment I would recommend establishing a SQL job to clear it out on a scheduled basis. Regarding the table field definition, as it is not listed in the SDK materials I am not able to locate it, but my assumption is it may be temporarily filled with a '1' during the actual print process.

Best Regards,

Jeff

Dynamics GP Support

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans