Dynamics 365 Great Plains
Microsoft Dynamics GP Workflow Approval SQL Views: Payables Transactions
This post is part of the Microsoft Dynamics GP Workflow Approval SQL Views series and contains a SQL view to return the workflow approval…
Tag: SQL
Dynamics 365 Great Plains
Microsoft Dynamics GP Workflow Approval SQL Views: Series Index
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…
Dynamics 365 Great Plains
SQL View to Return Accounts Assigned to Inventory Item Classes in Microsoft Dynamics GP
I was writing a report pulling data from the Inventory Control module of Microsoft Dynamics GP the other day and I needed to include…
Finance & Operations
Date format issue in ‘Execute a SQL Query (V2)’ logic apps – D365FO integration
I had already explained about using sql query execution in my earlier blog posts. Recently I had another issue when using date column in…
Dynamics 365 Business Central
Export SQL data to CSV or XML File via Powershell
Export SQL data to CSV or XML File via Powershell Sometimes it may be useful or necessary to use powershell to read data from…