Application – Page 19 – Winthrop Development Consultants Blog

Developing For Dynamics GP

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

Jun 15, 2010 Tagged with Application, Blogsphere, Dex.ini, Encryption, Passwords, SQL, Upgrade 3 Comments

This 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.

Developing For Dynamics GP

Why can’t I maximize my window?

Jun 6, 2010 Tagged with Application, VBA 6 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

A recent support case asked “Why can’t I maximise my Payable Transaction Entry Distribution window?”. This worked for versions 8.0 and 9.0 but does not work for version 10.0 and GP 2010 (v11.0). What has changed?

Everything. Well … lots in the way windows in the Microsoft Dynamics GP application are handled.

Developing For Dynamics GP

Modifying Microsoft Dynamics GP 2010 Word Templates

May 30, 2010 Tagged with Application, GP 2010, Report Writer, Word Templates 27 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Microsoft Dynamics GP 2010 added some very cool functionality to the product which allows reports to be generated in Microsoft Word. It is perfect for creating custom layouts with logos and graphics for Sale Order Processing (SOP) and Purchase Order Processing (POP) documents.

Developing For Dynamics GP

Dynamics GP Lists: Exports slowly to Excel

May 27, 2010 Tagged with Application, Dex.ini, NDM, Patrick Roth, Performance 4 Comments

This 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.

Developing For Dynamics GP

Microsoft Dynamics GP Application Password System

May 25, 2010 Tagged with Application, Blogsphere, News, Security No Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Wow, what a weekend that was! Now that the MSDN & Technet blogs are back online, I have written a summary post of the weekend’s activities on the blogsphere.

Developing For Dynamics GP

Recurring Transactions and Record Notes

May 19, 2010 Tagged with Application, Marian Verzosa, NDM, Support Debugging Tool 1 Comment

This is a reposting of an article Marian Verzosa originally wrote on my Developing for Dynamics GP blog.

Hi, my name is Marian Verzosa and I work with David Musgrave in the Asia Pacific support team.

I wanted to share with you a recent support incident that I worked on.

Developing For Dynamics GP

Smartlist: Exports slowly to Excel – Part 1

May 13, 2010 Tagged with Application, Dex.ini, NDM, Patrick Roth, Performance, Smartlist 32 Comments

This 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.

Developing For Dynamics GP

Unexplained Temp Table Errors

Apr 20, 2010 Tagged with Allan Cahill, Application, Exception, NDM 10 Comments

This is a reposting of an article Allan Cahill originally wrote on my Developing for Dynamics GP blog.

Hi, my name is Allan Cahill (pronounced “Carl”) and I work with David Musgrave in the Asia Pacific support team and I wanted to share the experiences I had working on a recent incident.

Developing For Dynamics GP

POP Distributions randomly being deleted

Apr 8, 2010 Tagged with Application, Dexterity, NDM, Patrick Roth, SmartList Builder, Support Debugging Tool No Comments

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

So many interesting cases, so little time to talk about them.

My interesting case this week is the mystery of the deleted POP Distributions.

The ISV had a customer where all of the distribution records in the POP10390 were being randomly deleted. They had been trying to track this down for weeks and with the help of the Support Debugging Tool was able to capture a script.log of this happening.

Developing For Dynamics GP

Revisiting: “Welcome to Dynamics”

Mar 30, 2010 Tagged with Application, Fun, History 7 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This post has me revisiting a post from the past with an update.

While working on a performance case recently, I was analysing a Process Monitor log and noticed something interesting. In the log there was an attempt to reference a GPSSystemStart.wav file in the Windows folder with the result failing with NOT_FOUND. I decided to investigate further….

Developing For Dynamics GP

Microsoft Dynamics GP Architectural Foundations Series

Mar 29, 2010 Tagged with Application, Blogsphere, Dexterity No Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

My good friend and co-presenter, the Dynamics GP Blogster himself, Mariano Gomez has managed to organise a fantastic series of posts about the architecture of Microsoft Dynamics GP

Developing For Dynamics GP

SmartList Shows Duplicate Year End Journal Entry Distributions

Mar 7, 2010 Tagged with Application, Exception, SQL 10 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I have had two support cases with this issue recently. So I thought I would post an explanation of the problem along with a script to fix it. The good news is that the underlying cause of the issue has been fixed in Microsoft Dynamics GP 2010 (v11.00).

Developing For Dynamics GP

Differentiating Companies in Microsoft Dynamics GP

Mar 2, 2010 Tagged with Application, Support Debugging Tool 9 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

One issue that I have seen cause much pain in the past is entering data into the wrong company. This could be entering a day’s worth of transactions into the test company instead of the live company, or entering data into the wrong subsidiary company for a multinational corporation. Whatever the actual circumstances are, the solution is always a lot of hard work. You either have to re-enter the data manually or try various means to extract the information entered and reverse it in one company and import it into the other company.

So … wouldn’t help the end user if there was a obvious visual cue to differentiate the different companies in a Microsoft Dynamics GP system.

Developing For Dynamics GP

Removing Extender Data when deleting Transactions or Lines Revisited

Feb 9, 2010 Tagged with Application, Extender, SQL 1 Comment

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Last week, I tackled the subject of orphaned records in the Extender tables when the parent records were deleted and the Extender data was left behind. If you have not read this post the link is below:

Removing Extender Data when deleting Transactions or Lines

Developing For Dynamics GP

Fixing missing Note Index values

Feb 4, 2010 Tagged with Application, Exception, Notes & OLE Attachments, SQL 13 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

A recent newsgroup post asked about how to fix the error message shown below from occurring when clicking the Attach button on the Note window for a record level note.

“The note ID has not been set.”

Developing For Dynamics GP

Removing Extender Data when deleting Transactions or Lines

Jan 26, 2010 Tagged with ADO, Application, Extender, SQL, VBA 8 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I was recently asked to assist a colleague with an Extender case. The problem was that Extender data was not being removed from the Extender SQL tables when its parent record was deleted.

Developing For Dynamics GP

Increasing the Microsoft Dynamics GP 10.0 Homepage Font Size

Jan 24, 2010 Tagged with Application, Customizations 8 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I was recently asked if it was possible to change the fonts on the Microsoft Dynamics GP 10.0 Homepage. A customer had asked if they could be made a little bit bigger as they were hard to read at the resolution that the machine was running at.

Developing For Dynamics GP

Do we really want Windows Authentication for Microsoft Dynamics GP?

Dec 8, 2009 Tagged with Application, Encryption, Passwords, Security, SQL 23 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Over the years, I have seen many requests for Windows Authentication support for Microsoft Dynamics GP, and I have to say I have mixed feelings about it. In theory, it sounds good, but in practice it may be a threat to your customer’s financial information security.

Regardless of authentication method, users will still have to select a company to access which defeats the purpose of having a single sign-on.

Developing For Dynamics GP

What is the A4 Chunk?

Dec 6, 2009 Tagged with APAC, Application, Dexterity, Report Writer 6 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Recently on the newsgroups, I responded to two separate questions on the same day asking about handling A4 size paper with Microsoft Dynamics GP. So I thought a post about the A4 chunk would be helpful.

Developing For Dynamics GP

More on Windows 7, bitmap fonts and DPI settings

Dec 1, 2009 Tagged with Application, Fonts, Windows 7 9 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This post is a follow up to the previous post on the topic which discussed how you can use the registry editor to adjust the font files used for bitmap fonts to restore them to the default 100% DPI size. If you have not read the previous post, please use the link below:

Windows 7, bitmap fonts and Microsoft Dynamics GP