AP check reconciliation 1

[salescp]

We just converted to version 7.6.300 and now have almost 700 pages on our AP check reconciliation report (old datea that converted over). we don't want to keep anything before 2005. Is there a way to get rid of all these entries without manually reconciling them thru the system or using sql to either delete them or flag them as reconciled.
Thanks.

 

[NEmacGuy]

In the system you have to reconcil the checks one at a time. Then you can purge the data for reconciled checks in a range by date of check number. If I was in your spot, I would do what you mentioned. I would use a sql update script to flag the checks as reconciled. Before running the script, I would backup my database, then fire away.
Then you could use the natural system to purge. I always figure the level of harm ranges from select (minor), update (major), insert (dangerous), delete (never do - unless gun to the head).

I would update the checkrec_sql file and set recon_dt = 19800101 where chk_dt < 20040101 (You would set this date) and recon_dt is null (this is optional).

Note I have given you the sql to update the data, but you would have to know sql to piece back togther. I didn't think it was a good idea to dirrectly post an update script.
If you know SQL you can put it back togther then you own the script, and the effects there of.

 

[NEmacGuy]

Having already posted, I just wanted to say this is something might want to use a reseller or Exact support for.

 

[dgillz]

What does the upgrade to 76300 have to do with this? Are you saying this was not 700+ pages before?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[salescp]

Thanks a bundle. I was hoping it was a matter of just updating some flag or field. My next step was to see what changed on a record when the check was reconciled, but I'm always reluctant to assume that only one table changes. I know that sometimes there are ramifications elsewhere in the system not are not obvious.
I can do the sql. Thanks again.

 

[NEmacGuy]

You can always run an SQL trace. I have been using it more and more. Clear the log, perform the trx, and get the SQL statement. Or run a report and get the SQL, then past it into crystal and have your report half done.