I am new to Jet Reports and have created some simple reports. We have several financial reports that reflect numerous accounts that are consolidated on a single row.
I would appreciate any suggestions of where to look for the help topic in this community or how to handle this issue.
Thank you.
Hello Patricia -
The Jet functions give you a great deal of control over what information you present and how you do it.
The GL function for both Dynamics GP and NAV can be used to reflect data from a single or multiple GL accounts.
This simple snapshot shows four different ways that data can be treated:
The first list show all accounts in a particular range (a combination of both posting and totaling accounts) along with the balance of each.
The next list is filtered to show only posting accounts and their balances.
The third example shows how to use a single function to return the same total as is present in the second.
Finally, the last example shows how to pick and choose which accounts you would want totaled by the GL function.
In each case, the NAV GL function would simply look like:
=GL("Balance",C4)
I hope that helps.
