Overview
Consulting Toolkit is a collection of utilities for Dynamics GP. It consists of three core modules and several free tools.
Core Modules:
- Stored Queries – This tool allows creating and saving pre-defined SQL queries that can be executed by an end-user through the Execute Stored Query window. The Execute Stored Query window allows the user to pick a Stored Query from a list and execute it but does not allow making changes to the query. This tool allows you to create ad hoc queries that can be easily and securely executed by an end without them having to use Query Analyzer.
- Virtual Triggers – This utility provides the ability to add small code changes to Dynamics GP. This tool is NOT intended for end users. It requires advanced Dexterity programming skills to use this window. It provides WilloWare with an inexpensive way to quickly provide customers with custom programming functionality without the need to install custom code. Please contact WilloWare for programming services when purchasing Virtual Triggers.
- GP Report Extender – This tool makes it easy to add information to GP Report Writer reports where the data comes from a table that is not linked to the report.
Free Tools:
- SQL Database Manager – an “Enterprise Manager” or “SQL Management Studio” type tool for exploring the SQL Server. It provides read-only access to the properties of the server, databases, tables, views and stored procedures.
- Trace – a “SQL Profiler” type tool for tracing the communication between the GP client and the SQL server
- SQL Query – a “Query Analyzer” type tool to creating, saving, and executing ad-hoc tSQL queries.
- Finder – a search tool for locating all tables that contain a particular user entered value.
- Resource Explorer – a search tool for locating Dexterity product information about a field, window, table, or report.
- View Wizard – a tool for creating SQL views using the Dexterity “descriptive names” for column names.