Dynamics GP Land

Dynamics GP Land
  • eConnect 2010 / 2013 error: Procedure or function 'ta___________' expects parameter '@________, which was not supplied

    By Steve Endow It can be really strange how some Dynamics GP issues come in clusters. One week, all will be quiet, but the next week, you'll get multiple calls, often regarding the same issue. Last Saturday, I received an email asking for help with...
  • Microsoft Project Auto Schedule option

    By Steve Endow I recently started a new project that looked like it would require a bit of planning between at least two different client teams, the GP partner, and two contractors. I initially created an Excel file to start recording tasks, dates, and...
  • Search for text in all SQL Server stored procedures

    By Steve Endow A customer emailed me this morning saying they were getting this error when posting some batches in their test environment: The stored procedure glpPostBatch returned the following results: DBMS: 0, Microsoft Dynamics GP: 20507 I opened...
  • Finding your Dynamics GP Site Name to Request ISV Registration Keys

    By Steve Endow This may seem pretty basic to many, but it is such a common issue for me that I want to discuss it in the hopes of clarifying it for GP customers. I sell several ISV "add-on" solutions for Microsoft Dynamics GP. To allow customers...
  • SOP Orders imported with eConnect auto allocate and auto fulfill

    By Steve Endow I received a call from a customer who has an eConnect application to import SOP orders. The import was developed by another partner many years ago, and I inhereted it for ongoing support. It has been working fine, but the client is changing...
  • Delete Deductions? Um, Not So Fast.

    Did you know you can delete a deduction assigned to an employee even if there is activity for that deduction? As long as the activity is in a prior year, and the year end close for Payroll has been completed, Dynamics GP will allow you to delete the code...
  • "Background process is running: Exit Aborted" message when trying to close GP

    By Steve Endow I am developing a Dynamics GP VS Tools AddIn for a customer, and while testing the AddIn, I started to get this message when I tried to close GP: "Background process is running: Exit Aborted" In my VS Tools AddIn code, I am accessing...
  • Adding 1099 Box Number to Reports

    A shout out to the fabulous Patrick Roth at Microsoft for pointing me in the right direction for this one. We had been trying to add the 1099 Box Number from the Vendor Maintenance Options window to the 1099s Printed report (printed from the Print 1099s...
  • Recreating Year End Wage File After 2014 Payrolls

    Ah, Payroll Year End. It deserves to be capitalized. So much fun, in such a short time frame :) Just a quick reminder post that you can recreate the Year End Wage File if absolutely necessary after running 2014 payrolls. Assuming you have applied the...
  • Tracking Actual Hours Worked in Payroll

    There is no good excuse for my absence from blog land in the past few months. It seems like I came out of Technical Airlift and GPUG in to a whirlwind of holidays, projects, and January 1st go lives. So in all of that, the rhythm of posting to the blog...
  • Inventory transaction "Reason Code" field in GP 2013

    By Steve Endow I admit, I am not enough of a Dynamics GP geek to thoroughly review all of the new features and enhancements that come out with each new version (okay, that can actually mean that I'm lazy). I typically glance at the GP team's features...
  • Unable To Open Select Human Resources Windows?

    I ran across an odd case when I was on site with a client a couple of weeks ago. The users could navigate easily to all of the Human Resources window. But when they navigated to Employee Maintenance window, clicked Human Resources, and the tried to click...
  • When good backups just aren't enough

    By Steve Endow Today I was hoping to start a new development project. I blocked out my day to focus on the project and was ready to dig into some code. This morning I fired up one of my HyperV virtual servers that was setup for this particular type of...
  • Year Over Year Comparison in SQL

    Either we are slacking, or we are both so busy lately! We had a great time at Technical Airlift, and I am gearing up for the Partner Event (GPCC) and GPUG Summit next week in lovely Tampa, FL. In the meantime, here is a little bit I put together based...
  • SQL Server Composite Primary Key Trivia

    By Steve Endow Coincidentally, after working on a really interesting Dynamics GP SQL Server performance issue earlier this week, I will be having a call tomorrow with another GP partner and GP customer to discuss a different Dynamics GP SQL performance...
  • A most EPIC tale of troubleshooting a Dynamics GP SQL performance issue

    By Steve Endow Today was a very good day. After hours of effort by a team of three consultants, we solved a vexing Dynamics GP SQL performance issue for a client. I'll start with the conclusion and explain why this was such a great achievement. 1...
  • How NOT to develop an eConnect integration: Lesson #29

    By Steve Endow I've come across some really bad Dynamics GP integrations. I had one where the developer made a really pretty user interface with their own company logo and fancy controls and dynamic layout, but the import simply didn't work and...
  • Want to use cloud computing? Make sure and have an exit strategy!

    I had lunch with a friend today who manages internal IT systems for a large film and television media company. He said that he was swamped at work because of an unexpected business crisis: one of his company's cloud storage service providers is going...
  • Another Great Dynamics GP Technical Airlift, in Scenic Fargo!

    By Steve Endow This week Christina and I attended the Technical Airlift 2013 in lovely Fargo. The weather mostly behaved, but varied from 80 degrees and foggy to 45 degrees with some rain. The conference was great, with reviews of the features and enhancements...
  • Technical Airlift Here We Come! SQL Tips and Tricks

    Hopefully we will see some of our ardent followers at the upcoming Microsoft Technical Airlift for Dynamics GP in Fargo, ND later this month. Steve and I are presenting a session on SQL tips and tricks for consultants. Definitely not a developer-oriented...
  • Checking SQL permissions on many SQL Server objects

    By Steve Endow I am working with a Dynamics GP client that is having an odd issue with an ISV solution related to SQL server permissions. The ISV solution is designed to only allow one Dynamics GP login to access its tables and stored procedures--so that...
  • NetSuite vs. Dynamics GP: Navigation: Browser Tabs vs. Application Windows

    By Steve Endow For background, please see my introduction to this series, NetSuite vs. Dynamics GP: A Series If you are familiar with the Dynamics GP client application, you know that you can navigate throughout it much like any other Windows application...
  • Importing Payroll Posting Accounts

    Payroll posting accounts can be fairly straightforward, but for some users the combination of code/department/position can create a seemingly neverending matrix of possibilities- particularly when factoring in the use of ALL for some of the components...
  • Two potential Dynamics GP design limitations for larger or growing companies

    By Steve Endow I recently spoke with a Lawson consulting firm. One of their Lawson customers acquired a company that uses Microsoft Dynamics GP. The Lawson client manages 3 companies in their system, while the GP client manages 9 companies. In Lawson...
  • eConnectException: The stored procedure 'ta______' doesn't exist

    By Steve Endow Tonight a customer e-mailed me saying he was receiving this eConnect error message: eConnectException: The stored procedure 'taPMManualCheck' doesn't exist He was trying to use my AP Payment and Apply Import utility to bring...