Showing posts with label SmartView. Show all posts
Showing posts with label SmartView. Show all posts

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

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! 

    Wednesday, June 11, 2014

    New Release of the Inclusion of Dynamic Aged Trial Balances within SmartView


    A quick google search on term ‘GP aged trial balance’ indicates what a critical reports ATB’s for all those people that use Dynamics GP every day.

    So now to share some exciting news in the world of Dynamics GP Aged Trial Balances. Please note that Trial Balances are only available inside of GP at this time. Releasing this week will be the inclusion of dynamic Aged Trial balances within eOne’s SmartView reporting tool. Let me run through a few of the things that make this an awesome addition to every Dynamics GP installation.


    1. Super easy and flexible filtering: SmartView lets you filter on anything.  

    • If you look at the list above it contains many $0 balance customers. To filter these out you simply drop down and select the values you want. No need to rerun the report – just check a box.  


    • This works the same for any column of data where you can filter on those with a 30 day balance, or filter by a territory, salesperson or any other related field. Giving you a really flexible ATP on the fly.


    2. Ability to Re Age your ATB: Anytime based upon any date you enter. No need to run any background GP processes – simply change the date.  


    3. Auto Grouping: Auto grouping and expansion to see all the outstanding transactions in your selection. This ensures you can start with balances and drill to the details on the particular records you need to see.


    4. Drill Down: To the detail in GP via the GOTo’s.


    5. Grouping and totaling by any field you choose: In this example, we have grouped the ATB by SalesPerson. Subtotals are auto displayed on the screen and each group can be expanded or closed.


    6. Find: CTRL F for "find" lets you find any value anywhere in the ATB. 

    7. Export the report to: Excel, CSV or PDF. When you export it keeps the formatting you have on screen. 

    8. Cut and Paste: This is the coolest. Simply cut and paste any selection of records, sequential or not, using CTRL C and CTRL V to paste to Excel or Outlook or anywhere you choose.

    Interested in learning more about SmartView? Email sales@eonesolutions.com for more!