Analytical Accounting with Dynamics GP

How many of you out there are using Analytical Accounting with Dynamics GP?  It is a great tool that allows you to flag distribution amounts to codes, without having to increase the length of your General Ledger Accounts.  Through many times of implementing this module, we at Tridea have found that a few custom reports can make everyone’s lives easier.  Because it is an additional module, outside of the standard GP modules, Smartlists and Edit Lists are limited and can be made more efficient.

Using SQL Server Reporting Services to create custom reports, users can access their Analytical accounting data and balances quickly and accurately.  Furthermore, SSRS reporting can be used to create edit lists that will combine standard Edit List reports from GP with the Analytical accounting information.  Custom buttons can be added to the batch entry window that will trigger the SQL report to generate, pulling only transactions contained in the batch selected.  Not only does this consolidate the information needed for editing and reviewing batches, but it will also reduce the amount of paper allowing for a greener approach to accounting!

This article was written by Kaydee Baker, Dynamics GP Application Consultant for Tridea Partners. Tridea is a leading Microsoft Dynamics provider serving CA, AZ, UT, CO, New England and surrounding regions.

Microsoft Dynamics GP2015 R2 Feature of the Day

Purchasing All in One Document View Options

This is a newly designed window inside of Microsoft Dynamics GP to enable users to view related purchasing documents in the same window.  Accessible from the Vendor Maintenance window, many purchasing inquiry windows, Navigation lists and even the Home Page this window will save users time in searching for all relevant information for a purchasing document.  The Options button will allow users to select which columns they want to see in this window.  For example, if customers do not use Purchase Orders, they can uncheck the box and the first column would be Receipts.  By default the Credit Documents column does not display but with this column checked up to six columns of data can be shown.

GP 2015 R2

Contact Tridea Partners if you are looking to find out more information on GP2015 R2! 

Microsoft Dynamics GP2015 R2 Feature of the Day

Purchasing All in One Document View – Filter

This is a newly designed window inside of Microsoft Dynamics GP to enable users to view related purchasing documents in the same window.  Accessible from the Vendor Maintenance window, many purchasing inquiry windows, Navigation lists and even the Home Page this window will save users time in searching for all relevant information for a purchasing document.  The Filter icon allows users to select open and/or historical or saved vs. posted documents in the Purchasing All in One Document View window.  The options are specific to each column and saved per user allowing users to customize what they want to see.  Specific searches are also enabled in the filter window to narrow down the search results.  The clear filter icon with the red x will clear all filters and reset to the defaults.  

Purchasing All in One Document View – Filter

Contact Tridea Partners if you are looking to find out more information on GP2015 R2! 

Macros in Microsoft Dynamics GP

Have you ever needed to mass update something that isn’t available through Integration Manager? I know that most people would say ABSOLUTELY!  Sometimes we have to bring it back to how things were before we had eConnect and Integration Manager…meaning, let’s use a macro!

Macro’s are easy to create through Microsoft Dynamics GP (Microsoft Dynamics GP > Tools > Macro > Play/Record).  In order to create a macro to update many records, start by compiling your data into an excel workbook.  Next record your macro within the GP interface.  Be careful to use your keyboard as much as possible, and your mouse as little as possible while doing so.  After complete, copy and paste the macro into MS Word and create a mail merge with your excel data and the macro.  Go all the way through the mail merge wizard until you get to the point where you can ‘Edit Letters’.  Copy and paste that data into the macro and voila!  You are now ready to play the macro to update records. 

This article was written by Kaydee Baker, Dynamics GP Application Consultant for Tridea Partners. Tridea is a leading Microsoft Dynamics provider serving CA, AZ, UT, CO, New England and surrounding regions.

 

 

Project Tracking in Dynamics GP

Deciding what is the best way to account for project data in Dynamics GP is a widely debated topic. You can always add a segment to your chart of account structure for “project”, but if you have a high turnover rate on projects this option will result in a very large chart of accounts over time. In order to keep the general ledger from growing to large, using a sub ledger is the next best choice. Two built in options are Analytical Accounting (AA), and Multi-Dimensional Analysis (MDA). MDA is very easy to setup but is a bit limited on features. AA offers more features than MDA and is therefore a bit more complex to configure. If you have complex project billing (invoicing) requirements, then you will want to take a look at a 3rd option from the Microsoft Dynamics GP offering called Project Accounting. From a licensing point of view, you most likely own AA and MDA, but you may need to purchase Project Accounting based on when you bought Dynamics GP originally.

In addition to the 3 modules mentioned above, you might want to have a look at a module called Project Tracking from Encore Business Solutions. Project Tracking (PT) is a fully integrated project module built to work with Dynamics GP exclusively. Once installed, it looks and feels just like any other module that comes with Dynamics GP. PT adds a project sub ledger that can be accessed from all transaction entry windows in GP. PT is very easy to use and comes with many user defined fields allowing it to address a wide variety of project reporting needs.  In addition to the core functionality, PT has optional add-ins that can be purchased for project budgeting and importing data.

Here are screen shots of some of the Project Tracking windows:

Project Tracking

Project Maintenance

Project Tracking Distribution

 

Tridea Partners has implemented all of the solutions mentioned above and we are happy to speak with you to help identify the best option for addressing your project accounting needs.

This article was written by Andy Warner, Dynamics GP Application Consultant for Tridea Partners. Tridea is a leading Microsoft Dynamics provider serving CA, AZ, UT, CO and surrounding regions.