O'Reilly logo

Building Dashboards with Microsoft Dynamics GP 2016 - Second Edition 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

Jet Express for GP

There are two additional features we'd like to share regarding the GL function for building any financial statements using Jet Express for GP. One feature can eliminate a potential problem, while the second adds cool functionality to refreshing reports. Let's dig into these now.

Eliminating values that should be zero

Occasionally, when referencing categories or accounts that have no transactions and, therefore, a zero balance, Jet may display an amount because it doesn't know what to do if no transactions exist. This is easy to correct and/or prevent.

In the following example, we have built a report that displays the account number, account description, and the amount for two account categories. The first category is Cash and the ...

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