You’re offline. This is a read only version of the page.
6,010
*This post is locked for comments
Ron,
You can purge checkbook data using the 'Remove Bank History' utility in Financial Utilities. You have 3 range options available for selecting the data you want to purge. I would recommend using the 'Reconcile Audit Trail Code' range and using this to select the cleared transactions you want to purge, by reconciliation date.
I'd also run the 'Print Report Only' option prior to actually purging the data so you can review what's going to be purged. I'd then run the purge and print the final report to pdf for archive purposes. I'd also do a backup of the database and archive it just for safe keeping, prior to purging the data.
Browse to the Tips and Tricks section of our web site (in the Learning Center), Look in the Archived Tips and Tricks under System for one titled Increasing Speed via Indexes for information on adding suplimental indexes.
So why have you not purged data? You can purge in segments. You do not need to purge EVERYTHING but you can purge checkbook data back a few years.
If you MUST keep the data, run a SQL log to capture the search keys and then build a suplimental index on that.
Web site is www.AccoladePublications.com
Ron, I've heard that adding an index to the table containing these transactions would dramatically speed the record retrieval. I'm hoping Richard Whaley sees this post because he knows how to add an index to a table.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (