Tuesday, April 16, 2013

Tech Tuesday – SmartConnect Key Fields and Grouping

One of the most important steps to setting up an integration in SmartConnect is ensuring that the correct key fields are set and the proper grouping is done.

Key fields needs to be added in on every map when setting up the data source, these fields are used by SmartConnect to break up the data into different records that it sends through to eConnect. SmartConnect does not look at the original source to determine the keys – it only cares about what is setup in the key fields section.

An example below shows how we broke up a GL Entry map into different records. There wasn’t a journal number in the source, so the batch ID and GL Reference were the fields used to break up the data. This setup will cause every unique combination of batch ID and reference to create a separate document/record that is sent through to eConnect.

 
An easy way to test whether the grouping and key fields are setup correctly is to change the destination to GP – File and run the map. The map will then create one xml file per record – which is determined based on the key fields. If one of those files are opened up, there should be one occurrence of the header node and possibly multiple entries for the line nodes in the record.
 
Chris Hanson
Senior Technical Consultant

Monday, April 15, 2013

New SmartConnect Online Training Offering

Need some training on SmartConnect but don’t have time to dedicate two full days to it?? No need to worry – we are providing you with a few new options. Every Tuesday, starting April 30th, we are now offering a 2 hour SmartConnect Online Public Training that will begin at 10 am to 12 pm CST. You’ll have the opportunity to learn from our experienced SmartConnect trainers live over Web Ex and walk away with a new set of skills to add to your integration tool belt.

Since we want you to take the best steps, in the best order possible, we encourage you to take each class and sign up as soon as possible (limited seating!). If however, you’d only like a small amount of training – you can do so – but just know there is a 2 session minimum requirement. Please see the class offerings below:

·         April 30th& June 11th: SmartConnect Install & Set Up
·         May 7th& June 18th: SmartConnect Basics
·         May 14th & June 25th: SmartConnect Advanced*
·         May 21st& July 2nd: SmartConnect & GP**
·         May 28th& July 9th: SmartConnect & CRM**
·         June 4th& July 16th: SmartConnect & SalesForce.com**
*SmartConnect Basics is a pre-requisite.
**SmartConnect Advanced is a pre-requisite.

Want to know the steps to attend?

1.       Tell us which classes you’re interested in. (sales@eonesolutions.com)
2.       Pay for a 4 hour block of time for every 2 sessions you want to attend. (Pay for 12 hours total if you want to attend all sessions.)
3.       Receive the Web Ex invites from the eOne team.

Easy, right?

 Any questions at all? Feel free to reach out to me directly as I’d love to help! abbey.cooper@eonesolutions.com 

Also check out our Events calendar for more trainings: http://www.eonesolutions.com/Events.aspx 

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.