How to Address a Functionality Gap in Dynamics GP

When you have a functionality gap between what Microsoft Dynamics GP offers and what you need the software to do, you will need to pick one of three ways to address the issue. The first is to adjust your procedures such that standard Dynamics GP functionality can address the requirement. This “work-around” approach is the least amount of out of pocket money upfront, and is a good approach as long as it doesn’t cause procedural in-efficiencies that can come at a price tag over time. The second option is to explore having a customization written to address the functional gap. Dynamics GP Customizations can be pricey but are justified if the added functionality is essential to the software ultimately meeting the company’s needs.  The third option for addressing a functionality gap is to look at what are called 3rd party products. These products are designed by independent firms, and exist specifically to enhance the Dynamics GP offering. 3rd party products most of the time will have the same look and feel as your version of GP, are upgraded in line with Microsoft’s scheduled upgrades of GP, and are usually priced affordably.

On a recent project we were faced with 2 functional gaps that we addressed with 2 different 3rd party products. The customer wanted to account for all 20 of their companies in one Dynamics GP database. Putting the companies under one database allows them to share vendor and customer accounts, centralize cash disbursements, and stay in one database file instead of constantly logging in and out of the different databases all day long. One requirement they had was the need to book transactions between companies that would result in automatic intercompany postings. This was a challenge with all companies being in one database. Dynamics GP has a module called Interfund that came close to meeting their needs, but ultimately fell short. We ended up deploying Nolan Business Solutions 3rd party product called Intercompany Postings. It comes with functionality that addresses what they call “Intra-company” postings when the companies are in the same database. This module gave our customer the functionality they needed to get the correct intercompany entries booked automatically.

The second challenge we faced was that their customers could buy from the different companies in Dynamics GP, and they wanted GP to book all debits and credits for the sale to that locations general ledger accounts (sales, accounts receivable, inventory, and cost of sales). Setting up Inventory Sites for each company, and assigning the appropriate company code to the site, gave them all the right general ledger postings for sales, cost of sales, and inventory, but not accounts receivable. The accounts receivable account didn’t default to the correct company code. We deployed a 3rd party product from KTL Solutions called SOP/POP Advanced Distribution that allowed us to default the correct company code to the accounts receivable account.

The products from Nolan and KTL Solutions mentioned above were reasonably priced, easy to deploy, and met our customer’s business requirements.

 

This post was written by Andrew Warner, Solutions Consultant at Tridea Partners, a CA, UT, CO Dynamics GP Partner 

System Considerations Before Your Life Sciences Company Goes Commercial

There is no question there are many system considerations when it comes to preparing your company to go commercial – each of which will depend on the business model you have and what business processes will be maintained in-house versus what is outsourced.  Such considerations might depend on whether manufacturing and fulfillment would be internal or through both a contract manufacturer and 3PL.  Other considerations include the following:

  • System of Record: Do you want your ERP software system to be the ‘system of record’ where you’ll be able to defend full product traceability in this system for FDA purposes.  Or, will this traceabilty be paper-based?
  • 3PL Integration / Contract Manufacturer Integration: Is your 3rd party logistics provider able to provide data integrations communications of product that was shipped.  How about providing your manufacturer with visibility into sales demand, and you with visibility into finished product or product costing?
  • Serial / Lot Controlled Items: Unless you’ve passed off all inventory responsibility to a contract manufacturing and 3PL, you’ll need full product lot or serial traceability and a means for managing this added element of effort.
  • CRM Requirements: Do you have plans for a CRM system, or the ability for the sales team to easily manage leads, opportunities and prospective client communications and follow ups so that new business doesn’t fall through the cracks?
  • Quality Management: Once sales of product occurs, it important to have strict controls over the inbound product quality and quality control through the manufacturing process.  Only specialized systems can manage these quality considerations.
  • Material Planning: Making sure the right products are available for the forecasted sales activity can become very important for some companies, which means they need to put an MRP and Sales Forecasting system in place to balance supply and demand.
  • Online Ordering / eCommerce: Today’s customer requires much more flexibility into how and when orders are placed for your product in the market.  However, online ordering comes with many complex challenges especially when dealing with FDA controlled products and operations. 
  • Expense Management: Once there is a sales team selling product, there are regulations in place for how they communicate with potential clients and how they can spend money on them.  One of those requirements is outlined in the ‘Sunshine Act’.  Make sure the systems help you managed towards these regulations.

 

If you would like to discuss these system considerations in more detail, or would like an assessment done of your current system, please contact Tridea Partners: sales@trideapartners.com.

This post was written by Andy Collins, Partner at Tridea Partners. Tridea Partners is a leading consulting provider of Microsoft Dynamics AX, Dynamics GP, and Microsoft Dynamics CRM software applications and professional services for the life sciences and health care industry.

5 Steps to a Smooth Dynamics GP Upgrade

New versions of Dynamics GP are released every couple of years. As new versions are released, older versions eventually fall off the supported list at Microsoft. When this happens, it is a good time to consider an upgrade to the current version of Dynamics GP. Don’t worry; your unsupported version will not automatically stop working. However, you do run the risk of having compatibility issues with GP and the other applications that support or interact with GP. Another reason to upgrade is to take advantage of the features introduced in the new version of GP. A list of new features can be obtained on the www.Microsoft.com\dynamics site.

Many accounting and finance users have the “if it aint broke don’t fix it” feeling about upgrades. This sentiment is rooted in the concern that the upgrade will cause some issues that don’t exist today, so why risk it. As a formal accountant, I completely understand the concerns.

After 18+ years supporting GP, and performing over 80 upgrades, I have put together a list of the 5 things you should follow that will all but guarantee a successful upgrade. If you follow these 5 steps, your concerns should subside, and you will be able to reap the benefits of being on the most current version of Dynamics GP.

1)      Know Your GP Environment:

  1. Which GP Modules are installed and in use – Some modules will require special steps during the upgrade.
  2. Are you using any 3rd party (ISV) products – these will need to be installed and upgraded separately.
  3. Do you have any customizations or integrations with GP – these will need special attention and possible modification as part of the upgrade process.
  4. Do you have modified or custom reports – these may also need to be modified as part of the upgrade.

2)      Make sure your IT infrastructure supports the new version of Dynamics GP – You can acquire a list of System Requirements that provide a detail list of what is compatible with the new version of Dynamics GP.

3)      Perform a test upgrade – Completing a Test upgrade is recommended by Microsoft, and is an especially good idea if you have customizations, integrations, 3rd party products, or custom reports. Performing a test upgrade will allow you to identify and address any unforeseen issues that may come up. This will eliminate the downtime that the issues would have otherwise caused.

4)      Include users in the testing process – Whether you are testing the validity of the test upgrade or the live upgrade, the actual GP users need to be included in the testing. It is easy for consultants and managers to compare reports before and after an upgrade (which by the way is a must), but the users will be able to complete the real stress testing of simulated daily use of GP.

5)      Schedule the live upgrade when you have ample time to complete it – Example, if you estimate it will take 16 hours to complete the upgrade, plan to be down for 20, and give yourself ample time to complete some final validity testing.

Good luck!!

This post was written by Andy Warner, Solutions Consultant at Tridea Partners, Southern California Microsoft Dynamics GP Partner. For more information on Microsoft Dynamics GP, visit our website at http://www.trideapartners.com/.

SmartList in Dynamics GP

SmartList is a powerful querying tool that comes with Microsoft Dynamics GP.  It allows you to view and search through all of your system’s raw data, which GP also conveniently organizes by module in folders and subfolders.  You can choose to set search for data from a wide selection of parameters as well as add additional fields to your SmartList view.  You can create custom reports and set them as reminders to your home page.  So, for example, you could have notifications of any negative customer balances or a certain number of orders past due.  Here are some of the benefits and highlights of SmartList.

User friendly and comes with prebuilt reports

 SmartList organizes all your hard data into folders and subfolders based on which module it originates: General Ledger, Sales/Receivables, Purchasing/Payables, Inventory.  You’ll notice these folders in the left content pane of SmartList.  This makes it easy to filter by module to obtain the data you are searching for.  Within each subfolder, Dynamics GP comes with canned reports.  Some examples of this are views for: posted past due customers, open sales orders and items shipped today.  The benefit of having these prebuilt reports is that it saves users the time of having to create their own from scratch.  Or, if you need a more advanced report, you can use the canned report as a basis to create your view –thereby saving you a bit of time, since GP has done some of the legwork for you.

SmartList in Dynamics GP

Personalize SmartList reports by adding Columns and search criteria

If you click on the Columns button and then Add, you can add additional header fields to your view.  GP provides a long list of fields to select from and you can choose to add an unlimited number of fields to your view.  This makes SmartList very versatile in terms of customizing views for each user and company department’s needs.

One useful header worth pointing out is “Void Status” (Yes or No) for Payables and Receivables.  This field is especially helpful because it allows you to set a restriction that ensures you are searching for only data that is valid.  Often times, users may be viewing incorrect subtotals if they forget to exclude the range of transactions that have been voided.

Personalize GP SmartList reports

If you click on the Search button, you are given a total of four search parameters.  You can use any field as a search criteria and set a wide variety of filters, including but not limited to: date ranges, greater than/less than/equal to rules, contains certain character(s).

GP SmartList search fields

Create Favorites and Reminders on your Home Page

If there is a view that you frequently use, you can set that SmartList as a “Favorite” by clicking on the Favorites button at the top menu bar of SmartList.  Your SmartList will then appear in the folders as a saved view.  You can also set this Favorite as a Reminder.  For example, if you wanted a reminder whenever a new vendor is created, you could set a search parameter of “Number of Records > 0” and set that as a Favorite and Reminder.  Any time this parameter holds true, you’ll see a reminder on your home page.

GP SmartList Custom Reminder

Export to Excel to share reports and for further data manipulation

You can click the Excel button to export your SmartList directly to Excel.  From there, you have the ability to share reports and further organize your data to your company’s needs and liking.

GP SmartList export to Excel

These are just a few of the many features of SmartList.  SmartList’s flexibility and customizability makes it extremely helpful when it comes to things such as, month-end close, cross-checking balances, investigating any reconciliation discrepancies, and troubleshooting your general support issues. For more information on SmartList, please contact Tridea Partners at sales@trideapartners.com.

Written by Renee Leung, GP Application Consultant for Tridea Partners, a San Diego based Microsoft Gold Certified Dynamics Partner.

Posting to a Closed Year in Microsoft Dynamics GP

Recently, we received the question of whether a user could enter a journal entry for an adjustment to a closed year in Dynamics GP.  The answer is that, this is possible depending on how far back you need to post. The rule follows that you cannot post to more than one closed year.  So if I have closed 2012, I can only post back to 2011 and no further.  As such, when closing the current year, it is a good idea to verify that all closing entries and adjustments to the previous year have been made.

Let’s say you are ready to close 2012 but need to post a JE adjustment for 2011.  To do this, you will need to reopen the fiscal period in which you will be posting by navigating to the Fiscal Periods Setup window.  Go to Microsoft Dynamics GP > Setup > Company > Fiscal Periods.

Select the year that needs to be reopened.  Then, deselect the appropriate checkbox corresponding to the period and module you need to reopen. In my case, I have deselected the Financial module for December of 2011 because I need to make a journal entry adjustment to December 2011

General Ledger post to a prior fiscal year in Dynamics GP

Next, you will need to verify that you are allowed to post to history.  Verify that the Allow Posting to History option in the General Ledger Setup window is selected. Go to Microsoft Dynamics GP > Tools > Setup > Financial > General Ledger.

General Ledger

Now, you are ready to create and post your transaction entry for the closed year.  Once you are finished, go back to the General Ledger setup and unmark the Allow Posting to History option (you may leave it marked if that is the default setup), and close the same fiscal period that was opened earlier, using the Fiscal Periods Setup window.

Navigation Paths:
General Ledger Setup – Microsoft Dynamics GP > Tools > Setup > Financial > General Ledger
Fiscal Periods Setup – Microsoft Dynamics GP > Setup > Company > Fiscal Periods

If you do need to post to more than one closed year, Microsoft does offer a service to achieve this.  For more information, please contact support@trideapartners.com.