Transcript Baan Query Tool

A new and elegant way to create queries and ad-hoc
reports on your Baan / Infor ERP LN data. This Baan
session is a query builder that comes with an easy to
use graphical interface.
1. NAZDAQ Company
2. The Problem
3. The solution – Using Baan Query Tool
4. Success Stories
NAZDAQ is a provider of Add-ons for Baan and Infor ERP Ln. The
NAZDAQ tools provide a great return on investment and enable Emailing, faxing, archiving, printing documents like Purchase Orders
and Invoices, and allow an easy way to convert reports to Excel,
Word, PDF HTML and XML. Other solutions cover areas of
document management, reporting and notification.
The NAZDAQ tools are installed at hundreds of servers in more
than 60 countries. They are used daily by users to automate
transfer of Baan reports into front-office applications, as well as
automating business processes.
www.nazdaq-it.com
Generic Query Tools
Difficult to install and configure
Difficult to use
Time consuming
Expensive to configure and run
Not Baan/ERP LN specific
Baan Query Tool
Quick Installation: Load few sessions and all
Baan and ERP LN users will have access to
Baan Query Tool
Easy to Configure: No ODBC or database
drivers need to be configured
Use Baan Data Dictionary: Browse tables and
fields and create a query - using the Baan data
dictionary
Baan Query Tool
Baan Query Tool: Is fully
integrated in Baan. Reports
run as native Baan reports
Can work with Baan special
fields like enumerated fields,
arrays and text fields
Does not have the limitation of
255 characters, like standard
Baan reports
Baan Query Tool – Easy to find a Baan table
Simply use the zoom option, then search the table description or code.
Baan Query Tool – Finding and adding fields
Using this graphical tool, you can easily find the fields and add them to the query.
Baan Query Tool – Printing results
You can easily set the range and print the results.
Baan Query Tool – Customizing the print form
You can save different field values using “Saving Defaults”.
Save Defaults sets the fixed “where” statement of the Query.
Baan Query Tool – Customize fields
You can customize any field details such as: description, width,
alignment and format in the print results.
Baan Query Tool – Adding fields from another table
Add customer name and country name, change title and change it’s
position.
Baan Query Tool – Adding calculated fields
Formulas can be added as fields to the query.
Baan Query Tool – Adding conditional fields
Conditional fields can be added as fields to the query.
Baan Query Tool – Sorting your output
You can have 4 levels of sorting.
Baan Query Tool – Adding aggregation functions
You can use a group by option for a field using functions such as: sum, avg,
min, max and count.
Text before field You can add sort
fields values as
variables: SORT1,
SORT2, SORT3,
SORT4
Baan Query Tool – Working with output
You can pre-define your output device.
Baan Query Tool – Integrating with B2Win & B2Email
If you use B2Win and B2Email, you can automatically format the output in Excel
format and Email it by setting the device and output file.
Baan Query Tool – Running wide reports
In order to overcome the limitation of 255 characters in Baan, use device type
“Wide”. With this, you can write a query with unlimited number of fields.
Baan Query Tool – Automating queries
By defining the output device and hiding the print form, Baan Query Tool does not
require any input and can run in a job.
Baan Query Tool – Run queries
Baan Query Tool is a tool for power users. For normal users you allow them to run
queries using a limited interface. They can also run queries written by other users.
Baan Query Tool – Copy query
Baan Query Tool is a tool for power users. For normal users you can also allow them to
copy queries from other users and run them.
Kistler in Switzerland - Kistler is using B2Win now in almost all departments, in order
to put Baan reports into Excel. Baan Query Tool (BQT) is used mostly in IT to create fast
and easy reports. In addition, they have a new project where they have to gather data
together from all the Baan systems and consolidate it. BQT has been a great help
because they can take out every data they want. BQT runs fast, even with more
complex multi-table queries.
Since they also have to perform large data cleanup, they can simply extract data into
Excel. The users can modify the data in Excel and they can import it back using
Exchange. According to Mr. Cajoos, “This technique saves man-weeks of work,
because the users do not have to go through many Baan sessions, record by record. “
[email protected]