Microsoft Dynamics ERPs are user friendly and cost effective ERP Systems for your organisation, with the help of Microsoft Dynamics ERPs small and medium sized organisation can automate their existing processes and bring efficiency to their businesses. Be a follower in order to get more tip and tricks directly in your mail box.
With advancement in Microsoft Office Tools, Dynamics ERPs always have new features to enjoy, In my previous posts i have discussed how Excel reports could help non technical users to extract easy information in form of Excel File from MS Dynamics GP.
Technical Users can just write SQL Queries and will be able to get results via Excel File, in this method files are automatically/manually refreshed.
To Enter SQL Query, Extract one excel file from MS DYNAMICS GP UNDER EXCEL REPORTS in order to get default connection settings. Once you get the data from default report make a backup of that report and use it every time for new reports.
To Enter SQL Query,
Within Excel > Data Tab > Connections > [Select the Connection] Properties > Definition Tab > Enter Query in Command Text
Click ok, Click Refresh All.
Some Basic Queries you can work with,
SOP Transaction [ Both from Work and History Table ], this query helps you track where document exist and what's the status of the document.
INNERJOIN SOP10200 ON SOP10100.SOPNUMBE = SOP10200.SOPNUMBE
AND sop10100.soptype = sop10200.soptype
SELECT'History' DataType ,SOP30200.SOPNUMBE,
INNERJOIN SOP30300 ON SOP30200.SOPNUMBE = SOP30300.SOPNUMBE
AND SOP30200.soptype = SOP30300.soptype
Excel Based Dash Board
With some basic Excel Skills you can design you own customize dashboards, look at this example.