You’re offline. This is a read only version of the page.
I am looking for a report that shows my open purchase orders as of 12/31/09. Is there a report out there for this or a Smartlist suggestion?
*This post is locked for comments
How to get PO report on selected 6 suppliers from particular date.
While William's suggestion will give you a list of all POs that existed at 12/31/09, it won't tell you which ones were open at 12/31/09. That's because there is no date recorded in GP indicating when the PO is closed. There is no way to tell in GP when it was closed, only that it is closed.
Likewise, Sandip's suggestion for PO Inquiry - the date range is based on the PO create date, which will provide all open PO documents created 12/31/09 or prior that are still open as of today, but notthose that might have been open as of 12/31/09.
Elizabeth,
Inquiry is available for open purchase order(Inquiry-->Purchasing-->Purchase Order Documents) you can give date range plus report also available in Reports-->Purchasing -->Analysis-->Purchase Order staus.
Thanks
Sandip
You may use SmartList
Dynamics GP > Smartlist > Purchasing > Purchase Order > *
Click "Search" button
Column name : Document Date
Filter : is less than
Value : Enter Date
1/1/2010
Then define enough of Maximum Records (at the bottom)
Click OK
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (