Microsoft Dynamics GP Archives - Page 9 of 12 - FMT

Search Archive
A Guide to Modifying Third-Party Forms in Microsoft Dynamics GP
When developing integrations for Dynamics GP, there are times when you need to modify a form installed with a third-party add-on. This blog provides step-by-step instructions on how to do so. First, use the Alternate/Modified Forms and Reports form in the Setup section of Tools. Ensure that the third-party form is selected. Open the desired form. In this example, I have selected Item Maintenance. Click on Tools > Customize > Modify Current Window. This will open the Window customization application. Click New on the toolbar window. Enter the information below and click OK. In this example we’re modifying a toolbar button. Change the Appearance and the Back Color to match the image below. From the toolbar, drag the okButton to the toolbar of the form window. Then click on File > Microsoft Dynamics GP. Launch Visual Studio and create a new Microsoft Dynamics GP Add-in project. In the GPAddIn.cs file, […]
Item Allocation Quantity Does Not Match Sum of Allocated Orders in Microsoft Dynamics GP
Issue This is an issue in Dynamics GP that I have seen a few times, especially with clients that have a number of third-party products or customizations. The ITEM INQUIRY window is showing a certain quantity allocated, but when you drill down on the allocation, the allocated orders do not add up to the total allocated quantity. You might try to run the ITEM RECONCILE, but it doesn’t make any changes to the allocation. You might try to do a manual update to the item allocation quantity in the backend, but as soon as you run the ITEM RECONCILE again, it reverses the changes you just made. So at this point, what do you do? Diagnostic Tools Item_Allocation_Detail.sql - As it turns out, there are a number of possible inventory allocations that do not show up in the ITEM ALLOCATION INQUIRY window. However, the following script will show all the […]
Experience Microsoft Dynamics GP 2013 R2 and a Wealth of Third Party Dynamics GP Applications at nVerge 2014
nVerge 2014 is a one-day technology conference taking place on September 25th, 2014 in San Diego, CA. The conference focuses on the latest feature updates and trends for Microsoft Dynamics GP, Dynamics CRM, Dynamics Marketing, Microsoft SharePoint, Microsoft Office 365, Business Intelligence and much more. See the full agenda here and learn more at The Dynamics GP sessions at nVerge include: Dynamics GP 2013 R2 – The Top 16 Crowd Pleasing Features This high-paced 60-minute Dynamics GP session dives in to some of the most popular new features of Dynamics GP 2013 R2, including Document Attach 2.0, Copy-Paste to GL, Checkbook IDs on Cash Receipt and Reverse GL Year-End Close. This session is presented in a shootout fashion. Dynamics GP 2013 R2 - Workflow Design & Demo With Dynamics GP 2013 R2 came a brand new workflow system allowing GP users to design and automate workflows for various document approvals. […]
FMT Consultants Announces nVerge 2014 - a One-Day Technology Conference Focusing on Microsoft Dynamics GP, Dynamics CRM, Dynamics Marketing, SharePoint, Office 365 and IT Environments  
nVerge 2014 takes place on September 25th in San Diego, CA and offers a combination of keynotes, breakout sessions, learning labs, ongoing exhibition with software developers and IT service providers, networking sessions and a post-conference cocktail reception. San Diego, CA, July 29, 2014 - FMT Consultants, a leading San Diego and Los Angeles-based provider of technology solutions, announces nVerge 2014. nVerge 2014 is a one-day technology conference focusing on the latest feature updates and trends for Microsoft Dynamics GP, Dynamics CRM, Microsoft SharePoint, Microsoft Office 365, Business Intelligence, Corporate Performance Management (CPM) solutions, third party software applications for the Microsoft Dynamics product line, hardware solutions and IT services. The one-day conference offers a combination of keynote and breakout sessions, presentations by premiere San Diego businesses, ongoing learning labs, exhibition with IT service providers and independent software vendors, networking sessions, breakfast, lunch featuring a special presentation by Dale Carnegie of San […]
Scribe Insight: How to Implement Long Running Batch Jobs in Scribe
For organizations that use multiple systems, there often is a need to synchronize company data, such as accounts and invoices, between different systems. Scribe Insight is a powerful and viable integration tool designed to save organizations from complex and often costly custom integrations. With the intuitive visual tools available in Scribe Insight you can quickly build, maintain and add integrations without having to write much code, if any at all. We were recently asked by a client to mass update the statuses on invoices in Microsoft Dynamics CRM Online from Dynamics GP. The number of invoices that needed to be updated every day was in the tens of thousands. We found limited documentation on how to run long batch jobs in Scribe and decided to write this article to provide guidance on best practices for integrating a large amount of data. There are various ways you can implement the integrations to […]
Issue with Dynamics GP Web Client - Unable to Log into the GP Web Client with Error Code: “There is no such object on the server”
I recently encountered an issue where Dynamics GP users no longer were able to log into the GP Web Client with their domain credentials. Before the issue was reported (by multiple users), the users were able to log in without problems. When attempting to log in to the GP Web Client with domain credentials at the initial login, an error was displayed stating “Unexpected Error” with the following notes – “An unexpected error has occurred. Press the Sign-in button to reconnect to the application.” When clicking the “Sign In” button the system will load the login screen. By browsing to the Event Viewer and reviewing the logs for Dynamics GP I noted the following message: d2ac643a-e378-45a3-bc89-b508c8de5d66:An unexpected error has occurred. Press the Sign-in button to reconnect to the application.: (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]: There is no such object on the server. (Fault Detail is equal to […]
Decrypting Microsoft Dynamics GP eConnect Stored Procedures
On a recent project, I had to decrypt an eConnect stored procedure – something you typically never have to do when using eConnect. eConnect provides both Pre and Post procedures for modifying business logic before passing a transaction through eConnect to Microsoft Dynamics GP (I advise against modifying any Dynamics GP stored procedures as it may cause problems down the road with upgrades). In my case, I was working on an integration using SmartConnect to insert a payables transaction into Dynamics GP. (If you haven’t used SmartConnect before, it’s a terrific tool for creating quick integrations to GP from other sources including flat files, SQL, CRM etc.; but that’s a blog for another day.) It was a pretty straightforward integration using eConnect and leveraging the taPMTransactionInsert procedure. However, I was running into issues because of an error caused by code written by a previous consulting firm in the post procedure […]
Video: Unproductive Dynamics GP Habits and How to Get Rid of Them
The video discusses some of the most common bad Dynamics GP habits (and how to get rid of them), and covers a wide range of Dynamics GP best practices that will help you speed up your GP business processes, avoid common mistakes and ultimately, make your life as a GP user a heck of a lot easier. The topics of the video include: Enhancing internal control: batching vs. transactional posting, batch approvals, utilizing SmartLists to review un-posted data Optimizing business processes: posting to/through and closing sub-ledger periods Simplifying sub-ledger reconciliations: allow account entry setting, using separate GL accrual accounts and using the sub-ledger reconciliation tool The video was recorded on March 27th 2014 by Ryan Pekrul, Senior GP Consultant at FMT Consultants. FMT is a leading Microsoft Dynamics GP partner and consulting firm serving all of the US and Canada with a significant presence in San Diego County, Orange County […]
Are You Considering an Upgrade to Microsoft Dynamics GP 2013? Here’s Why the New Licensing Model will Work in Your Favor
Need a reason to upgrade your current GP environment to GP 2013? How about getting a bunch of modules from Microsoft for FREE? Did you know that Microsoft is now requiring clients to upgrade to its latest Dynamics GP licensing schema, perpetual licensing, prior to upgrading to Dynamics GP 2013? This means that all current Microsoft Dynamics GP clients will have to have their current licensing schema (Professional, Standard, Business Essentials (BE), Advanced Management (AM), etc.) reviewed and then upgraded. So, why is this a positive thing? Because everyone that we have run through the licensing upgrade process has come out ahead. How so? In the past, figuring out the licensing costs, user privileges and modules included was quite the challenge. Depending on which licensing schema you were on, there could be three different types of users, and/or over 50 module options. If you were in the Standard or Professional Licensing […]
Microsoft Dynamics GP Year-End Closing Procedures: Solutions to Common Issues
It’s year-end season and there is no better time to discuss Dynamics GP year-end issues, and provide solutions to the most common Microsoft Dynamics GP year-end closing problems. In this blog I’m covering common errors experienced when attempting to close the G/L year in Microsoft Dynamics GP. In addition, I will supply a few helpful links to sites that I, myself, will reference from time to time. Before we cover common errors, I’ll briefly discuss the nuts and bolts of the closing process. Once you hit the ‘close year’ button on the year-end closing window, two major processes occur: The year is marked as historical and all entries marked with the year in question will be moved from the YTD OPEN table (GL20000) to the Historical table (GL30000). A year-end closing journal entry is created closing all Profit and Loss type accounts to designated Retained Earnings account(s). In addition, all […]
New in Microsoft Dynamics GP 2013 Service Pack 2: SmartList Designer
Earlier this year, we heard that Microsoft was returning sales and support of SmartList Builder to its original developer, eOne. While we were still waiting to find out what that meant for our customers, GP 2013 Service Pack 2 was released, quietly unveiling SmartList Designer: Similar to SmartList Builder, you do need to have a feel for how to join tables together. Also like SmartList Builder, you have the ability to point the Designer at any SQL view or table, including ones you create yourself, which means you can display just about any query you can imagine. It’s very new and there are a few small bugs that I expect will be ironed out in the next release, but it’s ready to use today. The manual can be found in the newest release of the Dynamics GP User Guide. For a quick tutorial, check out this video from Microsoft:   […]
Multi-Entity Management in Microsoft Dynamics GP Made Easy with Binary Stream
Does your company have a complex business structure that may require multiple legal entities with complicated reporting requirements? Are you tired of the hassle associated with maintaining separate GP companies for each entity? Are you frustrated with maintaining multiple vendor, customer, employee and fixed asset master records or managing consolidated reporting through differing chart of accounts? If so, Binary Stream’s Multi-Entity Management tool for Dynamics GP may be of interest to you. This product allows multiple entities to be managed within a single Dynamics GP company by using an entity designation within your chart of accounts. Below are some of the key benefits of the Multi-Entity Management tool: The ability to manage centralized or de-centralized checkbooks, customer, vendor, item master listings for all entities within a company. The capacity to generate entity-specific reporting such as Accounts Payable/Receivable trial balances, Vendor 1099s, Employee W2s and Accounts Payable/Payroll check formats, etc. The […]
1 5 6 7 8 9 10 11 12
 FMT Consultants, LLC.
Privacy Policy

Contact Us


Newsletter Sign-up

menu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram