PT Sterling Tulus Cemerlang



Ruko Graha Arteri Mas Kav 30
Jl. Panjang No.68, RT.19/RW.4
Kedoya Selatan, Kebon Jeruk
Kota Jakarta Barat
Jakarta, 11520 Indonesia

500+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

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.
    • SAP Business One Indonesia Partner/TotalinQuery3
  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.
    • SAP Business One Indonesia Partner/TotalinQuery2
  3. The total of column will be shown on the bottom row of the data
    •   SAP Business One Indonesia Partner/TotalinQuery1

Also read:

Copyright © PT Sterling Tulus Cemerlang – 2016

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: or call +6221-5806336 or wa +6287786555055