Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

same PO active and in history

(0) ShareShare
ReportReport
Posted on by 30

Hello, Im having issues with a PO, same PO appears as open and history, the PO is nowhere in Purchas order entry, it only shows as active, when I do the search in purchase order document.

pastedimage1570463873197v1.png

Categories:
  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: same PO active and in history

    That will do it. May I suggest you run IV Reconcile to insure IV quantities are correct. Were you in the process of Removing Completed Purchase Orders when this happen?

  • Virgilio Profile Picture
    30 on at
    RE: same PO active and in history

    thank you Richard, I'm leaving this for future reference, might help others.

    someone else helped me, otherwise I would have never know that the PO had to be deleted from the POP below.

    SELECT * FROM POP10100 WHERE PONUMBER = ''

    SELECT * FROM POP10110 WHERE PONUMBER = ''

    SELECT * FROM POP10150 WHERE POPNUMBE = ''

    SELECT * FROM POP10160 WHERE POP10160.PONUMBER = ''

    then Delete

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: same PO active and in history

    When you go to Edit PO's, what is the status of this PO? If it is closed and all receipts exist. you will need to delete the open using SSMS.

  • Virgilio Profile Picture
    30 on at
    RE: same PO active and in history

    I did reopened and closed the PO and still the same.

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 565

#2
Martin Dráb Profile Picture

Martin Dráb 536 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 402 Super User 2025 Season 1

Product updates

Dynamics 365 release plans