NTG 02 50 Resources in 50 Minutes GPUGsummit

NTG 02: 50 Resources in 50 Minutes #GPUGsummit

GPUG All Star – Béat Bucher, Business Analyst Forensic Technology, Montreal, Quebec Experience - Over 10 years of GP experience GP System Administrator, newly converted IT-Guy to Finance BI-Geek Modules: Project Accounting, Canadian Payroll, Inventory, POP, Management Reporter, Manufacturing Fun Facts - Website/Blog: http: //dyngpbeat. wordpress. com/ Remember that the past does not equal the future… always look ahead. Think out of the box and remember there is always another way of doing things. #GPUGsummit

Problem Solver #GPUGsummit 5

Resource Types • Educational • On the go (Hey boss, please pay for this class!) (Solve it now!) • Read and relax (Watch the Oakland Raiders lose, or relax and read a SQL blog? ) #GPUGsummit 6

Customer. Source e. Learning 1. Go to Customer. Source. 2. On the top navigation, choose your Microsoft Dynamics product. 3. On the top navigation, hover Learning. 4. Click E-Learning. http: //dynamics. microsoftelearning. com/catalog/default. aspx https: //mbs. microsoft. com/customersource/northamerica/gp/lear ning/documentation/ Get a Customer. Source login from your GP Administrator. Step by step transactions for every module. #GPUGsummit 7

Manuals located in your install folders Have your GP Administrator copy them to an accessible location. C: Program Files (x 86)Microsoft DynamicsGP 2010Documentation Every module! #GPUGsummit 8

More Reading Materials • Accolade Books http: //www. accoladepublications. com • PACKT Books https: //www. packtpub. com #GPUGsummit 9

Forums • GPUG Collaborate http: //www. gpug. com/home • Microsoft Dynamics Forum https: //community. dynamics. com/gp/default. aspx #GPUGsummit 10

Microsoft Dynamics Resource Library https: //www. microsoft. com/en-us/dynamics/resource-library. aspx Learn about available products. #GPUGsummit 11

GPUG Academy classes and webinar series http: //www. gpug. com/academy #GPUGsummit 12

Dynamics University http: //dynamicsuniversity. com #GPUGsummit 13

Official Microsoft classes with your GP partner Talk with your partner. If you’re hiring a power user or staff accountant who doesn’t have specific GP experience, these classes can be valuable. You get the training books! #GPUGsummit 14

GP Window http: //www. gpwindow. com/index. php More than 50 resources… thousands of resources… #GPUGsummit 15

GP Help – About this window Bottom corner of every window: Search by topic! #GPUGsummit 16

Security Roles • List of security roles (Jivtesh Singh) http: //www. jivtesh. com/2007/11/gp-10 -security-excel-sheet-which-has. html GP 10 security principles still apply in later versions! #GPUGsummit 17

Planning for Security (IT) • Planning for security whitepaper http: //www. microsoft. com/en-us/download/details. aspx? id=3537 http: //www. microsoft. com/en-us/download/details. aspx? id=21753 http: //www. microsoft. com/en-us/download/details. aspx? id=34666 GP 10, GP 2013 #GPUGsummit 18

Support Debugging Tool http: //blogs. msdn. com/b/developingfordynamicsgp/archive/2009/ 08/07/support-debugging-tool. aspx David Musgrave, Mariano Gomez Really great tool for examining security & permissions! #GPUGsummit 19

Troubleshooting GP • Knowledgebase https: //mbs. microsoft. com/customersource/northamerica Get a Customer. Source login from your GP Administrator. #GPUGsummit 20

Macros in GP http: //blogs. msdn. com/b/developingfordynamicsgp/archive/2008/10/3 0/how-to-use-word-mail-merge-and-macros-to-import-data. aspx Using Word and macros to import data to GP. https: //app. box. com/shared/nbdzqzkt 29 List of macro commands for GP by Kevin Gross, link kindly provided by Mark Polino. #GPUGsummit 21

Resource Descriptions in GP Microsoft Dynamics GP > Tools > Resource Descriptions #GPUGsummit 22

#GPUGsummit 23

Dexterity Manual – for Smartlist Tables • Want to know what tables are used in your out-of-the-box Smartlists? • Go to part 7, begin on page 328 of chapter 32. http: //www. microsoft. com/en-us/download/details. aspx? id=10739 Tip: Install the GP SDK manuals that are part of the DVD #GPUGsummit 24

Smartlists Templates Can be imported and modified with Smartlist Builder http: //dynamicsuser. net/blogs/developinggp/archive/2012/04/18/editingstandard-smartlists-with-smartlist-builder. aspx #GPUGsummit 25

Table References, http: //victoriayudin. com/gp-tables/ #GPUGsummit 26

Table References, http: //dyndeveloper. com/Dyn. Module. aspx #GPUGsummit 27

and more Table References… Mark Polino https: //onedrive. live. com/edit. aspx? cid=BC 679914609 AA 946 &resid=BC 679914609 AA 946%2160991&app=Excel GP Table Reference https: //www. gptablereference. com/ #GPUGsummit 28

…including third party Table References. Wennsoft Table Reference (Zubin Gidwani) https: //app. box. com/shared/tv 67 o 0 iilf Ask your vendor – don’t be shy! #GPUGsummit 29

GPUG Share My Code http: //community. gpug. com/Communities/View. Communities/Gro up. Details/? communitykey=75691 c 5 f-3 e 7 d-4373 -9 b 92 dbb 8973 fd 972&tab=Group. Details Use the folder view to get the entire list! #GPUGsummit 30

Learning SQL? • Look for local classes (Places like New Horizons, or your local tech training school) • Look for online classes (Sites like Pluralsight and others) #GPUGsummit 31

W 3 Schools Online Tutorials http: //www. w 3 schools. com/sql/default. asp #GPUGsummit 32

SQL PASS Professional Association for SQL Server http: //www. sqlpass. org because user groups are AWESOME! they have local chapters too! #GPUGsummit 33

SQL Saturday https: //www. sqlsaturday. com because you can’t beat free training by expert users! #GPUGsummit 34

Microsoft Training Courses and Certifications http: //www. microsoft. com/learning/en-us/sql-training. aspx MTA, MCSE #GPUGsummit 35

Microsoft Technet http: //technet. microsoft. com/en-us/library/jj 673201(v=gp. 30). aspx Amazing online library! All Microsoft products! But wait, there’s more… #GPUGsummit 36

A crazy number of SQL blogs… • Dave Pinal (SQL in Sixty Seconds) http: //blog. sqlauthority. com • Jeff Smith http: //weblogs. sqlteam. com/jeffs/default. aspx #GPUGsummit 37

Stack Exchange http: //stackoverflow. com Crazy big encyclopedia with years’ worth of people’s “help me code this” questions and answers. Use “SQL Server” as your search term. #GPUGsummit 38

SQL Server Central www. SQLServer. Central. com Another forum and crazy big online encyclopedia of SQL stuff. Browse away! #GPUGsummit 39

Microsoft Virtual Academy http: //www. microsoftvirtualacademy. com/ Can’t beat free training! #GPUGsummit 40

Microsoft Office Online Training http: //office. microsoft. com/en-us/training/ #GPUGsummit 41

Microsoft Dynamics Developer Center http: //msdn. microsoft. com/en-us/dynamics/aa 937751. aspx #GPUGsummit 42

MS Development Documentation http: //msdn. microsoft. com/en-us/dynamics/gp/bb 687714. aspx #GPUGsummit 43

Developing for Dynamics GP http: //blogs. msdn. com/b/developingfordynamicsgp/ David Musgrave (the Support Debugging Tool dude) Find a comfortable seat, read for a while… #GPUGsummit 44

Microsoft Blogs http: //community. dynamics. com/gp/b Lots of GP people writing about lots of GP stuff #GPUGsummit 45

GPUG Collaborate Blogs http: //www. gpug. com/resources/blog Lots of GPUG people writing about lots of GP stuff #GPUGsummit 46

Your GP MVP blogs • Victoria Yudin http: //victoriayudin. com/ • Jivtesh Singh http: //www. jivtesh. com/ • Mark Polino http: //mpolino. com/gp/ Mariano Gomez http: //dynamicsgpblogster. blogspot. com/ Leslie Vail ttp: //dynamicsconfessions. blogspot. com/ Belinda Allen http: //saci. com/blogs/belinda-the-gp-csi/ Beat Bucher http: //dyngpbeat. wordpress. com … and other awesome folks I forgot about on the day I was creating this slide… #GPUGsummit 47

Twitter #gpug #msdyngp Which list is more fun? GPUG or Pittsburgh? #sqlserver #sqlhelp #gpugsummit Make a list, use a dashboard… #GPUGsummit 48

Linked. In • Search for Microsoft Dynamics and other groups • Follow users like Microsoft Dynamics, your ISV or VAR #GPUGsummit 49

You. Tube There’s a Dynamics channel! http: //www. youtube. com/playlist? list=PLEF 2 F 87 F 176 AB 5 BFA #GPUGsummit 50

Microsoft Case Studies http: //www. microsoft. com/casestudies/ Find out what other companies are doing. #GPUGsummit 51

Zines! When you’re done reading your excellent GPUG magazine, other online publications are also available: http: //msdynamicsworld. com #GPUGsummit 52

SQL PASS Summit http: //www. sqlpass. org/summit/2016/welcome. aspx And Online 24 h : http: //www. sqlpass. org/Events/24 Hoursof. PASS. aspx #GPUGsummit 54

Microsoft Ignite 2016 • The replacement for Convergence. . Maybe. • https: //ignite. microsoft. com/#fbid=h. IG 1 H 1 Ym. BS 4 • September 26– 30, 2016, Atlanta, GA • 700+ sessions • Deep dives and demos • 100+ vendors at the expo • Not much Dynamics GP content. #GPUGsummit 56

GPUG Summit! You’re here at Summit! What do you get? • Your local user group This clip art is called “Business people jumping for joy” • Your classes and forums • The shared knowledge of your peers #GPUGsummit 57

You can be your own best resource Keep a One. Note notebook of all your problems and solutions #GPUGsummit 58

Summary List • Classes • Books, manuals • Blogs • User groups • Industry associations • Microsoft resources • Forums • People #GPUGsummit 59

Thank You For Attending! Still have questions ? Send me your questions by e-mail or follow me on the GPUG Collaborate site and Twitter E-mail Twitter Blog beat. bucher@ultra-ft. com @GP_Beat http: //dyngpbeat. wordpress. com/ #GPUGsummit 60