PT Sterling Tulus Cemerlang

+62 (21) 580-6055


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

Formatted Search Multiple Triggers

SAP Business One Tips Formatted Search Multiple Triggers

User-Defined Value, usually called a formatted search, has been existed since SAP Business One 2007 and many people still use it for quick customizing solutions for their business process needs.

This feature is very useful when users need to automatically fill in one column field on the SAP screen, based on one or several other columns’ values or calculation formula. Until SAP Business One version 9.3, to trigger this automation, the user can only determine one column as a trigger.

Now, in SAP Business One 10, the user can determine more than one column to trigger this feature.

For example, to calculate volume, we need 4 columns: Length, Width, Height, and Volume Result.

We can create a simple formula to calculate this in a query:

SELECT $[$38.U_Length.Number] * $[$38.U_Width.Number] * $[$38.U_Height.Number] AS “Volume” FROM DUMMY

and saved it in User Queries.

SAP Business One Tips - Formatted Search Multiple Triggers

SAP Business One Tips – Formatted Search Multiple Triggers

On the U_Volume column, activate User-Defined Values by pressing ALT+SHIFT+F2, and choose “Search in Existing User-Defined Values according to Saved Query”, then choose your saved query.

Checkmark “Auto Refresh” and choose “When Exiting Altered Columns”.

On the “Field” column, choose Length, Width, Height columns as triggers.

Now, your Volume column will be automatically calculated when you change values on Length, Width, and Height columns.


Note: Valid for SAP Business One 10, SAP Business One 10 version for HANA

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

, , , ,