Void check with date of 2008

[lingtring]

The girl in charge of accounts payable registered a check with the date of 09-27-2008, but now that I want to void it I can't, what can I do with this?

I know that the table CM20200 has the check register, but i'm not sure if I change it here it will have some odd effects later.

I am on GP V-8

 

[lingtring]

Any suggestions?

 

[PTina]

I think you may need to remove history for the transaction:

Tools --> Utilities --> Purchasing --> Remove Trx History

 

[lingtring]

Wouldn't that only remoive the Historical of the transaction but keep the check in question sitting there with a date of 2008? and not voiding it or removing it?

 

[PTina]

I'm not absolutely sure - I'm currently trying to test it myself as one of my users has the same problem. As there is no way to void it in GP; removing history seems to be the only other option.

Removing history should make it appear as if the transaction was never done.

Since its a check, history will need to be removed for the invoice as well as the invoice is already in history and removing history will not make it open again.

I'm expecting this to allow us to rekey the invoice and cheque.

I would suggest testing it in the test company before trying to do it on the live and make sure you have a working backup before doing it on the live database.

 

[lingtring]

What I have done, on the test company, is to edit it directly on the Data Base, and everything seems correct, it shows on the bank conciliation, on the checkbook with correct dates. But I'm not sure if it has some other issues that I maight have overlooked.

 

[PTina]

That's not a bad idea, however I'm very cautious about changing dates in the files as this can totally mess up the system if you're not absolutely certain of all the tables and fields that you need to update.

I think I'm just going to remove the cheque and invoice and have the user redo them.