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/2013/04/24/sql-view-for-current-payables-aging-detail-in-dynamics-gp/
Thanks Victoria for sharing your hard work!
Originally Posted 8/5/2013