Showing posts with label SmartList Builder. Show all posts
Showing posts with label SmartList Builder. Show all posts

Monday, August 4, 2014

The Easiest Way to Find Tables in GP - Table Finder (SmartList Builder)

We love it when customers jump in and take advantage of new product features. Last week we received a message from a long time customer who shared her love of Table Finder - one of the 8 new features we added with our build of SmartList Builder for GP 2013. 

"Hey Martin - 

I just had to drop you a note to tell you that Table Finder is my new favorite feature in GP! 

I use it time and time again to figure out what is where, especially when dealing with new things.  Right now I am setting up the HR system and I opened my master excel sheet that has all the tables list in it (old way to find tables), I was overwhelmed with where to even begin to find what I needed and then I remembered TABLE FINDER!!  5 seconds later, I have my answer!!!

I LOVE IT!

Michelle Kocher
Internal Operations Manager
Delta Medical Systems, Inc."



So, have you taken a moment to learn more about Table Finder - to help you find the exact tables you need in GP? Take a minute to learn more. 

Have questions? Let us know - email sales@eonesolutions.com. 

Tuesday, July 22, 2014

Tech Tuesday: Which Build of SmartList Builder and Extender 2013 Do I Need?

With the Microsoft Dynamics GP 2013 R2 release, we had to make some changes with SmartList Builder and Extender to work with the changes made in R2.

With that change, came the need to have two different releases of SmartList Builder and Extender. On our download page, you will see two different listings for SmartList Builder 2013 and two for Extender 2013. 



When deciding which to download, you need to take into account your Microsoft Dynamics GP 2013 version. To find your Microsoft Dynamics GP 2013 build, you will need to go to Help - About Microsoft Dynamics GP and note the Microsoft Dynamics GP version. It is going to be 12.00.xxxx. If the xxxx is 1745 or higher, then you will need the R2 release (1st one in the list). If it is 1744 or lower, you will need the Pre R2 release (2nd one in the list). 



You can also find the version information on the User Login window if you are not already logged into GP.

It is important that you get the correct build of SmartList Builder or Extender as you will find that certain features don't function or are missing from the options if you have the incorrect one. If you have installed the R2 build already and are not yet updated to Microsoft Dynamics GP 2013 R2, please contact support at 888-319-3663 or support@eonesolutions.com.

If you have any questions or are interested in Extender or SmartList Builder please feel free to email us at sales@eonesolutions.com! 

Monday, July 21, 2014

SmartView - Exporting to Excel from GP

This is really simple, but for those of you that wait for data to export to Excel - it is really cool.
Check out how long it to pull my data to screen and then get it to Excel.

https://www.youtube.com/watch?v=qSGieTut8mw


Martin

Tuesday, July 15, 2014

Tech Tuesday: How to Change the SQL Server for SmartView External

Take a look at one of our helpful articles on SmartView from Nicole Albertson. You can search the Knowledge Base section of our website for articles on any of our products. It has been known to help lots of people sort through common support questions. Take a look at it when you have a moment! 

SmartView External hold the SQL Server name in the SmartView.exe.config file.  If the SQL Server that Microsoft Dynamics GP resides on is moved, this will need to be changed for SmartView External as well.

To change the SQL Server, follow these steps:

  1. 1. Open the SmartView.exe.config file.  By default it is installed in one of the following locations.
    1. 32 bit OS:  C:\Program Files\eOne IntegratedBusinessSolutions\SmartView
    2. b.      64 bit OS:  C:\Program Files (x86)\eOne Integrated Business Solutions\SmartView

  2. 2. Find the following line:  xxxxxxxxx" />

  • 3. In the value, enter the name of the SQL Server that Microsoft Dynamics GP is installed to.  If it includes an instance name, be sure to include that.  If desired, instead of the name, you can use the IP address, port number.

  • 4. Find the following line: 
  • In the value, if the system database name is not DYNAMICS in the current Microsoft Dynamics GP installation, enter the correct system database name.  If it is DYNAMICS, just leave the value in this line at DYNAMICS.

  • 5. When completed, the file should look something like the following.
  • xml
    version="1.0" encoding="UTF-8" standalone="yes"?>

      <appSettings>
       
       
        svuser
    " />
        PhoneNumberFormat" value="(XXX) XXX-XXXX  Ext. XXXX" />

    6.  Save the File.

    Once you have changed the SQL Server information in the config file, launch SmartView External and verify that it is pointing to the data on the new server.

    Questions? Let us know! 

    Monday, June 23, 2014

    SmartList Builder vs. SmartList Designer

    We have been getting a lot of questions regarding the differences between eOne’s SmartList Builder and Microsoft’s new SmartList Designer tool.

    To make it easier for you in your decision making process, we have interviewed the two candidates in the video below to see who is better qualified to create custom SmartLists for Microsoft Dynamics GP.



    Spoiler alert: SmartList Builder wins!

    Interested in more information on SmartList Builder? Please feel free to email us at sales@eonesolutions.com!

    Tuesday, June 17, 2014

    Tech Tuesday: Remove All Date Formatting in Excel Report Builder

    This week's Tech Tuesday is from Jared Dux in Quality Assurance. He highlights the Excel Report Builder aspect of SmartList Builder and how to remove all date formatting within it.

    In Excel Report Builder version 12.00.0067 and 12.00.0068 you can add a line to the Dex.ini to remove all date formatting from published Excel Reports. Add EXCEL_REPORT_BUILDER_REMOVE_DATE_FORMATS=TRUE to the Dex.ini to pass in a number rather than a formatted date to Excel.When you publish your Excel Report you will now have all your date fields showing as numbers similar to the Document Date in the image below.



    You can now select all the date columns and format them with the many date options in Excel.


    Interested in learning more about SmartList Builder? Feel free to email us at sales@eonesolutions.com for more information!

    Thursday, June 5, 2014

    eOne now compatible with Microsoft Dynamics GP 2013 R2

    Today is the day many of you (like us) have been looking forward to! We are excited to announce multiple product releases today, many which are needed to be compatible with the Microsoft Dynamics GP 2013 R2 release that was posted by Microsoft on May 28th.

    We have posted new installs of the following products:

    Extender 2013 (12.00.0103) - This release includes the compatibility for Microsoft Dynamics GP 2013 R2 as well as many other small fixes. Please see the Extender 2013 Release Notes for the changes.

    Flexicoder 2013 (12.00.0011) - This release includes the compatibility for Microsoft Dynamics GP 2013 R2 as well as a few fixes around the RM documents. Please see the Flexicoder 2013 Release Notes for the changes.

    SmartList Builder 2010 (11.00.0059) - This release includes a few new features including the Table Finder and Preview. It also includes a change to the Date formatting in Excel Report Builder. Please see the SmartList Builder 2010 Release Notes for the changes.

    With SmartList Builder 2013, there are now two releases to be aware of:

    SmartList Builder 2013 - Pre R2 (GP Build 1744 or less) (12.00.0067) - This build is for those users NOT on the Microsoft Dynamics GP 2013 R2 release. This release includes many different fixes. Please see the SmartList Builder 2013 Release Notes for the changes.

    SmartList Builder 2013 R2 (GP Build 1745 or higher) (12.00.0068) - This build is for those users that ARE on the Microsoft Dynamics GP 2013 R2 release. This release includes the compatibility for Microsoft Dynamics GP 2013 R2 as well as many other fixes. Please see the SmartList Builder 2013 R2 Release Notes for the changes.

    SmartView 2013 Internal (12.0.25) - This release includes a few new features.  We have added the ability to run Receivables and Payables Trial Balances. You can also now Drag and Drop fields onto the list as well as copy single fields instead of having to copy the entire row.  Please see the SmartView 2013 Release Notes for the changes. SmartView was previously already compatible with Microsoft Dynamics GP 203 R2, so this release just adds new features.

    The releases of SmartConnect, Node Builder, and SmartPost that are currently available for download are compatible with any release of Microsoft Dynamics GP 2013.

    Have questions? Reach out to us! Email info@eonesolutions.com. 

    Thursday, May 29, 2014

    SmartList Builder Article Compliation

    Ever since we've transitioned SmartList Builder back from our friends at Microsoft we've been utilizing our new found freedom and have been working hard on making it better than it's ever been before! Throughout the year we've had plenty of articles on the new SmartList Builder features. In case you've missed them I've compiled them below for you:

    SmartList Builder 2013 New Feature of the Day:

    Table Finder

    New Icons

    Preview Data

    SQL Scripting

    Built in GoTo's  

    Create New SLB Setups from SmartList

    Modifying Existing SmartLists

    Auto Updating SmartList

    Tech Tuesday: SmartList Builder

    SQL Views vs SQL Script in SmartList Builder

    SmartList Builder 2013 no longer requires Service Pack 2

    Including Extender Fields in SmartLists using a Calculated Field in SLB

    Table Joins in SmartList Builder

    Using Drill Down Builder outside of Excel Report Builder

    General SmartList Builder News

    SmartList Builder to Come Home to eOne 

    What is SmartList Builder? 

    Where to Send Your Questions on SmartList Builder

    SmartList Design Feature from Microsoft vs. SmartList Builder 

    Send Your SmartList Builder Feature Requests our Way! 

    Updated: SmartList Design Feature from Microsoft vs. SmartList Builder

    New SLB 2013 Features Released

    Ode to SmartList Builder

    Look what's coming to SmartList Builder 

    SmartList Builder, a Partner Perspective 

    New Feature for SmartList Builder

    If you have any questions regarding SmartList Builder or about an article please feel free to email us at sales@eonesolutions.com and we would be happy to assist you!

    Wednesday, May 28, 2014

    Microsoft releases R2 for Dynamics GP Today

    It is great to see Microsoft keeps enhancing Dynamics GP and the release today has some nice features added. At eOne we have been busy testing SmartList Builder, Extender, Flexicoder, SmartConnect and SmartPost on the pre-release builds from Microsoft. Everything is looking good and as we do our final Quality Assurance regressions on the released build we will be releasing new builds next week.

    We will have additional blogs on the new features we are adding in this release.

    Thanks,
    Chris Dew

    Tuesday, May 20, 2014

    Tech Tuesday: Using Drill Down Builder outside of Excel Report Builder

    Drill Down Builder has been a part of SmartList Builder for a few releases now. It can be used to give you the ability to drill back from an outside application to the GP windows. Of course, it does require that you have security to the window that you are trying to drill back to and that you are logged into GP and into the company that the data is for.

    To get started, you must setup the Drill Down in Drill Down Builder, defining the parameters and window you want to drill back to. Once you have that defined, the setup from Drill Down Builder can be added in Excel Report Builder and SmartList Builder. It can also be added to other locations such as Web Sites, e-mails, and SQL Reporting Services reports.

    When you add that drill down to the external application, it is going to need some information from you so that it knows how to drill back and with what data. Below is the basic syntax for the drill down.

    dgpp://DGPB/?Db=SQL_Instance&Srv=Server_ name
    &Cmp=Database_Name&Prod=3830&Act=OPEN&Func=Drill_Down_ID&Param_Name=Value

    The variables in the drill down break down as so:
    Db: Equal to the Instance name of your SQL Server. If you do not have a SQL instance name, leave it equal to nothing.
    Srv: Equal to the Server name of the SQL Server.
    Cmp: Equal to the database ID of the company database to drill back to.
    Prod: Equal to the product the drill down is from. If you are using Drill Down Builder, this would be 3830
    Act: Equal to the Action Type which is generally going to be OPEN.
    Func: Equal to the Drill Down Function you are calling. If you are using Drill Down Builder, it would be equal to the Drill Down ID.
    Param_Name: Param_Name is to be replaced by the Parameter you are calling and set equal to the value to pass to that parameter.

    Here are a couple of examples:

    1. In this example, we are using the default Microsoft Dynamics GP drill down functionality.

    dgpp://DGPB/?Db=SQL2012&Srv=EONE&Cmp=TWO&Prod=0&Act=OPEN&Func=OpenAcctIndx&ACTINDX=1

    The SQL Server is an instance called EONE\SQL2012, the Company is TWO, it is using one of the built in drill downs in GP so the Prod is 0, the function being called is OpenAcctIndx, and the Parameter being passed is the Account Index (ACTINDX) with the value of 1.


    2. In this second example, we are using a Drill Down Builder setup.

    dgpp://DGPB/?Db=&Srv=EONE&Cmp=TWODM&Prod=3830&Act=OPEN&Func=RMDOC&FromRMNUMBE=
    STDINV2060&ToRMNUMBE=STDINV2060

    The SQL Server is the default instance on the EONE server, the Company is TWODM, it is using a Drill Down Builder built setup so the Prod is 3830, the function being called is RM, and the Parameters being passed are the FromRMNUMBE and ToRMNUMBE, both with the value of STDINV2060.

    To help with this example, here is the setup in Drill Down Builder.

    One easy way to find the syntax of a drill down that you have built with Drill Down Builder is to add it to an Excel Report Builder report. After publishing, open the file and unhide the hidden columns. You will see a column with the drill down for each record where you can find the syntax that is being used.

    Interested in SmartList Builder? Sign up for an 11am Wednesday public demo here or email sales@eonesolutions.com for more information!

    Thursday, May 8, 2014

    New Feature for SmartList Builder

    When we look at new features for our products the ideas come from all sorts of places. Some come from customer feedback, some from implementation consultants, some are on the list because the developers just really want to write it and others are driven by the sales team. 

    This latest feature comes from the weirdest source of all – and that is Microsoft. Now Microsoft never called and asked us to build this one – but in a roundabout way they always knew we would. 

    Feature:SmartLists can now be upgraded from SmartList Designer to SmartListBuilder (SLB). 

    Why: It turns out there are a few GP VAR’s out there that thought it would be good to give the designer a try at their entry level customers. These customers went ahead and built a few SmartLists with the designer. It turns out that being frustrated by the myriad of limitations they went ahead and purchased SmartList Builder to complete these lists and build some new ones.

    Then there was a new issue – the lists they had built were unable to upgrade to SLB and they had to start again. This scenario has happened numerous times so we thought we would make it easy for people to get the lists they started into SLB – by providing an upgrade path to SLB. 

    How: There is a new maintenance form called Upgrade from SmartList Designer in the SmartList Builder >> Maintenance submenu. This form lets you select the SmartLists that you want to upgrade and when they are upgraded it automatically fixes all of the problems with them. The upgraded SmartLists have all of the fields in the selected tables with the fields in Designer displayed by default. The currency field settings in Designer are ignored and defaulted to the real settings read from the GP metadata. List fields are created correctly. The lists work for third party products and can be edited. We will not be upgrading the GoTo function in designer as it is not good enough for anyone to have had anything useful working. 

    Benefits:  Lets you quickly get to the point that you should have started at – SmartList Builder. 

    Are you looking to upgrade to SmartList Builder or have any questions regarding its functionality? Please reach out to sales@eonesolutions.com and we would be happy to assist you!

    Thursday, April 17, 2014

    eOne's 2014 Goals & Successes


    Everyone works really hard and sometimes we set goals and strive to hit those goals. Often when we hit those goals and are successful as a group – we turn around the next day and start on the next goal.  I think it is important for small businesses like ours to celebrate their successes. 

    Over the past few months eOne has set and reached some goals and I would like to highlight them here. 

    1.     Goal to reach 2000 SmartConnect Customers: For some time we have been aiming at reaching the 2000 customer target for SmartConnect. For a product that has existed for only 5 years - It is a great achievement, which we were really excited about, to reach the 2000 customer number in March 2014.  This means that there are 2000 mid-market companies that rely every day on SmartConnect to help run their business. That is a humbling responsibility. 

    A massive congratulations goes to our development team Kevin, Ruaan and Sarvanaz for continuing to produce such a high quality product. I also need to highlight Dave, Chris D, Chris H and Lorren who provide all the support and implementation skills that let us sell. And last but certainly not least thanks to Abbey who has made these sales happen.

    2.     Goal to sell 80% as much SmartList Builder as Microsoft did:  This goal was something we thought would be a steep one. The great result is that in the first quarter of 2014 we sold MORE SmartList Builders than Microsoft had sold in the same quarter a year before. This is a direct results of having great resellers. The direct responsibility goes to our sales and sales support team on getting the message out there effectively. A huge thanks to Abbey, Danielle, Alicia and Lauri.

    3.     Goal to provide our resellers the easiest possible way to make AEP payments and keep track of the eOne modules their customers own: I measure this as a raging success for a few reasons – the first being that since Jan 1st we have processed 3319 module renewals almost seamlessly. There are always a few hiccups but overall it has been a great experience.

    I add to this feedback from our resellers that goes like this: “This is the easiest site we work with and we work with 50 different ISV’s” and “Thank you for making such a great site, paying everything online without having to talk to anyone means I save so much time”.

    So a huge thanks to Lauri, Bob, Jason, Alicia and SmartConnect for helping us get the new fully integrated processes running on the website.

    I was back visiting our Australian office in March when we hit the 2000 SmartConnect customer  - so took the dev team out for a celebratory lunch – that started at 12pm and ended up sometime around 4pm.  It was a good thing that the only way home was public transport! 

    We are shortly to have a celebration in our Fargo office – just waiting for the weather to warm up a little!