Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Checkout

Change country

Modal Close icon
Country selected Country selected
country flag Germany
Country selected
country flag Slovakia
Country selected
country flag Canada
Country selected
country flag Brazil
Country selected
country flag Singapore
Country selected
country flag Hungary
Country selected
country flag Philippines
Country selected
country flag Mexico
Country selected
country flag Thailand
Country selected
country flag Ukraine
Country selected
country flag Luxembourg
Country selected
country flag Estonia
Country selected
country flag Lithuania
Country selected
country flag Norway
Country selected
country flag Chile
Country selected
country flag United States
Country selected
country flag Great Britain
Country selected
country flag India
Country selected
country flag Spain
Country selected
country flag South Korea
Country selected
country flag Ecuador
Country selected
country flag Colombia
Country selected
country flag Taiwan
Country selected
country flag Switzerland
Country selected
country flag Indonesia
Country selected
country flag Cyprus
Country selected
country flag Denmark
Country selected
country flag Finland
Country selected
country flag Poland
Country selected
country flag Malta
Country selected
country flag Czechia
Country selected
country flag New Zealand
Country selected
country flag Austria
Country selected
country flag Turkey
Country selected
country flag France
Country selected
country flag Sweden
Country selected
country flag Italy
Country selected
country flag Egypt
Country selected
country flag Belgium
Country selected
country flag Portugal
Country selected
country flag Slovenia
Country selected
country flag Ireland
Country selected
country flag Romania
Country selected
country flag Greece
Country selected
country flag Argentina
Country selected
country flag Malaysia
Country selected
country flag South Africa
Country selected
country flag Netherlands
Country selected
country flag Bulgaria
Country selected
country flag Latvia
Country selected
country flag Australia
Country selected
country flag Japan
Country selected
country flag Russia
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Home > Business & Other > Enterprise Resource Planning > Microsoft Dynamics GP 2016 Cookbook
Microsoft Dynamics GP 2016 Cookbook
Microsoft Dynamics GP 2016 Cookbook

Microsoft Dynamics GP 2016 Cookbook: Over 100 powerful and effective recipes to help you solve real-world Dynamics GP problems

Arrow left icon
Profile Icon Grieve Profile Icon Polino
Arrow right icon
€49.99
Paperback Aug 2016 376 pages 1st Edition
eBook
€27.98 €39.99
Paperback
€49.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Grieve Profile Icon Polino
Arrow right icon
€49.99
Paperback Aug 2016 376 pages 1st Edition
eBook
€27.98 €39.99
Paperback
€49.99
Subscription
Free Trial
Renews at €18.99p/m
eBook
€27.98 €39.99
Paperback
€49.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR

Contact Details

Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

Microsoft Dynamics GP 2016 Cookbook

Chapter 2. Organizing Dynamics GP

In this chapter, we will look at:

  • Speeding up account entry with account aliases
  • Cleaning account lookups by removing accounts from lookups
  • Gaining visibility with horizontal scroll arrows
  • Streamlining payables processing by prioritizing vendors
  • Getting clarity with user-defined fields
  • Developing connections with Internet User Defined fields
  • Controlling reporting with account rollups
  • Remembering processes with an ad hoc workflow
  • Improving financial reporting clarity by splitting purchasing accounts
  • Speeding up lookups with advanced lookups
  • Going straight to the site with web links

Introduction

Dynamics GP provides a number of features to better organize the overall system and improve its usefulness for all users; these recipes are designed for the use of administrators rather than typical users. This chapter is designed to demonstrate how to implement and fine-tune these features to provide the most benefit.

Speeding up account entry with Account Alias

As organizations grow up, the chart of accounts tends to grow larger and more complex as well. Companies want to segment their business by departments, locations, or divisions; all of this means that more and more accounts get added to the chart and, as the chart of accounts grows, it gets more difficult to select the right account. Dynamics GP provides the Account Alias feature as a way to quickly select the right account. Account aliases provide a way to create shortcuts to specific accounts, which can dramatically speed up the process of selecting the correct account. We'll look at how that works in this recipe.

Getting ready

Setting up account aliases requires a user with access to the Account Maintenance window.

To get to this window perform the following steps:

  1. Select Financial from the Navigation pane on the left. Click Accounts on the Financial area page under Cards. This will open the Account Maintenance window.
  2. Click the lookup button...

Cleaning account lookups by removing accounts from lookups

A consequence of company growth is that the chart of accounts grows and account lookups can get clogged up by the number of accounts on the system. While the general ledger will stop showing an account in a lookup when the account is made inactive, other modules will continue to show these inactive codes.

However, Dynamics GP does contain a feature which can be used to remove inactive account from lookups; this same feature can also be used to remove accounts from lookups in series where the account should not be used, such as a sales account in the purchasing or inventory series.

How to do it…

Here we will see how to remove inactive accounts from lookups.

  1. Open Financial from the Navigation pane on the left. In the main area page, under Cards, select Account.
  2. Enter, or do a lookup for, the account to be made inactive and removed from the lookups:
    How to do it…
  3. Check the Inactive checkbox.
  4. Press and hold the Ctrl key and click on each of the lines...

Gaining visibility with horizontal scroll arrows

A consequence of company growth is that not only does the chart of accounts grow larger and less intuitive, but the actual length of account numbers tends to grow longer as well. Companies want to be able to report by account, department, location, and so on, which results in a proliferation of segments added to the main account number and can create very long accounts. Dynamics GP can accommodate an account number as long as 66 characters. The longest I've seen used in practice was 27 characters and even that was unwieldy. Most users only need a portion of that length for their day-to-day work.

This presents a problem because very long account numbers won't fit into the account number field on most screens. For this recipe, we'll look at how Dynamics GP provides a solution to this in the User Preferences area.

How to do it…

Here we'll see how to increase the visibility of long account numbers:

  1. On the Navigation pane...

Streamlining payables processing by prioritizing vendors

Management of vendor payments is a critical activity for any firm; it's even more critical in difficult economic times. Companies need to understand and control payments and a key component of this is prioritizing vendors. Every firm has both critical and expendable vendors. Paying critical vendors on time is a key business driver.

For example, a newspaper that doesn't pay their newsprint supplier won't be in business long. However, they can safely delay payments to their janitorial vendor without worrying about going under.

Dynamics GP provides a mechanism to prioritize vendors and apply those priorities when selecting which checks to print. That is the focus of this recipe.

Getting ready

Setting this up first requires that the company figure out who the priority vendors are. That part is beyond the scope of this book. The Vendor Priority field in Dynamics GP is a three-character field, but users shouldn't be seduced...

Getting clarity with user-defined fields

Throughout Dynamics GP, maintenance cards typically include at least two user-defined fields. User-defined fields can be renamed in the setup screen for the related module. This provides a great mechanism to add in special information. We'll take a look at a typical use of a user defined field in this recipe.

How to do it…

For our example, we'll look at using a user-defined field to rename the User-Defined1 field to Region in Customer Master:. To do so use the following steps:

  1. From the Navigation pane select Sales. In the Sales area page under Setup click Receivables and then, finally, the Options button.
  2. In the User-Defined 1 field type Region and click OK to close each window:
    How to do it…
  3. Back on the Sales area page, click Customer under the Cards area. On the bottom left above User-Defined 2 is the newly named Region field, ready to be filled in:
    How to do it…

How it works…

Changing the field name only changes the display field; it doesn't change...

Introduction

Dynamics GP provides a number of features to better organize the overall system and improve its usefulness for all users; these recipes are designed for the use of administrators rather than typical users. This chapter is designed to demonstrate how to implement and fine-tune these features to provide the most benefit.

Speeding up account entry with Account Alias

As organizations grow up, the chart of accounts tends to grow larger and more complex as well. Companies want to segment their business by departments, locations, or divisions; all of this means that more and more accounts get added to the chart and, as the chart of accounts grows, it gets more difficult to select the right account. Dynamics GP provides the Account Alias feature as a way to quickly select the right account. Account aliases provide a way to create shortcuts to specific accounts, which can dramatically speed up the process of selecting the correct account. We'll look at how that works in this recipe.

Getting ready

Setting up account aliases requires a user with access to the Account Maintenance window.

To get to this window perform the following steps:

  1. Select Financial from the Navigation pane on the left. Click Accounts on the Financial area page under Cards. This will open the Account Maintenance window.

  2. Click the lookup button (the...

Cleaning account lookups by removing accounts from lookups

A consequence of company growth is that the chart of accounts grows and account lookups can get clogged up by the number of accounts on the system. While the general ledger will stop showing an account in a lookup when the account is made inactive, other modules will continue to show these inactive codes.

However, Dynamics GP does contain a feature which can be used to remove inactive account from lookups; this same feature can also be used to remove accounts from lookups in series where the account should not be used, such as a sales account in the purchasing or inventory series.

How to do it…

Here we will see how to remove inactive accounts from lookups.

  1. Open Financial from the Navigation pane on the left. In the main area page, under Cards, select Account.

  2. Enter, or do a lookup for, the account to be made inactive and removed from the lookups:

  3. Check the Inactive checkbox.

  4. Press and hold the Ctrl key and click on each of the lines in...

Gaining visibility with horizontal scroll arrows

A consequence of company growth is that not only does the chart of accounts grow larger and less intuitive, but the actual length of account numbers tends to grow longer as well. Companies want to be able to report by account, department, location, and so on, which results in a proliferation of segments added to the main account number and can create very long accounts. Dynamics GP can accommodate an account number as long as 66 characters. The longest I've seen used in practice was 27 characters and even that was unwieldy. Most users only need a portion of that length for their day-to-day work.

This presents a problem because very long account numbers won't fit into the account number field on most screens. For this recipe, we'll look at how Dynamics GP provides a solution to this in the User Preferences area.

How to do it…

Here we'll see how to increase the visibility of long account numbers:

  1. On the Navigation pane on the left, select Home.

  2. Click...

Streamlining payables processing by prioritizing vendors

Management of vendor payments is a critical activity for any firm; it's even more critical in difficult economic times. Companies need to understand and control payments and a key component of this is prioritizing vendors. Every firm has both critical and expendable vendors. Paying critical vendors on time is a key business driver.

For example, a newspaper that doesn't pay their newsprint supplier won't be in business long. However, they can safely delay payments to their janitorial vendor without worrying about going under.

Dynamics GP provides a mechanism to prioritize vendors and apply those priorities when selecting which checks to print. That is the focus of this recipe.

Getting ready

Setting this up first requires that the company figure out who the priority vendors are. That part is beyond the scope of this book. The Vendor Priority field in Dynamics GP is a three-character field, but users shouldn't be seduced by the possibilities...

Getting clarity with user-defined fields

Throughout Dynamics GP, maintenance cards typically include at least two user-defined fields. User-defined fields can be renamed in the setup screen for the related module. This provides a great mechanism to add in special information. We'll take a look at a typical use of a user defined field in this recipe.

How to do it…

For our example, we'll look at using a user-defined field to rename the User-Defined1 field to Region in Customer Master:. To do so use the following steps:

  1. From the Navigation pane select Sales. In the Sales area page under Setup click Receivables and then, finally, the Options button.

  2. In the User-Defined 1 field type Region and click OK to close each window:

  3. Back on the Sales area page, click Customer under the Cards area. On the bottom left above User-Defined 2 is the newly named Region field, ready to be filled in:

How it works…

Changing the field name only changes the display field; it doesn't change the underlying field name in...

Left arrow icon

Page 1 of 13

Right arrow icon

Key benefits

  • Switch to Dynamics GP 2016 to take advantage of improved cloud support, workflow enhancements, and a more intuitive user experience
  • 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 2016 with easy-to-understand and practical recipes

Description

The latest release of Dynamics GP 2016 offers a powerful, adaptable, and cloud enabled enterprise accounting software solution. The new version has experienced changes in serviced-based architecture, workflow, existing functionalities, and the introduction of plenty of new features. This book will help you get the most out of Dynamics GP quickly and effectively. This book picks up where implementation training leaves off. Whether you are new or experienced, you will find useful recipes to improve the way you use and work with Dynamics GP. 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 you 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, connecting Dynamics GP to Microsoft Office, exposing hidden features in Dynamics GP, PowerBI, and much more!

Who is this book for?

The book is for Dynamics GP users or Dynamics GP partners. It assumes that you have a basic understanding of business management systems and Microsoft Dynamics GP.

What you will learn

  • Explore the new enhancements in Dynamics GP 2016
  • Personalize Microsoft Dynamics GP to improve accessibility and efficiencies
  • Maintain Dynamics GP and ensure proper operation of the system using optimum processes
  • Efficiently organize Microsoft Dynamics GP to improve processes
  • Leverage the power of SmartLists using proven tips and techniques and undocumented search functionalities
  • Connect Microsoft Dynamics GP 2016 to Microsoft Office 2013
  • Enhance the usability of Microsoft Dynamics GP with hacks
  • Expose the hidden features in Microsoft Dynamics GP to improve efficiency and get more from the system
  • Deploy and use the Support Debugging tool to trace, locate, and resolve problems encountered by users
  • Explore PowerBI and how it can be used with Dynamics GP 2016
Estimated delivery fee Deliver to Romania

Premium delivery 7 - 10 business days

€25.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Aug 24, 2016
Length: 376 pages
Edition : 1st
Language : English
ISBN-13 : 9781786463401
Vendor :
Microsoft
Category :
Business & Other
Concepts :
Enterprise Resource Planning
Tools :
Dynamics GP

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR

Contact Details

Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to Romania

Premium delivery 7 - 10 business days

€25.95
(Includes tracking information)

Product Details

Publication date : Aug 24, 2016
Length: 376 pages
Edition : 1st
Language : English
ISBN-13 : 9781786463401
Vendor :
Microsoft
Category :
Business & Other
Concepts :
Enterprise Resource Planning
Tools :
Dynamics GP

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
START FREE TRIAL
BUY NOW
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW

Frequently bought together

Microsoft Dynamics GP 2016 Cookbook
Microsoft Dynamics GP 2016 Cookbook
Read more
Aug 2016 376 pages
eBook
eBook
  • eBook eBook €27.98
  • Paperback Paperback €49.99
€27.98 €39.99
€49.99
Real-world Business Intelligence with Microsoft Dynamics GP
Real-world Business Intelligence with Microsoft Dynamics GP
Read more
May 2015 364 pages
Full star icon 5 (1)
eBook
eBook
  • eBook eBook €24.99
  • Paperback Paperback €45.99
€24.99 €36.99
€45.99
Building Dashboards with Microsoft Dynamics GP 2016
Building Dashboards with Microsoft Dynamics GP 2016
Read more
Mar 2017 354 pages
Full star icon 5 (1)
eBook
eBook
  • eBook eBook €24.99
  • Paperback Paperback €45.99
€24.99 €36.99
€45.99
Stars icon
Total € 141.97
Microsoft Dynamics GP 2016 Cookbook
€49.99
Real-world Business Intelligence with Microsoft Dynamics GP
€45.99
Building Dashboards with Microsoft Dynamics GP 2016
€45.99
Total € 141.97 Stars icon
Banner background image

Table of Contents

14 Chapters
1. Personalizing Dynamics GP Chevron down icon Chevron up icon
1. Personalizing Dynamics GP
Introduction
Personalizing the home page by selecting the right role
Improving visibility by setting required fields to bold and red
Further personalizing the home page by customizing the layout
Speeding up access to data with Quick Links
Rearranging navigation to make it easier
Managing personal reports with My Reports
Viewing open items with Task List
Accessing accounts faster with Favorites in lookups
Cleaning up the mess by fixing AutoComplete errors
2. Organizing Dynamics GP Chevron down icon Chevron up icon
2. Organizing Dynamics GP
Introduction
Speeding up account entry with Account Alias
Cleaning account lookups by removing accounts from lookups
Gaining visibility with horizontal scroll arrows
Streamlining payables processing by prioritizing vendors
Getting clarity with user-defined fields
Developing connections with Internet User Defined fields
Controlling reporting with account rollups
Remembering processes with an ad hoc workflow
Improving financial reporting clarity by splitting purchasing accounts
Speeding up lookups with advanced lookups
Going straight to the site with web links
3. Automating Dynamics GP Chevron down icon Chevron up icon
3. Automating Dynamics GP
Introduction
Copying security from an existing user
Using Reminders to remember important events
Controlling reporting dates with beginning and ending periods
Speeding up entry by copying an inventory item
Automating processes with macros
Getting early warnings with Business Alerts
Splitting AP across departments automatically with Control Account Management
Speeding document delivery with e-mail
Relating or linking items for suggested sales
Automatically post cash receipt deposits
Simplifying statement delivery with print remaining documents
4. Leveraging New and Updated Features in Dynamics GP Chevron down icon Chevron up icon
4. Leveraging New and Updated Features in Dynamics GP
Introduction
Take the company offline for maintenance
Copying and pasting journals from Excel
Budget Import Exception reporting
Enhanced GL Year-End Closing
Fix cross-company mistakes by voiding intercompany transactions
Improving cross-company visibility with Intercompany Journal inquiries
EFT Format Enhancements
Expanding payment options with credit card payment runs
Merging records with Customer Combiner and Modifier
Modifying Sales Order Ship To Address
Getting a complete view with All-In-One View
Tracking serial and lot numbers on drop ship POs
Selecting multiple serial or lot numbers
Intercompany asset transfer
Historical depreciation report
Fixed Assets Batches
Improve year-end with the Fixed Asset Year-End Closing Report
Purchase requisitions
Gaining efficiency by printing or e-mailing any report with Word templates
Attaching documents to records
5. Exposing Hidden Features in Dynamics GP Chevron down icon Chevron up icon
5. Exposing Hidden Features in Dynamics GP
Introduction
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 general ledger
Changing the Remit-To Address on a Payables transaction after posting
Understanding an asset's financial information with Asset Details
Speeding up entry by copying a purchase order
Getting control of printing with Named Printers
Speeding up month-end processing with the Reconcile to GL functionality
Improving budget creation with Combine Budgets
Controlling POs with prepayments
Gaining flexibility with Inventory Tolerance Handling
Creating Fixed Assets with a default ID
Avoid creating Payables Invoices when a PO already exists
6. Improving Dynamics GP with Hacks Chevron down icon Chevron up icon
6. Improving Dynamics GP with Hacks
Introduction
Using comments without needing a comment name
Keeping the chart of accounts clean by reactivating Account Segment warnings
Reducing licensing needs by preventing multiple company logins
Turning on more features with the Dex.ini settings
Tackling self-assessed taxes such as Use Tax with the Reverse Tax functionality
Correcting a lost password by resetting the system password
Getting greater journal entry control by clearing recurring batch amounts
7. Preventing Errors in Dynamics GP Chevron down icon Chevron up icon
7. Preventing Errors in Dynamics GP
Introduction
Preventing posting errors by managing Batch Date
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 segment names
Ensuring proper year-end closing by checking Posting Types
Preventing sales of discontinued inventory
Correcting errors by backing out, correcting, and copying journal entries
8. Harnessing the Power of SmartLists Chevron down icon Chevron up icon
8. Harnessing the Power of SmartLists
Introduction
Changing the Favorites pane size and visibility
Sorting data to get the information you want
Improving information returned with SmartList Search
Tailoring SmartLists by adding fields
Renaming fields for clarity
Speeding up access to information with SmartList Favorites
Controlling data with SmartList record limits
Getting warnings with SmartList alerts
Controlling access by sharing or restricting SmartList Favorites
9. SmartList Designer Chevron down icon Chevron up icon
9. SmartList Designer
Introduction
Creating a new SmartList
Creating a new SmartList from a SQL View
Adding a filter to a SmartList
Exporting a SmartList object
Importing a SmartList object
Creating a refreshable Excel report from a SmartList
10. Connecting Dynamics GP to Microsoft Office 2016 Chevron down icon Chevron up icon
10. Connecting Dynamics GP to Microsoft Office 2016
Introduction
Building analyses by exporting SmartLists to Microsoft Excel
Getting fine-grained control of Excel Exports from Navigation lists to Excel
Improving reports by sending SmartLists to Word
Communicating with customers using Letters from Microsoft Word
Skipping the exports by using pre-built Excel reports
Delivering the goods with Excel-based dashboards
Reporting on any Dynamics GP data with direct Excel connections
Importing data with Microsoft Word and a Dynamics GP macro
Getting fine-grained control of Excel Exports from SmartList
Gaining flexibility by printing documents with Microsoft Word
11. Maintaining Dynamics GP Chevron down icon Chevron up icon
11. Maintaining Dynamics GP
Introduction
Speeding up Navigation lists by disabling Business Analyzer
Preventing entry to wrong dates by closing periods
Improving performance by adjusting AutoComplete settings
Cleaning up Accounts Receivable with Paid Transaction Removal
Providing correct tax information by updating 1099 information
Maintaining updated code by rolling down service packs with Client Updates
Improving stability by managing dictionaries
Safeguarding data by backing everything up
Resolving errors with the Check Links utility
Speeding up login by clearing the Menu Master table
Validating balances with the Reconcile utility
Troubleshooting issues with a DexSQL.log file
12. Extending Dynamics GP Professional Services Tools Library Chevron down icon Chevron up icon
12. Extending Dynamics GP Professional Services Tools Library
Introduction
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
Using Customer Name Modifier
Set a minimum PO/receipt number
Preventing date errors with Doc Date Verify
13. Modern Business Intelligence for Dynamics GP Chevron down icon Chevron up icon
13. Modern Business Intelligence for Dynamics GP
Introduction
Activating OData for better external analysis
Secure OData to control access
Connecting OData to Excel for Business Intelligence
Connecting GP to Power BI with OData
Adding Power BI to the home page in Dynamics GP
Index Chevron down icon Chevron up icon
Index

Recommendations for you

Left arrow icon
Power Apps Tips, Tricks, and Best Practices
Power Apps Tips, Tricks, and Best Practices
Read more
Nov 2024 430 pages
eBook
eBook
  • eBook eBook €17.99
  • Paperback Paperback €33.99
€17.99 €26.99
€33.99
Workflow Automation with Microsoft Power Automate, Second edition
Workflow Automation with Microsoft Power Automate, Second edition
Read more
Aug 2022 424 pages
Full star icon 4.3 (36)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Information Theory
Information Theory
Read more
Nov 2024 294 pages
eBook
eBook
  • eBook eBook €4.99
€4.99 €7.99
Odoo Development Cookbook
Odoo Development Cookbook
Read more
May 2024 774 pages
Full star icon 4.2 (10)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Tools and Skills for .NET 8
Tools and Skills for .NET 8
Read more
Jul 2024 778 pages
Full star icon 5 (12)
eBook
eBook
  • eBook eBook €19.99
  • Paperback Paperback €24.99
€19.99 €28.99
€24.99 €35.99
Mastering QuickBooks 2024
Mastering QuickBooks 2024
Read more
Dec 2023 570 pages
Full star icon 4.6 (19)
eBook
eBook
  • eBook eBook €13.99
  • Paperback Paperback €26.99
€13.99 €20.99
€26.99
Mastering Microsoft Dynamics 365 Business Central
Mastering Microsoft Dynamics 365 Business Central
Read more
Mar 2024 684 pages
Full star icon 4.9 (17)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Programming Microsoft Dynamics 365 Business Central
Programming Microsoft Dynamics 365 Business Central
Read more
Oct 2024 466 pages
eBook
eBook
  • eBook eBook €17.99
  • Paperback Paperback €33.99
€17.99 €26.99
€33.99
Microsoft 365 and SharePoint Online Cookbook
Microsoft 365 and SharePoint Online Cookbook
Read more
Feb 2024 640 pages
Full star icon 5 (22)
eBook
eBook
  • eBook eBook €15.99
  • Paperback Paperback €20.98
€15.99 €23.99
€20.98 €29.99
Mastering PyTorch
Mastering PyTorch
Read more
May 2024 558 pages
Full star icon 4.7 (18)
eBook
eBook
  • eBook eBook €21.99
  • Paperback Paperback €26.99
€21.99 €31.99
€26.99 €38.99
Right arrow icon

People who bought this also bought

Left arrow icon
Learn Blender Simulations the Right Way
Learn Blender Simulations the Right Way
Read more
Nov 2022 368 pages
Full star icon 4 (14)
eBook
eBook
  • eBook eBook €17.99
  • Paperback Paperback €33.99
€17.99 €26.99
€33.99
Mastering Microsoft Dynamics 365 Business Central
Mastering Microsoft Dynamics 365 Business Central
Read more
Mar 2024 684 pages
Full star icon 4.9 (17)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Mastering PostgreSQL 15
Mastering PostgreSQL 15
Read more
Jan 2023 522 pages
Full star icon 4.9 (7)
eBook
eBook
  • eBook eBook €21.99
  • Paperback Paperback €38.99
€21.99 €31.99
€38.99
101 UX Principles – 2nd edition
101 UX Principles – 2nd edition
Read more
May 2022 454 pages
Full star icon 4.7 (60)
eBook
eBook
  • eBook eBook €17.99
  • Paperback Paperback €33.99
  • Audiobook Audiobook €31.99
€17.99 €26.99
€33.99
€31.99
Workflow Automation with Microsoft Power Automate, Second edition
Workflow Automation with Microsoft Power Automate, Second edition
Read more
Aug 2022 424 pages
Full star icon 4.3 (36)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Right arrow icon

About the authors

Left arrow icon
Profile icon Grieve
Grieve
LinkedIn icon Github icon
Ian Grieve is a Microsoft Most Valuable Professional for Microsoft Dynamics GP. He is also a certified Dynamics CRM consultant, specializing in the delivery of Microsoft Dynamics GP. He is the ERP Practice Manager at Perfect Image Ltd., a Microsoft partner, and VAR in the North-East of England, where he is responsible for the delivery, by his team, of all Dynamics GP projects. Ian has worked with Microsoft Dynamics GP since 2003, and over the years, he has dealt with all aspects of the product's life cycle, ranging from presales, implementation, technical, and functional training post go-live support to subsequent upgrades and process reviews. Ian is the author of Microsoft Dynamics GP 2013 Financial Management by Packt Publisihing and Microsoft Dynamics GP Workflow 2.0 and Implementing the Microsoft Dynamics GP Web Client by azurecurve Publishing. He is also the co-author of Microsoft Dynamics GP 2013 Cookbook by Packt Publisihing. Additionally, he has produced the Microsoft Dynamics GP Techniques online learning course and was the technical reviewer for several books on Microsoft Dynamics CRM published by Packt Publishing, including Microsoft Dynamics CRM 2011 Cookbook. In his spare time, Ian runs the azurecurve blog, Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk), which is dedicated to Microsoft Dynamics GP and related products. The most recent offshoot of running his blog is that Ian has started writing plugins to extend the functionality of the blogging platform, WordPress. A new site, azurecurve Development (http://development.azurecurve.co.uk), contains information about his plugins.
Read more
See other products by Grieve
Profile icon Polino
Polino
Mark Polino is CPA, with additional certifications in financial forensics (CFF) and information technology (CITP). He is a Microsoft MVP for Business Solutions and a GPUG All Star who has worked with Dynamics GP and its predecessors since 1999. He works as the Director of Client Services for Fastpath, and he runs the DynamicAccounting.net website dedicated to all things Dynamics GP. He is a regularly featured speaker at Dynamics GP related events. This is Mark's tenth book, and his seventh GP related book with Packt Publishing. His work includes eight technology-focused books and two novels. He is also the author of the best-selling Microsoft Dynamics GP 2010 Cookbook, the spin off Lite edition, and a co-author for updated GP 2013 and 2016 editions, all from Packt Publishing.
Read more
See other products by Polino
Right arrow icon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact [email protected] with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at [email protected] using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on [email protected] with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on [email protected] within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on [email protected] who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on [email protected] within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela