Integration Service

Deploy and Configure: Payables Transaction Excel Template for Dynamics GP



eOne Solutions will help you deploy the Payables Transaction Excel Template for Dynamics GP. Our goal is to help your team get setup and using the Excel template quickly and efficiently.

The Payables Transaction Excel Template provides an interface within Excel that pulls down appropriate information from your Dynamics GP environment – accounts, vendors, currencies, etc. – and allows entry of a payables transaction with data validation built right in where the distributions can be provided or defaulted at runtime.

This Excel template is powered by SmartConnect on-premise, which gives your team full integration capabilities with not only Dynamics GP, but also any other connection that is setup within SmartConnect on-premise.

This eOne service offering includes:

  • Deployment of the Excel template on a workstation.
  • Connecting SQL queries within the template to the appropriate Dynamics GP tenant.
  • Configuration of the payables transaction integration within SmartConnect on-premise.
  • 1-hour training covering the general journal Excel template.

When complete, your team will have a configured payables transaction Excel template that can be easily copied and deployed to other workstations.

Additional customization of the templates – creating additional fields, changing the logic processes, modifying the underlying integration, etc. – are not within the scope of this offering. The eOne Solutions services team would be able to define any additional requirements as an add-on to this offering.

*An on-premise SmartConnect environment is required.