That's right, this site is all Dynamics GP, all the time. If you spend time with Microsoft's Dynamics GP ERP software, then this is the place for you.
Syndicated From:
http://msdynamicsgp.blogspot.com/ Browse by Tags
All Tags » SQL ( RSS)
-
|
David Musgrave looks at fixing Note Index values in Dynamics GP. Missing Note Indexes typically result from data imports that didn't include the index values. David looks at causes, fixes and a SQL script to help fix the problem.
|
-
|
In Touch with Dynamics GP has a new post up on comparing data in two SQL tables for Dynamics GP.
|
-
|
Coincidentally, SQL Saturday , a free day of SQL Server training, is going on in Atlanta on April 24, 2010. This is the first day of Convergence 2010 and it means that there is going to be ton of great training going on at the same time.
|
-
|
We see a surprising number of huge transaction logs in clients who should know better. This commonly happens when transaction logs are not being backed up regularly and the database is running in Full recovery mode. If the log grows large enough, SQL...
|
-
|
Mohammad Daoud points us to a great Microsoft Support article on Stopping Unexpected Transaction Log Growth in SQL Server . I still see an awful lot of this in IT departments that should know better.
|
-
|
In the newsgroup Victoria Yudin provided SQL code to get the YTD account balance for an account in the GL. This is useful when building reporting using Excel or other outside reporting tools.
|
-
|
For those of you using SSRS with Dynamics GP, SQLServerCenteral.com has a new article up with tips and tricks when using expressions in SSRS. There a lot of date related help in here as well.
|
-
|
In case you missed it, GP has an optional program on the CD called the Support Administrator Console. Essentially, this a SQL Query Analyzer type application done in a GP style. It doesn't use the GP encrypted logins, only a regular SQL login. This...
|
-
|
Mariano Gomez took a break from his long Thanksgiving weekend to post a SQL Script to get the most recent inventory receipt information along with more information about on hand inventory.
|
-
|
Frank Hamelly gets a little technical with his latest tip as he looks at some great new features in SQL 2008 and SSRS.
|
-
|
Dynamics GP 9 and 10 allow you to schedule backups from within the application. You'll need to be logged in to GP as an administrator and you'll need to be on the server. Go to File-Backup. Enter the system password if you've set one. The...
|
-
|
Somehow I missed this October post from Duke Del Prado where he provides SQL code to show customers with more than one address.
|
-
|
Leslie Vail has coverage of the Database Maintenance Utility for Dynamics GP over at Dynamics Confessor.
|
-
|
For those GP Admins wanting to dig deeper into SQL Server, MSSQL Tips has a great article up on reading graphical query execution plans from SQL Server. The article is very detailed with lots of screen shots and explanations of each element.
|
-
|
Mohammad Daoud has a new post up with coverage of how to use the Rapid Implementation tool to export, copy and backup setup between companies.
|
-
|
Doing data validation, database compares and other queries in SQL Server is a pretty common occurrence when working with Dynamics GP, especially during implementation. Often this involves running a SQL query in Management Studio and pasting the results...
|
-
|
David Musgrave continues his series on OLE attachments and Notes by looking at how to copy them between companies.
|
-
|
Steve Endow of Dynamics GP Land fame has a great new article up on Using and Debugging SQL Triggers with Dynamics GP. He posted it on Saturday so now we know what Steve does with his weekends!
|
-
|
David Musgrave has a great post up at Developing for Dynamics GP where he looks at OLE Attachments and Record Notes i n Dynamics GP. I'm still catching up from a busy weekend so this is catchup day. Great job David!
|
-
|
Frank Hamelly's tip yesterday contained a SQL script to set all posting journals to print to screen. Check out Frank's site for the script.
|
-
|
Dave Dusek has a great post up on slowdowns they were seeing using VS Tools for Dynamics GP and the troubleshooting steps and results they went through to attack the issue.
|
-
|
New from Victoria Yudin is a SQL view for all posted payables payments in Dynamics GP. I love all of these little SQL nuggets. They make things so much faster when you actually need a view like this.
|
-
|
Victoria Yudin has a great new post up with SQL code to show all unapplied Receivables transactions in Dynamics GP.
|
-
|
The My Reports section of the GP home page does a pretty good job of cleaning up after itself. If you create a report option, add it to the my reports section and then delete the report you should end up with an orphaned link. However, Dynamics GP cleans...
|
-
|
New from the DynamicsBlogger is nice post on using Microsoft Dynamics GP on a Cluster Environment.
|
More Posts Next page »
|
|
|
|
|
|
|