Restoring A Database Without Encountering A Locking Issue
I periodically have problems when trying to restore a GP company database over the Test database as SQL reports that the database is currently in use. One way of resolving is to restart the SQL Server but this is only … Continue reading → Read More: Restoring A Database Without Encountering A Locking Issue VN:F [1.9.13_1145]Please wait while your rating is cast...Rating: 0.0/10 (0 votes cast)VN:F [1.9.13_1145]R Read the rest of this entry
February 6, 2012
· 
Ian Grieve · 
No Comments
Tags: apikey, bgimg, bitly, microsoft sql server, notes, shortener, SQL Script, sql server 2008, target, tsql · Posted in: Blogs I Follow Total Views: 2
The Kinect Effect and Kinect Star Wars: Duel
Another off topic post, but one that shows lots of potential for many applications. The Kinect was originally created for use with the Xbox 360, but has now found its way into many other applications. Applications such as optical camouflage, puppetry, robot automation and even real time lightsabers. For more examples go to http://kinecthacks.net/. Anyhow Microsoft have acknowledged the possibility of using the Kin Read the rest of this entry
February 6, 2012
· David Musgrave · No Comments
Tags: Customizations, dynamics, fun, security, Smartlist Builder, support debugging tool, upgrade, windows · Posted in: Blogs I Follow Total Views: 0
What happens with Landed Cost when you perform a Returns Transaction in GP2010?
This question popped up on the Microsoft Dynamics Community today so I thought I’d share the answer here. The new functionality in GP2010 that edits the original PO for a purchase return (or creates a new one if the original is closed) is awesome. Not sure why it took this long to add that functionality but it is what it is. However, there is no facility in the Returns Transaction to reverse the Land Read the rest of this entry
February 5, 2012
· Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: budget, financial, General Ledger, generator, learning, manufacturing, po returns, security, sql server 2008, united-states, utilities · Posted in: Blogs I Follow Total Views: 2
How to change SQL Collation for SQL Server 2008 R2
Have you ever been in a situation where you wanted to change the SQL Collation to match SQL Database Collation?? Last year I have posted a script that resolves this for SQL Server 2005, but the same syntax is not applicable for SQL 2008 R2, while investigating this I found the correct syntax that need to be used as below: “E:SQLsetup.exe” /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SAP Read the rest of this entry
February 4, 2012
· · No Comments
Tags: Analytical Accounting, auto, colleague, Customizations, development, fun, knowledge, sql server, sql server 2008, virtual · Posted in: Blogs I Follow Total Views: 2
Down Under
˙ɐıןɐɹʇsnɐ ɯoɹɟ sıɥʇ buıʇsod ɯɐ ı ˙uǝǝɹɔs ɹnoʎ ɥʇıʍ buoɹʍ buıɥʇou sı ǝɹǝɥʇ ‘ʎɐʞo sʇı More updates to follow once I get accustomed to reading and posting from here. Posted from – Perth, Feb 2012. More: Down Under VN:F [1.9.13_1145]Please wait while your rating is cast...Rating: 0.0/10 (0 votes cast)VN:F [1.9.13_1145]Rating: 0 (from 0 votes) Read the rest of this entry
February 4, 2012
· Jivtesh Singh · No Comments
Tags: Analytical Accounting, Customizations, development, dynamics, extender, georgia, great plains, jivtesh-singh, management, support debugging tool, technology, upgrade · Posted in: Blogs I Follow Total Views: 3
DynamicsGP.me – Support System Launched
DynamicsGP.me team today launched the incident tracking system for Microsoft Dynamics GP & Dynamics RMS with the aim to cater clients with critical issues. The clients can track and follow up with the incidents logged in the system. Please visit the Support System here. Cheers. View article: DynamicsGP.me – Support System Launched VN:F [1.9.13_1145]Please wait while your rating is cast...Rating Read the rest of this entry
February 3, 2012
· Mohammed Feradh Zain · No Comments
Tags: business, downloads, dynamics, launched, microsoft, microsoft-dynamics, palatino-linotype, picture-window, reporting, security, support-system · Posted in: Blogs I Follow Total Views: 8
GL Trial Balance in FRx
For those of us on GP2010, Reporting Services reports provides a nice GL Trial Balance that is easy to export to Excel. For the rest of us, we still have to print the Report Writer version to a text file, open it in Excel, then start the cleanup and reformatting. There is an easier way using FRx. Victoria Yudin has a great article on doing just this here – http://victoriayudin.com/2009/07/17/dynamics-g Read the rest of this entry
February 3, 2012
· Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: accounting, budget, development, dynamics, facebook, frx, General Ledger, GL Trial Balance, houston, Inventory · Posted in: Blogs I Follow Total Views: 10
Microsoft Dynamics Convergence 2012 Houston Sessions
It is now February and Converegence 2012 Houston is happening next month (March 18-21). If you are not registered to attend yet ….. why not? Sign up now click on the image above or the link below Mariano Gomez (The Dynamics GP Blogster) and I will be back to present one session at the GPUG Day One event and two sessions (both repeated) for Convergence. Make sure you come and learn all about the Support De Read the rest of this entry
February 3, 2012
· David Musgrave · No Comments
Tags: conference, Customizations, Dex.ini, Dexterity, dynamics, extender, security, Smartlist Builder, sql server, support debugging tool, upgrade, windows · Posted in: Blogs I Follow Total Views: 4
Accelerated Demos for Microsoft Dynamics GP 2010 and Best Practices When Using Hyper V Web Seminars
Join us in February and March for three powerful web seminars about accelerated demo scenarios specifically for Microsoft Dynamics GP 2010 and best practices when working with Hyper V. The details and registration information are included below for each session. Microsoft Dynamic GP – An Accelerated Demo (Part I)February 2, 2012 at 11:00 AM PacificIf you are seeking ways to shorten your sales cycles, attend the Read the rest of this entry
February 2, 2012
· Errol Schoenfish · No Comments
Tags: dynamics · Posted in: Blogs I Follow Total Views: 7
Change the name of the SQL Server
Sometimes it comes up that we need to change the name of the SQL Server. Below is a quick and dirty checklist on how to accomplish this task. I feel certain there are several iterations of this all over the Internet – now there is one more . 1. Open SQL Server Management Studio and click New Query. 2. Type Select @@ServerName to find out the current server name. In our example, we’ll be changing the ser Read the rest of this entry
February 2, 2012
· Leslie Vail · No Comments
Tags: atom, dallas, extender, house, industry, internet, Inventory, reporting, Smartlist Builder, sql server, united-states, utility · Posted in: Blogs I Follow Total Views: 9