SAP Business One is the only application that uses Drag&Relate to provide you with end-to-end visibility of your business operations. This feature is also useful in helping you instantly understand key relationships and transactions within the business. A query generator features user-intuitive functionality for creating database inquiries and defining reports. You can use the data from any field to create a report at either the detailed or summary level. Once a query is defined, you can save it in the query library for future use. If needed, you can use a report editor to refine and change any existing queries. The query wizard is similar to the query generator, but in this case you are guided step by step through the process of generating queries. This tool is helpful if you want to build queries but are unfamiliar with SQL syntax.

Predefined Reports
SAP Business One provides a large number of predefined reports for each functional area. You can generate reports for a specific functional area in your business and customize the output to suit your needs. You can also print, e-mail, or export any report to Microsoft Excel.

XL Reporter
SAP Business One XL Reporter is a fully integrated advanced reporting and financial analysis tool that enables SAP Business One users to gain new levels of control over their operations. Using information pulled from SAP Business One’s unified database, XL Reporter offers you the flexibility to analyse real-time financial data in any format. Furthermore, XL Reporter uses a familiar standard Microsoft® Excel interface, as well as a unique drag-and-drop technology; report creation is simple, even for novice users.

Through real-time dashboards, XL Reporter also provides business intelligence across all areas of your organisation: from accounting and sales to fulfillment and inventory management. The dashboard offers instant snapshots of key performance indicators such as sales bookings, year-to-date revenue, accounts receivables, and open orders.

Crystal Reports
SAP Business One offers tight integration to Crystal Reports. This fully integrated solution allows SAP Business One users to design and deliver marketing documents and custom Crystal Reports from within the SAP Business One environment, eliminating the inefficiencies associated with using an external reporting tool. With Crystal Reports, you can conveniently connect to data from your SAP Business One application and access data regarding all critical business functions like supply chain and finance.

SQL Query Generator
SAP Business One’s Query Generator is a tool, which uses the SQL’s query engine and allows SAP Business One users to create their own queries. The Query Generator features user-intuitive functionality for creating database inquiries and defining reports. You can use the data from any field to create a report at either the detailed or summary level. Once a query is defined, you can save it in the query library for future use. If needed, you can use a report editor to refine and change any existing queries.

You can use the Query Generator to design nearly any query yourself and to quickly answer questions that regularly arise at your company. You can access all the data in the database and evaluate it according to your needs. The syntax for creating queries is extremely simple, making it easy for you to create individual report forms.

Business Intelligence Tools (BI)
BI tools go beyond traditional reporting to offer analysis of trends, snapshots of key performance indicators (KPIs), digital dashboards, slice and dice and multi-dimensional analysis. These tools can help you drill down to the key performance indicators which identify your strengths and weaknesses in operational performance, marketing, and sales—the key components to optimizing efficiency and profitability.

The BI tools you implement must be easy to use and learn and must be able to present data in a way that everyone can understand. If you have access to BI tools that can convert all of your key performance data into easy-to-understand terms that management can fully grasp, you have a tremendous opportunity to boost bottom-line performance and overall profitability.

A number of BI tools are available for SAP Business One including Business Objects Xcelsius, Alchemex, PowerOLAP, etc. The best tool for your business will depend on your requirements. With over 20 years of experience in matching requirements to functionality, MicroChannel Services will assist you in selecting the correct solution.

“The support we received during the implementation of SAP Business One by MicroChannel Services was excellent. I do not hesitate to call on MicroChannel for further assistance or support because I know their friendly team is always happy to help. I am a very satisfied customer!”

- Director – Finance and Operations, Australian Brushware Corporation