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


Tech Tuesday: Accessing the Real-time Request Log in SmartConnect.com
Tech Thursday: New Field Types in Extender
Integrations from Excel to Microsoft CRM - A Match Made in Heaven
eOne GPUG Summit Sessions
SmartConnect 2018 now compatible with Microsoft Business Central October Release

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

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 Flexicoder 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.