gpug ® summit 2011 november 8-11 caesars palace – las vegas, nv the worst mistakes you can make...
TRANSCRIPT
![Page 1: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/1.jpg)
GPUG® Summit 2011November 8-11
Caesars Palace – Las Vegas, NV
The Worst Mistakes You Can Make With Dynamics
GPMark Polino - I.B.I.S., Inc.
John Lowther – Sta-Home Health
![Page 2: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/2.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Share
Feel free to Tweet, Blog or update Facebook live with things you learned in this session.
Official Tag: #GP2011
![Page 3: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/3.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Not Backing Up
Backing up only the sample DB Not backing up files, forms, reports, etc. Not backing up before year end Not backing up before SQL commands Not backing up to separate drive Not performing TEST RESTORES!
![Page 4: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/4.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Chart of Accounts Errors
Framework too small Not updating the chart
for GP Wrong account posting
type
![Page 5: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/5.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Deleting
Drop Table Remove Delete – Batch– Budget
Deleting the LDF/MDF files Deleting SQL Elements – users,
procedures, views, etc.
![Page 6: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/6.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
History
Not Maintaining History Maintaining Inconsistent History Running utilities without History
![Page 7: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/7.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Ignorance
What does this utility do? Testing Mass Modify in Production Activating Account Security without setup Changing posting settings Testing in production Using Auto Shrink
![Page 8: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/8.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Ownership
No process owner Lack of business buy in Separating decision making from
consequences No implementer/poor implementer Lack of internal resources
![Page 9: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/9.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Reconciling
Multiple AR/AP accounts Bringing unreconciled accounts into GP Timing Differences– Setup– Transactional
Not maintaining history Posting in summary
![Page 10: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/10.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Security
Locking security down to the point that people can’t do their jobs
Security through obscurity Everyone a Power User Turning off company master security Not rebuilding security from v9 to v10+
![Page 11: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/11.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Year End
Running Fixed Asset Year End Close without depreciating through Year End
Not checking account types Fixed Asset calendar out of sync with
Fiscal Year Closing year multiple times [GL, Inv., etc.] Not backing up
![Page 12: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/12.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Attention to Detail
SQL statements without a Where clause Trying to remove one history record and
removing them all Not validating correct posting [payroll, GL,
etc.] Allow Logs or TempDB to grow
uncontrolled and use up all available space
![Page 13: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/13.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Customizations
Customizing to fit old system Customizing instead of using ISV solution Customizing for today with no room for
change Solving problems with complicated
processes instead of customization No customization support
![Page 14: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/14.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Implementation
Not running and clearing catch up depreciation before 1st depreciation run
Running the full GP client remotely over VPN
Truncating zeros with Excel/CSV on master data load
Assuming that change is easy Under training Under communicating
![Page 15: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/15.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Support
MyGPSearch.com– Custom search engine dedicated to Dynamics
GP– Search more than 100 sites with tens of
thousands of resources for supportinformation on Dynamics GP
– Web (http://mygpsearch.com)– Mobile (http://m.gpsearch.com)– Android (http://tinyurl.com/4uqr3bf)
![Page 16: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/16.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
More Tipshttp://community.dynamics.com/product/gp/f/32.aspx
![Page 17: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/17.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
More Tips
Microsoft Dynamics GP 2010 Cookbook– Book, Kinkdle, ePub and PDF options– Amazon, Barnes and Noble, Packt Publishing
![Page 18: GPUG ® Summit 2011 November 8-11 Caesars Palace – Las Vegas, NV The Worst Mistakes You Can Make With Dynamics GP Mark Polino - I.B.I.S., Inc. John Lowther](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f225503460f94c3a360/html5/thumbnails/18.jpg)
GPUG Summit 2011– Las Vegas www.gpug.com
Follow Up
Mark [email protected]/mpolinoTwitter.com/DynAcctNetFacebook.com/DynAcctNetLinkedIn.com/in/mpolino
John LowtherJohn [email protected] Dynamics GP DBA (Blog)GPUG Member Tidbits (Blog)Microsoft Dynamics GP "Ask The Community Website" (Post)