O'Reilly logo

Real-world Business Intelligence with Microsoft Dynamics GP by Mark Polino, Belinda Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Sharable aged trial balance

This is by far the most common report we are asked to deliver in Excel. Every AP department uses this report to help determine which vendors need to be paid and which vendors need attention. It's also a favorite request of the auditors. There is a nice version of this report in GP; however, it requires being logged in, and it's not (easily) exportable to Excel. We see many organizations wanting this report in Excel, so they can use Excel features to review large amounts of data effortlessly.

Brief background of the company

This report is for all companies. It allows sharing the ability to generate an aged trial balance, regardless of who can and cannot log into GP.

Pain or goal defined

It is difficult to set up GP so that ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required