Summary

You have learned about a very important tool for SAP Business One in this chapter: Formatted Search.

This tool can save the company a fortune comparing with developing customized solution by using SDK programming. Combined by User Defined Field, Formatted Search will be very useful in getting the information to the right place without double entries.

You have learned about User Defined Value and the relationship with Formatted Search. You have learned the $ sign variable as $[$item.column.type] and $[table.field.type].

With the large amount of real world examples of FMS queries in this chapter, you will be able to create your own with ease.

Get Mastering SQL Queries for SAP Business One now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.