Happy Thanksgiving Wishes for 2010

Just a quick post today to wish our readership a wonderful Thanksgiving holiday.  A time for a get-together with family and friends and (traditionally) eat and eat and eat some more. For those of you out there wondering – Fargo finally has our first snow on Monday.  About 10″ or so and we had our first…

0

Another Dynamics GP Consultant Blog

I am always on the lookout for new blogs about Microsoft Dynamics GP. There are so many users, consultants and partners in the Dynamics GP community with fantastic knowledge and different perspectives on issues and challenges they face. When they make the effort to share that knowledge by writing articles on a blog, it is…

5

Using Barcodes from the Dynamics GP Report Writer

A few months ago, I worked on a support case where we needed to add a barcode to a Sales Order Processing transaction print out.  We were able to achieve what we needed using Visual Basic for Applications (VBA) to handle some of the scripting for us.  I have been meaning to write a blog post on…

11

Dynamics Report Writer is the Best Report Writer in the World

Alright, maybe I am stretching the truth a little, but I do get frustrated when people discount the Dynamics Report Writer as a useful tool. [Edit] I am not biased at all…. honest. I recently worked on a support case where the partner had spent a significant amount of time trying to get Report Writer…

3

Determining Role Access To Extender Objects

An Extender case came up recently where the customer was having security issues with Extender forms. To solve the issue, we needed to determine which Security Roles have access to particular Extender forms. Note: This method uses the DYNAMICS.dbo.EXT00001 table which was added for version 10.0 Service Pack 4 and later. We were able to…

1

Announcing the "Must Attend" Conferences for 2011

It is with great pleasure that I am announcing the “Must Attend” conferences for 2011. You might ask why they are the “Must Attend” conferences… the answer is simple…. I am planning to be there and I would love to meet with the members of our great Dynamics GP community.   Microsoft Dynamics GP Technical…

7

Two New Blogs in Town

It has been a while since I posted about any new blogs, but there are a couple of recent additions to the blogsphere.  Here is a quick post with the links to the blogs. Please go and have a look.   Todd McDaniel has created “a blog dedicated to the wholesale distribution industry with an emphasis…

1

File not found: VBA6.dll error occurs or GP crashes

This is a follow up to my previous post on the VBA6.dll not found error (for 64-bit). I have found this can occur on 32-bit computers and Microsoft Dynamics GP 10.0 and GP 2010. [Edit] Re-installing the VBA 6.4 core components (as used by Dynamics GP) has been shown to resolve this issue for VBA6.DLL, VBE.DLL, VBA7.DLL…

10

Procedure or function ‘aagCreateGLWorkDist’ expects parameter ‘@LedgerID’, which was not supplied

A number of support cases have popped up recently with this error message, it can occur when using eConnect to integrate General Ledger transactions or when using the eConnect Adaptor for General Ledger transactions from Integration Manager. Vaidy Mohan has some details in his post: GL With AA – IM2010 Integration – aagCreateGLWorkDist Error Message. The LedgerID…

0

Changing the Phone Number Format

One of the most common customisations outside of North America is changing the Phone Number Format.  The North American default format of (XXX) XXX-XXXX  Ext. XXXX is not always suitable for other countries. For example: Australia, Singapore and Malaysia now use a domestic format of a 2 digit area code and a 8 digit phone…

10

Login Performance Issue for Microsoft Dynamics GP 10.0 SP5 and GP 2010 SP1

It has been brought to my notice that we have another issue with a dictionary adding records to the syMenuMstr (SY07110) table each time a user logs into Microsoft Dynamics GP.  This issue is caused by the new Dynamics Online Services dictionary which was installed as part of Microsoft Dynamics GP 10.0 Service Pack 5 and Microsoft Dynamics…

8

Dexterity: Cannot See Table Buffer Values in 10.0 SP5 or 2010 SP1

A long standing pain point for ISV’s has been the inability to see 3rd party table buffers while debugging ISV code in runtime. Most development – I assume – is in test mode where your customization and Dynamics are on a level playing field and the ISV can see anything they like easily. However for…

1

Why does Microsoft Dynamics GP 10.0 and later use a Data Folder?

I recently responded on a forum post which asked why the paths for the custom forms and reports dictionaries in the Dynamics.set launch file where pointing to the Data folder. The post also asked why the application did not complain about the fact that the dictionaries listed in the Dynamics.set did not actually exist in the Data…

2

Backing up and Restoring data when recreating SQL Tables

Added to the Useful SQL Scripts Series. There are times when you need to recreate a table to change its structure but don’t want to lose the data stored in the table.  I have had this situation a number of times when working on upgrade support cases where (for some unknown reason) a table does…

3