I have a situation where I need to void the payment fully applied to a posted SOP Invoice. Now since I ran the remove paid transaction removal utility in Sales module, both Invoice and payment were moved to HIST from OPEN status. Now when I go and try to void the payment so I can apply the Invoice to another payment, the payment does not show up in Apply Sales Document window (I assume because the payment is sitting in HIST table).
I would really appreciate if someone could help me in how should I remove the payment and Invoice from Historical table to Open status.
My apologies, I was thinking Payables Management. You can use PSTL to move historical Receivables Management transactions to OPEN.
Hi Richard,
No I did not void the payment as I can't because GP won't allow me to since it's in HIST table. I want to void the payment and for that I need to know if there any way I could ask my IT guy to run the SQL query to move the Invoice and payment applied to it from HIST to OPEN status so I can void the payment and apply Invoice to another payment.
Your feedback is greatly appreciated.
The SOP Invoice will remain history no matter what you do. When you voided the payment it is now marked as voided in history. The associated AR document should have moved to OPEN so you can now apply a new payment to it.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148