Announcements
No record found.
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.
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.
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.
My apologies, I was thinking Payables Management. You can use PSTL to move historical Receivables Management transactions to OPEN.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 528 Most Valuable Professional
André Arnaud de Cal... 424 Super User 2026 Season 2
CU10121822-0 374
