Microsoft Dynamics GP 2016 Cookbook电子书

Microsoft Dynamics GP 2016 Cookbook

Table of Contents

Microsoft Dynamics GP 2016 Cookbook

Credits

About the Authors

About the Reviewers

www.PacktPub.com

eBooks, discount offers, and more

Why subscribe?

Instant updates on new Packt books

Preface

What this book covers

What you need for this book

Who this book is for

Sections

Getting ready

How to do it…

How it works…

There's more…

See also

Conventions

Reader feedback

Customer support

Downloading the color images of this book

Errata

Piracy

Questions

1. Personalizing Dynamics GP

Introduction

Personalizing the home page by selecting the right role

How to do it...

See also

Improving visibility by setting required fields to bold and red

Getting ready

How to do it...

How it works...

There's more...

Modifier with VBA

Further personalizing the home page by customizing the layout

How to do it...

There's more...

See also

Speeding up access to data with Quick Links

Getting ready

How to do it...

How it works...

See also

Rearranging navigation to make it easier

Getting ready

How to do it...

How it works...

Managing personal reports with My Reports

How to do it...

There's more...

Reports without options

Better dates in report options

See also

Viewing open items with Task List

Getting ready

How to do it...

How it works...

There's more...

Recurring tasks

See also

Accessing accounts faster with Favorites in lookups

Getting ready

How to do it...

There's more...

Set as default view

Restricted list

Resetting

Account security

See also

Cleaning up the mess by fixing AutoComplete errors

Getting ready

How to do it...

How it works...

There's more...

Removed unused entries

Reducing the number of AutoComplete entries

Resetting AutoComplete

2. Organizing Dynamics GP

Introduction

Speeding up account entry with Account Alias

Getting ready

How to do it…

How it works…

See also

Cleaning account lookups by removing accounts from lookups

How to do it…

How it works…

Gaining visibility with horizontal scroll arrows

How to do it…

How it works…

There's more…

Activating Horizontal Scroll Arrows for all users

Widening segments for better visibility

Streamlining payables processing by prioritizing vendors

Getting ready

How to do it…

How it works…

Getting clarity with user-defined fields

How to do it…

How it works…

There's more...

Special User-Defined 1 features

Company Setup user-defined fields

Expanded user-defined fields

See also

Developing connections with Internet User Defined fields

How to do it…

How it works…

There's more…

Login and password

Labels 7 and 8

See also

Controlling reporting with account rollups

Getting ready

How to do it...

How it works…

See also

Remembering processes with an ad hoc workflow

Getting ready

How to do it...

How it works…

See also...

Improving financial reporting clarity by splitting purchasing accounts

How to do it…

How it works...

Speeding up lookups with advanced lookups

Getting ready

How to do it...

How it works...

See also

Going straight to the site with web links

Getting ready

How to do it...

How it works...

There's more...

The All Field Values box

Multiple values

See also

3. Automating Dynamics GP

Introduction

Copying security from an existing user

Using Reminders to remember important events

How to do it...

How it works...

There's more...

Drilling down into reminders

See also

Controlling reporting dates with beginning and ending periods

Getting ready

How to do it...

How it works...

There's more...

Fiscal period versus month

Beyond the period

Speeding up entry by copying an inventory item

How to do it...

How it works...

Automating processes with macros

How to do it...

How it works...

There's more...

Macros can be made faster

Macros and the shortcut bar

Macros can be run with a keystroke combination

Macro pauses

Sequential macros

See also...

Getting early warnings with Business Alerts

Getting ready

How to do it...

How it works...

There's more...

Prebuilt alerts

See also

Splitting AP across departments automatically with Control Account Management

Getting ready

How to do it...

How it works...

There's more...

Multi-company

See also

Speeding document delivery with e-mail

Getting ready

How to do it...

How it works...

There's more...

Customer and vendor setup

Company setup

Relating or linking items for suggested sales

Getting ready

How to do it...

See also

Automatically post cash receipt deposits

Simplifying statement delivery with print remaining documents

How to do it...

How it works...

4. Leveraging New and Updated Features in Dynamics GP

Introduction

Take the company offline for maintenance

How to do it...

How it works…

There's more…

Copying and pasting journals from Excel

Getting ready

How to do it...

There's more...

Budget Import Exception reporting

Getting ready

How to do it...

Enhanced GL Year-End Closing

How to do it...

How it works...

There's more...

Unit Account

Reversing Year-End Close

Fix cross-company mistakes by voiding intercompany transactions

Getting ready

How to do it...

See also

Improving cross-company visibility with Intercompany Journal inquiries

How to do it...

How it works...

EFT Format Enhancements

Getting ready

How to do it...

There's more...

Expanding payment options with credit card payment runs

Getting ready

How to do it...

How it works...

Merging records with Customer Combiner and Modifier

How to do it...

There's more...

Modifying a customer number

Import from spreadsheet

Other Combiner functions

Modifying Sales Order Ship To Address

Getting ready

How to do it...

How it works...

There's more...

See also

Getting a complete view with All-In-One View

How to do it...

How it works...

Tracking serial and lot numbers on drop ship POs

Getting ready

How to do it...

How it works...

There's more…

See also

Selecting multiple serial or lot numbers

How to do it...

There's more…

See also

Intercompany asset transfer

How to do it...

There's more...

See also

Historical depreciation report

How to do it...

How it works...

There's more...

Mass depreciation reversal

Reset History in Detail

See also

Fixed Assets Batches

How to do it...

There's more...

See also

Improve year-end with the Fixed Asset Year-End Closing Report

Getting ready

How to do it...

Purchase requisitions

How to do it...

There's more…

Gaining efficiency by printing or e-mailing any report with Word templates

Getting ready

How to do it...

There's more...

Attaching documents to records

Getting ready

How to do it...

5. Exposing Hidden Features in Dynamics GP

Introduction

Controlling Posting Dates when not posting by batch

How to do it...

How it works…

Reducing posting steps with better Printing Control

Getting ready

How to do it...

How it works...

There's more...

Posting reports

Print Options box

See also

Improving information with Tax Dates in transactions

Getting ready

How to do it...

How it works...

See also

Gaining the option to process taxes in general ledger

Getting ready

How to do it...

How it works...

See also

Changing the Remit-To Address on a Payables transaction after posting

How to do it...

Understanding an asset's financial information with Asset Details

How to do it...

How it works...

Speeding up entry by copying a purchase order

How to do it...

How it works...

There's more...

Copying a sales order

Getting control of printing with Named Printers

Getting ready

How to do it...

How it works...

There's more...

Printer classes

See also

Speeding up month-end processing with the Reconcile to GL functionality

How to do it...

How it works...

There's more...

Balancing the year

When AP and AR aren't enough

Improving budget creation with Combine Budgets

How to do it...

How it works...

Controlling POs with prepayments

Getting ready

How to do it...

There's more...

Gaining flexibility with Inventory Tolerance Handling

How to do it...

How it works…

Creating Fixed Assets with a default ID

Getting started…

How to do it...

Avoid creating Payables Invoices when a PO already exists

How to do it...

How it works...

6. Improving Dynamics GP with Hacks

Introduction

Using comments without needing a comment name

How to do it…

How it works…

There's more…

Line item comments

Keeping the chart of accounts clean by reactivating Account Segment warnings

How to do it…

How it works…

Reducing licensing needs by preventing multiple company logins

How to do it…

How it works…

Turning on more features with the Dex.ini settings

Getting ready

How to do it…

There's more…

Additional Dex.ini settings

Popular Dex.ini resources

See also

Tackling self-assessed taxes such as Use Tax with the Reverse Tax functionality

Getting ready

How to do it...

How it works…

There's more…

Correcting a lost password by resetting the system password

How to do it…

How it works…

There's more…

Getting greater journal entry control by clearing recurring batch amounts

How to do it…

7. Preventing Errors in Dynamics GP

Introduction

Preventing posting errors by managing Batch Date

Getting ready

How to do it…

How it works…

See also

Reducing out of balance problems with Allow Account Entry

How to do it…

How it works…

There's more…

Adjustments

See also

Ensuring entry in the correct company by warning about test companies

How to do it…

How it works…

Protecting Dynamics GP with key security settings

How to do it…

How it works…

There's more…

Security for security

Security solutions

Providing clean vendor information by properly closing Purchase Orders

How to do it…

How it works…

Preventing account selection errors with segment names

Getting ready

How to do it…

How it works…

See also

Ensuring proper year-end closing by checking Posting Types

Getting ready

How to do it…

How it works…

See also

Preventing sales of discontinued inventory

How to do it…

How it works…

There's more…

Correcting errors by backing out, correcting, and copying journal entries

How to do it…

How it works…

There's more…

Subledger corrections

8. Harnessing the Power of SmartLists

Introduction

Changing the Favorites pane size and visibility

How to do it...

Sorting data to get the information you want

How to do it...

How it works...

See also

Improving information returned with SmartList Search

How to do it...

How it works...

There's more...

Field comparison

Match case

Search type

Wildcard search

See also

Tailoring SmartLists by adding fields

How to do it…

Theres more...

Removing fields

Favorites

Default SmartLists

See also

Renaming fields for clarity

How to do it...

How it works...

There's more...

Default SmartList column names

See also

Speeding up access to information with SmartList Favorites

How to do it...

How it works...

There's more...

Modifying SmartList Favorites

Go To

See also

Controlling data with SmartList record limits

How to do it...

How it works...

Getting warnings with SmartList alerts

Getting ready

How to do it...

How it works...

There's more...

Modifying and removing custom Reminders

See also

Controlling access by sharing or restricting SmartList Favorites

Getting started…

How to do it...

How it works...

There's more...

SmartList security

Favorite naming best practices

9. SmartList Designer

Introduction

Creating a new SmartList

How to do it…

There's more…

Preview the SmartList

Configuring default columns for new SmartLists

Creating a new SmartList from a SQL View

Getting ready

How to do it…

There's more…

Adding a filter to a SmartList

How to do it…

Exporting a SmartList object

How to do it...

Importing a SmartList object

How to do it…

Creating a refreshable Excel report from a SmartList

Getting ready

How to do it…

10. Connecting Dynamics GP to Microsoft Office 2016

Introduction

Building analyses by exporting SmartLists to Microsoft Excel

How to do it…

How it works…

See also

Getting fine-grained control of Excel Exports from Navigation lists to Excel

How to do it…

How it works…

See also

Improving reports by sending SmartLists to Word

How to do it…

How it works…

See also

Communicating with customers using Letters from Microsoft Word

How to do it…

There's more…

SmartList Favorites

Letter customization

Other starting points

See also

Skipping the exports by using pre-built Excel reports

Getting ready

How to do it…

How it works…

There's more…

Excel Report Designer

SQL and ODC connections

Trust and security

See also

Delivering the goods with Excel-based dashboards

Getting ready

How to do it…

How it works…

There's more…

See also

Reporting on any Dynamics GP data with direct Excel connections

How to do it…

How it works…

There's more…

Tables

Advanced options

Importing data with Microsoft Word and a Dynamics GP macro

Getting ready

How to do it…

How it works…

There's more…

Limitations

Getting fine-grained control of Excel Exports from SmartList

Getting ready

How to do it…

How it works…

See also

Gaining flexibility by printing documents with Microsoft Word

How to do it…

How it works…

There's more…

Which report to use?

User template creation

11. Maintaining Dynamics GP

Introduction

Speeding up Navigation lists by disabling Business Analyzer

How to do it…

How it works…

There's more…

See also

Preventing entry to wrong dates by closing periods

How to do it…

There's more…

Mass Close

Improving performance by adjusting AutoComplete settings

How to do it…

How it works…

There's more…

Making the change for all users

See also

Cleaning up Accounts Receivable with Paid Transaction Removal

Getting ready

How to do it…

How it works…

There's more…

Balance forward

Providing correct tax information by updating 1099 information

How to do it…

How it works…

There's more…

1099 vendor setup

Maintaining updated code by rolling down service packs with Client Updates

Getting ready

How to do it…

How it works…

There's more…

Service pack errors

Improving stability by managing dictionaries

How to do it…

How it works…

There's more…

The Dynamics.set file

Safeguarding data by backing everything up

How to do it…

How it works…

There's more…

Additional backups

Resolving errors with the Check Links utility

How to do it…

How it works…

See also

Speeding up login by clearing the Menu Master table

How to do it…

Validating balances with the Reconcile utility

How to do it…

How it works…

See also

Troubleshooting issues with a DexSQL.log file

How to do it…

How it works…

12. Extending Dynamics GP Professional Services Tools Library

Introduction

Replicate settings and data to a new company with Company Copy

Getting ready...

How to do it...

How it works…

See also...

Duplicate data between companies using Master Triggers

How to do it...

How it works…

There's more…

See also...

Merge records with Combiner

How to do it...

There's more...

Other Combiner functions

See also...

Change data using Modifier

How to do it…

There's more...

Import from spreadsheet

Other Modifier functions

Using Customer Name Modifier

How to do it…

Import from spreadsheet

Other Name Modifiers

Set a minimum PO/receipt number

Getting ready

How to do it...

How it works…

See also...

Preventing date errors with Doc Date Verify

Getting ready

How to do it...

How it works...

See also...

13. Modern Business Intelligence for Dynamics GP

Introduction

Activating OData for better external analysis

Getting ready

How to do it…

How it works…

There's more…

See also

Secure OData to control access

Getting ready

How to do it…

There's more…

SQL objects

Connecting OData to Excel for Business Intelligence

Getting ready

How to do it…

How it works…

Connecting GP to Power BI with OData

Getting ready

How to do it…

How it works…

There's more…

Adding Power BI to the home page in Dynamics GP

Getting ready

How to do it…

How it works…

Index