A couple of years ago, I posted a SQL view which returned the status of general ledger batches.
I’ve recently been working with a few clients with workflow in Purchasing and a common request was being able to report on the status of documents.
I have three views which were created and which I will post over the next few days. If I create additional ones in future, I’ll tag them into this post.
| Microsoft Dynamics GP Workflow Approval SQL Views |
|---|
| Show Workflow Approval Status of posted Microsoft Dynamics GP General Ledger batches |
| Payables Transactions |
| Purchase Requisitions |
| Purchase Orders |