How to execute adhoc query?

1) There is an "Adhoc Query" function in ERPro - System Manager - Enquiry, which enable user to query the database in way that ERPro has not yet supported.

2) User can then enter query statement to query the database. Our support staff will be able to provide the query you need.

The query is the same as the query used in Business Alert. See Business Alert Query Samples

3) The results can be viewed through a Window, or be exported to Excel.

4) Queries can be saved for future reporting. User can save unlimited queries as they need.