Great Plains Guy

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.

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