New and Uncommonly Used Features in Dynamics GP

by | Updated September 9, 2021 | Dynamics GP

Get the most out of Dynamics GP by keeping up to date with new functionality. New and uncommonly used features in Dynamics GP may offer more efficient alternatives to existing processes.

Integrating Payables Management with Fixed Assets

Link the fixed assets module with the payable management module to ensure all received assets are recorded. To utilize this, on the Dynamics GP menu, click on tools, point to setup, point to fixed assets, and click Company. The Post PM through to FA checkbox should be marked. In addition, the require asset account checkbox should be marked.

Fixed Assets Company Setup in GP

The key to this functionality rests in the purchasing posting account, or trigger account. On the Dynamics GP menu, click on tools, point to setup, fixed assets, and click purchase posting accounts. Click the lookup button next to the account number field to specify the GL account. The account listed here will be the trigger account to interface purchasing with fixed assets.

2

When entering the transaction in payables transaction entry, click on the distribution button. The trigger account must be keyed in the PURCH line and debit to the trigger account. Post the transaction in payables.

Integrating payables

Now when you go to the asset general information window in fixed assets, the purchase button will show. However, first, you must enter the Asset ID and suffix, then click the purchase button and mark the checkbox for the purchases document. Click select to populate the asset general information window.

4

Multidimensional Analysis (MDA)

Analytical accounting provides the ability to add additional details to transactions without adding new segments to your chart of accounts. However, a little-known alternative called multidimensional analysis (MDA) offers an underutilized alternative. Analytical accounting does much more than MDA, but MDA still has its rightful place in our decision-making process. Consider a simple scenario: you want to know how much you spend on repairs by vehicle in your vehicle repairs expense account. This problem has simple requirements, so the solution should be simple as well. This scenario can be addressed with multidimensional analysis.

Multidimensional analysis allows users to keep their chart of accounts unchanged by adding tags to transactions. These tags, or dimensions, allow you to analyze data in Smart Lists, Excel, etc. A limitation is they cannot be reported in management reporter.

5

Multidimensional Analysis (MDA): Analysis Groups

Analysis groups group analysis codes. From the example above, the analysis codes will be the vehicle ID (Vehicle 1, Vehicle 2, etc.). Those vehicle IDs will be grouped together into the analysis group called “vehicle repairs”.

6

Multidimensional Analysis (MDA): Analysis Defaults

With analysis defaults, any time an account is used you will be required to enter an analysis code(s) that transactions relate to. Analysis default can also be set up to track quantities.

Analysis defaults define the GL Account you want to use with MDA, along with how you want to use MDA if that GL account is selected as a distribution line. Analysis Groups can be set to different “types”: Fixed, Required, Optional, or None.

7

Multidimensional Analysis (MDA): Using MDA

In the example shown below, a payable transaction for $1000 was entered for a travel company. Under distributions, the vehicle repair account that was linked to analysis codes was brought over. Based on this code, the system knows immediately that it is linked to analysis or MDA codes.

Multidimensional analysis in GP

In this case, the GL Distribution account is one of the GL Accounts setup in your analysis defaults settings. Hence, you get an error if you do not assign an analysis code to the transaction.

To assign the analysis code from the distribution window, you can either use the view/analysis option on the ribbon or, with the correct GL distribution line selected, click the “A” icon in the scrolling window header.

9

This will then take you to the payables analysis posting detail window. This window is similar to the analysis defaults setup window, but the posting detail window looks for actual transaction details.

In the example below, VEHICLE REPAIRS are required for GL account 000-6410-02. You will need to add analysis codes to this transaction.

10

Multidimensional Analysis (MDA): Analysis Codes

Analysis codes can either be set up early in the process or on the fly during data entry.

11

In the example, both vehicles in the transaction must be selected. Notice that the totals match in the image below. The transaction is ready to be posted.

12

Multidimensional Analysis (MDA): Reporting

Dynamics GP has a multidimensional analysis Smart List available out of the box.

13

Powerful data is captured within these columns, allowing you to track non-GL level transactions and amounts.

14

Using Account Categories with Management Reporter

Account categories can be used to simplify management reporter reports. Account categories are groupings of General Ledger accounts that are reported on together, especially for financial statements. Dynamics GP Financials provide 48 predefined account categories. Account categories cannot be deleted, but their descriptions may be changed. Unlimited account categories may be added for your reporting needs.

15

When you add accounts (financial > cards > account) you assign an account category. This account will be included in the totals for that category on reports run in Dynamics GP.

16

Once account categories are added, they are available when creating your link to financial dimensions for use in rows, columns, and reporting trees. As you add new account cards with assigned categories to the general ledger, they will automatically be included on any existing reports where you have defined that account category as your dimension. This added benefit helps reduce the need to maintain report design.

17

Reconcile to GL Routine

Reconcile to GL is a powerful tool that greatly reduces the time it takes to find errors between trial balances in your subledgers (purchasing, receivables, inventory bank reconciliation) and your general ledger (GL). This tool can be found by clicking financial > routines > financial > reconcile to GL. Reconcile to GL is a troubleshooting tool only. It does not make corrections, nor tie to the historical aged trial balance (HATB). If your HATB matches your GL balance, there is no need to use the reconcile to GL tool.

Consider an example: you are trying to reconcile accounts payable to the general ledger and are off for the month. Reconciliation for payables has been set up as follows:

  • The reconciliation date is 04/12/2017.
  • The date range is 03/01/2017 – 03/31/2017.
  • The module is payables management.
  • The A/P GL is 000-2100-00.

18

Click the process button to run. This will cause two things to occur: a file will be saved to the location you chose for output, and the file will open in Excel format. The reconciliation number will increment on its own, without any need to enter something in that field. The file output is divided into three sections: matched transactions, potentially matched transactions, and unmatched transactions.

Matched transactions are those that Dynamics GP has verified all the following:

  • Payables management matches GL.
  • The voucher number matches originating control number.
  • TRX source matches originating TRX source.
  • The posting date matches the transaction date.
  • On account, the amount matches the debit amount or credit amount.

Potentially matched transactions contain transactions with most data points verified but may be missing verification for other data points. Items will commonly show up under potentially matched transactions when the discount amount differs. To avoid this, use the discount GL account as well as the regular A/P GL account.

Unmatched transactions are those that do not match any of the criteria. This could mean there is a transaction in purchasing but not on the GL, or there is an entry in the GL that does not match any transactions in purchasing. If your reconciliation is unbalanced, unmatched transactions are likely where your error is. Concentrate your efforts here to find reconciliation issues.

A good way to avoid mistaken postings to your master sub-ledger accounts (cash, accounts receivable, accounts payable, inventory) is to disallow posting to those accounts. This is done on the account card by unmarking the allow account entry checkbox.

19

All-in-One Views

All-in-one view (AIO) is an exceptional new feature that allows users to easily track the complete cycle for a transaction or group of transactions. It is available for purchasing, sales, and inventory in Dynamics GP. With AIO, you can easily view all transactions related to a specific vendor in one window. For each vendor, you can view the PO, invoice, receipt, returns, credits, and other purchasing documents related to a transaction. This tool can be accessed from purchasing > inquiry > all-in-one view.

20

To use this tool, enter the vendor and select the document in question. Mark the checkbox in the upper left corner of the box. This will show all additional transactions affecting the document and hide all others.

Purchasing all in one view

If you’re new to Dynamics GP and are interested in hands-on training, reach out to our team to inquire about upcoming classes.

Stay up to date on new features, functionality, how-to’s, tips, and tricks by subscribing to our blog.

Related Posts

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

september

01sep10:00 am10:30 amEnsuring Quality and Compliance for Batch Manufacturers in Life Sciences

01sep12:00 pm12:30 pmIs it Worth It to Move to the Cloud? A Look at Considerations for Current Agribusinesses Using Dynamics GP

01sep2:00 pm2:45 pmWhat’s New in Dynamics 365 Finance and Supply Chain

09sep11:00 am12:00 pmConfab Live with Stoneridge – Data Strategy and Reporting – Mining Decision Making Insights

15sep10:00 am11:00 amSolving the Biggest Challenges in Agribusiness Through Innovation and Technology

22sep12:00 am12:30 pmSimplifying Payroll and HR Management with ADP Workforce Now

22sep10:00 am10:30 amStreamlining Batch Manufacturing with Technology

22sep2:00 pm2:30 pmProcess Automation for Microsoft Dynamics D365 for Business Central, Finance and Operations and GP

23sep11:00 am12:00 pmConfab LIVE with Stoneridge - Riding the Wave 2 Release – Key Features Coming to Dynamics 365 this October

27sep(sep 27)9:00 am15oct(oct 15)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

29sep10:00 am11:00 amTop Five Reasons Why NOW is the Right Time to Move from Salesforce to Dynamics 365 Customer Engagement

29sep12:00 pm12:45 pmUnderstanding Job Costing and Tax Management in Business Central

29sep2:00 pm3:00 pmDigitalizing Horticulture & Agriculture - How to Sell Plants Online and Simplify Business Management

30sep12:00 pm4:00 pmSecurity and Permissions Training for D365 Business Central or Dynamics NAV

october

27sep(sep 27)9:00 am15oct(oct 15)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X