Welcome Microsoft Dynamics GP User Group GPUG Colorado

Welcome! Microsoft Dynamics GP User Group (GPUG®) Colorado Regional Chapter Meeting May 21, 2013 Regional Chapters

Agenda 8: 30 Welcome & Introductions 9: 00 Tour of SACWSD and Member Showcase 9: 30 Where the *&(# is My Data? 10: 30 Rockton Software 12: 00 End Announcements Regional Chapters

Welcome & Introductions § § § Name Company Role in Company How long have you personally used GP? Did you attend Convergence? – What did you enjoy most? Regional Chapters

Connect Learn Share http: //community. gpug. com

4 -Steps for Getting Started 1. Log in using your Windows Live ID 2. Subscribe to the “All Members” and your Regional Chapter discussion groups 3. Start a conversation in the All Members group 4. Respond to a discussion thread Regional Chapters

Step 1 Log in at http: //community. gpug. com using your Windows Live ID – – Complete your profile and add a photo Hint: Use the ‘Grab from Linked. In’ option Regional Chapters

Step 2 Subscribe to the “All Members” and your Regional Chapter discussion groups – Select the Daily Digest option – Scroll to bottom of page and select ‘Save’ Regional Chapters

Step 3 Start a conversation in the All Members group – Ask a question to collect insight from your peers Regional Chapters

Step 4 Respond to a discussion thread – Post an answer to another member’s question or additional comments Regional Chapters

WHERE THE (*#$ IS MY DATA!? !? Tips, Tools, and Tricks Mark Huff South Adams County Water Peer to Peer | Greater Scale | More Voices | Faster www. GPUG. com Where USERS Make the Difference!

WHERE IS MY DATA!? !? §Tips and tricks to finding GP Data §Roundtable discussion §Ideas Where USERS Make the Difference!

WHERE IS MY DATA!? !? §Core Dynamics GP Resources –Dynamics GP Resource Descriptions –Dynamics GP SDK • Install from Dynamics GP media –Report Builder hide and seek • Things to watch –Creates a “modified report” when opening the original –Modifier hide and seek Where USERS Make the Difference!

WHERE IS MY DATA!? !? §“Other” Dynamics GP Resources –SQL Logging –Dexterity –Smartlist and Smartlist Builder –Support Debugger Tool –Debug Mode—not on a production server Where USERS Make the Difference!

WHERE IS MY DATA!? !? §“Other” Resources –SQL Profiler Where USERS Make the Difference!

WHERE IS MY DATA!? !? §Third Party Resources –Rockton Toolbox • Inspector –Third Party Books • Accolade Publications—Information Flow and Posting • Mark Polino- Microsoft Dynamics GP 2010 Cookbook Where USERS Make the Difference!

WHERE IS MY DATA!? !? §Third Party Resources –Web • Mark Polino-- http: //dynamicaccouting. net/ • Victoria Yudin --http: //victoriayudin. com/gp-tables/ • David Musgrave-http: //blogs. msdn. com/b/developingfordynamicsgp/archi ve/2008/10/05/finding-table-and-field-information-inmicrosoft-dynamics-gp. aspx Where USERS Make the Difference!

WHERE IS MY DATA!? !? §Third Party Resources –ANY Dynamics MVP –GPUG Members –Dynamics Communities –-----Johns Blog----- • http: //community. dynamics. com/product/gp/gptechnical /b/gpdba/default. aspx Where USERS Make the Difference!

WHERE IS MY DATA!? !? §Third Party Resources –How do you deal with ISV products? • Ask the ISV • Use other methods shown here • Member profiles in GPUG Where USERS Make the Difference!

WHERE IS MY DATA!? !? §My Tricks for finding data –A GREAT memory for trivia –Table Names and numbering “schemes” • http: //dynamicsconfessions. blogspot. com/2010/07/dyna mics-gp-table-names. html Where USERS Make the Difference!

WHERE IS MY DATA!? !? Mark Huff Technology Services Specialist South Adams County Water & Sanitation District Commerce City, Colorado mhuff@sacwsd. org Please put GPUG in subject line 720 -206 -0540 (office) 720 -480 -3429(cell) Where USERS Make the Difference!

GPUG Regional Chapter Meeting - Colorado Making Microsoft Dynamics® GP Work Simpler and Easier Presented by: Mark Rockwell www. rocktonsoftware. com Work Simpler & Easier®

Who is Rockton Software? Rockton Software is a creative company that develops products that make Microsoft Dynamics GP more intuitive and user-friendly to improve customers’ lives by making their work simpler and easier. Established: 1999 www. rocktonsoftware. com Work Simpler & Easier®

Suite of Products Smart. Fill Dynamics GP Toolbox Auditor Dynamics Report Manager (DRM) Omni Price www. rocktonsoftware. com Work Simpler & Easier®

Smart. Fill The Google-style data entry search tool. § Motions count! § Boosts productivity! § Save time and money! www. rocktonsoftware. com Work Simpler & Easier®

For the chart below 4 lookups = 1 minute of savings* Based on any lookups done within Microsoft Dynamics GP Lookups If user make $15/hour Lookups Per Day 100 300 500 Savings in Seconds 1500 4500 7500 Savings in Minutes 25 75 125 Savings in $ Per Day $6. 30 $18. 75 $31. 25 Savings in $ Per Week $31. 25 $93. 75 $156. 25 Savings in $ Per Year $1, 638. 00 $4, 875. 00 $8, 125. 00 1000 15000 250 $62. 50 $312. 50 $16, 250. 00 Smart. Fill can save you time and money… www. rocktonsoftware. com Work Simpler & Easier®

Dynamics GP Toolbox A collection of tools that improve the Microsoft Dynamics GP experience. § Less deadbeats hogging your Microsoft Dynamics GP licenses § Better control over security § Easily find windows in Microsoft Dynamics GP § Find the data that hides behind those window fields www. rocktonsoftware. com Work Simpler & Easier®

Auditor Track data changes in Microsoft Dynamics GP, including at the SQL database level. Why auditing is important: § Fraud Prevention § Procedural Clarification § Performance Evaluation § Find the data that hides behind those window fields www. rocktonsoftware. com Work Simpler & Easier®

Dynamics Report Manager (DRM) Any report, any time, any where, any device. § More discretion and efficiency when distributing reports § Skip licensing and training on additional technology § E-mail invoices, individually or in batches www. rocktonsoftware. com Work Simpler & Easier®

Omni Price Your magical slice-and-dice-your-price device. § Simple and easy price updates § More control of Price levels § Change pricing just for a certain date range § Special pricing for certain Customers or Items www. rocktonsoftware. com Work Simpler & Easier®

Product Statistics Installs as of May 15, 2013 Sites Users 354 12, 130 1, 405 24, 873 Auditor 601 17, 043 Omni Price 200 5, 078 Dynamics Report Manager (DRM) 521 13, 437 Dynamics GP Toolbox Smart. Fill www. rocktonsoftware. com Work Simpler & Easier®

Demos can be viewed with a quick click of a mouse! http: //www. youtube. com/user/rocktonsoftware/videos Product Pricing varies depending on your product selection. http: //www. rocktonsoftware. com/sales/pricing. aspx FREE trial keys! Request your FREE 30 -day trial keys today! email sales@rocktonsoftware. com www. rocktonsoftware. com Work Simpler & Easier®

END ANNOUNCEMENTS Regional Chapters

GPUG – What’s Next? § Mark your calendars for the next meeting – Tuesday August 20 – Who’d like to host? § GPUG Proposed Topics for Q 3: – Fixed Assets – Smart. Lists Tips & Tricks – Upgrade Insights § Join GPUG to be sure you are included on the invitation list for upcoming events – http: //www. gpug. com/join-gpug – Already a member? Update your Profile! Regional Chapters

GPUG Membership Basic Free Premium Small Business Mid-Market Enterprise 1 -9 GP Licenses 10 -49 GP Licenses 50+ GP Licenses $400 USD/year $700 USD/year $950 USD/year A single GPUG Membership includes benefits for your entire organization. Basic Membership Includes: • e. Newsletter • Level 100 Webinars • Paid access to Regional Chapter Meetings & Events • Partner Showcase Webinars • Academy Learning • Share My Code www. gpug. com Premium Membership Includes: § Basic level benefits, PLUS: § Unlimited Workshops, Webinars & Roundtables • FREE access to Regional Chapter Meetings & Events § Special Interest Groups § Microsoft Conduit Meetings § Discounts on Summit (annual conf) § Free & Discounted Academy Courses Regional Chapters

Elevate… § § …Your Knowledge - choose from over 150 sessions …Your Network - Participate with over 550 attendees …Your Experience - optional Academy Onsite Learning courses …Your Team - Attend ISV Partner Solutions Expo The only Microsoft Dynamics GP conference For Users by Users! Week of October 21 st Early Bird Registration is NOW OPEN! Premium Members Receive a $200 person Registration Discount! (GPUG Summit 2013 Preview Webinar May 22) http: //gpugsummit. com/ Contact: Bob Buresh GPUG Membership Manager bob@gpug. com Regional Chapters

Why Do You Attend GPUG Summit? HTTP: //WWW. YOUTUBE. COM/WATCH? FEATURE=PLAYER_EMBEDDED&V=_FGJTZQIE 8 S Regional Chapters