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
What changes do you want to make to the PO?
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (