Tips & Tricks Dynamics GP

To restore a full backup of the Company database or the DYNAMICS database, follow the appropriate steps.   Using Microsoft SQL Server 2000 1. Click Start , point to All Programs , point to Microsoft SQL Server , and then click Enterprise Manager . 2. In the navigation pane, expand Microsoft SQL Servers, expand SQL Server Group, expand (local) (Windows NT), and then expand Database. 3. Right-click the database that you want to restore, click All Tasks , and then click Restore Database . 4. In the Restore as database box, select the database that you want to restore. 5. In the Restore area, click From device . 6. In the Parameters area, click Select Devices to open the Choose Restore Devices dialog box, and then click Add . 7. Click the File name field lookup (…) button, and then select the backup file of the dat

If you have SmartList Builder and GP 2010, you have access to a new feature called Navigation List Builder.  This tool enables you to create your own lists that appear on the Navigation Pane.  What are navigation lists, and why would you want to create your own?  Let’s look at an example of a navigation list that’s a standard option with GP for viewing sales documents. Click the Sales button on the Navigation Pane. Click “Sales Order Transactions” in the Shortcut Bar. You can filter this list and save your filter as a favorite. For example, you can filter the list to display only invoices and exclude historic invoices. The only problem you may have is that the system can be slow to display your data. Using Navigation List Builder, you can create a list that automatically displays just the data you want and the columns you want. Go to Microsoft Dynamics GP menu >> Tools >> SmartList Builder >> Navigation List Builder. Enter List ID, List Name and Navigation Pane op

If you are current on your annual maintenance and have not yet upgraded to Dynamics GP 2010, it’s time to think about taking advantage of your maintenance benefits. While every company is unique and may have specific reasons for not upgrading, you may want to consider getting current. By staying current, upgrading to future versions will be simpler. Why would you want to upgrade to GP 2010? There are several improvements and new features in GP 2010, even for those companies using GP 10. Here are 10 reasons you may want to consider upgrading to GP 2010, including: 1.     Deliver faster access to personalized insight – You no longer have to give users full access to GP for them to get information from the system. With role centers, you can give users personalized dashboards and KPIs with drill-back capabilities. You also can view GP data on a variety of devices and applications. 2.     Get more out of Excel integration – Imagine being able to open an Excel file and have up-to

By default, the work drive path is set to the temp directory for the current user (as defined by the TEMP environment variable), but it can be changed for each user. If the user's TEMP environment variable contains an invalid path, or if the path specified was removed, this error will occur.   The Optional Work Drive is a directory used by FRx while building GL index files or reports. Once the index or report has been built, FRx moves the file to its proper location.   The path may be changed by using either of the following methods: From within the FRx Designer: On the Admin menu,click Processing Options.Click thearrow in the Optional Work Drive box.Browse to the desired path. Click OK. Close Designer, and then open it again - the error should no longer occur. From the FRX.INI file: Click the Start button, then click Run. Type frx.ini, and then click OK - the file should open in Notepad. Locate the [Network] section. Change the value on the WorkDrive line to a val