A typical FMS query application: auto code creation
The first kind of examples for FMS query will be the typical ones.
FMS query is a very good tool to facilitate auto code generation to maintain a cleaner database. It is a good practice to create code without human intervention.
The code creation required is the BP code generation. The others will be for new item code. Some special requirements can be user document numbers or line numbers auto code.
Let's take a look at BP auto code generation first, then item code creation, and finally a special code-related issue will be discussed briefly.
BP code auto generation
When adding BP code, auto generation can save time and reduce certain problems. First, classify BP to three categories, namely: Lead, ...
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.
