Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: SmartView Aged Trial Balance Cannot Be Modified


SmartView has a great feature to give you a Receivables Aged Trial Balance as well as a Payables Aged Trial Balance.  If you are unfamiliar with this feature, you can find more information on it here.

Need a Better Aged Trial Balance? Check Out SmartView.

The one big question we get on these lists is if they can be modified in SmartList Builder.  These lists allow you to select the aging date as well as give you expandable detail options.  Because of this, they had to be built differently to work in SmartView and cannot be modified in SmartList Builder.  

To help with this, we have created templates that can be imported into SmartList Builder for the Payables and Receivables Aged Trial Balance lists.  We have created one for a Summary List as well as one for Detail.  The big difference between these lists and the default one in SmartView is that you cannot select an aging date in the SmartList Builder built one.  It will always age as of the actual date you run it on and what is currently in Microsoft Dynamics GP.



If these templates interest you, you can import them into SmartList Builder by going to Microsoft Dynamics GP – Tools – SmartList Builder – Import.  From there, you will select the Import from Web tab, select the Product of Microsoft Dynamics GP, and the Series of Sales or Purchasing.  From there, you can select the lists you want to import and click the Import button.  You will see that the lists are available for Excel Report Builder and Navigation List Builder as well.



If needed, you can also download and import the lists from file as well.  You can download them here.

Leave a Comment





RECENT POSTS


Happy Thanksgiving from eOne! - US Office Closed November 25 & 26
Popdock: What is your Locale?
Q4 2021 Partner All Hands Call - Recording Now Available
An Announcement regarding SmartList Builder and SmartView from eOne Solutions
Join us for the Q4 2021 Partner All Hands Call!

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.