Skip to content


Tech Tuesday – New Excel Template (Again)

Hey everyone, I have some great news from our services manager Chris Dew involving our Excel templates again. I made a post a while back on them but we held off on releasing anything until we were able to add a couple more features to it that we think everyone will really be able to make use of:

We are very excited to finally release our new Excel GL Templates for SmartConnect! We had three major goals for this release:
    1. Remove the reliance on SOAP
    2. Prevent Data Entry errors
    3. Configurable without coding

    The past templates have had a reliance on the Microsoft SOAP SDK that was used for calling the SmartConnect webservice from VBA. Microsoft has discontinued this support a long time ago and with this new release we can now simplify the install process of the templates to just copying the Excel sheet where you need on the network. This also allows us to support 64-bit environments for Office.

    One of the largest uses of the Excel templates is copying data from other sheets. Excel will often display only two decimal places but behind the scenes there could be 15 decimal places and oftentimes rounding errors would occur in larger journal entries. We have added logic to handle that rounding for you so copy and paste away!

    I think my favorite new feature to report is the easy configuration of the new template. You can now dynamically change the amount of rows without changing any of the code. Also, we locked the totaling row for the debits and credits so you can always see the balance. This was one of the most common customizations we did for our partners and customers and now you won’t need us anymore!

    We have locked down the code in the template to ensure the delivery of the solution. Additionally, we updated the documentation for the template. If you would like to add some additional functionality to the template please feel free to contact me ( and our services team can help you design a custom template.

    As always, we welcome your feedback. We have plans to roll out a lot of these changes to the other 11 templates available today (over the next couple of months) and may release a generic template that is unlocked as well. Please let us know if you have additional ideas for new templates or features.


    Chris Dew


    1. BrianG on October 8, 2012 at 1:31 pm

      Where can we download it from? When I access the download section it has from March.

    2. on October 10, 2012 at 2:47 pm


      We replace that download with the new template. It is the correct one.


    3. BrianG on October 25, 2012 at 3:28 pm

      Looks pretty good. I like the easier way to increase the number of rows and the archive path πŸ™‚

    4. Alex zender on December 18, 2012 at 12:28 am

      This blog is very cool!

      excel templates and help
      excel templates

    5. NEERAJA B on April 3, 2014 at 3:31 am

      Thank you somuch for sharing this information
      packers and movers in thane

    6. NEERAJA B on April 3, 2014 at 3:31 am

      Thank you somuch for sharing this information
      packers and movers in thane

    7. Amarjeet Verma on September 9, 2014 at 7:48 am

      Thanks for giving good information I Really like your information

      Packers and movers kharadi pune |
      Packers and movers hadapsar pune |

    Leave a Comment


    Accessing Historical Dynamics GP Data in NetSuite: Using Popdock
    Popdock's Top 10 New Features
    New Webinar: Getting Started with Matrix Reporting in Popdock
    Tech Tuesday: Popdock User Security in D365 Business Central
    Popdock Data Lake Upload Tool for Dynamics NAV Data - FREE TRAINING


    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



    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 Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

    Integrate & Automate without Any Code.

    SmartList Data has Never Been Faster.

    The Easiest Way to Report on GP Data.