Tuesday, April 9, 2013

SmartConnect Feature Review: Import/Export eConnect Node Definitions

A great feature we have just implemented in the SP2 release of SmartConnect 2012 is the ability to Import/Export the Nodes that have been setup in Node Maintenance. What exactly does this mean to you? Well, in the past we have allowed you to add any eConnect node into SmartConnect but this would need to be done on each Test and Production system. If you had added any list values, added any parameters (eg Binary Stream Facility ID), or changed names of the parameters this would need to be repeated in each system.

With the new release you can now Export/Import the solution directly from Node Maintenance under the following path: Maintenance-->Node Maintenance-->Import/Export.
We have wanted to put this feature in for a while now but the timing was right as we are trying to make SmartConnect even more powerful and easy to use.

Chris Dew
Director of Product Management

Friday, April 5, 2013

Extender and Extender Enterprise Release Dates



Next week we will be shipping the release of Extender that will upgrade from the Microsoft Dynamics GP 10.0 version of Extender to go along with the 2010 upgrade that is already available. 

The next Extender release after that will be for the full Extender Enterprise release that will support upgrades from Dynamics GP 10.0 and 2010. This version is still undergoing some upgrade testing and you can participate by exporting your current solution and sending to us to help us in ensuring the upgrades will be completely successful. Please send to chris.dew@eonesolutions.com.

The release of Extender Enterprise 2013 will be June 1st.

Thanks,
Chris Dew

Wednesday, April 3, 2013

Convergence Proves Again That GP is Still The Very Best Mid Market ERP Available

Convergence in New Orleans: 11,000 people, 4 days, extreme working hours, no sleep, 1000 smiles, some new friendships and way too many beverages.

My big take away from New Orleans this year is that there is absolutely no doubt that Microsoft Dynamics and specifically GP and CRM provide one of the very best mid-market solutions available. Here are a few of my thoughts as to why I reached that conclusion:

1. GP is Experienced: and has been around forever meaning it is tried, tested and an extremely solid solution. Fully functional and relatively bug free.

2.  GP customers just love it: Some folks seem to be even too passionate (a little over the top) about their software! I met thousands of customers that think their GP solution is just awesome. I want to clarify this a little - as every one of the people that love GP - put a lot of effort into making it work to suit their business. They invest time and effort into their systems and use it to do way more than just basic accounting functions.  If you want any software solution to do everything for you without putting in an effort - you will be sorely disappointed no matter how much software you purchase. ERP and CRM are complex, they must be configured, must be maintained and most of all must be deeply understood if you are going to reap the benefits.

3. WebClient:  I believe that too many people are getting hung up in the cloud. That said - the new GP web client is providing access to critical ERP functionality via a browser for those that need it. Microsoft sinking plenty of dollars into this as the delivery mechanism for GP. CRM already has a world class browser and cloud delivery.

4. Mid Market Flexibility: The happy clients I met were not small businesses. These companies are mid to large enterprises with complex needs, complex solutions and clever people to deliver them.  Many of these companies were amazed at the value for money they receive vs. a large scale SAP type ERP solution. If you are a small company wanting a generic solution that does your accounting  - then GP is probably not for you. (Go and buy NetSuite).

5. ISV community: Some call this a downside, I believe it is awesome. The ISV development community for GP and CRM is deep, experienced and passionate. This community is the envy of most other ERP solutions. The ERP that tries to build in functionality to fit every situation ' is really dreaming'. The knowledge required to truly nail these more niche solutions is something that a large ERP solution (including Microsoft) can not and do not possess (leading to half baked software releases).  If you need some extra functionality - there is an App for that.  These ISV's have been around for a long time and have deep domain knowledge in their chosen solutions. They all integrate seamlessly and closely with Microsoft Dynamics (especially as more of them take on SmartConnect as the integration tool of choice).

6. Ease of Integration:  Every business has some very business specific solution in place. It might be a point of sale system, a transaction website, an industry specific CRM or billing engine, warehouse or any number of point software solutions. This makes GP the back end core for all these systems - and with tools like SmartConnect it becomes a very simple process to integrate data in and out.

7. Clever hard working people:  This is perhaps the best and most important factor - the people I met were smart, they had good ideas, were creative and knew how to get things done. Software is no use to anyone unless it fits into the daily process of your business, and that's where people fit in.

 8. Community: The willingness to both learn and share was amazing. Groups like GPUG (GP user group) do an amazing job in connecting people who are working on the same types of businesses with similar needs and similar solutions.  Learning from others and learning their lessons the easy way is just super.  Other ERP solutions I look at would do anything for a strong user community like GP and CRM has.

You will notice that many of the points above are about people rather than technology. The GP technology is current and as good an anything in the market - but it is the people that make it a success. I for one - will continue to invest my money in my business building solutions for the Dynamics range. There is a long future for GP, and other products will come and go while creating a buzz, but GP will remain a technology leader with the best network of people supporting it.

Tuesday, April 2, 2013

Tech Tuesday - Calculating Dates Using Scripts

This week we're going to look at a couple specific scripts dealing with how to determine dates in SmartConnect. The first one will show how to get the last day of the previous month, and the second will show how to get the last day of the current month. The second script involves an extra step, but using these as a basis you should be able to get any other day you need as well.

Last day of the previous month:

 Dim myDate As DateTime = Date.Now.ToString("MM/01/yyyy")

 myDate = myDate.AddDays(-1)

 return myDate

The first thing we do in this script is declare the variable to hold the date, along with assigning it a value. Date.Now gets the current date, but we throw a format onto it in order to modify the date its generating. MM/01/yyyy in the format means we grab the current month and year, but the day is hardcoded to the value 01.


So if we ran the first line of code anytime during this month it would generate 04/01/2013. The second line then is simply setting that date equal to itself minus 1 day, which ends up being the last day of the previous month. By calculating it in this manner we don't have to worry about whether the previous day had 30 or 31 days (or 28), we let the .Net framework take care of that for us.

Last day of the current month:


 Dim myDate As DateTime = Date.Now.ToString("MM/01/yyyy")

 myDate = myDate.AddMonths(1)

 myDate = myDate.AddDays(-1)

  return myDate


This second script adds one extra step to the process. We are able to add and subtract months the same way we can with days on any date we have. So before we subtract a day, we add one month to the date so that it will end up being the last day of the current month.

Hopefully these scripts help out when creating new integrations where we need to calculate a date separate from what is in the source file. Using these, you could easily modify them to get the first day of the month or any other day you needed.


Chris Hanson
Senior Technical Consultant

Monday, April 1, 2013

SmartConnect Classroom Training Locations – April, May, June

We’re hitting the road again to train the best and brightest! Are you a partner or a customer that wants to learn to leverage SmartConnect to its fullest extent? Join us for two full days of intense, classroom training on SmartConnect at one of the locations below:

April 16th & 17thin New York, NY
May 14th & 15thin Chicago, IL
June 18th & 19thin Dallas, TX

At $1400/person, you’ll receive two, full days of hands on training from our experienced consultants, our latest product training manual, our training image and lunch each day. (Here’s a secret – if you send two people from your organization, the second person is ½ off!)

After you attend classroom training, here are just a few of the outcomes you can expect:
1. To become independent on SmartConnect – meaning you can easily complete the install, set-up, configuration of maps, support yourself, etc.
2. To identify additional ways to leverage SmartConnect at your site or at other customers’ sites.
3. Provide more value for the customer's overall solution.

Be sure to sign up early – we are limiting each session to 14 people. (We will provide 1 trainer for every 7 people.)

Interested in joining us? Email abbey.cooper@eonesolutions.com or danielle.erickson@eonesolutions.com for more information and to sign up.
Do the dates not line up with your calendar? Never fear! We will host more classroom training, you can join us online over Web Ex during a public, 4 hour online session, OR we can come to your site when it suits you best. Just let Abbey or Danielle know (see email addresses above) what works the best for you and your team.

Friday, March 29, 2013

SmartView Provides Fast & Flexible Reporting


Company
The SSI Group is leading the healthcare industry in claims management technology, EDI Platforms and networking. They provide a wide range of provider/payer/physician services and technologies for managing the revenue cycle.

Project Scope

Processing over 350 million transactions annually and relying on SmartList in Microsoft Dynamics GP as their reporting tool, The SSI Group, Inc. began to search for a solution that would provide flexible reporting. They found with SmartList that the reports were “antiquated and inflexible” and that most reports required “manual” work anyway – exporting to Excel to do totaling, subtotaling and adding more filters.  At a training class hosted by the eOne team, Jason Jones, Financial Analyst at SSI, found the solution.

“I was looking at many other tools to speed this process up but once I saw SmartView with its ability to add more than 4 filters, drag and drop columns, subtotaling and more, I knew it was exactly what we needed.”
Solution – Flexibility & Speed

Before SmartView, Jones and his team would “pull their hair out” trying to find reports and wait for SmartList to load. “Once SmartView came in we started seeing thousands of records in just a second or less, whereas with SmartList we would wait for a long time and sometimes wouldn’t even get any results back!” Continuing, Jones shared: “SmartView is very straightforward and intuitive. You just look at the guide and you’re done.”

When asked about recommending SmartView, Jones' boldly claims "you would be stupid not to have it!" explaining that: "just the flexibility of it gives you the information that SmartList does not give you. It makes it faster, easier and you can drill it down to exactly what you need, right there insite the tool!"

SmartView

Did you attend Convergence? Then take advantage of our SmartView Internal/SmartView External promo - purchase both for $2000 + maintenance.

Contact abbey.cooper@eonesolutions.com or danielle.erickson@eonesolutions.com for more details.

Tuesday, March 26, 2013

Tech Tuesday: Extender 2013 - New Actions


What are Actions?
Extender Actions allow a window or form to perform specific actions based on user input.  Actions were previously available in the Microsoft release of Extender 2010.  The options available were Disable Field, Enable Field, and Run Template. These options will still be available in Extender 2013.
 
What are the New Actions?
Additional Actions have been added to extend and replace the existing Logic feature in the Extender Enterprise.  While you can still add your own coding scenarios using the Actions, there are some available to replace the common coding scenarios.
 
Besides the Disable Field, Enable Field and Run Template Actions that were already mentioned, the following action will also be available in Extender Enterprise 2013.  The Actions may differ depending on if you call them from a Form, Window, or the Shared Actions.

Clear Field Values
Set Field Value
Open Extender Form
Close Extender Form
Open Application
Display Dialog
Run Macro
Run SQL Script
Run Dynamics GP Script
Run Shared Action
Run Event
 
 

Conditions can also be setup for each Action, defining when that action should be executed.
More action types will be added in later versions, including on to run SmartConnect maps.