Is it possible to move HIST status SOP Invoice to OPEN status?

(0) Share

Report

Posted on by Mirza Adnan

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.

Categories:

Microsoft Dynamics GP

All responses (3)

Answers (0)

Richard Wheeler 75,730 on at

Like (0)

Report

RE: Is it possible to move HIST status SOP Invoice to OPEN status?

My apologies, I was thinking Payables Management. You can use PSTL to move historical Receivables Management transactions to OPEN.
Mirza Adnan 20 on at

Like (0)

Report

RE: Is it possible to move HIST status SOP Invoice to OPEN status?

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.
Richard Wheeler 75,730 on at

Like (0)

Report

RE: Is it possible to move HIST status SOP Invoice 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.