Enterprise Resource Planning Blog Posts by SAP
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Exploring UDV Enhancements (Part 1): Using APIs in Formulas

OferOz
Product and Topic Expert
Product and Topic Expert
2 weeks ago
395

After the first release of the User-Defined Values (UDV) feature in SAP Business One 10.0 FP 2502, the latest version, FP 2508, introduces 3 main enhancements:

  1. Support for new Business Objects: Business Partner master data and Activities
  2. Enhanced UDV Formulas with API Usage: ability to use APIs in UDV formulas, which is covered in this article
  3. UDV Management: ability to manage UDVs, which is covered in this article

In FP 2508, UDV formulas support 2 more types of components:

  • Global variables
  • Data manipulation APIs

Usage of global variables: assume that I’d like to show the user name that created a sales order in the “Remarks” field. For this purpose, I simply define the formula as follows:

OferOz_0-1762269081046.png

If you want to access a list of all available global variables, use the “app” namespace. For information on all supported global variables, see our online help here.

Usage of data manipulation APIs: now, let’s assume that I want to see this user name in capital letters – all I need to do is change the formula to:

OferOz_1-1762269177916.png

Another useful type is conditional API: 'IF' statement. Assume that when the item quantity is greater than 100, I’d like to apply a 10% discount to the unit price. The formula will look like this:

OferOz_2-1762269201382.png

This API provides 2 condition-based variants: the simple IF (if-else) and the complex IFS (IF statement with many conditions, similar to the “switch” keyword in programming language).

To discover many more string and mathematical manipulation APIs, visit our online help here.

To deepen your understanding, watch this short video for another use case.

By incorporating these enhancements, you can leverage SAP Business One more effectively, optimizing processes and increasing flexibility in data handling.