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 |
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.
Looking for support or consultancy with Microsoft Dynamics GP?
I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.