HELP ARTICLE

Excel Report Builder Setups SmartList Builder Template


  The Excel Report Builder SmartList Builder setup is built to display the Excel Reports that have been setup in Excel Report Builder.

SmartList ID:  ERB_SETUPS
SmartList Name:  Excel Report Builder Setups

Tables Involved:

  • Excel Reports

This setup has calculated fields to define the Product ID’s, Series, and Publish To fields.  Many have been defined, but you may find others that you need to define in the Drop Down List of the Calculated Field.

Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation List Builder.
Excel Report Builder Setups SLB

Excel erb

Excel nlb

Note: These templates are designed to be a starting place for your reporting needs.  While we try to make them as accurate as possible, we always recommend you check them with your data as we don’t guarantee their results.  Differences in how data is entered and used in Microsoft Dynamics GP can produce different results with these templates.

RECENT POSTS


SmartConnect – Zip File as Source
RM Apply Detail SmartList Builder Template
The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement
GlobalFileName not populated when using in a script
Wrong Date in Dynamics CRM/D365 for Customer Engagement Data Source

POPULAR POSTS


Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
Manufacturing Serial Trace SmartList Builder Template
The server process could not be started because the configured identity is incorrect.
How to update SmartConnect from 10.0.0.51 to SmartConnect 2014
Using WINSCP and a task to upload or download files from an SFTP site

CATEGORIES

ARCHIVES

open all | close all

TAGS

CRM 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 dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Office Hours 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.