Announcements
No record found.
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.
I did reopened and closed the PO and still the same.
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.
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
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?
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 426 Most Valuable Professional
CU10121822-0 358
André Arnaud de Cal... 353 Super User 2026 Season 2
