Is there a way to get a report showing the workflow status of a PO? I don't see anything in SmartList (yes, I looked at all the fields)
Do I have to do this via SQL?
I'm mainly concerned about PO's submitted but not approved/still pending
*This post is locked for comments
Got it - thanks!
It's not a Smartlist. Click on the Purchasing Page and then click on the Purchase Orders Pending Approval Navigation List.
This will open up a navigation list where it will list all the PO's pending approval. You can check the checkbox on the column headers to mark all. Then click Go To and then Excel to send the list to Excel. The navigation list is nice as well because you can directly open up the PO, review, and approve.
Sorry - don't see that report in smartlist anywhere
Have you tried the Navigation List for "Purchase Orders Pending Approval"? You can mark all in that and then send to Excel through the Go To button. I'm sure you could customize something better with SQL but this should give you what you are looking for.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
