We accidentally posted an invoice (SO) to AR for 8/7/08.  Then we thought we could fix it by changing the date in GL-O to the correct date of 8/7/08.  Of course, this didn't work.  Now we have it in AR as 8/08 and posted on the GL as 8/07.  How can I fix this?

HI, I changed the BKARHINV but the invoice is still showing up in 2008 instead of 2007.  What other files do I need to change the date?

Quote from Lynn_Pantic on 08/14/07 at 07:31:29:

 
 
Don't you just wish you had access to triggers and rules within the database?

Ok, maybe I'm hormonal and can't focus clearly but I'm not getting this.
 
I voided invoice in 2008 (the wrong one)
I left the AR portion in 2008 (as I did when I posted it the first time)
I changed the date to 2007 in GL-P before posting (as I did on the first time)
 
My GL account for sales is high by the amount of the invoice if I compare 2007 gl to 2007 ar aging.  If I compare 2007gl to 2008 ar aging, I am fine.  
 
When I look in AR-F, the only dates left on the customer account are 2007 (the 2008 have been voided).  So why am I not balancing 2007 gl sales to 2007 ar aging?
 
Thanks,
J