Download - QAD .NET UI – Tips n Tricks
![Page 1: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/1.jpg)
QAD .NET UI – Tips n Tricks
Stacy Elwood, BravePointMWUG March 2010
![Page 2: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/2.jpg)
Agenda
IntroductionMultiple Servers/ConfigurationsReturn Multiple Fields from a Browse Browse Maintenance Security Reporting EngineOperational Metrics Questions and AnswersNext Steps
![Page 3: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/3.jpg)
.NET UI in Multiple Environments
Challenge:
In today’s world, there are often multiple QAD .NET UI environments, including test servers, development servers, and production. Installing .NET UI from a new server overwrites the initial installation.
Solution:
Set up each server with a unique icon and client destination folder.
![Page 4: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/4.jpg)
Change icon name
Change the icon name in /apps/tomcat/webapps/qadhome/client/options.jsBy default, this file reads var Vers=“ 2009 SE”Note: Be sure to leave the space in front!
![Page 5: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/5.jpg)
Change client working directory
Change the client working directory in /apps/tomcat/webapps/qadhome/configurations/default/client-bootstrap.xmlBy default, this is &{APPDATA}\QAD\Shell&{APPDATA} =C:\Documents and Settings\userid\Application Data
![Page 6: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/6.jpg)
Run the QAD .NET UI Installation
![Page 7: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/7.jpg)
Run the QAD .NET UI Installation (ctd)
Choose Install a new instance of this application
![Page 8: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/8.jpg)
Run the QAD .NET UI Installation (ctd)
Finish Installation Icon will be created with new name
Client working directory will be created with new name
![Page 9: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/9.jpg)
Returning Multiple Values from a Browse
Challenge:
In some areas of QAD, there is a requirement to return more than one value from a browse. For example, in Voucher Maintenance, if you do a lookup in the Receiver Matching frame, it should also return the PO line. In CHUI, this was handled by scrolling windows.
Solution:
Configure .NET to return more than one value from a browse.
![Page 10: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/10.jpg)
Return Multiple Fields from a Browse
![Page 11: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/11.jpg)
Return Multiple Fields from a Browse
Configuration file for multiple values is /apps/tomcat/webapps/<qadui>/net/lookups/lookupreturnfields.xml
![Page 12: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/12.jpg)
Return Multiple Fields – Other Examples:Inventory
– Location– Lot/Serial– Reference
Work Orders– Work Order Number– Work Order ID/Lot
Routings– Routing – Operation– Start Date
![Page 13: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/13.jpg)
Browse Maintenance – Table Security
Challenge:
Want to be able to have “power users” create their own browses for their areas. However, once users have menu security access to Browse Maintenance, they can create browses on potentially sensitive data.
Solution:
Set up table restrictions for Browse Maintenance by user or user security groups (eg “non-fin”).
![Page 14: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/14.jpg)
Browse Maintenance – Table SecuritySet up Restricted Tables by user or role in /apps/tomcat/webapps/qadhome/configurations/<qadui>/client-session.xmlBy default, all tables are visible in Browse Maintenance
![Page 15: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/15.jpg)
Operational Metrics
Constantly keep tabs on your data
Set your own criteria
Constant Improvement
![Page 16: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/16.jpg)
Operational Metrics
DEMO
![Page 17: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/17.jpg)
Reporting Framework
Use a browse as the basis for the report
Save Report Criteria to run in a batch
Send reports directly to PDF or Excel
Schedule jobs
![Page 18: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/18.jpg)
Operational Metrics
DEMO
![Page 19: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/19.jpg)
Questions?
![Page 20: QAD .NET UI – Tips n Tricks](https://reader030.vdocuments.us/reader030/viewer/2022033013/56815a86550346895dc7f5bd/html5/thumbnails/20.jpg)
Next Steps – The Future’s So Bright…
Today, many IT departments face challenges of down-sizing. What can you do to prove you’re worth keeping?
Set up Operational Metrics to help increase data accuracy and drive continual business improvement
Help your users be more efficient