How To View Inventory by Warehouse

Here’s how to view inventory by warehouse or item group: 1) Inside the Modules Tab, navigate to: Inventory > Inventory Reports > Inventory in Warehouse Report 2) Choose an “Item Group” to only show inventory items in a certain group only. Check “Hide Items with No Quantity in Stock”. Choose the warehouse. 3) Optional: if […]

Read More

How To Hide Columns Before Printing or Exporting A Report In SAP

To hide Columns before Printing or Exporting follow these instructions: 1) We assume you already have the report you want to print/export pulled up. If not, pull up the report. 2) From the toolbar choose Form Settings to hide the fields you don’t want. See icon below. 3) When the Form Settings window pulls up, […]

Read More

How To View Top Sales By Customer

Here’s how you run a report in SAP Business One so you can see who your top customers are, based on the amount they’ve purchased: 1) From the Modules tab navigate to: Modules > Sales – A/R > Sales Reports > Sales Analysis 2) Choose the Customers Tab, Select the Invoice Radio Button, and Select […]

Read More

How Do I Tell What My Top Selling Inventory Items Are?

Here’s how you run a report in SAP Business One so you can see what your top selling items are, either by quantity sold or dollar amount sold: 1) From the Modules tab navigate to: Modules > Sales – A/R > Sales Reports > Sales Analysis 2) Choose the Item Tab, Select the Invoice Radio […]

Read More

What’s the Difference Between Crystal Reports and Crystal Server?

Crystal Reports and Crystal Server are two different pieces of software. There are many differences between Crystal Reports and Crystal Server, but simply put: Crystal Reports is used to design/modify/manipulate/create the actual report from a multitude of separate data source locations. Crystal Server is used to view or send the completed reports to user. The […]

Read More

How Does Drag & Relate Reporting Work?

The Drag & Relate tool inside SAP Business One is a tool for running reports on the fly. It’s based on a set of pre-defined queries which are engaged when you drag certain elements and drop them on top of other elements inside of the SAP Business One application. The user-friendly nature of this type […]

Read More

What Is the Reports Module?

The Reports Module enables you to compile reports with corporate data and information in exactly the way you want to see it. This includes company internal evaluations, inventory reports, financial reports, and accounting data. In addition to the predefined reports, you can also define individual queries. This is a screenshot of the Reports Module Menu […]

Read More