a Microsoft Dynamics GP Archives
 

Tracking and Reporting Projects using Office 365 and Project Online

Did you know Office 365’s tools can make your PMO run more efficiently?

Read More
  1. How to Deal with eConnect Exceptions 9.4.19
    Development, Microsoft Dynamics GP

    How to Deal with eConnect Exceptions for Bank Transactions Integration in Dynamics GP

    In this blog post, we are going to discuss how to deal with eConnect primary key exceptions. Let’s say there is a company called Fabrikam Inc. and they provided the data for Dynamics GP. We are going to leverage eConnect to integrate Bank Transactions into Dynamics GP.   The eConnect Primary Key Exception When I…

    Read More
  2. Migrating from Dynamics GP to D365 Business Central Image
    ERP, Microsoft Dynamics 365, Microsoft Dynamics GP

    Migrating from Dynamics GP to D365 Business Central

    So you want to take your business to the cloud. Dynamics GP has been great. It’s comfortable, it’s widely used and supported across North America, but let’s face it…it could use some updates to take advantage of newer technologies offered by other systems. Moving to a more modern platform can provide many advantages to an…

    Read More
  3. Tips For Year End Closing Image
    Microsoft Dynamics GP

    Tips for Year End Closing in Microsoft Dynamics GP

    Closing out the year in Dynamics GP requires a very specific set of actions to complete. Please refer to the Period and Year-End Best Practices for more details from our Dynamics GP 2018 Period-End & Year-End Closing Manual.   So in this blog, we’ll go over general tips for all year-end closings as well as…

    Read More
  4. GP migration webinar image
    ERP, Microsoft Dynamics, Microsoft Dynamics GP

    Moving from GP to the Cloud

      Learn how moving to a cloud-based Enterprise Resource Planning (ERP) will improve your company’s ability to overcome challenges and transform your business for long-term success.   In this session, you’ll learn …     Why you need to move off GP     What happens if you don’t move     5 Ways moving…

    Read More
  5. Auditing Changes in Dynamics GP-Blog Header
    Microsoft Dynamics GP

    Choosing the Right Tools for Auditing Activity Inside Dynamics GP

    Change… It is something that every organization faces.  Whether it is the change of a business process, change of personnel, change of a software solution or change of data within a software.  Some types of change are more complex than others, but even something as simple as the changing of data within a system can…

    Read More
  6. Finding the right columns for your everyday Smartlists in Dynamics GP - Blog Header
    Microsoft Dynamics GP

    Finding the right columns for your everyday Smartlists in Dynamics GP

    We all know how powerful Dynamics GP Smartlists are, but sometimes it can be hard to find the right columns/fields to build them out with additional information that we need. One that comes up quite a bit, is the Batch ID associated with posted account transactions. When you add the Batch Number column to the…

    Read More
  7. Reconciling Inventory to the GL in Dynamics GP
    ERP, Microsoft Dynamics GP

    Reconciling Inventory to the GL in Dynamics GP

    There are multiple ways to reconcile sub-ledgers to the GL in Dynamics GP, the Reconcile to GL routine being one of my favorite, but there can be times when you’re still stumped wondering what happened? I had a client recently face this situation. They ticked and tied every transaction to the GL, but their Inventory…

    Read More
  8. Unit of Measures Design with Item Configuration Equals Inventory Accuracy
    ERP, Microsoft Dynamics GP

    Unit of Measures Design with Item Configuration Equals Inventory Accuracy

    In the Importance of a Good Unit of Measure Schedule blog, we walked through the importance of unit of measure schedules and how to design a unit of measure schedule. Using a well-designed unit of measure schedule and proper configuration of inventoried items in Dynamics GP, enables your system to accurately track inventory balances. An item card…

    Read More
  9. Importance of Good Unit of Measure Schedule GP
    ERP, Microsoft Dynamics GP

    The Importance of a Good Unit of Measure Schedule in Dynamics GP

    When configuring inventoried items in Microsoft Dynamics GP, we need a clear understanding of the types of transactions which occur against inventoried items. You purchase items, sell items, transfer items between sites and bins, consume items during production, and produce items. That is A LOT of transactions. But…if you think about it, you probably already…

    Read More
  10. Extender-Record-GP
    Microsoft Dynamics GP

    Creating Extender Records automatically using Extender Actions

    We all know how to create an Extender window and track additional information. Recently there was a customer request to track the Revision Level whenever an item is purchased. In order to track the Revision Level, an Extender window has been created and linked with the Purchase Order Detail Entry window as shown below. During…

    Read More
  11. Integrate fixed assets from an Excel spreadsheet into Dynamics using SmartConnect
    Microsoft Dynamics GP

    Using SmartConnect Customization to capture Dynamics GP Fixed Asset ID with GP Rolling Column

    Recently, I had a client that needed to integrate fixed assets from an Excel spreadsheet into Dynamics using SmartConnect. When building the integration, I encountered an issue with using a GP Rolling Column for the Fixed Asset ID; SmartConnect does not include the native capability to capture the next Fixed Asset ID with their GP…

    Read More
  12. create new companies with existing setups in GP
    Microsoft Dynamics GP

    Create new companies with existing setups in Dynamics GP using clear data

    Creating new companies in GP and copying the set-up on an existing company into them, is frequent request consultants usually get. In this blog, we will go over how to create a new company with the setup of a current company with the same chart of accounts using data  The traditional method for creating new…

    Read More

The FMT Way

Optimizing your business processes—and achieving your goals—can be easier. With our team of experts, from designers to architects, you’ll gain the technology experience, dedication, and know-how that your business needs.

We’re here to inspire your greatness through technology.

Let's Start the Conversation