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”

Microsoft Dynamics GP User Group (GPUG) Tech Tips Exert

Below is an exert from a future “Tech Tips” that I wrote for the Microsoft Dynamics GP User Group (GPUG) to send to it’s members.  If you are not a member, you should review membership. 

Originally Posed 1/23/13

Below is an exert from a future “Tech Tips” that I wrote for the Microsoft Dynamics GP User Group (GPUG) to send to it’s members.  If you are not a member, you should review membership.

 

Continue reading “Microsoft Dynamics GP User Group (GPUG) Tech Tips Exert”

Microsoft Dynamics GP Purchase Order Approvals

OK, so you are using Microsoft Dynamics GP with the Purchase Order Enhancement “Approvals” but now you want to see “unapproved” Purchase Orders in SmartList.  What do you do?

OK, so you are using Microsoft Dynamics GP with the Purchase Order Enhancement “Approvals” but now you want to see “unapproved” Purchase Orders in SmartList.  What do you do?

Originally Posted 1/4/2013

NOTE:  This is using eOne’s SmartList Builder Tool

OK, so you are using Microsoft Dynamics GP with the Purchase Order Enhancement “Approvals” but now you want to see “unapproved” Purchase Orders in SmartList.  What do you do?

Continue reading “Microsoft Dynamics GP Purchase Order Approvals”

Microsoft Dynamics GP Metrics Dashboard

You would not drive your car without a dashboard, why do you drive your business without one? Using Microsoft SQL Server Reporting Services with Microsoft SQL Server 2008 and Microsoft Dynamics GP 2010 R2, will give you a dashboard with the click of 1 box. No kidding, watch me do it in this video! 

Originally Posted 8/3/2011

You would not drive your car without a dashboard, why do you drive your business without one? Using Microsoft SQL Server Reporting Services with Microsoft SQL Server 2008 and Microsoft Dynamics GP 2010 R2, will give you a dashboard with the click of 1 box. No kidding, watch me do it in this video!

Home

Continue reading “Microsoft Dynamics GP Metrics Dashboard”

Microsoft Dynamics GP FRx Sales Report

This video shows how I use FRx to create Operational Reports, such as a Sales Report from Microsoft Dynamics GP data. I build it from scratch so you can see each step along the way. 

Originally Posted 7/12/11

This video shows how I use FRx to create Operational Reports, such as a Sales Report from Microsoft Dynamics GP data. I build it from scratch so you can see each step along the way.

Continue reading “Microsoft Dynamics GP FRx Sales Report”