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

Views (1206)

Belinda Allen

2,652

Like(0)

Report

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.

This video shows how I use this view to build a quick Microsoft Dynamics GP Payables Management Aged Trial Balance in a few minutes.

If you haven’t visited Victoria’s blog, you should. It can be found @ http://victoriayudin.com/ and this view in particular @ http://victoriayudin.com/2008/11/28/sql-view-to-show-all-gl-distributions-for-ap-transactions/.

Thanks Victoria for sharing your hard work!

Belinda, from Smith & Allen Consulting, Inc. in New York City, uses a view by fellow Microsoft MVP Victoria Yudin to create a Payables Aged Trial Balance in Excel for Microsoft Dynamics GP.