AP - Unapply a check or edit invoice date?

[JRHollywood]

Hello, I'm a new user to great plains.
I have someone who entered an invoice into GP with a 2009 (should be 2005) date. She then cut a check, and applied it to this invoice.
Now on the AP aging it shows the payment as a credit, but doesn't reflect the invoice. We want to fix it as easy as possible.

Someone suggested unapplying the check, fixing the invoice, then reapply the check. Is this possible? If not, whats the best way to go about fixing it?

Thanks in advance, Im sure I'll be a regular!

 

[Luvsql]

You could just update the dates using a sql script against the company database (input voucher number):

update pm30200 set docdate='XXXX-XX-XX' where vchrnmbr=''
go
update pm30300 set aptodcdt='XXXX-XX-XX' where vchrnmbr=''
update pm30300 set docdate='XXXX-XX-XX' where vchrnmbr=''
update pm30300 set date1='XXXX-XX-XX' where vchrnmbr=''

 

[stef315]

The way a user would have to do it is to void the check, void the invoice, re-enter the correct invoice, then re-enter the check with a dif number like 1005B or something (provided you are now allowing duplicate check numbers). You won't be able to void the check if it's been reconciled though.

Anyway, I'm not saying Luvsql's way won't work, just that this is a possible way within the program.

 

[JRHollywood]

Thanks. Yep your right Im just a user so I'll have to go the void route. Thanks!