Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Moving few POP entries from History to OPEN

(0) ShareShare
ReportReport
Posted on by 5

Hi,

I would like to inquire if there is a way to move the completed PO from history to open since the procedure was accidentally run by a user. 

The PO status was changed by a user to cancel and then the procedure "Remove Completed Purchase Order" was run as well.

I hope there is a way to move back the PO from history to open

Categories:
  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Moving few POP entries from History to OPEN

    You would need to write SQL scripts to bring over the POP10100 and POP10110 tables. Then you would need to remove then from the POP30100 and POP30110 tables. Did any receivings occur off those POs? After moving them you will need to run IV Reconcile. You will also need to change the status of these two tables back to either new or released.

  • Moniong Profile Picture
    Moniong 5 on at
    RE: Moving few POP entries from History to OPEN

    Hi Richard,

    The POs are a bit plenty, about 20 POs at minimum.

    In SSMS, I just need to find the PO number in the history table and then cut it then append to the open table?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Moving few POP entries from History to OPEN

    You will need to use SSMS to accomplish this plus you will need to run IV reconcile. Can you simply enter a new PO to replace this?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans