Tuesday, August 19, 2014

eOne Adds Another to Team

Just two weeks, after our last new hire post, we are very excited to announce another new member of the eOne Team. Amanda Schultz, has joined us in the role of Web Developer. Together with the IT, marketing, and management team, Amanda will help streamline and support the eOne websites, portals, and other web projects. With her background and education in computer science, and experience in web programing, she makes a perfect addition to the team.

A graduate of Jamestown College, and a native of Fargo, she is an avid tennis player, which isn't the entire reason we hired her, but it's definitely an added bonus. We are all about transferable skill sets at eOne, and are confident she will make an excellent ping pong opponent.

Please join us in welcoming Amanda.

Tech Tuesdsay: Table Changes in Extender 2013

As many Extender users are looking to update to Microsoft Dynamics GP 2013 and along with that updating Extender to 2013, there are table changes to be aware of. In the update from Extender on GP 10 or 2010 to Extender on 2013, almost all of the tables change to a new set of tables. 

What does this mean for you as you update?
If you wrote anything directly to the tables, such as SQL Views, SSRS reports, etc, you are going to need to make changes to those customizations so they pull from the new tables. They will be pulling from tables that are no longer used by Extender. While we leave the tables in place so that your customizations don't fail, we do empty the tables after we have transferred the data into the new structure. This means there is no actual data to pull from the "old" tables.

How do I know what table to pull from in 2013?
We have posted a document that outlines all of the new tables and their structure. Then on page 110, you will find a mapping of the old tables to the new tables. You can find the document on our website by going to Downloads. Then select the Product of Extender and the Download Category of Documentation. It is the Extender 2013 Table Structures document that you will want. You can also go to it directly here.

What can I do to get around this in the future?
We don't have a mass table update planned at this time like we did for the 2013 release, but to be safe, the best way to get around this is to use Extender Views. If you log into Extender as a user that has sysadmin or db_owner rights in SQL (or the 'sa' user), you will see an option called Views. This allows you to create a SQL View of your Extender Windows and Forms. You can also link in Microsoft Dynamics GP tables. These views will link in all of the tables needed to pull data from an Extender Resource. It will display the nice names of your data for lists, yes/no fields, etc. instead of the numerical values. It also uses your field name as the name in the view. You can change the options on the display if you need to pull in more of the SQL naming conventions and data storage.

So to make a long story short, if you manually pulled anything from the Extender tables in SQL and you are updating to GP 2013, you are going to need to make some changes to those customizations. 

Of course if you have any questions as you make these changes, our support team is happy to assist and can be reached at 888-319-3663 option 2 or by e-mailing support@eonesolutions.com.

Friday, August 15, 2014

Best Dynamics GP Event Ever - reIMAGINE 2014

The Dynamics GP consultant is the most important person in any Dynamics GP VAR. But they never get to have fun. Consultants are overworked, pushed to hit 90% utilization day in day out. That’s makes them sad. 


There are many events that are geared at sales people and Executives – but the consultants are billing machines that always have to stay home. Like any productive machine  - consultants needs to be looked after, have their oil changed and given a chance to refresh and renew. If you do not give your number one employees a break and a chance to get out and mingle they end up looking like a very tired old consultant that can scare customers away. 

So – reIMAGINE 2014 provides a chance for every Dynamics GP VAR and every Professional Services manager to correct many years of unspeakable wrongs against consultants. There is nothing a consultant loves to do more than learn new technologies, talk to other like minded consultants and drink alcohol. In fact learning and drinking goes hand in hand, with the later improving the former.

Every consultant can add serious improvements in revenue by learning more about products, tools and technologies. After all - you have to admit that it is a consultant that sells a new tool to a customer – not the sales person. In fact it is impossible to sell any software unless your consultant knows how to make it all work. So regardless if you are coming to learn more about GP 2015, more about Sharepoint and other Microsoft tools or to brush up on all the ISV products – there is no better place than reIMAGINE 2014. Your consultant will bring back all this new knowledge that will lead to MORE software sales into prospects and your existing base. Last time I checked more revenue is a good thing.

Presales is where it is at. If you want to sell, you have to know how to build a solution and show it off in all its software sexiness. Consultants do NOT know how to do this. Consultants are awesome at training and by nature are bad at demonstrations. reIMAGINE 2014 is a great chance to reinvent your consultant into a Presales Gun. Both Microsoft and eOne will be running session on how to turn those demos sexy with hands on examples and experience. IF you want to BRING SEXY back to your software demonstrations – then get to reIMAGINE 2014.

Now back to beer and drinking in general. There is no better place on earth than Fargo in November for drinking. It is simply too cold to do anything else. Having lived here for 18 months I am familiar with all the best places to consume golden liquid. Here is the deal – if you are a GP consultant and you come and give me your business card and introduce yourself – I will buy you a beer. No questions asked. The only caveat will be that you might have to drink it with me. 

Training the Mind. There will be Microsoft training, other ISV training and most importantly eOne is running training on the two days before reIMAGINE 2014. Come and hang with the product gurus at eOne and we will teach you everything you need to know about our products. We will be hosting Certification training for SmartConnect, SmartList Builder refreshers and a deep dig into eXtender. 


Now back to drinking for a minute – we are going to have one big eOne party during reIMAGINE 2014. This is our home town and we want to show everyone some home town hospitality. When we party we know how to do it properly. We see this as a chance to ‘give back’ to all our partners for helping us through the days when SLB and Extender came home. We know there were some tricky moments as those products extracted themselves from Microsoft – but we all made it and it has worked out great for everyone. So details are to come – but this is going to be a GP party to remember. 

So to summarize:
     1. Consultants need a break and need to be appreciated.

     2. Send your consultants to #reIMAGINE2014. Tell them it’s a break and they'll come home smarter.

     3. Microsoft is doing some great things with GP – get on board.

     4. You get to party with eOne – who doesn't want to do that?

     5. You get to learn with and from the smartest and brightest people in the GP community. (They all live in Fargo)

See you here in Fargo in November. 

Thursday, August 14, 2014

Press Release: Solver and eOne Announce Strategic Partnership

FARGO, ND, August 14, 2014 – Today, eOne Integrated Business Solutions and Solver, Inc. announced a global, strategic partnership to enhance the experience and ROI of their mutual customers and partners. Solver is the global leader in complete Business Intelligence suites for Microsoft Dynamics AX, GP, NAV, SL and other enterprise resource planning (ERP) systems. Fargo based eOne is the leading provider of integration, migration, and data productivity tools for Microsoft Dynamics systems as well as other platforms and web services including SQL Server, ODBC, and Salesforce.com.

“We are excited to partner with eOne, one of the most well-known and respected Independent Software Vendor’s in the Microsoft Dynamics space,” said Nils Rasmussen, CEO of Solver. “With this partnership our customers and partners using Dynamics GP or Microsoft CRM will immediately benefit because they can configure an integration using eOne’s SmartConnect and load data into our BI360 solution in record time and with no technical skills required.”

“This is a great example of a partnership aimed at putting customers and partners first, and at eOne we are excited to be working with Solver to enable higher productivity and better Corporate Performance Management for our joint customers,” said Martin Olsen, Director at eOne Integrated Business Solutions. 

The first stage of the partnership is an integration using the eOne SmartConnect extraction, transformation and loading (ETL) tool to populate the BI360 Data Warehouse. With Pre-built SmartConnect integration templates specifically for BI360, the partnership simplifies and automates the loading of data from Dynamics GP and Microsoft CRM.

A webinar overview will be held on August 19th to showcase the new functionality.

To register for online session or for more information, visit: http://eone.solutions/solver-webinar.

About eOne Solutions

Headquartered in Fargo, ND, eOne Solutions is the proud creator of smart, configurable, and integrated software tools for business platforms and web services including Microsoft Dynamics GP, CRM, Microsoft SQL, and Salesforce.com. Founded in 2001, eOne has a family of seven flagship products specifically designed to enable business users with the easiest way to view, automate, report, and take action on information. In 2005, Microsoft and eOne built one of the most successful OEM partnerships in the history of Dynamics. With more than 13,000 companies trusting eOne tools daily and over 21,000 installs worldwide, eOne helps more Dynamics customers and partners than any other ISV or service provider.

For any questions, visit eOne’s website, or contact info@eonesolutions.com.

About Solver

Solver provides BI360, the leading Business Intelligence suite for Microsoft Dynamics AX, GP, NAV, SL, Sage 500 and X3, Intacct, Acumatica and other ERP systems. Solver is a Microsoft Gold ISV Partner and the winner of the Microsoft BI Partner of Year Award and has a presence on the Gartner Group CPM Magic Quadrant. BI360 is sold through a world-wide network of resellers and is ideal for companies looking to find a user friendly, yet highly functional Reporting, Budgeting, Dashboard, Collaboration Portal, and Data Warehouse solution to give them deep insight and actionable information across all facets of their organization.

For any questions, visit Solver's website or contact Solver at info@solverusa.com.

Tuesday, August 12, 2014

Tech Tuesday: Automatically changing Dynamics GP SOP distributions based on business rules

The Flexicoder product is one of the most interesting ones in the mix offered from eOne. Businesses that need it, REALLY need it while the businesses that don't, REALLY don't. Let me explain, when you have an internal business need to track your Sales or COGS (or other accounts) by something other than just the account attached to the item or customer you introduce a manual process. Manual processes introduce humans into the equation and humans make mistakes!

Flexicoder helps you eliminate the time-consuming and error prone processes by defining the business rules one time and having the system automatically apply the rules for each transaction. I will outline two scenarios where you can see Flexicoder applied to change one or more of your account segments based upon the rule you setup.

Scenario 1: Change the first account segment based on Salesperson

One common scenario we see is a need to recode one of your Segments based on a Salesperson or Sales Territory. Both of these options are available to you with a host of others as well. In the image below you can see that it will automatically fill with the values for your Salespeople and then you can assign the values that are appropriate for your business case. The example below shows assigning some of the segments and leaving others to stay with the standard account.

This is a simple example of using the Sales distribution type but you have the ability to recode Accounts Receivable, Cash, COGS, Freight, Inventory, Markdown, Miscellaneous, Sales and Trade Discount types in the Sales Order Processing area and quite a few others in the Receivables area.

Scenario 2: Change the first and third segments based on Salesperson and additional Extender fields

This scenario shows that we can recode multiple segments and can use Extender windows to hold information to recode a segment. In this example I have an Extender window on the Sales Transaction Entry form in Dynamics GP that simple tracks a Subscription Type field as Monthly or Annual. I will see any Extender window attached to the Sales Transaction Entry, Item, or Customer windows in Dynamics GP.

One other thing to point out is that in the image above is the Exception area on the bottom right corner. This is a great tool to have if you need to exclude certain accounts, document types, batches or customers from the predefined process.

Finally, in order for this to work, you simply save the transaction and then pull it up again to view the distributions that have changed.

If you have a need for this try it out in the sample company and see if it will reclaim an hour a day to do something better than change distributions manually.

If you have any questions regarding Flexicoder or simply would like more information please email sales@eonesolutions.com and we would be happy to assist you!