Share
ReportIs there a way, other than going into SQL, that I can close a group of open PO's?
thanks!
*This post is locked for comments
You’re offline. This is a read only version of the page.
Is there a way, other than going into SQL, that I can close a group of open PO's?
thanks!
*This post is locked for comments
I wish there was. I create a smartlist for the open purchase orders , then run the following macro (GP2010)
# DEXVERSION=11.00.0359.000 2 2
CheckActiveWin dictionary 'SmartList' form 'ASI_Explorer' window 'ASI_Explorer'
MoveTo field 'ASI_GoTo_List' item 1 # 'View'
ClickHit field 'ASI_GoTo_List' item 4 # 'Edit Purchase Order Status'
NewActiveWin dictionary 'default' form 'POP_Edit_PO_Status' window 'POP_Edit_PO_Status'
ActivateWindow dictionary 'default' form 'POP_Edit_PO_Status' window 'POP_Edit_PO_Status'
ActivateWindow dictionary 'default' form 'POP_Edit_PO_Status' window 'POP_Edit_PO_Status'
ClickHit field 'PO Status' item 2 # 'Closed'
MoveTo field 'Process Button P'
ClickHit field 'Process Button P'
I prefer to use macros in situations like this.
redbeardblogging.blogspot.com/.../how-to-create-and-run-simple-macro-in.html
Hi Jeanne!
I have actually seen this question a few times pop up in cases. Unfortunately as Mahmoud has mentioned there is no way to quickly close a group of open PO's. You would have to use the "Edit Purchase Order window" for each individual PO this is the support method. An unsupported method would be going into the SQL tables and updating them.
I do however recommend creating a product suggestion for this if one has not already been submitted as I do believe that this would be a great product suggestion. Our development team looks at the suggestions for features to add to future releases. Here’s the link to the suggestion page.
connect.microsoft.com/dynamicssuggestions
If you do create a product suggestion please post the link so others can vote on it as well.
Best regards,
~Thomas Newcomb
------------------------------------------
Microsoft Dynamics GP Support
------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
The SQL method is absolutely the quickest but it would not give you the validation provided on the application level. I would go for a Macro tool on the "Edit Purchase Order window" to achieve such target, in this essence, the available status to which it can be changed shows up according to every purchase order case, such as fully received and invoiced or still partially received ...etc
I have considered both methods, it still depends on how much you are aware of the data to be manipulated.
Your feedback is highly appreciated,
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (