Does anyone know how to uncheck/unclear/unmark the range of cleared items in Bank Reconciliation without having to do it one by one?
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.
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?
*Community Hub is the new name for Sage City