What is the best way to do this in GP 2010?
Void the transaction and re-enter it with the correct date.
** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **
Frank E. Hamelly, MCP-GP, MCP-AX, MCITP, MCT, MVP
Sorry Frank, but is it possible to void a payables transaction that is in history?
Yes, under Payables Transactions, select Void Historical Transactions. You'll have to void the payment first, then void the Invoice, then re-enter the Invoice, re-enter and apply the payment. I would use Manual Payments to re-enter the payment so you don't have to create a second check. One thing to consider is if the Payment has already been reconciled in Bank Rec. If so, you might want to reconsider whether it's worth it to do all this just to change an invoice date.
I suppose editing the invoice date via SQL is no-no?