Skip to content


New Release of the Inclusion of Dynamic Aged Trial Balances within SmartView

A quick google search on term ‘GP aged trial balance’ indicates what a critical reports ATB’s for all those people that use Dynamics GP every day.

So now to share some exciting news in the world of Dynamics GP Aged Trial Balances. Please note that Trial Balances are only available inside of GP at this time. Releasing this week will be the inclusion of dynamic Aged Trial balances within eOne’s SmartView reporting tool. Let me run through a few of the things that make this an awesome addition to every Dynamics GP installation.
1. Super easy and flexible filtering: SmartView lets you filter on anything.  

  • If you look at the list above it contains many $0 balance customers. To filter these out you simply drop down and select the values you want. No need to rerun the report – just check a box.  
  • This works the same for any column of data where you can filter on those with a 30 day balance, or filter by a territory, salesperson or any other related field. Giving you a really flexible ATP on the fly.

2. Ability to Re Age your ATB: Anytime based upon any date you enter. No need to run any background GP processes – simply change the date.  

3. Auto Grouping: Auto grouping and expansion to see all the outstanding transactions in your selection. This ensures you can start with balances and drill to the details on the particular records you need to see.

4. Drill Down: To the detail in GP via the GOTo’s.
5. Grouping and totaling by any field you choose: In this example, we have grouped the ATB by SalesPerson. Subtotals are auto displayed on the screen and each group can be expanded or closed.

6. Find: CTRL F for "find" lets you find any value anywhere in the ATB. 

7. Export the report to: Excel, CSV or PDF. When you export it keeps the formatting you have on screen. 

8. Cut and Paste: This is the coolest. Simply cut and paste any selection of records, sequential or not, using CTRL C and CTRL V to paste to Excel or Outlook or anywhere you choose.

Interested in learning more about SmartView? Email for more!

Leave a Comment


Q1 2023 All Hands Call
2023 Advanced SmartConnect Bootcamp: REST Web Services Integration
Accessing Your Historical Dynamics NAV Data in D365 Business Central - Part 1: Getting Started
2023 Migration from Dynamics GP to D365 Business Central Training
eOne Welcomes Incremental Group as a New eOne iPaaS Integration Partner


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.