Published by ERP SPECIALISTS, INC.

Other products by ERP SPECIALISTS, INC.


This useful tool will allow you to create and build a Customized Pane for SYSPRO 6.1 that contains the contents of any SQL Query or SQL View.


Version: 1.0

This application tutorial and tool will show you how to quickly add any SQL View or SQL query to a text file and build a customized pane in SYSPRO. 

Using the text files and examples provided you will quickly and easily add SQL data queries and show them as a Customized Pane in SYSPRO.  This will have all the functionality and features of a standard SYSPRO ListView Pane. You can sort columns, filter, search, total and sub-total, export to excel, and much more.

Unlimited uses and applications
The text file can be re-used over and over delivering many possibilities to expose data. Look at Sales Orders daily (sort by status, date, customer, stock code); view WIP Jobs, the options are limitless.

Report DashBoards
Convert all your regular reports to customized panes and have the advantage of accurate and up-to-date information without having to generate time-consuming paper reports, pdf copies and emails.

SQL Server 2005 or later.

It is expected that the User has sufficient knowledge of the following:

  1. Understand and can maintain SQL Server 2005/2008 Login and Security settings.
  2. SQL Server 2005/2008 skills in creating and saving SQL Queries and Views.
  3. Importing and Re-positioning Customized Panes in SYSPRO 6.1

 

License type: Unlimited Users with annual license fee
Pricing: Once-off payment