Chapter 6. SQL Query for Formatted Search (FMS)
In the previous chapter, you learned about user query security and user query for approval procedures in SAP Business One.
This chapter focuses on one of the most frequently used but error-prone processes. It is to create SQL Query for Formatted Search (FMS). This chapter covers the following topics:
- Discussing the following two terms:
- Formatted Search
- User-Defined Values (UDV)
- Clarification of these two terms
- The process of how to set up UDV
- Focus is given to FMS query and issues related to FMS query, such as why there are internal error messages popping up and what a dollar sign or negative sign means in FMS query
- The last section gives you some FMS query examples
Within this chapter, the term "field" ...
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.
