Tag: SQL Server

Dimension Analysis for MDA – SQL View for Microsoft Dynamics GP — GP Life Hacks

I LOVE MDA and apparently, so does Microsoft Dynamics GP MVP, Shawn Dorward.  checkout his blog post below.  He gives away a free MDA SQL View.

I LOVE MDA and apparently, so does Microsoft Dynamics GP MVP, Shawn Dorward.  checkout his blog post below.  He gives away a free MDA SQL View.

Earlier I wrote about how to use MDA for dimension analysis rather than Analytical Accounting. You can find that blog here. To continue that thought, I have created a SQL view to help users get that dimensional analysis data easily! The script captures commonly used data – if you feel I am missing something, please…

Continue reading “Dimension Analysis for MDA – SQL View for Microsoft Dynamics GP — GP Life Hacks”

Mark Polino asks: “Who needs a vacation?”

Historical Excel Reporting for Dynamics GP. Users of Historical Excel Reporting…

I’m telling you, this tools is cheaper than building it yourself.

It’s April and spring keeps trying to break through. If you aren’t thinking about vacation, you haven’t been cooped up long enough. Once you start thinking about tropical beaches and drinks with umbrellas in them, how do you find the time? One option is Historical Excel Reporting for Dynamics GP. Users of Historical Excel Reporting…

via Who needs a vacation? — DynamicAccounting.net

 

 

Introducing Microsoft Dynamics GP OData Version 4

Thanks Mark, I am going to be testing and playing with the new OData this week, so this was timely!  🙂

Introducing Microsoft Dynamics GP OData Version 4 – Microsoft Dynamics GP Community The original OData release had a few issues so it’s nice to see ongoing updates with this feature. The post Introducing Microsoft Dynamics GP OData Version 4 – Microsoft Dynamics GP Community appeared first on DynamicAccounting.net.

via Introducing Microsoft Dynamics GP OData Version 4 – Microsoft Dynamics GP Community — DynamicAccounting.net

Using Microsoft Excel to create a Dynamics GP auto refreshing report (Video)

Last week, a Microsoft Dynamics GP User (Glenda) asked about making an Excel Refreshable Report refreshable.  She not only wanted the table to refresh, but she wanted the associated PivotTable to refresh as well. 

Last week, a Microsoft Dynamics GP User (Glenda) asked about making an Excel Refreshable Report refreshable.  She not only wanted the table to refresh, but she wanted the associated PivotTable to refresh as well.

Microsoft Dynamics GP User Group.

Continue reading “Using Microsoft Excel to create a Dynamics GP auto refreshing report (Video)”

Microsoft Dynamics GP SOP, Which Status Field to use when building reports

When creating reports using Microsoft Dynamics GP Sales Order Processing (SOP) data, there are 8 potential status fields.  Watch the following video to see an explanation of these 8 fields.  In the video, Belinda uses Microsoft Excel and Get & Transform (the tool formerly known as Query Editor to review the SalesLineItems view in GP.

When creating reports using Microsoft Dynamics GP Sales Order Processing (SOP) data, there are 8 potential status fields.  Watch the following video to see an explanation of these 8 fields.  In the video, Belinda uses Microsoft Excel and Get & Transform (the tool formerly known as Query Editor to review the SalesLineItems view in GP.

Since the Early 80’ Microsoft Dynamics GP has been an ERP industry leader.
Since the Early 80’ Microsoft Dynamics GP has been an ERP industry leader.

Continue reading “Microsoft Dynamics GP SOP, Which Status Field to use when building reports”

Creating a Microsoft SQL Server view from 2 Microsoft Dynamics GP Databases (Video)

In the following video I will show how to create a single Microsoft SQL Server View using 2 Microsoft Dynamics GP databases.

Someone reading my book asked me the following question:

Do you know or can point me in the right direction on how to join or union other company databases? For example we have 4 companies with separate databases and these queries will only pull from one company at a time

In the following video I will show how to create a single Microsoft SQL Server View using 2 Microsoft Dynamics GP databases. Continue reading “Creating a Microsoft SQL Server view from 2 Microsoft Dynamics GP Databases (Video)”

Microsoft Dynamics GP – Inventory Item Reorder Dashboard (with video)

This is part 4 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Originally Posted 11/25/2013

This is part 4 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Continue reading “Microsoft Dynamics GP – Inventory Item Reorder Dashboard (with video)”

Microsoft Dynamics GP – Excel Power Pivot SOP Dashboard (with video)

This is part 3 of a 7-part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Originally Posted 11/18/13

This is part 3 of a 7-part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

Continue reading “Microsoft Dynamics GP – Excel Power Pivot SOP Dashboard (with video)”

How to track changes in Payroll in Microsoft Dynamics GP (with video)

Every time I teach a GPUG (Microsoft Dynamics GP User Group) Payroll training class I am asked about how changes to payroll records can be tracked. In this video, I show you how!

Originally Posted on August 9, 2013

Every time I teach a GPUG (Microsoft Dynamics GP User Group) Payroll training class I am asked about how changes to payroll records can be tracked.  In this video, I show you how!

Continue reading “How to track changes in Payroll in Microsoft Dynamics GP (with video)”

AP aging in Excel thanks to Victoria Yudin in Microsoft Dynamics GP

A GPUG (Microsoft Dynamics GP User Group) member was asking about building a report in Excel that displayed open payables that actually matches GP.  There were several great responses to his question, but now I want to add my two cents!

A GPUG (Microsoft Dynamics GP User Group) member was asking about building a report in Excel that displayed open payables that actually matches GP.  There were several great responses to his question, but now I want to add my two cents!

My Friend and fellow Microsoft MVP, Victoria Yudin has made this process a lot easier for you.  She has a SQL view that will organize your open payables and age them for you.

A GPUG (Microsoft Dynamics GP User Group) member was asking about building a report in Excel that displayed open payables that actually matches GP.  There were several great responses to his question, but now I want to add my two cents!

Continue reading “AP aging in Excel thanks to Victoria Yudin in Microsoft Dynamics GP”