SmartConnect Excel Templates

Enter all your Microsoft Dynamics GP transactions directly in Excel, and have it update Dynamics GP right away. If you have heard enough already you can Skip straight to the GL Journal entry video or Skip straight to the PO entry video.

These ready to go Excel Templates are just the answer for every Dynamics GP user that prefers Excel for data entry. There are a number of critical reasons why customers are deploying these templates for Dynamics GP.

• Save in GP license costs: Rather than buying a new GP user, have your staff enter data into Excel instead.
• Remote users: Those employees that do not have or need network logins can now update GP directly from Excel, from home or from remote locations. e.g. Have your project managers enter AP invoices from where ever they may be. Have your external accountants enter journals without needing to log into GP etc.
• Love of Excel: All accountants, and most GP users are familiar with Excel for day to day use. Given a choice of where to enter data, the majority of users will choose Excel.
• Simple data entry: If you have ever had people say "that GP screen is too complex and hard to use" the SmartConnect templates are your answer. Build simple data entry forms for users that make sense for them, and then update GP without ever logging in.

How the templates work:
VBA for Validation: We have used VBA to build some validation checks into the spreadsheet to ensure only good data is used in the integration e.g. that the Debits=Credits on journals or that there is a valid site assigned to PO lines etc.
SQL Data Connection: If the user has access to the network they are able to check important entries against the GP database directly from Excel. For example it makes no sense to try and transfer a quantity of an item that you do not have. The template will check transfer quantities against the Qty on hand in GP, and warn the user if they need to review these numbers. If the user is external and has no access to the network, they are able to use the same template, but disable the real time SQL connection.
SmartConnect: When you hit submit on the template, this triggers the SmartConnect map to run via the SmartConnect web service. The user need not be a GP user, need not be connected to the network, all they need is an internet connection. The SmartConnect map ships with the template, so you are ready to go when you complete the download, and import the map.
Documentation: To get things started for you, we have included comprehensive documentation with each map, including how to install it, how to configure on your system and exactly what it does field by field.
Audit Trails: When you submit to GP via an Excel Template, the Excel file is saved with a data time stamp and unique name, and then clears out the template ready for your next transaction.
Can I have eOne modify or build a new template for me? Absolutely, the eOne professional services team can do just that. If you or your customer needs to customize the template to fit specific needs, or build a brand new one from scratch then let us know. Our team are experts in SmartConnect and can build templates specifically for your needs. If you have a specific request please contact Chris who can assist with your request. Chris Dew