You are previewing Microsoft Dynamics GP 2013 Cookbook.
O'Reilly logo
Microsoft Dynamics GP 2013 Cookbook

Book Description

For beginners or intermediate users this is a highly practical cookbook for Microsoft Dynamics GP. Now you can really get to grips with enterprise resource planning by engaging with real-world solutions through recipes and screenshots.

  • Understand the various tips and tricks to master Dynamics GP, and improve your system's stability in order to enable you to get work done faster

  • Discover how to solve real world problems in Microsoft Dynamics GP 2013 with easy-to-understand and practical recipes

  • Access proven and effective Dynamics GP techniques from authors with vast and rich experience in Dynamics GP

  • In Detail

    Microsoft Dynamics GP is an enterprise resource planning system, essentially an accounting system on steroids, designed for mid-sized organizations. The implementation of Dynamics GP is usually considered to be complex, and people often realize there must be more efficient ways of working with the system. This book will show readers how to improve their use of Dynamics GP and get the most out of this tool quickly and effectively.

    "Microsoft Dynamics GP 2013 Cookbook" picks up where implementation training leaves off. Whether you are new or experienced you will find useful recipes for improving the way you use and work with Dynamics GP. The clear recipe steps and screenshots make implementing these solutions easy for users of any level and will be sure to improve your efficiency with the Dynamics GP 2013 system.

    The book starts with recipes designed to enhance the usefulness of Microsoft Dynamics GP by personalizing the look and feel of the application. Most of the recipes are designed to give tips for a typical installation of Dynamics GP, including core financials and distribution modules. The book then moves through recipes that include automating Dynamics GP to allow users or administrators to focus on value adding tasks, harnessing the power of SmartLists to leverage both simplicity and power, connecting Dynamics GP to Microsoft Office 2013, exposing hidden features in Dynamics GP, and much more!

    Through the final chapters, the book covers system maintenance and extending Dynamics GP with the Support Debugging Tool and Professional Services Tools Library.

    Table of Contents

    1. Microsoft Dynamics GP 2013 Cookbook
      1. Table of Contents
      2. Microsoft Dynamics GP 2013 Cookbook
      3. Credits
      4. About the Author
      5. Acknowledgment
      6. About the Author
      7. Acknowledgment
      8. About the Reviewers
      9. www.PacktPub.com
        1. Support files, eBooks, discount offers and more
          1. Why Subscribe?
          2. Free Access for Packt account holders
          3. Instant Updates on New Packt Books
      10. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Errata
          2. Piracy
          3. Questions
      11. 1. Personalizing Dynamics GP
        1. Introduction
        2. Improving visibility by setting required fields to bold and red
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Modifier with Visual Basic for Applications (VBA)
        3. Getting faster access to data with the shortcut bar
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Use external Shortcuts for greater flexibility
            2. Organize with folders
            3. Complex shortcuts
          5. See also
        4. Reducing clicks with start-up shortcuts
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. File example
            2. Drag and drop
          5. See also
        5. Personalizing the Home page by selecting the right role
          1. How to do it...
          2. See also
        6. Further personalizing the Home page by customizing the layout
          1. How to do it...
          2. There's more...
          3. See also
        7. Speeding access to data with Quick Links
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        8. Rearranging navigation to make it easier
          1. Getting ready
          2. How to do it...
          3. How it works...
        9. Jumping to the right location with breadcrumbs
          1. Getting ready
          2. How to do it...
        10. Managing personal reports with My Reports
          1. How to do it...
          2. There's more...
            1. Reports without options
            2. Better dates in report options
          3. See also
        11. Viewing open items with the Task List
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Recurring tasks
          5. See also
        12. Visualizing information with Business Analyzer on the Home page
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Multiple Business Analyzer reports
            2. Full view
          4. See also
        13. Accessing accounts faster with favorites in lookups
          1. Getting ready
          2. How to do it...
          3. There's more...
            1. Set as default view
            2. Restricted list
            3. Resetting
            4. Account security
          4. See also
        14. Cleaning up the mess by fixing AutoComplete errors
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Removed unused entries
            2. Reduce the number of AutoComplete entries
            3. Reset AutoComplete
      12. 2. New in Dynamics GP 2013
        1. Introduction
        2. EFT format enhancements
          1. Getting ready
          2. How to do it...
          3. There's more...
        3. Enhanced GL Year-End Closing
          1. How to do it...
          2. How it works...
          3. There's more...
        4. Modifying the sales order's Ship To address
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        5. Reason codes for inventory transactions
          1. Getting ready
          2. How to do it...
          3. There's more...
          4. See also
        6. Tolerance handling
          1. How to do it...
          2. How it works...
          3. See also
        7. Tracking serial and lot numbers on drop ship POs
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more…
          5. See also
        8. Selecting multiple serial or lot numbers
          1. How to do it...
          2. There's more…
          3. See also
        9. Relating or linking items for suggested sales
          1. Getting ready
          2. How to do it...
          3. See also
        10. Intercompany asset transfer
          1. How to do it...
          2. There's more...
          3. See also
        11. Historical depreciation report
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Mass depreciation reversal
            2. Reset history in detail
          4. See also
        12. Fixed assets batches
          1. How to do it...
          2. There's more...
          3. See also
      13. 3. Organizing Dynamics GP
        1. Introduction
        2. Speeding account entry with account aliases
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        3. Cleaning account lookups by removing accounts from lookups
          1. How to do it...
          2. How it works...
        4. Gaining visibility by using horizontal scroll arrows
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Activating horizontal scroll arrows for all users
            2. Widening segments for better visibility
        5. Streamlining payables processing by prioritizing vendors
          1. Getting ready
          2. How to do it...
          3. How it works...
        6. Getting clarity with user-defined fields
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Special User-Defined 1 features
            2. Company Setup user-defined fields
            3. Expanded user-defined fields
          4. See also
        7. Developing connections with Internet user-defined fields
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Login and password
            2. Label 7 and Label 8
          4. See also
        8. Gaining reporting control with account rollups
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        9. Remembering processes with an ad hoc workflow
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        10. Improving financial reporting clarity by splitting purchasing accounts
          1. How to do it...
          2. How it works...
        11. Speeding lookups with advanced lookups
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        12. Going straight to the site with web links
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. All field values
            2. Multiple values
          5. See also
      14. 4. Automating Dynamics GP
        1. Introduction
        2. Using reminders to remember important events
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Drilling down into reminders
          4. See also
        3. Controlling reporting dates with beginning and ending periods
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Fiscal period versus month
            2. Beyond the period
        4. Automating reporting with report groups
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Groups of groups
          5. See also
        5. Speeding entry by copying an inventory item
          1. How to do it...
          2. How it works...
        6. Improving consistency with shortcuts and user classes
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        7. Speeding month-end closing by reconciling bank accounts daily
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. High transaction volume accounts
            2. Bank statement cut off
        8. Automating processes with macros
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Macros and the shortcut bar
            2. Macros can be run with a keystroke combination
            3. Macro pauses
            4. Sequential macros
          4. See also
        9. Getting early warnings with business alerts
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Prebuilt alerts
          5. See also
        10. Splitting AP across departments automatically with Control Account Management
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Multi-company
          5. See also
        11. Getting control of accruals and deferrals with recurring GL batches
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Recurring batch best practices
            2. Revenue/expense deferral module
            3. Field service contracts module
        12. Speeding document delivery with an e-mail
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Setup
      15. 5. Harnessing the Power of SmartLists
        1. Introduction
        2. Sorting data to get the information you want
          1. How to do it...
          2. How it works...
          3. See also
        3. Speeding access to information with SmartList favorites
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Modifying SmartList favorites
            2. GoTo
          4. See also
        4. Getting warnings with SmartList alerts
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Modifying and removing custom reminders
          5. See also
        5. Improving information returned with SmartList Search
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Field Comparison
            2. Match Case
            3. Search Type
            4. Wildcard search
          4. See also
        6. Controlling data with SmartList record limits
          1. How to do it...
          2. How it works...
        7. Tailoring SmartLists by adding fields
          1. How to do it...
          2. There's more...
            1. Removing fields
            2. Favorites
            3. Default SmartLists
          3. See also
        8. Controlling access by sharing or restricting SmartList favorites
          1. How to do it...
          2. How it works...
          3. There's more...
            1. SmartList security
            2. Favorite naming best practices
        9. Renaming fields for clarity
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Default SmartList column names
          4. See also
      16. 6. Connecting Dynamics GP to Microsoft Office 2013
        1. Introduction
        2. Building analyses by exporting SmartLists to Microsoft Excel
          1. How to do it...
          2. How it works...
          3. See also
        3. Delivering flexibility by exporting navigation lists to Excel
          1. How to do it...
          2. How it works...
          3. See also
        4. Improving reports by sending SmartLists to Word
          1. How to do it...
          2. How it works...
          3. See also
        5. Communicating with customers using letters from Microsoft Word
          1. How to do it...
          2. There's more...
            1. SmartList favorites
            2. Letter customization
            3. Other starting points
          3. See also
        6. Skipping the exports by using prebuilt Excel reports
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Excel Report Builder
            2. SQL and ODC connections
            3. Trust and security
          5. See also
        7. Reporting on any Dynamics GP data with direct Excel connections
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Tables
            2. Advanced options
        8. Importing data with Microsoft Word and a Dynamics GP macro
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Limitations
        9. Getting fine grain control of Excel exports from SmartList
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        10. Gaining flexibility by printing documents with Microsoft Word
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Which report to use?
            2. User template creation
      17. 7. Exposing Hidden Features in Dynamics GP
        1. Introduction
        2. Controlling posting dates when not posting by batch
          1. How to do it...
          2. How it works…
        3. Reducing posting steps with better printing control
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Posting reports
            2. Print Options box
          5. See also
        4. Improving information with tax dates in transactions
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        5. Gaining the option to process taxes in the general ledger
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        6. Changing the remit-to address on a payables transaction after posting
          1. How to do it...
          2. See also
        7. Understanding all the financial information about an asset with fixed asset details
          1. How to do it...
          2. How it works...
        8. Speeding entry by copying a purchase order
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Copying a sales order
        9. Getting control of printing with named printers
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Printer classes
          5. See also
        10. Speeding month-end processing with Reconcile to GL functionality
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Balancing the year
            2. When standard functionality isn't enough
        11. Improving budget creation with Combine Budgets
          1. How to do it...
          2. How it works...
      18. 8. Improving Dynamics GP with Hacks
        1. Introduction
        2. Building custom help with window notes
          1. How to do it...
          2. How it works…
        3. Using comments without needing a comment name
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Line item comments
        4. Keeping the chart of accounts clean by reactivating the Account Segment warnings
          1. How to do it...
          2. How it works...
        5. Reducing licensing needs by preventing multiple company logins
          1. How to do it...
          2. How it works...
        6. Using a CNAME alias to prevent resetting all passwords in migrations or DR failovers
          1. Getting ready
          2. How to do it...
          3. How it works…
        7. Turning on more features with Dex.ini settings
          1. Getting ready
          2. How to do it...
          3. There's more...
            1. Additional Dex.ini settings
          4. See also
        8. Entering and tracking use tax with credit card functionality
          1. Getting ready
          2. How to do it...
          3. How it works...
        9. Correcting a lost password by resetting the system password
          1. How to do it...
          2. How it works...
          3. There's more...
        10. Warning the user if Caps Lock is on during login
          1. How to do it...
          2. There's more…
            1. Patrick Roth's solution
            2. Vaidhyanathan Mohan's solution
        11. Getting greater journal entry control by clearing recurring batch amounts
          1. How to do it...
          2. See also
      19. 9. Preventing Errors in Dynamics GP
        1. Introduction
        2. Preventing posting errors by managing batch dates
          1. Getting ready
          2. How to do it...
          3. How it works…
          4. See also
        3. Reducing out-of-balance problems with Allow Account Entry
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Adjustments
          4. See also
        4. Ensuring entry in the correct company by warning about test companies
          1. How to do it...
          2. How it works...
          3. There's more…
          4. See also
        5. Protecting Dynamics GP with key security settings
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Security for security
            2. Security solutions
        6. Providing clean vendor information by properly closing purchase orders
          1. How to do it...
          2. How it works...
        7. Preventing account selection errors with chart segment names
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        8. Ensuring proper year-end closing by checking posting types
          1. How to do it...
          2. How it works...
          3. See also
        9. Preventing sales of a discontinued inventory item
          1. How to do it...
          2. How it works...
          3. There's more...
          4. See also...
        10. Correcting errors by backing out, correcting, and copying GL entries
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Subledger corrections
      20. 10. Maintaining Dynamics GP
        1. Introduction
        2. Speeding up navigation lists by disabling Business Analyzer
          1. How to do it...
          2. How it works…
          3. There's more...
          4. See also
        3. Preventing entry of wrong dates by closing periods
          1. How to do it...
          2. There's more...
            1. The Mass Close button
        4. Improving performance by adjusting the AutoComplete settings
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Making the change for all users
          4. See also
        5. Cleaning up Accounts Receivable with Paid Transaction Removal
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. The balance forward method
        6. Providing correct tax information by updating 1099 information
          1. How to do it...
          2. How it works...
          3. There's more...
            1. 1099 vendor setup
        7. Maintaining updated code by rolling out service packs with Client Update
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
            1. Service pack errors
        8. Improving stability by managing dictionaries
          1. How to do it...
          2. How it works...
          3. There's more...
            1. The Dynamics.set file
        9. Safeguarding data by backing everything up
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Additional backups
        10. Resolving errors with the Check Links utility
          1. How to do it...
          2. How it works...
          3. See also
        11. Speeding login by clearing the Menu Master table
          1. How to do it...
          2. How it works...
        12. Validating balances with the Reconcile utility
          1. How to do it...
          2. How it works...
          3. See also
        13. Troubleshooting issues with a DexSQL log
          1. How to do it...
          2. How it works...
          3. See also
        14. Speeding security setup with user copy
          1. Getting ready
          2. How to do it...
      21. 11. Extending Dynamics GP with the Support Debugging Tool
        1. Introduction
        2. Extending Dynamics GP with the Support Debugging Tool
          1. How to do it...
        3. Coloring windows by company
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more…
          5. See also...
        4. Capturing and sending screenshots for support
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Default settings
        5. Logging transactions for troubleshooting
          1. How to do it...
          2. There's more...
            1. Automatic logging
        6. Executing SQL from within Dynamics GP
          1. How to do it...
          2. How it works...
        7. Getting information about security resources
          1. How to do it...
          2. How it works...
          3. There's more...
            1. Automatic security profiles
            2. Export/import security logs
      22. 12. Extending Dynamics GP Professional Services Tools Library
        1. Introduction
        2. Installing and configuring Professional Services Tools Library
          1. Getting ready
          2. How to do it...
          3. There's more…
        3. Disable a company database to prevent users from logging in
          1. How to do it...
          2. How it works…
        4. Replicate settings and data to a new company with Company Copy
          1. Getting ready...
          2. How to do it...
          3. How it works…
        5. Duplicate data between companies using Master Triggers
          1. Getting ready...
          2. How to do it…
          3. How it works…
          4. There's more…
        6. Merge records with Combiner
          1. How to do it...
          2. There's more...
            1. Import from spreadsheet
            2. Other Combiner functions
        7. Change data using Modifier
          1. How to do it…
          2. There's more...
            1. Customer name Modifier
            2. Import from spreadsheet
            3. Other Modifier functions
        8. Setting a minimum PO/Receipt Number
          1. Getting ready
          2. How to do it...
          3. How it works…
        9. Preventing date errors with Doc Date Verify
          1. Getting ready
          2. How to do it...
          3. How it works...
      23. Index