Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

same PO active and in history

Posted on by 6

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
    Richard Wheeler 75,730 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
    Virgilio 6 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
    Richard Wheeler 75,730 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
    Virgilio 6 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

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,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans