Skip to main content

Notifications

Microsoft Dynamics GP forum
Unanswered

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

Posted on by 20

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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    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 Profile Picture
    Mirza Adnan 20 on at
    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 Profile Picture
    Richard Wheeler 75,730 on at
    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.

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.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans