|
|
Collection of Useful Microsoft Dynamics GP Sql Scripts, Tips and Tricks
How to query ms dynamics database
Long Description:
To determine the tables you need to run query statements on, just go to:
1. On main menu, click Tools - Resource Descriptions - Tables
2. Click the tables lookup icon
3. On "Product" pulldown menu, select "Microsoft Dynamics GP"
4. On "Series" pulldown menu, select a group - either:
Financial, Sales, Purchasing, Inventory, Payroll, Project, System, Company, Online Documentation, 3rd Party, Payroll Tax, Pathname, Design Document, Dexterity, Dexterity System, or Report Writer
5. If you know the table name, you can also use the "Find" button.
6. Click "Print"
7. Using the report, the "Physical Name" column will give you the actual physical column names.
|
IMPORTANT:
Commands with UPDATE, DELETE or DROP can ruin your data! Please use these queries with caution.
We highly recommend that you backup your database before trying out these commands and to load them up first on a test server. Use at your own risk.
Associated SQL Command:
Viewed: 2921 times
Submitted by:
Robert
|
Did you find this script useful?
Please reciprocate by submitting your own script
or any proven advice regarding Dynamics GP use. Click here.
Send the script above to a friend
|
|
|
|
