The customer discovered a free application that removed the check mark from the Cleared check box automatically.  

Hi keyhant. What was the application? Is there a way to do it without the application?

There is a way to select a range of checks to be cleared in the standard Reconcile Bank task. 

I think they wanted the opposite of that

Yes. I am looking for a way to unclear or unreconcile the checks. For instance, if I am out of balance and would like to start over is there a way to mass uncheck them instead of one-by-one.

I read that too fast.  

Perhaps a VI job?

VI as in the Visual Integrator module? Can you please elaborate? I have not used this feature yet to know how it will unreconcile current items.

Thanks!

Visual Integrator is used to import data into Sage 100. 

In theory you could create a VI job to import updates to the BR_Transaction table, including the key fields for the records you want to update, and a new value for the checkbox field. 

Be very careful if attempting to do this, because it is easy to get an import setting wrong, and there is no "undo".  Always test new jobs in a test company.

Visual Integrator is used to import data into Sage 100. 

In theory you could create a VI job to import updates to the BR_Transaction table, including the key fields for the records you want to update, and a new value for the checkbox field. 

Be very careful if attempting to do this, because it is easy to get an import setting wrong, and there is no "undo".  Always test new jobs in a test company.

Would this only work once? For example, if it worked for the set of transactions I needed this time, but I needed to do it again later or for a future month, would I be able to reuse it without changing the import or would it need to be modified for each transaction each time? 

Typically you would specify a data source for your import as a text file / csv, where you could re-use the settings, with a new text file / csv.

That makes sense, thanks. Is there a way to uncheck items without having to import then? By the time I create the file and import it, I think I would be able to manually uncheck it faster. I was just hoping to avoid having to manually do it, but still get it done quickly. 

VI is my only idea, short of a script.

Yes.  There is a way.  You will have to download an app that does this.  I will post the link here to download at your own risk.  Always make a backup before making any changes.