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. 

1 Comment

  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!

Leave a Comment




RECENT POSTS


SmartConnect.com: an Introductory Video
Tech Tuesday: Connecting to SmartConnect and SmartConnect Online From Excel
SmartConnect.com is Generally Available
Create Rockstar Integrations - Attend Our SmartConnect Bootcamp in Phoenix
Don't Miss These Key Sessions at Directions North America

POPULAR POSTS


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

CATEGORIES

ARCHIVES

open all | close all

TAGS

#fargo CRM Demo Dynamics Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight ERP Events Excel Excel Report Builder Extender Extender Enterprise GP GPUG integration integration manager Meet the Team Microsoft Microsoft dynamics crm Microsoft Dynamics GP MSDYNGP Office Relationships partners release SalesForce SalesForce.com scripting SmartConnect SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.