That's a weird one

The date of clearing was added into the program roughly four years ago.  Only checks printed after that upgrade would show that they had been cleared as the bank rec was done. So that would explain the old checks not showing as being cleared.

My first question would be are you sure that you want to clear out vendors that have been paid that recently?   Typically for IRS purposes you want to keep records seven years.

However, eventually seven years will roll around and this will be an issue anyway.  This might be an oversight in the programming.  It makes sense not to allow deletion of a vendor with TRUE outstanding checks, but these aren't TRUE outstanding checks.

I haven't spotted any specific references to this so I'm making some guesses you can try on a BACKUP OF YOUR DATABASE.

1.  Have you tried the Delete And Change Vendors utilities in A/P Utilities?   Be extremely careful with this utility as you can accidentally delete a lot more than you want.

2.  In A/P Utilities try Purge Accounts Payable History.   This unfortunately would purge it for all vendors.

3.  Use of Data File Display and Maintenance to set the cleared flag on the checks to Y.   You might have to set the date cleared flag as well.  Painful at the least.

4.  Use Visual Integrator to effectively do the same thing.

Hi Tom, thanks for your time. These ideas sound promising. I like the idea that I could use a VI job since I have several hundred vendors each with multiple checks showing "uncleared."  Are you saying I can use a VI Job to change flags in DFD/Maintenance on specific checks? If so, can you tell me which VI Job template I would use? 

...or...did you mean to suggest I use a VI Job for another of the suggested approaches?

just to clarify, the vendors i want to delete have had no activity at all for the last 7 years. The checks showing as "uncleared" are quite old

thanks again for your help!

Based on everything being more than seven years,  I would start with testing the purge a/p history theory (#2) on a backup database.  Probably the most promising if it works.

Regarding using of VI,  there wouldn't be any precreated templates,  you would have to create them.