Showing posts with label Microsoft Dynamics GP. Show all posts
Showing posts with label Microsoft Dynamics GP. Show all posts

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!

Friday, August 8, 2014

Two eOne Pros Nominated for 2014 GP Community All-Stars!



FARGO, ND, August 07, 2014 – We are excited to announce that two members of the eOne team have been nominated for this year’s Dynamics GP All-Stars.  Nicole Albertson and Martin Olsen have been selected among 11 other candidates for the 2014 award. 

“Nicole is outstanding in the GPUG Community,” stated Kim Peterson, Director of GPUG, regarding the nomination.

“She is and has been instrumental in the educational aspects of the products eOne produces. She helped form SmartList Monday, which has morphed into Builder Monday, with monthly webinars on all of the builder products.  She’s a high demand presenter at conferences and always active in answering questions on GPUG Collaborate.  I don’t know what we’d do without Nicole! I’m very proud, and not surprised that she made the nomination list for GPUG All-Star 2014."

Martin Olsen, Product Director at eOne, is also on the candidate list, but has attributed the nomination solely to the work of his team. “If there are any congratulations in order, they should go to Nicole and the work of the amazing team here at eOne,” he stated.

“This year marks a major milestone for Nicole. With over 15 year of contributions to Dynamics GP, and approaching a decade of service with eOne tools like SmartList Builder, Extender, and SmartView, she has been nothing but a humble servant, dedicated to the success of the GP community.”

Voting for the community-based awards is now open and available at this link.

If eOne tools like SmartList Builder, Extender, or SmartView have made your GP experience better, please join us in congratulating Nicole and Martin in their efforts.

For the complete list of nominees, and to cast your vote for this year’s GP All-Star visit: https://www.surveymonkey.com/s/voteAllStar2014


About eOne Integrated Business 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 GPUG:

The Dynamics GP User Group (GPUG) is a user-driven, independent organization powered by Dynamic Communities, Inc.  GPUG’s leaders strive to help individuals and company members maximize the value they receive from Microsoft Dynamics GP.  Members learn, network, and share expertise through a number of educational events, webinars, training courses, virtual collaborative meetings, regional networking opportunities and a vibrant online community.  Learn more at http://www.gpug.com.


Wednesday, August 6, 2014

A Business Manager's Perspective on The Ease of SmartView


Upon being employed as the Business Manager at eOne, I realized my most valuable tool was SmartView. Not only for fast reporting, but because it was extremely easy to learn. 

I had never used GP, only other accounting software like Quickbooks. When learning GP, one of the most frustrating parts for me was to see if someone had paid their renewal and what method they used to pay. Or if someone would call, to have quick access to the invoices they were referencing and all the information in one spot. I thought, why does this have to be so painful?! 

With the help of our SmartList Builder Expert, Nicole Albertson, we were able to customize a couple of lists for me to move into SmartView and also manipulate the canned lists that were already existing within SmartView. It took me a couple days of just playing around with SmartView to really grasp what I could do with it. I now have approximately 25 favorite lists I’ve created myself. These range from daily sales, to monthly sales, to project accounting tracking for commission reports. The greatest part about this is I can share these lists with whomever I want in our office!

I also have had several chances to install SmartView. It’s a running joke at eOne as to when I will break my next computer. I’m on number 3 so far and I’ve only been here for 10 months. With each computer I’ve had to reinstall SmartView External and all I needed to know was the server name (I know this by memory now). So the ease of install is incredible (no nerd involvement needed).  ;)

SmartView took me a very short time to learn and I’m now able to give demos on the product. If you can use a mouse, you can do a SmartView demo. This product saves me around 5-8 hours a week of admin time and I highly recommend it as it is truly my favorite tool here at eOne. 

Please take a look here at SmartView. I promise you can’t report quickly without it! 

Best,
Alicia Bement
Business Manager

Tuesday, August 5, 2014

Tech Tuesday: SmartConnect Web Service Destination

This week's Tech Tuesday is from our Senior Technical Consultant, Chris Hanson, who has provided a video demonstration on SmartConnect's web service destination! 

This week we are looking at using the web service destination within SmartConnect, which allows for integrations that can be setup to systems or web sites that use web services as their primary means for communication. The setup for the web service destination is a two step process where the web service connection has to be defined initially and then after that it can be used in any map you setup. There is also an option to use a web service as a data source which we will cover in a future article to illustrate how to pull data out from them as well. 


Want more SmartConnect info? Email sales@eonesolutions.com!

Wednesday, July 23, 2014

Microsoft Dynamics GP is going from Strength to Strength.

Microsoft Dynamics GP seems to be going from strength to strength. I want to deliver a few reasons why I say this and what I believe the cause may be.

What makes me say that:

      1.  Growth: Every VAR I speak to - and I speak to plenty – are really busy and growing their teams. These VAR’s are adding to the people they employ to support Dynamics GP, because they are signing up new customers and are continually supporting the solutions for their existing customers.

      2.  Sales: eOne is selling more product than ever in our 12 year ISV history. I have always used SmartList Builder as a barometer of total GP sales - and if those ratios are still roughly the same then there is still plenty of GP being sold on a monthly basis.

      3.  ISV Sales: Sales into the GP customer base – Mid Market companies that use GP are still spending on their GP system via addons from eOne, other ISV’s, upgrades, consulting etc. The base would not be investing in existing systems to this extent unless they were planning to stay with Dynamics GP for a long time.

Why I think GP is going great and will be for a long time to come:

      1.  No Competition: It still amazes me that ERP’s really have not changed dramatically in the last 15 years and that there is still no truly credible competition. Think about it – have there been massive leaps since 2000? This is partially that Accounting underpins an ERP – and nothing changes slower than accounting practice.

There are some new players in the cloud space which are certainly doing okay – but from a functional perspective they offer little if anything that is better than GP.  Netsuite have a clever integrated CRM with their ERP – but if you put GP and Microsoft CRM together (using SmartConnect of course) you get a way better outcome (albeit at a cost).

Tools like Intacct, Acumatica are good but are really the same old tools delivered differently via a browser. Functionality, which is what counts for the end users, in GP offers everything and more than any other horizontal product in the mid market space.

      2.  Mid Market: GP is in the mid market, the true mid market, which covers from the top of small to some really large companies. There are some amazing companies and brand names that rely on GP all day every day. The mid market need all the controls of a strong ERP. A mid market company needs all the reporting power of a strong ERP.

There is a huge push from tiny cloud players like Zero and Freshbooks. All good products but really targeted at a completely different business demographic. They are aiming up at quickbooks and sage – and not the GP space. These are perfect for small companies, but when you look at those tools they really provide very little in respect to functionality. These tools do not offer anything to any of the GP customer base that we work with everyday.

      3.  GP web client: Is actually pretty cool, eOne runs this in-house. It works and it works well. 

      4.  eConnect: I am not sure that everyone at Microsoft understands it – but eConnect is one of the best things that GP has going for it. It is a great API – that makes GP a perfect hub repository for all the data form the many systems a business deploys. With GP 2015 coming along that will expose even more API functionality through Dex Next - this is exciting times for GP. The GP API is very strong, very robust and fully developed. There are many ERP’s and CRM’s that would do anything to have an API as good as eConnect.

      5.  Cloud: The cloud is re-introducing the best of breed software concept. There are vertical cloud solutions for just about everything. These solution do the one thing they do ‘really well’. Mid market companies do not want or expect an ERP to ‘do everything’. They want it to do its core functions really well and be very stable, but also allow for easy integration with all the best of breed applications they decide to deploy.

For Example - Many ERP’s build web stores and eCommerce platforms. But there are way better solutions on the market than what any ERP provider could deliver. When you look for a web store, payment gateway, etc. you are looking at Braintree, 2CO and any of the many web stores. You need these integrated – but you do not expect your ERP to handle this natively.

On the CRM side of things you have tools like Mailchimp/Constant Contact which do their one task really well. As long as the integration is strong – you do not need this functionality inside of your CRM. There is a huge world of great addons – and it is eOne’s job to make sure you can integrate them all to your core systems as easily as possible.

      6.  Community: A fully developed and broad ISV community. At eOne we are contacted just about every week from an ISV that is wanting to get into the GP space! These are companies that have vertical solutions but everywhere they turn they meet customers who use GP and need integrations. They also know that this is a massive market for them and they want a piece of what the GP ISV’s are getting. 

GP has many great ISV’s. As business is swinging back to best of breed solutions - as opposed one system can do everything – it shows that the GP model has been right for a very long time. Microsoft builds the core solution, and experts in various fields build what goes around that core.

      7.  More with less: Microsoft is doing the right thing. This week Satya declared they will be doing more with less at Microsoft. This is something that has worked great for Dynamics GP. Over the last few years the GP team has shrunk – and as a result the GP team have actively looked to be cleverer and smarter – doing more with less. I think Microsoft has seen GP’s success and decided to try that model across the entire company.

     Have any questions or comments regarding Microsoft Dynamics GP? Feel free to comment below of email Martin at martin.olsen@eonesolutions.com!

Thursday, July 17, 2014

Join us in October at GPUG/CRMUG Summit 2014 in St. Louis, MO

As we put together our schedule of events this fall, we want to make sure you know about one of the most beneficial events for users. Join us and hundreds of GP & CRM users at GPUG & CRMUG Summits, October 14-17, in St. Louis, MO. 

Here are the reasons we love the Summit events: 

  • There are literally HUNDREDS of breakout sessions available on nearly every GP/CRM subject you can dream up. 
  • The vast majority of sessions are led by end users who will tell you exactly their experience and exactly how they feel about something. They don't carry a hidden agenda, so you get the information you want & need. The whole conference for users. 
  • The sessions are divided into specific learning tracks - making it easy for you to narrow down where you want to spend your time. 
  • There is a huge amount of networking, interacting and learning from others who are in the same boat as you - working with GP and/or CRM every. single. day.
  • Fun key note speakers that aren't there just to share a specific "message" from the guys at the top of say, a very large corporation located on the West Coast. They really are there to inspire you & get you thinking about bettering all areas of your life. 
  • If you head to the event early, you can take advantage of great training options to improve your skills.
  • Have I mentioned AWESOME ISV's who have solutions that are designed to make your lives a whole lot easier? We'd LOVE to see you come visit us in the expo hall - so be sure to schedule your time at booth 818! 

Have any questions or want to know a few more reasons why we participate? Let me know - I'd love to chat with you. We hope to see you in October! 

    Tuesday, July 8, 2014

    Tech Tuesday: Identifying the Source Company in a SmartConnect Real-Time Map

    This week's Tech Tuesday is from our Senior Technical Consultant, Chris Hanson, who will show us the easiest method to tracking the Source Company in a Real-Time Map.

    One of our features in SmartConnect is a real-time data source that allows maps to automatically execute when a certain event is triggered. When using a GP real-time source you can setup that source once to be used across every GP company if needed. The issue is then how you can identify which company the event/data comes from as that is not tracked by default within the source.

    The easiest method to track the source company is to use the DB_NAME() function that is built into SQL. That statement can be added to any SQL based data source (real-time or otherwise) in order to identify the database the data is coming from as it will return the current database if no parameter is passed into it.

    For a real-time map, that function would be added within the query builder when setting up the source. In the screenshot below, DB_NAME() was added as an expression with the Alias for that result set to SourceCompany so it is easy to identify when looking through the columns while building the actual mapping. 



    The result of that function should return the SQL name of the database/company that the data is coming from. So if we were using the Fabrikam company to test this map, it would have TWO set as the value when triggered from that company. That value can then be used in restrictions, tasks, or other additional columns as needed to ensure the data is processed correctly when the map runs.

    Have something you'd like to see covered in a Tech Tuesday article? Send them in to sales@eonesolutions.com!

    Friday, June 27, 2014

    SmartConnect 2014 releases today!

    It's here... SmartConnect 2014!
    We are very excited to release SmartConnect 2014 today!

    This release will work for any of the following versions of Dynamics GP(10, 2010, 2013, 2013 R2), Dynamics CRM (4, 2011, 2013, online) and all the more generic connectors (SalesForce.com, Web Services, Text Files, XML, SQL,etc).


    SmartConnect 2014 has some really great features added along with several fixes. Below are a few of the really exciting features along with the download below:
    http://www.eonesolutions.com/Products/Downloads


    SQL Server Realtime Triggers – This feature allows you to run a SmartConnect map and use the data from the just saved record in SQL Server. Any SQL table can have this added.

    Microsoft Dynamics CRM Bulk Destination – As larger datasets need to be sent to Dynamics CRM the load on the CRM Webservice can be reduced by using the Bulk Destination for CRM and sending more data in one document.

    Microsoft Dynamics CRM Entity Lookup Enhancements – Entity Lookups allow you to work with Microsoft Dynamics CRM data without needing to know the complexities of the GUIDs or needing an intermediary datastore to synchronize Dynamics CRM data. We have enhanced this feature set allowing you to use other calculated fields and transformations in the lookups.

    SalesForce.com Entity Lookup Enhancements – Entity Lookups allow you to work with SalesForce data without needing to know the complexities of the GUIDs or needing an intermediary datastore to synchronize SalesForce data. We have enhanced this feature set allowing you to use other calculated fields and transformations in the lookups.

    Rolling Column New Features (Next Document Numbers) – We have added most document types and now you can even have multiple in a specific map. Custom Rolling Columns are available globally now instead of just on a specific map. Additionally, you can pass in data source fields and calculated fields in determining the correct document type.

    Disable/Enable all tasks – Quickly enable/disable all tasks when testing maps. This can be very useful when you have a process like sending an email or updating a SQL table on the success or failure and you only want that to run when the map is ready for production. 


    Enhanced Transformation Abilities – I really love this feature. We have basically allowed you to use the transformation fields (Calculated Fields, Lookups, Translations, etc.) everywhere inside of the application. When you look at SmartConnect as an ETL tool you can see that this adds another level of robustness when delivering any solution for your business needs.

    Thanks,
    Chris Dew
    Director of Product Management


    Do you have any questions regarding the latest release of SmartConnect 2014? Email us at sales@eonesolutions.com and we would be happy to help!