Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

I want to know why Closed POs

Posted on by 60

I am trying to zero out any old, open POs, all are 2+ years old. I'm trying to close them with a zero balance. Some of the POs, have a Standard, a Shipment, but no invoice. They have somehow been Closed, without being invoiced against. Which means they're closed with a balance. Is there a way to reopen the PO, or otherwise remove the balance still existing on the PO?  DinarRecaps.com

Categories:
  • RE: I want to know why Closed POs

    Try this in your test system first.

    Use SQL to change the PO to a status other than closedThe tables are POP10100 and POP10110. You'd need to update the PO status and Line Status columns in the two tables. Run a Reconcile on the PO and you should be able to invoice 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…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans