How to Display Total for a Column in Query Manager SAP Business One

In SAP Business One, a query is mighty useful as a quick way to create a report. But often times, result of a query in Query Manager might not be as user friendly as a well designed report in Crystal Report, where you can easily add a subtotal or a grand total. A standard result in query manager does not show a sum of the value in column. However, in a pinch, you can easily show the sum of a column for instant information without moving the information to excel.

1. This is the usual result of a query.
   • 
2. To show the total of the Document Total column for example, simply press the Ctrl button on your keyboard while clicking once on the title of the column.
   • 
3. The total of column will be shown on the bottom row of the data
   •   

Also read:

• How to Get Login User Code in SAP Business One Query Manager
• View and Customize Graph in Query Manager
• How to Use Custom Parameter on Query Manager in HANA
• How to Use Custom Parameter on Query Manager
• Easier Way to Search Query on Query Manager

Copyright © PT Sterling Tulus Cemerlang – 2016