Great Plains Guy

Nice article on creating Macros in Dynamics GP!

http://www.dynamicscare.com/blog/index.php/macros-in-dynamics-gp/

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/

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!

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!

Couldn't make it to WPC? Check it out!

http://hub.digitalwpc.com/

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.