Query wizard is the second tool to be discussed in this chapter. It is similar to query generator. We are going to compare both tools later in the book.
Query Wizard overview
Query Wizard enables easy access to the database and an easy way of building user-defined reports. It is designed for data retrieval/selection only. You are not able to do any DML queries such as updates, insert, or delete. This menu item can be accessed from Tools | Queries | Query Wizard.
With this tool, you can do the following:
- Create queries through five steps from a fixed set of tables from SAP Business One
- Access all data in those tables and get help from tips on each step
- Create individual reports without writing any single query statements