Purchase Order Returns Modification

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This post is a public service announcement for those customers and partners using the free customization from Microsoft, Purchase Order Returns Modification (Product ID: 4159) for Microsoft Dynamics GP versions 9.0 and 10.0.

Note: The functionality of this customization has been incorporated into the core Dynamics.dic dictionary for Microsoft Dynamics GP 2010 and so is no longer required.

Continue reading

Workstation Level Settings Lost during Upgrade

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

When upgrading Microsoft Dynamics GP, it is quite common to get one client (often on the SQL Server) updated first and then update the system and company databases using Dynamics GP Utilities. The final step is then to go around the various workstations and upgrade the client application on those machines.

Continue reading

Where has my Microsoft Dynamics GP window gone?

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

The technique I will discuss in this post is not specific for Microsoft Dynamics GP, but as this is a Microsoft Dynamics GP related blog, I will put a GP “spin” on it.

Since the user interface change from MDI (Multiple Document Interface) to SDI (Single Document Interface) for version 10.0 of GP (see Version 10.0 and its individual windows), we now have a situation that can occur when a window can open outside of the visible area of your windows desktop.

Continue reading

Why making the Dex.ini file read only is evil

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Time and time again I have heard consultants say that the solution to stopping Microsoft Dynamics GP remembering the last user on a Terminal Server or Citrix installation is to make the Dex.ini file read-only.  There was even a Knowledge Base (KB) article that suggested clearing the SQLLastUser setting from the Dex.ini file and then marking the file as read-only.  Well, in my opinion this method has always been evil and from Microsoft Dynamics GP 10.0 onwards will not work anyhow.

Continue reading

Users (other than ‘sa’) unable to login after upgrade

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

A couple of nights ago, my friend Sivakumar Venkataraman (Siva) pinged me on Messenger about an issue he was having.  He was in the process of upgrading a customer’s site from Microsoft Business Solutions – Great Plains 8.0 to Microsoft Dynamics GP 10.0, and after the upgrade none of the users were able to log into Dynamics GP. The only exception was the ‘sa’ user.

My first thought was … Security.

Continue reading

Dynamics GP Lists: Exports slowly to Excel

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

Breaking with my recent series on Smartlist and specifically the Smartlist: Exports slowly to Excel – Part 1 post, a comment and followup question to that post was:

This is great!  But is there a similar switch for the Dynamics GP lists such as the “All Sales Transactions” or “Accounts” list?

Good question and honestly I did wonder about that myself.  But it was outside my “all things Smartlist” topic so I figured I’d check it out later.

Now that it came up – today looks like “later” so I thought I’d dig into it.

Continue reading

Smartlist: Exports slowly to Excel – Part 2

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

This is the 4th post in a series of Smartlist posts in the last weeks.  In these articles, I’ve given answers and solutions to common questions about Smartlist that are typically of the “Why doesn’t Smartlist..?” variety.

Last week, the question we were looking at was:

Continue reading

Smartlist: Exports slowly to Excel – Part 1

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

In the last few weeks (here and here), I’ve enumerated several questions that I’ve been asked and have seen posted to the public Dynamics GP newsgroups.  These questions are typically of the “Why doesn’t Smartlist..?” variety.

In this post and a few planned future posts, I’ll look at each of these questions individually and give a few thoughts around them and maybe a few solutions as well.

Continue reading

Testing Date Driven Features in GP

Alice Newsam - Click for blog homepageThis is a reposting of an article Alice Newsam originally wrote on my Developing for Dynamics GP blog.

Have you ever had a piece of functionality that is date driven that you wanted to automate a test for but couldn’t figure out the best way to control the dates in the system?  Then this post will be very helpful for you!  A common area I receive questions on when talking with partners and customers is around automating features such as MRP which is extremely date driven.  This post is going to cover settings in the Dex.ini and Keys.ini files that will help you set the system to specific dates and times.

Continue reading

Dexterity Chunk file wouldn’t merge

Dave Dusek - Click for blog homepageThis is a reposting of an article Dave Dusek originally wrote on my Developing for Dynamics GP blog.

This blog post is about a Dexterity support incident that I recently had that ended up to be more difficult than I originally thought.  This one should have been easy, when a chunk doesn’t merge, it’s usually always easy.  Except this case.  The background is the following.

Continue reading

Copying Record Notes and OLE Attachments between Companies

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Following on from last week’s post on OLE Attachments and Record Notes, I can now get to the reason for the interest in notes and OLE attachments.

The partner was trying to copy master records for Vendors from one company to a new company.  They wanted to use SmartList to export the Vendor data out of the source company and then use Integration Manager to bring the data into the target company.  The problem was how to handle the record notes that may be attached and how to handle the OLE attachments if they existed.

Continue reading

OLE Attachments and Record Notes

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

While working on a recent support case, I was asked again about how Notes work and in particular the OLE attachments.  In the previous post, Understanding Notes and the Note Index field, we discussed where the next Note Index value comes from. In this post, we will discuss how the record notes are created and where the OLE attachments are stored.

Continue reading

Installing the Support Debugging Tool for Microsoft Dynamics GP FAQ

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (http://winthropdc.com/GPPT)

I have been asked a few times recently about installing the Support Debugging Tool for Microsoft Dynamics GP on a live system.  This post covers some of the Frequently Asked Questions about installing the tool.

Continue reading

Any Font in the Dexterity Script Editor

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

Aren’t secrets fun?  And while having a secret is fun in and of itself, it is also fun to share them from time to time (and allowed to share them).

The secret today is an undocumented feature that I believe was added to 10.0 SP2.  As an undocumented feature, this means:

  • It might not work for you
  • It might cause “issues”
  • Don’t ask support about it if it causes “issues”
  • Might not work in the future

That said:

  • I can’t see why it wouldn’t work
  • I don’t see what issues it would cause and is completely reversible

Continue reading

Dexterity: Creating custom ini files

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

One question that I’ve been asked a few times in the past has been – “Can I read/write to other sections of the Dex.ini other than the [General] section with Dexterity?”.

Here I presume the questioner would like to have their own section of the dex.ini file to write their own application settings instead of mixing them into the settings that Dynamics GP uses.

Continue reading

All about the Dexterity OLE Container

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Over the years, the question of how to interact with the Microsoft Dynamics GP OLE Notes from outside the application has been raised many times.

I have responded to newsgroup posts with information that would hopefully lead the developers in the right direction.

Continue reading