Microsoft Dynamics GP Archives - FMT
Are You Using Contract Billing in Dynamics GP?
Are you familiar with the amazing functionality for Contract Billing that is hidden inside Microsoft Dynamics GP and within the Field Service module? This functionality allows you to easily manage contracts with your customers with the ability to enter multiple lines of detail with item numbers whether it’s inventoried or a service type. One of the many benefits of this module is its capability to quickly generate multiple invoices from multiple contracts as well as perform revenue recognition to move dollars out of Deferred accrual account and into actual Revenue account. As actual transactions are processed, the billing schedules and revenue recognition schedules are updated to show the current status of your contracts. The image below shows the screen in which general contract information is entered. The key fields are the contract start date, number of periods, the billing frequency, and the day of the month to bill. You can also […]
Payroll Year-End Update Simplified
Wondering how to prepare the Dynamics GP Payroll module for 2020? First, apply the Payroll Year-End Update provided by Microsoft, complete your Payroll Year-End Closing procedures, and then install the payroll tax update for 2020. It sounds fairly simple, right? You might be just a bit nervous because ultimately we’re touching a sensitive part of the system, employees’ money. Have no fear, FMT is here to help. I’m going to provide the basic instructions and links to all the information you need to complete the Payroll Year-End update successfully. Let’s start with where to get the Payroll Year-End Update. Find your version of Dynamics GP below If you are using Microsoft Dynamics GP 2018, find the U.S. Payroll Year-End Update Here If you are using Microsoft Dynamics GP 2016, find the U.S. Payroll Year-End Update Here If you are using Microsoft Dynamics GP 2015, find the U.S. Payroll Year-End Update […]
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 try to integrate Bank Transactions into Dynamics GP, the eConnect throws an exception and the following message shows up "Violation of PRIMARY KEY constraint 'PKCM20100'. Cannot insert duplicate key in object 'dbo.CM20100'." This Primary Key error is thrown by the SQL Server whenever I tried to insert duplicate key values into the table. The primary key for the table dbo.CM20100 is a combination of two fields CMDNUMWK and VOIDED. Take a look at the screenshot below to view the schema of dbo.CM20100 table and highlighted the primary key. The Data Issue I analyzed […]
You down with SOP? Yeah you know me!
Are you a Dynamics GP user feeling the constraints of the GP SOP interface? Do you crave more flexibility within the system? Would you like to pay less than the full core GP user? Many of our client have expressed the same. In this blog, I will introduce SalesPad as a preferred Dynamics GP add-in, review who the ideal candidate is and discuss the benefits of their software. Who is SalesPad? Founded in 2003, SalesPad is not your average technology vendor. Headquartered in Grand Rapids, Michigan, SalesPad has created a state-of-the-art “skin” that enhances the operational modules within Dynamics GP that helps recognize opportunities for greater profitability. Who is the ideal SalesPad Desktop candidate? A company that SELLS stuff. It’s that simple. If you are in the distribution and manufacturing industry SalesPad Desktop can be there for you as your operational ERP. Leave Dynamics GP for the accountants. […]
How to Set-Up Human Resources Accruals in Dynamics GP
Are you utilizing Payroll and Human Resources through Microsoft Dynamics GP? Are you still using Payroll Vacation/Sick time for recording available hours? It is time to get away from this functionality and use Human Resources to its fullest capabilities. First, go to Microsoft Dynamics GP Button | Tools | Setup | Human Resources | Attendance | Setup Choose Accrue Type of Human Resources. This will enable the options below. If you select to Allow entry of attendance type and reason in Payroll, a window will open in the Payroll Transaction Entry when entering a Pay Code related to Vacation/Sick/Holiday/etc. and prompt you to enter a Reason and Type. Next, set the Current Year and Last Day Accrued. If you are using the Payroll Accrue option currently, enter the date of the last time the accrual process ran. If you are just starting out with accruals it is […]
Dynamics GP Deployment in Multinational Environment
Company A is becoming a multinational corporation and has made acquisitions to expand operations at various locations across the world. Can a Dynamics GP solution be deployed so the environment only has a single set of databases? Yes, indeed. Multiple Dynamics GP clients of different languages can be installed and connected to the same database backend in a single environment. Should a company be operating in multiple areas in the world, localization is available for the Dynamics GP client. Some localizations may have additional features and functionality available that are geared towards its specific area. For a list of available modules and countries, click here. In general, a deployment of multiple Dynamics GP client localizations requires install and configuration of the primary location first, and then the secondary. Summarized steps are as follows: Install Primary localization of Dynamics GP Client. Run GP Utilities. Launch GP and log in SA for […]
Dynamics GP License Types That You Probably Didn’t Know About
When purchasing Dynamics GP, many companies are not aware that there are actually three different types of Dynamics GP licenses at three different price points. Full User License The first license I would like to discuss is the Full User license. This license provides you with the most functionality within Dynamics GP. With a Full User license, you will have unrestricted access to Dynamics GP with full read and write capabilities across your system. This is the most common type of license within a company, as well as, the most expensive at $3000 per user. Limited User License The second license is the Limited User license. Like the name states, the user will have limited access to the functionality within GP. This license is usually reserved for users who have to perform certain tasks within GP, such as sales, purchasing, or payroll tasks, but do not need the full functionality. […]
Management Reporter Replacement: Moving to Next-Gen Reporting
Microsoft recently announced the end of future development for the Management Reporter tool in Dynamics GP. While you’ll still be able to use MR and receive basic support—it’s not recommended to stay with a solution that is no longer going to be updated or enhanced. The good news is that you can switch to a next-gen solution like Solver BI360, and actually gain enhanced capabilities and intelligence beyond MR’s financial reporting. Watch this video to get a better look at BI360’s powerful reporting module and how it’s the perfect replacement to Management Reporter.
Say Goodbye to Applying Credit Memos at Month-End
Applying credit memos or returns to sales invoices at month end can cause duplicate efforts. If a user forgets to apply the credit memo, an invoice will populate on the aging report even though the true balance is $0. In addition, applying credit memos or returns is an extra step that is sometimes unnecessary. To reduce efforts, users can apply a credit memo, return, or overpayment at the same time a user enters a cash receipt. To do so, enter the cash receipt details by going to Sales >> Transactions >> Cash Receipts. After you enter the cash receipt details (such as customer, date, payment type and amount), select “Apply” to open the Apply Sales Documents window. From this window, mark the invoice to which you wish to apply this cash receipt. Now, don’t hit OK yet as tempting as it is! Look at the details of your applied […]
Deposit Cash Receipts Automatically with Dynamics GP 2016
New to Dynamics GP 2016, users no longer need to create a deposit for the cash receipts entered in the sales module. Configuring this feature is quick and easy! To post cash receipts as deposits, navigate to Administration >> Setup >> Company >> Company. Select Options and then mark the box next to “Automatically post cash receipt deposits”. Press OK, and then OK from the Company Setup window. Please note this is a configuration per company so if you have multiple databases, you will need to select this option in each database. Once you mark this option, a deposit will be automatically created when a user posts a cash receipts or cash receipts batch from Sales >> Transactions >> Cash Receipts. If you post an individual transaction, the deposit amount will be in the amount for that one transaction. If you post a batch of cash receipts, the deposit […]
Why SmartConnect Is the Go-To Integration Tool for Dynamics GP
SmartConnect is a very sophisticated tool for integrations. With its high level of versatility, it does a great job of automating your integration needs. It is definitely one of my tools of choice! Data can be read from Dynamics GP, Dynamics CRM, OLEDB or ODBC, text files, Excel, XML and more. You can even use multiple data sources and then join the results from the multiple data source. This makes utilizing data sources from separate databases or even joining a database data source with a text file data source possible! You can also set a network folder as a data source. The files in the folder can be Excel, text, XML, or XmlQuery. As long as the files match a designated template (or schema for a text file), SmartConnect will be able to process all the files contained in the folder. You can designate folders […]
[Video] Getting Started with Power BI and Dynamics GP
Do you spend hours every week trying to analyze and create visual reports from your Microsoft Dynamics GP data only to do it again for next week’s meeting? If this sounds like your weekly routine, Power BI is going to be a life-changing tool for you. Microsoft’s Power BI solution allows you to put your entire company’s data onto one visual dashboard. It will also create real-time interactive reports that you can easily share with the rest of your organization. Want to bring your GP data to life? Watch this video to see how easy it is to create reports through Power BI and gain insight into your Dynamics GP data from financials, to sales, to receivables, and so much more!