Purge records in pl_journalPDFlog

Question

Good morning. Does anyone know of utilities to purge records from the pl_journalPDFlog or to rebuild these files? Over time this file gets fairly large. Can the log be purged without deleting the PDF files? 
 
 Thanks so much.

Kevin M · Accepted Answer

I don't know why I never noticed this before... possibly a new feature (image below is v2023).

rclowe · Answer

Haven't thought about this. I suppose you could use the Link Maintenance Utility, sort by date and then select from the oldest until a certain date and then delete them. If you make a copy of the PDF directory then you'll always have the PDFs. 
 If you review other posts regarding this utility, as well as the Paperless Office Viewer, you will see that they are very clunky programs and prone to memory overloads and crashing, but it might be worth a try, in small bites.

Kevin M · Answer

If the reason you are asking is slow load times for the Paperless viewers, make sure you disable all the "Load Data..." options, and enter narrowed filters before clicking Refresh. 
 
 In addition to rwclowe's tip of using Link Maintenance, you should also be able to delete rows using the Paperless Viewer programs... and if you move the PDF's to an archive sub-folder before doing so, there should be no risk of them being deleted.

Sage 100

Purge records in pl_journalPDFlog

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING