«
»

50 Tips for Getting More out of Microsoft Dyanmics GP

Thanks to Mark Polino who presented these 50 tips for getting more out of Microsoft Dynamics GP:

1. Explore GP with Better Navigation

2. Brighten Things Up with Red Required Fields

3. Clarify Processes with Window Notes

4. Speed Things Up with Quick Links

  • Use Quick Links on the Home page for fast access to favorite windows, navigation lists, web pages, external apps and files.
  • Click the Pencil to edit and select Add or Modify to change. Use Up or Down to change order.

5. Improve Organization on the Navigation Bar

  • Reorganize the Navigation Bar for faster access to highly used areas
  • Click Configure Buttons on the bottom right. Click Navigation Pane Options
  • Use this to turn buttons on or off and reorder the navigation pane buttons
  • You can also show more or fewer buttons and add windows, Smartlists, web pages, etc. from the Configure Buttons menu

6. Gain Insight Into the Home Page Metrics

7. Get New Benefits from User Classes

8. Take Control with User Classes and Smartlists

9. Open Windows on Startup with the Shortcut Bar

10. Copy and Paste Header with Data in SQL Management Studio

11. Correct entries that didn’t originate in the GL

  • By default entries not originating in GL can’t be changed with GL correction entry
  • • This is controlled with a setting in Get an unposted entry for posting or adjustment
  • • http://msdynamicsgp.blogspot.com/2010/02/weekly-dynamic-correcting-entries-that.html

12. Control Entry with Allow Transaction Entry

13. Gain Audit Control with Posting Numbers

  • Turn on Posting Numbers for a second GL transaction numbering scheme
  • These numbers are “gapless” for better audit reporting
  • Setup->Company->Company, Options. Check “Enable Posting Numbers in General Ledger”
  • Select to reset by year or period below
  • These numbers will now appear on posting reports throughout the system including as a option in Smartlists

14. Get Complete Transactions with Taxes in Journal Entries

15. Control Bank Reconciliations with Grace Periods

16. Change up Payables with the Edit Check Batch window

17. Improve Picking with Picking Instructions

18. Improve Reporting by Properly Closing a Purchase Order

19. Move Things Around with In Transit Inventory Transfer

  • New in version 10, In-Transit Inventory provides a mechanism to move Inventory between company sites
  • Allows Transfer documents, site receiving and shipment tracking via web and prevents sale during transfer
  • Transactions->Inventory->In-Transit Transfer Entry

20. Improve Reporting with Purchasing Control Account Management

  • Purchase Control Account Management allows for the temporary allocation of Accounts Payable to a segment of the chart of accounts. Usually this represents a department or division. This is followed by an automatic reversal after month end
  • Allocation is based on the expense accounts for open AP
  • This is a Routine that is run at a regular interval like month end
  • http://msdynamicsgp.blogspot.com/2009/03/weekly-dynamic-control-account.html

21. Improve Transparency by Showing Payment Accounts

  • When applying payments as part of an AP or PO related transaction, the payment accounts are rolled up
  • There is a setting that doesn’t roll up the accounts and makes the transaction easier to understand
  • To Activate go to Tools->Setup->Company->Company and check

22. Prevent Errors with DocDateVerify

  • Free DocDateVerify utility from MS prevents subledger entry to non-existent fiscal years.
  • Contact MS or your Partner for a copy.

23. Smooth Accounts Payable with Scheduled Payments.

24. Gain Reporting Control with Tax Dates

25. Control Your Inventory by Preventing the Sale of Discontinued Items

  • Discontinued items can be sold until gone by default
  • Typical advice is to write off items to prevent sale if necessary
  • A setting can prevent the sale of discontinued items without writing off the items
  • Turn it on at Tools->Setup->Sales->Sales Order Processing, Options, Uncheck “Allow Sales of Discontinued Items” in the bottom grid area
  • http://msdynamicsgp.blogspot.com/2009/08/weekly-dynamic-prevent-sale-of.html

26. Speed Up AR Aging by NOT Printing the Report

27. Speed Up Collections Management with Paid Transaction Removal

  • With a large number of open transactions, the Collections Management windows can bog down and move slowly
  • The only solution is to run the Paid Transaction Removal routine
  • Run the Paid Transaction Removal Routine in Project Accounting first (if applicable) then in AR
  • Paid Transaction Removal moves paid transactions from Open to History. It does not delete data
  • http://msdynamicsgp.blogspot.com/2009/09/weekly-dynamic-speed-up-collections.html

28. Undo Errors with Referenced Transactions

  • In Project Accounting transactions (Timesheet, Equipment, Etc.) you can change the transaction type from Standard to Reference
  • Reference transactions refer back to a previous transaction and allow you to change transaction lines
  • They accept negatives and can be used to move transactions between projects and cost categories
  • Reference transactions cannot exceed the original transaction so they are safe for moving information
  • http://msdynamicsgp.blogspot.com/2009/02/weekly-dynamic-project-accounting.html

29. Speed Setup with Budget Line Update

  • If you wanted to add a cost category to multiple projects in the past it was a painful experience
  • Now with Budget Cost Category Roll out you can push a cost category to multiple projects
  • Start at Tools->Routines->Project->Update Budget Lines
  • Pick a cost category. Optionally set defaults. Select projects to roll out to by moving them from left to right. Optionally choose to add this to templates as well. Click Process
  • http://msdynamicsgp.blogspot.com/2008/12/weekly-dynamic-update-budget-lines-in.html

30. Spread Project Costs with Project Allocations

  • Sometimes companies want to collect costs in a project and allocate those costs across multiple projects
  • GP 10 Project Accounting now supports this with Project Allocations
  • Setup in Cards->Project->Project Allocations
  • Specify From and To Projects, Cost Categories, Allocation Type and Misc Transactions and Cost Categories for the allocation transactions
  • http://msdynamicsgp.blogspot.com/2008/10/weekly-dynamic-project-allocation.html

31. Spread Payroll Costs with Benefit Allocations

  • If you are using GP Payroll, you can apply payroll benefit costs to projects based on project timesheet data
  • Tools->Setup->Payroll->Benefit to setup a benefit
  • Cards->Project->Cost Category , Go Button (upper right), Benefits – Associate Benefit with a Cost Category
  • Pick benefits and choose to allocate by time or cost and select a misc log transaction to hold the allocation transactions
  • Tools->Routines->Project-Benefit Allocation actually runs the allocation and creates misc. log transactions
  • http://msdynamicsgp.blogspot.com/2008/10/weekly-dynamic-project-accounting.html

32. Create Assets from Project with a simple process.

  • A connection between PA and FA doesn’t exist
  • To turn a project into an Asset, setup a “Transfer to Asset” cost category
  • Once the project is done, create a negative Miscellaneous Log transaction to the Transfer to Asset category for the full amount of the project. The GL should be an offset credit to project costs and a debit to the FA clearing account
  • Create an asset from the amount in FA clearing
  • This process retains project details for auditing and reporting but project nets to zero.

33. Distribute FRx Reports Directly as Excel Files for Greater Compatibility

  • In FRx on the Output Tab, Output options, change the default FRx Drilldown Viewer to Formatted Excel

34. Improve Custom Report Writing with a Table Reference

  • Determining the appropriate tables for Dynamics GP can be time consuming using standard GP resource definitions
  • Use our Excel based Table Reference instead
  • http://www.box.net/shared/jc90kdsh2k

35. Control Smartlist printing with Column widths

36. Get Reporting Flexibility with Excel Report Builder

37. Gain Valuable Insight with Analysis Cubes

  • Analysis Cubes offer pivot table style looks into all of your Dynamics GP data

38. Get Free Spell Check Functionality In Dynamics GP

  • WillowWare, a 3rd party vendor, offers free spell check functionality for Dynamics GP
  • This is a CNK file so it’s an easy install
  • Registration required
  • http://www.willoware.com/spellcheck/

39. Personalize Internet Options with Internet User Defined fields

40. Make Logging On Easier with a Caps Lock is On Warning(VBA)

41. Control Licensing By Preventing Users from Logging In To Multiple Companies (VBA)

42. Reduce Errors with Colored Backgrounds Per Company

43. Resolve issue by turning off Outlook connections

44. Understand Security With Information About the Default Security Roles

  • There is a document which lists all the default GP Roles and descriptions of how they are used
  • It provides a great starting point for working with security
  • Download it here: http://www.box.net/shared/sgggsvnazv

45. Troubleshoot Security Issues with the Security Profiler

46. Get Group Help with Social Media – Blogs, Twitter, YouTube

  • Social Media sites provide additional avenues for support and learning

47. Watch Your Way to Greatness with CustomerSource Online Training Videos

48. Watch Your Way to Greatness with CustomerSource Online Training Videos
49. Use Screen Shot Capture and Email from the Support Debugging Tool for Precision Help

50. Show Security Details when access is denied

Tags:

This entry was posted on Thursday, April 29th, 2010 at 2:13 pm and is filed under Industry News. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply