Tuesday, November 24, 2009
Interesting article on all the Dynamics Products, who uses what and why!

http://www.softwareadvice.com/articles/manufacturing/understanding-the-difference-between-gp-nav-sl-ax-1111709/
Wednesday, September 2, 2009
Nice article on creating Macros in Dynamics GP!

http://www.dynamicscare.com/blog/index.php/macros-in-dynamics-gp/
Monday, August 31, 2009
I've become a bit spoiled. Always finding great nuggets of data in people's blogs (like MVP Victoria Yudin's - see my previous post), I tend to forget to RTFM.

I just revisited an old friend, the Great Plains SDK, which is chock full of good info that I didn't even have to google bing for!

Download the GP SDK yourself and get tons of Dynamics GP technical info for the low, low price of FREE!

http://www.microsoft.com/downloads/thankyou.aspx?familyId=16d5bcea-c965-4f9a-a965-f4a81b0dd564&displayLang=en
Check out this great blog article by fellow MVP Victoria Yudin on the Sales Order Processing Tables. (I've used it myself multiple times, I guess it was about time I shared the link!)

http://victoriayudin.com/gp-reports/sop-tables/
Sunday, August 23, 2009
ApexSQl, maker of a number of fine SQL tools, is giving away their SQL Code tool for free!

http://www.apexsql.com/blog/2009/03/free-code-generator-apex-sql-code.htm

Don't know how long this will last!
Thursday, July 16, 2009
I did not know about this. Dang!

https://community.dynamics.com/blogs/gpmarianogomez/archive/2009/07/07/microsoft-dynamics-gp-database-maintenance-utility.aspx

Great utility from MS to recreate GP objects.

Thanks for the detailed write up, Mariano!
Wednesday, July 15, 2009
Couldn't make it to WPC? Check it out!

http://hub.digitalwpc.com/
Tuesday, July 14, 2009
I was looking for SmartList tables in SQL so that I could restore some SmartLists that someone accidentally deleted. Here's what I came up with:

ASITAB20 -- empty for me
ASIEXP51 -- seems to hold SmartList exports, empty for me
ASIEXP81
ASIEXP83
ASIEXP86

After restoring a copy of my company db to my UA box, I copied missing rows from my UA server from these 5 tables back into my production servers tables and that did the trick!

I did a simple insert for each one (even though the first two tables didn't have any missing rows), like so:


SET IDENTITY_INSERT ASIEXP81 ON
INSERT INTO ASIEXP81
(ASI_Favorite_Dict_ID, ..., DEX_ROW_ID)
SELECT *
FROM [UA].DYNAMICS.dbo.ASIEXP81
WHERE DEX_ROW_ID NOT IN
(
  SELECT DEX_ROW_ID
  FROM DYNAMICS.dbo.ASIEXP81
)
SET IDENTITY_INSERT ASIEXP81 OFF


FYI, I ran this code on my production server and had my UA server set up as a linked server.
Check it out! You can attend the Dynamics GP conference that you thought you missed!

Lots of free content! Pay money if you want more, but I think the 50 Tips in 50 Minutes presentation (which is one of the free samples) is worth the time to click it!

http://vepexp.microsoft.com/convergence09
Stumbled across this little gem of an article when trouble-shooting my inventory costs. Very enlightening stuff!


http://www.pinncorp.com/LinkClick.aspx?fileticket=Q1hwsoTQRlA%3D&tabid=452&mid=3482
Monday, June 29, 2009

http://blogs.msdn.com/gp/archive/2009/06/27/week-3-did-you-know-series-of-the-week.aspx

Wednesday, June 17, 2009
MVP David Patrick-Dynamics GP
MVP David Patrick-Dynamics GP
Thursday, May 21, 2009
How do I leave feedback for Dynamics GP? Check this article out:

http://blogs.msdn.com/gp/archive/2009/05/19/ever-wonder-where-your-product-feedback-goes.aspx
Thursday, April 16, 2009
Ever wanted to see who was in a windows group?

As a SQL DBA, I used to be able to see this kind of information using SQL 2000, but that part of the GUI got left behind in SQL 2005/2008, however, there is a stored procedure that you can use to see this information:

xp_logininfo 'BUILTIN\Administrators', 'members'

This lists all the users who belong to a given group, in this example, it lists the members of the Administrators group, good stuff to know if you need to know just who can administer the SQL box that your Dynamics GP / Great Plains is running on!
Thursday, April 2, 2009
If you ever move your Great Plains databases from one server to another, make sure you do the following:

use master
go
GRANT EXEC ON smDEX_Max_Char TO PUBLIC
GRANT EXEC ON smDEX_Build_Locks TO PUBLIC


I've been burned more than once by forgetting these. Without them, you can't login and you'll pull your hair out because everything looks right (and indeed is right!) security setup-wise.

Having trouble logging in after a server move? Try this and see if it helps!
For all you local SharePoint guys and gals out there!

http://www.sharepointsaturday.org/dc/Pages/about.aspx
Wednesday, March 25, 2009
Not exactly a Great Plains specific event, but definitely something for Microsoft Developer's to check out:

https://www.msfttechdays.com/public/home.aspx

TechDays is a free, one day (24 hour), live virtual conference/event. It's on the web, so its in your region! Sign up and build your schedule already. Don't worry, you don't have to attend the whole 24 hours (except you hard core devs, you know who you are). Did I mention that it's free?
Monday, March 16, 2009
http://msdynamicsgp.blogspot.com/2009/03/convergence-2009-50-tips-in-50-minutes.html
Friday, March 6, 2009
Check out the new OFFICIAL blog of Dynamics Great Plains called Inside Microsoft Dynamics GP!

http://blogs.msdn.com/gp/

Since this is straight from the horse's mouth, this blog should be a great source of official information right from the guys at MS!
Friday, February 13, 2009
Convergence 2009 New Orleans is just around the corner!

Don't miss the must attend event for all Great Plains professionals!

· The session catalog (containing 225 sessions) is now live on the Convergence marketing site.
· The Convergence Customer Excellence Awards recognize, honor and celebrate customers who have achieved outstanding success with their Microsoft solutions as well as Microsoft partners' solutions. Customer Excellence Award nominations are now being accepted through January 20, 2009.

Check out these 6 reasons why you should go!

http://www.microsoft.com/dynamics/convergence/neworleans09/about_6reasonstoattend.aspx
Wednesday, January 28, 2009
Here's some quick information on how Forecaster stores application connections.

I'm running Forecaster 7.0 under Citrix and we ran into an issue where any new application connections that we're being created weren't being saved. It turns out that these connections are stored thusly:

T:\Documents and Settings\\Local Settings\Application Data\Microsoft\Forecaster\Forecaster.ini
(where T: is our system drive letter under Citrix).

The contents of Forecaster.ini are pretty straight forward, here's an example entry:

[Applications]
0=Demo
[Demo]
FileName=T:\Program Files\Microsoft Forecaster 7.0\Demo70.mdb

We're getting around the fact that Citrix cleans up this file on logoff (thus erasing any newly created application connections) by using a batch file to copy this file to and from the user's home drive during logon and logoff.

I hope this helps with anyone needing make sure these entries get saved or if they need to be moved (or copied or whatever)!


Tuesday, January 27, 2009
Take Great Plains for a try out virtually!

https://dynamicsgptestdrive.com/content.aspx


Thursday, January 22, 2009
Found this great video covering various tools available for customizing your Great Plains install!



You ever want to know how to do something? You don't want the why or a bunch of "fluff" about the architechure, you just want to know where to click to make things happen. I find that "How To" Videos can really help out in this situation! 

I was pleasantly surprised to find a bunch of these "How To" videos posted up on YouTube! Who would have thunk it? I thought YouTube was only for music videos and RickRolling! Well, come to find out, many reputeable companies are using YouTube to post all sorts of educational videos. 

For "How To" Video's in the Great Plains world, check out this link:

This is the YouTube homepage (aka channel) of our friend from DynamicAccouting.Net, Mark Polino. It's pure gold when it comes to finding out the how to do a specific thing in GP!


If it turns out that you are after more of the "why" type info (and I guess we do that need, too, eventually), try this YouTube channel:


or this one, from Microsoft:



Happy Video Watching!



Friday, January 9, 2009
Found this little gem, a great quick reference for Great Plains 10 Table Names!

http://www.box.net/shared/jc90kdsh2k

And more great downloads here:

http://msdynamicsgp.blogspot.com/2005/09/gp-downloads.html

Thanks to Mark Polino and the guys from from DynamicAccounting.net!
Monday, January 5, 2009
I found this bit of SQL while reviewing a trace of Great Plains acitivity:

SELECT desSPRkmhBBCreh FROM

and I was wondering what the heck the column desSPRkmhBBCreh was, as it wasn't in any tables that I could find.

Then I found this gem:

http://blogs.msdn.com/developingfordynamicsgp/archive/2008/10/15/what-is-column-dessprkmhbbcreh.aspx

Ah ha! It's all so clear now.... :-)
Sunday, January 4, 2009
So here's something I didn't know (among many things!), adding the text <TEST> to the end of a company name in Great Plains causes a pop up message to appear when a user first logs into the sysetem. The message warns the user that they are in a test system and not to put in any real data. Here's the actual pop up:







This is especially useful in my QA and Dev environments, since I occasionally have real end users in there testing new features.



Pretty cool trick!