web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Changing PO Status
Microsoft Dynamics GP (Archived)

Changing PO Status

(0) ShareShare
ReportReport
Posted on by Daniel Panth 110

Dear all, 

How can i change PO status from 'released' to 'new' after printing the PO in 'Microsoft Dynamics GP 10'

as i want to make changes to po

through functionaly only.

Regards,

Daniel.

 

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Daniel, I believe that change will have to be made directly in the tables.  No way to do that through the UI that I'm aware of.

  • Community Member Profile Picture
    Community Member on at

    Hi Daniel,

    The only way to change the status is in the backend by updating the tables as said by Frank

    The following update script should fix it.

    update pop10100 set postatus = '1' where PONUMBER = 'PO NUMBER'

    Just update the PO NUMBER and you will have the PO Status changed to New from Released.

    Regards,

    Paul

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    DONT DO THAT!  Remark the PO as New after it has been printed.  During the printing process the quantity on order is updated in the item cards.  Changing the flag in the PO via sql will let you print/release the PO again and again increase the on order quantity.  You will get these numbers out of sync and be required to run reconcile to fix them.

    You can edit a released PO and reprint it.  This pushes your changes down properly.  You cannot delete a printed line but you can change the quantity ordered to 0. 

     

    You might want to look at our Understanding Purchase Order Processing or Information Flow and Posting books to understand these processes better.  Check out our web site.

  • Community Member Profile Picture
    Community Member on at

    What changes do you want to make to the PO?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans