A query reads the required tables from the database and displays them formatted using a structured query language (SQL).
Queries enable you to quickly display and format data from an SAP Business One company database. You can use queries in several ways, for example:
with customization tools (alerts, approval procedures, and user-defined values added to existing fields or user-defined fields)
to produce ad hoc reports for users
to generate a sample report as an initial step when you create a custom report,
to validate the contents of a table or field during data migration. You can quickly display all the imported fields for a table.
You should understand that the query tools are primarily designed to produce ad hoc reports and for use with customization tools. If you need to produce complex, fully formatted reports or print layouts, you should use Crystal Reports.