SAP B1 blog

A tool that assists the user in defining queries in the system.

The query wizard in SAP Business One is a tool to retrieve and filter data from the SAP Business One database. It can be used to select and display the data users need using custom queries.

With the query wizard, queries can be created to retrieve information about customers, suppliers, items, business transactions and other data in the SAP Business One database. The Query Wizard allows you to filter queries based on specific criteria to display only the relevant results.

It is also possible to export the results of queries for further processing or analysis in other applications.

The tool guides you through all the steps to create an SQL query on the SAP Business One tables and is specially designed for users who have little or no knowledge of SQL syntax. You should have some basic knowledge of the table structure of SAP Business One. However, the query wizard also supports this by displaying the relationship to the linked tables after selecting a table.

Dashboard functions in MARIProject

SAP Business One has had distinctive functionalities for creating dashboards since version 9 at the latest. But also MARIProject, integrated project software ...
Continue reading ?

More key figures transparency in the ERP system

Many companies hope that the introduction of ERP software will bring more transparency to their key figures. However, it only becomes clearer...
Continue reading ?

Data warehouse or data lake

Data lakes and data warehouses are buzzwords one hears when it comes to data retention in the context of big data...
Continue reading ?

Big Data – Relevant for SMEs?

Big data is not relevant for small and medium-sized companies. Such an assessment can often be heard and read ...
Continue reading ?

Data analysis for SMEs

A critical analysis "Data analysis for SMEs" or "Data Science" should actually be one of the top issues for medium-sized companies. For it ...
Continue reading ?

Free MS Power Bi Ebook

Microsoft Power Bi is a business intelligence tool that can be used to dock different data sources. The data can be used by the Bi Tool ...
Continue reading ?

Monthly update to MS Power Bi

Microsoft Power Bi monthly update has been released. Of particular interest is a function that allows users to explore new ways...
Continue reading ?

Update for the data analysis tool: MS Power BI

Microsoft is regularly expanding the functionality of MS Power BI. A new version offers a number of new features...
Continue reading ?

New Reports / Power Bi for SAP Business One

Power Bi is a tool that allows you to analyze and visualize data in the simplest way. Versino has...
Continue reading ?

Smartshop Analytics prototype for SAP Business One

A YouTube video from SAP shows a prototype of a SAP Business One installation that uses SAP HANA Analytics to create new ...
Continue reading ?