Quick Addition of Total Field in User Query SAP Business One

In SAP Business One, After you created a query using query manager, you want to sum the total of all values in a column without having to write an extra SQL statement or export the data into excel to get the sum functionality.
To have that total, just Ctrl + Click on the column heading and the column total will appear at the bottom of the column.

Before

After

Copyright © PT Sterling Tulus Cemerlang – 2016

Also read:

• Set User Query to SAP Business One Main Menu
• Give Permissions for User Queries
• How to Get Login User Code in SAP Business One Query Manager
• Change Description Group Saved Query