Skip to content
+1-888-319-3663

EONE BLOG

Need a Better Aged Trial Balance? Check Out SmartView.


There are several different options for printing the Aged Trial Balance for Receivables Management and Payables Management in Microsoft Dynamics GP.

You can print the Aged Trial Balance for Receivables Management and Payables Management within GP and get the data you are looking for, but you cannot manipulate the data easily. You would have to always change the report options to change how you see the data.  

The SQL Reporting Services Reports that Microsoft ships with Microsoft Dynamics GP also have Aged Trial Balances in them. There aren’t as many there, but there are a few. They aren’t the easiest to export to Excel and keep a great format either so you can further “manipulate” the formatting.
  • Paybles Aged Trial Balance – by Document Date
  • Payables Aged Trial Balance Details Subreport – by Document Date
  • Payables Historical Aged Trial Balance
  • Receivables Aged Trial Balance – Detail
  • Receivables Historical Aged Trial Balance 

There are other options out there as well for purchase, but these are the main two I am aware of that come with Microsoft Dynamics GP.  

  I want to propose a better option:  SMARTVIEW



There are many things that make this a much better option, but let me share a few with you.
  • Easy Filtering:  With one check of a box, you can filter out things like $0 balance customers.  You can filter on 30 day balances above a certain amount, sales territories, or any other field you are including in your list.


  • Change Aging Date:  You can easily change the “Age as of Date” to have the list regenerate on the fly.  


  • Show Details:  By default the list runs in Summary, but with the check of a button, it will show the details.  You can expand each customer to see the detail.  You don’t have to see the detail for all customers at once.


  • GoTos:  There are many GoTo’s built into the list to drill back the Microsoft Dynamics GP data to view more detail on a specific record. 


  • Grouping:  The data can be grouped by any of the fields in the main list.  This means you can group by something like Class ID or Salesperson and then see the data based on this grouping.


  • Totaling:  Subtotals can be displayed for any column included in the list and will be subtotaled at the group and list level.
  • Find:  A find panel is included to allow you to search the data returned in the list for any value. 


  • Export to Excel:  You can export the entire list to Excel, CSV, or PDF.  When you export the list, it keeps the grouping, totaling, details, etc that you have expanded/collapsed on the screen.  You can also copy specific records to Excel from the list.
Have questions? Let me know! Email me at nicole.albertson@eonesolutions.com. 

5 Comments

  1. Karen Tessier on September 20, 2018 at 3:56 pm

    Hi Nicole,

    I checked this out, and I see that the Aged Trial Balance SmartLists exist in SmartView for Purchasing and Sales modules, and they do not exist in SmartList tool. You guys must have done something really cool to make these built-in SmartLists for SmartView. We are in the process of upgrading from GP 2015 to GP 2018, and I see that these SmartLists exist in GP 2015, so not new to GP 2018 version.

    In both 2015 and 2018, I get a \”This constraint cannot be enabled as not all values have corresponding parent values\” error when checking the Show details checkbox. Unchecking it causes it to re-query and never finish. Also if you change the “Age as at date” after this point, it re-queries and never finishes. This happens for both SmartLists in GP 2015 and 2018. Without checking the Show details checkbox, changing the Age as at date works, but not after checking and unchecking the Show details checkbox. Is there something wrong with our data, or what gives? For GP 2018, we are on the latest SmartView version 18.0.9.

    Thank you!

  2. Lisa Sorensen on November 25, 2019 at 2:36 pm

    This is a great Smart View, but we noticed if the Aging Buckets change in the RM Setup window, the Smart View doesn’t update. For example, instead of 4 aging buckets, we want to have 5 aging buckets. (0-30 days, 31 – 60 Days, 61 – 90 Days, 91 + Days)

    When the aging buckets are modified, the buckets don’t appear to update in the Smart View Aged Trial Balance.

  3. Patrick Roth on December 9, 2019 at 2:02 pm

    Lisa,

    SV sets this on the install for the company settinhgs. You would have to go to Tools | SmartView | Field Maintenance

    and then use Maintenance | Refresh Field Cache

    and SV will read the current company db and reset the fields/query to that new settings.

    The only “issue” is that SV reads the ‘current’ company for this so if your companies are different you’d have to do this every time you want the report in a different company.

  4. Lori Maxwell on July 30, 2020 at 1:42 pm

    Is it possible to have the historical aged trial balance across all companies? Better yet let the user “pick” which companies to include?

  5. Buck Brignac on January 27, 2021 at 7:49 am

    Is there a version that works with Binary Stream’s Multi-Entity product, so that the Smartview Trial will be by entity?

Leave a Comment





RECENT POSTS


2021 Q4 Promotions
Connect with us at Directions EMEA 2021 in Milan!
eOne at Summit North America 2021
Employee Spotlight: Megan Tripp, Business Development Representative
eOne is now compatible with Microsoft Dynamics GP October 2021 Release

POPULAR POSTS


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

CATEGORIES

TAGS

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 partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com 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.