PacktLib: Microsoft Dynamics GP 2013 Cookbook

Microsoft Dynamics GP 2013 Cookbook


About the Author


About the Author


About the Reviewers


Personalizing Dynamics GP


Improving visibility by setting required fields to bold and red

Getting faster access to data with the shortcut bar

Reducing clicks with start-up shortcuts

Personalizing the Home page by selecting the right role

Further personalizing the Home page by customizing the layout

Speeding access to data with Quick Links

Rearranging navigation to make it easier

Jumping to the right location with breadcrumbs

Managing personal reports with My Reports

Viewing open items with the Task List

Visualizing information with Business Analyzer on the Home page

Accessing accounts faster with favorites in lookups

Cleaning up the mess by fixing AutoComplete errors

New in Dynamics GP 2013


EFT format enhancements

Enhanced GL Year-End Closing

Modifying the sales order's Ship To address

Reason codes for inventory transactions

Tolerance handling

Tracking serial and lot numbers on drop ship POs

Selecting multiple serial or lot numbers

Relating or linking items for suggested sales

Intercompany asset transfer

Historical depreciation report

Fixed assets batches

Organizing Dynamics GP


Speeding account entry with account aliases

Cleaning account lookups by removing accounts from lookups

Gaining visibility by using horizontal scroll arrows

Streamlining payables processing by prioritizing vendors

Getting clarity with user-defined fields

Developing connections with Internet user-defined fields

Gaining reporting control with account rollups

Remembering processes with an ad hoc workflow

Improving financial reporting clarity by splitting purchasing accounts

Speeding lookups with advanced lookups

Going straight to the site with web links

Automating Dynamics GP


Using reminders to remember important events

Controlling reporting dates with beginning and ending periods

Automating reporting with report groups

Speeding entry by copying an inventory item

Improving consistency with shortcuts and user classes

Speeding month-end closing by reconciling bank accounts daily

Automating processes with macros

Getting early warnings with business alerts

Splitting AP across departments automatically with Control Account Management

Getting control of accruals and deferrals with recurring GL batches

Speeding document delivery with an e-mail

Harnessing the Power of SmartLists


Sorting data to get the information you want

Speeding access to information with SmartList favorites

Getting warnings with SmartList alerts

Improving information returned with SmartList Search

Controlling data with SmartList record limits

Tailoring SmartLists by adding fields

Controlling access by sharing or restricting SmartList favorites

Renaming fields for clarity

Connecting Dynamics GP to Microsoft Office 2013


Building analyses by exporting SmartLists to Microsoft Excel

Delivering flexibility by exporting navigation lists to Excel

Improving reports by sending SmartLists to Word

Communicating with customers using letters from Microsoft Word

Skipping the exports by using prebuilt Excel reports

Reporting on any Dynamics GP data with direct Excel connections

Importing data with Microsoft Word and a Dynamics GP macro

Getting fine grain control of Excel exports from SmartList

Gaining flexibility by printing documents with Microsoft Word

Exposing Hidden Features in Dynamics GP


Controlling posting dates when not posting by batch

Reducing posting steps with better printing control

Improving information with tax dates in transactions

Gaining the option to process taxes in the general ledger

Changing the remit-to address on a payables transaction after posting

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

Speeding entry by copying a purchase order

Getting control of printing with named printers

Speeding month-end processing with Reconcile to GL functionality

Improving budget creation with Combine Budgets

Improving Dynamics GP with Hacks


Building custom help with window notes

Using comments without needing a comment name

Keeping the chart of accounts clean by reactivating the Account Segment warnings

Reducing licensing needs by preventing multiple company logins

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

Turning on more features with Dex.ini settings

Entering and tracking use tax with credit card functionality

Correcting a lost password by resetting the system password

Warning the user if Caps Lock is on during login

Getting greater journal entry control by clearing recurring batch amounts

Preventing Errors in Dynamics GP


Preventing posting errors by managing batch dates

Reducing out-of-balance problems with Allow Account Entry

Ensuring entry in the correct company by warning about test companies

Protecting Dynamics GP with key security settings

Providing clean vendor information by properly closing purchase orders

Preventing account selection errors with chart segment names

Ensuring proper year-end closing by checking posting types

Preventing sales of a discontinued inventory item

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

Maintaining Dynamics GP


Speeding up navigation lists by disabling Business Analyzer

Preventing entry of wrong dates by closing periods

Improving performance by adjusting the AutoComplete settings

Cleaning up Accounts Receivable with Paid Transaction Removal

Providing correct tax information by updating 1099 information

Maintaining updated code by rolling out service packs with Client Update

Improving stability by managing dictionaries

Safeguarding data by backing everything up

Resolving errors with the Check Links utility

Speeding login by clearing the Menu Master table

Validating balances with the Reconcile utility

Troubleshooting issues with a DexSQL log

Speeding security setup with user copy

Extending Dynamics GP with the Support Debugging Tool


Extending Dynamics GP with the Support Debugging Tool

Coloring windows by company

Capturing and sending screenshots for support

Logging transactions for troubleshooting

Executing SQL from within Dynamics GP

Getting information about security resources

Extending Dynamics GP Professional Services Tools Library


Installing and configuring Professional Services Tools Library

Disable a company database to prevent users from logging in

Replicate settings and data to a new company with Company Copy

Duplicate data between companies using Master Triggers

Merge records with Combiner

Change data using Modifier

Setting a minimum PO/Receipt Number

Preventing date errors with Doc Date Verify