Sage 100

Sage 100 v2016 PU2 --- customer asks - ""Is there a utility to make past bank recon checks cleared show up in the new AP feature for cleared checks with date?"" Apparently, this relates to the feature added in Sage 100 v2013 upgrade which will show cleared check info in the AP Vendor Maintenance - but **only for checks entered in 2013+** Customer question is whether there's a utility to get checks into this screen that were entered prior to 2013. Has anyone dealt with this before or seen a utility that can accomplish this (I'm aware of VI so I guess I'd need the data table that would have to hold this info if VI were the only option).

It appears that the check history header table holds the cleared date and the cleared flag. So you ""should"" be able to VI the data into it. Unless they are VI savvy, I doubt that they will want to once they understand the cost of doing it.

but... how will you know the check ""cleared date""?

Since BR doesn't retain history, what would be your source file for cleared date?

Good point - I think you could set the ""Y"" flag but the cleared date is probably going to have to be some random date that you agree on.

Their problem. I would check the bank's web site to see how far back history is available. Maybe they download the data into Excel? And why would they even care about the data from three years ago?

More relevant question to ask is ""are they importing the cancelled checks using the BR import feature?