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.
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.
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:
- Understand and can maintain SQL Server 2005/2008 Login and Security settings.
- SQL Server 2005/2008 skills in creating and saving SQL Queries and Views.
- Importing and Re-positioning Customized Panes in SYSPRO 6.1
|License type: Unlimited Users with annual license fee|
|Pricing: Once-off payment|