I have some invoices that are entered in the system with invoice dates that are future dates. The invoices have been paid and are closed. However they still show up on my historical aging. How do I get rid of these?
Linda Tanner
*This post is locked for comments
Dumb question, what is the SQL? I had very little training as to the functions on G.P.
Within GP you would have to void the payments to these invoices, then void the invoices, then re-enter the invoices with the correct dates and then enter credit memos to move these invoices back into history. You would do this while you have turned off posting through the ledger as you do not want these transactions to hit your ledger. You may want to look into loading the Document Date Verify available in the PSTL. If you have access to SQL you could also adjust the dates in the historical payables tables.
Share
Report
All responses (
Answers (
75,848