Microsoft Dynamics GP 2013 Cookbook电子书

Microsoft Dynamics GP 2013 Cookbook

Table of Contents

Microsoft Dynamics GP 2013 Cookbook

Credits

About the Author

Acknowledgment

About the Author

Acknowledgment

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. Personalizing Dynamics GP

Introduction

Improving visibility by setting required fields to bold and red

Getting ready

How to do it...

How it works...

There's more...

Modifier with Visual Basic for Applications (VBA)

Getting faster access to data with the shortcut bar

Getting ready

How to do it...

How it works...

There's more...

Use external Shortcuts for greater flexibility

Organize with folders

Complex shortcuts

See also

Reducing clicks with start-up shortcuts

Getting ready

How to do it...

How it works...

There's more...

File example

Drag and drop

See also

Personalizing the Home page by selecting the right role

How to do it...

See also

Further personalizing the Home page by customizing the layout

How to do it...

There's more...

See also

Speeding 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...

Jumping to the right location with breadcrumbs

Getting ready

How to do it...

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 the Task List

Getting ready

How to do it...

How it works...

There's more...

Recurring tasks

See also

Visualizing information with Business Analyzer on the Home page

How to do it...

How it works...

There's more...

Multiple Business Analyzer reports

Full view

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

Reduce the number of AutoComplete entries

Reset AutoComplete

2. New in Dynamics GP 2013

Introduction

EFT format enhancements

Getting ready

How to do it...

There's more...

Enhanced GL Year-End Closing

How to do it...

How it works...

There's more...

Modifying the sales order's Ship To address

Getting ready

How to do it...

How it works...

There's more...

See also

Reason codes for inventory transactions

Getting ready

How to do it...

There's more...

See also

Tolerance handling

How to do it...

How it works...

See also

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

Relating or linking items for suggested sales

Getting ready

How to do it...

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

3. Organizing Dynamics GP

Introduction

Speeding account entry with account aliases

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 by using 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

Label 7 and Label 8

See also

Gaining reporting control 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 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...

All field values

Multiple values

See also

4. Automating Dynamics GP

Introduction

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

Automating reporting with report groups

Getting ready

How to do it...

How it works...

There's more...

Groups of groups

See also

Speeding entry by copying an inventory item

How to do it...

How it works...

Improving consistency with shortcuts and user classes

Getting ready

How to do it...

How it works...

See also

Speeding month-end closing by reconciling bank accounts daily

Getting ready

How to do it...

How it works...

There's more...

High transaction volume accounts

Bank statement cut off

Automating processes with macros

How to do it...

How it works...

There's more...

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

Getting control of accruals and deferrals with recurring GL batches

Getting ready

How to do it...

How it works...

There's more...

Recurring batch best practices

Revenue/expense deferral module

Field service contracts module

Speeding document delivery with an e-mail

Getting ready

How to do it...

How it works...

There's more...

Setup

5. Harnessing the Power of SmartLists

Introduction

Sorting data to get the information you want

How to do it...

How it works...

See also

Speeding access to information with SmartList favorites

How to do it...

How it works...

There's more...

Modifying SmartList favorites

GoTo

See also

Getting warnings with SmartList alerts

Getting ready

How to do it...

How it works...

There's more...

Modifying and removing custom reminders

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

Controlling data with SmartList record limits

How to do it...

How it works...

Tailoring SmartLists by adding fields

How to do it...

There's more...

Removing fields

Favorites

Default SmartLists

See also

Controlling access by sharing or restricting SmartList favorites

How to do it...

How it works...

There's more...

SmartList security

Favorite naming best practices

Renaming fields for clarity

How to do it...

How it works...

There's more...

Default SmartList column names

See also

6. Connecting Dynamics GP to Microsoft Office 2013

Introduction

Building analyses by exporting SmartLists to Microsoft Excel

How to do it...

How it works...

See also

Delivering flexibility by exporting 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 prebuilt Excel reports

Getting ready

How to do it...

How it works...

There's more...

Excel Report Builder

SQL and ODC connections

Trust and security

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 grain 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

7. 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 the 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...

See also

Understanding all the financial information about an asset with fixed asset details

How to do it...

How it works...

Speeding 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 month-end processing with Reconcile to GL functionality

How to do it...

How it works...

There's more...

Balancing the year

When standard functionality isn't enough

Improving budget creation with Combine Budgets

How to do it...

How it works...

8. Improving Dynamics GP with Hacks

Introduction

Building custom help with window notes

How to do it...

How it works…

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 the 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...

Using a CNAME alias to prevent resetting all passwords in migrations or DR failovers

Getting ready

How to do it...

How it works…

Turning on more features with Dex.ini settings

Getting ready

How to do it...

There's more...

Additional Dex.ini settings

See also

Entering and tracking use tax with credit card functionality

Getting ready

How to do it...

How it works...

Correcting a lost password by resetting the system password

How to do it...

How it works...

There's more...

Warning the user if Caps Lock is on during login

How to do it...

There's more…

Patrick Roth's solution

Vaidhyanathan Mohan's solution

Getting greater journal entry control by clearing recurring batch amounts

How to do it...

See also

9. Preventing Errors in Dynamics GP

Introduction

Preventing posting errors by managing batch dates

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...

There's more…

See also

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 chart segment names

Getting ready

How to do it...

How it works...

See also

Ensuring proper year-end closing by checking posting types

How to do it...

How it works...

See also

Preventing sales of a discontinued inventory item

How to do it...

How it works...

There's more...

See also...

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

How to do it...

How it works...

There's more...

Subledger corrections

10. 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 of wrong dates by closing periods

How to do it...

There's more...

The Mass Close button

Improving performance by adjusting the 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...

The balance forward method

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 out service packs with Client Update

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 login by clearing the Menu Master table

How to do it...

How it works...

Validating balances with the Reconcile utility

How to do it...

How it works...

See also

Troubleshooting issues with a DexSQL log

How to do it...

How it works...

See also

Speeding security setup with user copy

Getting ready

How to do it...

11. Extending Dynamics GP with the Support Debugging Tool

Introduction

Extending Dynamics GP with the Support Debugging Tool

How to do it...

Coloring windows by company

Getting ready

How to do it...

How it works...

There's more…

See also...

Capturing and sending screenshots for support

How to do it...

How it works...

There's more...

Default settings

Logging transactions for troubleshooting

How to do it...

There's more...

Automatic logging

Executing SQL from within Dynamics GP

How to do it...

How it works...

Getting information about security resources

How to do it...

How it works...

There's more...

Automatic security profiles

Export/import security logs

12. Extending Dynamics GP Professional Services Tools Library

Introduction

Installing and configuring Professional Services Tools Library

Getting ready

How to do it...

There's more…

Disable a company database to prevent users from logging in

How to do it...

How it works…

Replicate settings and data to a new company with Company Copy

Getting ready...

How to do it...

How it works…

Duplicate data between companies using Master Triggers

Getting ready...

How to do it…

How it works…

There's more…

Merge records with Combiner

How to do it...

There's more...

Import from spreadsheet

Other Combiner functions

Change data using Modifier

How to do it…

There's more...

Customer name Modifier

Import from spreadsheet

Other Modifier functions

Setting a minimum PO/Receipt Number

Getting ready

How to do it...

How it works…

Preventing date errors with Doc Date Verify

Getting ready

How to do it...

How it works...

Index