View Wizard
HelpID: 460022020
The View Wizard is a tool for generating SQL Views of Dynamics GP tables where the column names are “human readable”. For example, a view of the Item Master table would contain a field called “ItemTrackingOption” rather than ITMTRKOP.
Use View Wizard to create views for end-user reporting.
It can also be used to create views which are then used in queries to build a more complex view for SmartList Builder. Since View Wizard views have human readable column names, your SmartLists will then also have readable column names.
Navigation: Tools >> Utilities >> System >> View Wizard
Product: Select a Product (such as Manufacturing)
Series: Select a Series (such as 3rd Party or Inventory).
The Tables list will populate. Columns can be sorted by clicking on the Column Header.
Select a table by double-clicking on it.
This will automatically generate a suggested View Name. The system verifies that the view name does not already exist in the database. If it does, you will be prompted to overwrite it, or keep the existing view.
Select fields from the Available Fields list to include in your view.
Click the CREATE VIEW button. The view will be created, and security granted to DYNGRP.