0 votes
in M3 by (13.3k points)
retagged by
How do I add a custom field (UDF in M3 Terms {User Defined Field}) in M3 / H5?

2 Answers

0 votes
by (13.3k points)

To add a custom field in M3, you have to start with associating the data with a master table you want to use. Very high volume tables may not be the best choice for custom fields, as it adds a extra database write to every key change on that table.

As an example, I will setup an additional value for an Item. The Item Master table in M3 is MITMAS. For the new field, we'll call it the License Required field. We'll use this to see if a customer needs a special license to purchase a product.

When you open CMS080, you'll see three entry fields at the top of the grid. The first is the table you want to link the data to. In our case, it will be MITMAS. The next field is the reference we'll use to refer to the UDF. We'll call this one LICS for License. The 3rd field is for the map to point to a field in the extension table. (See CUSEXTMI/CUGEX1 for details on available fields) For this table, the first two characters are always F1. So in this example I'll map to F1A030, which is a 30 character field.


CMS080 - 1

Now, the rest of the information needs to be defined. You can configure several requirements on the custom field in CMS080/E. This will complete the addition of the field. Now, you can go to any detail panel that accesses that Master Table, in our case, MITMAS, and add that field.


enter image description here

Since we updated a field for the Item Master, open up MMS001 and select an item. Under the Related Menu, click on Personalize, then Add Custom Field. This will allow the addition of the field to the panel.

by (13.3k points)

Doesn't seem to work for CSYTAB, evil table that it is.

by (13.3k points)
As of 2020, Infor is staying they will actively be blocking of custom fields to any non-Master data tables to prevent Business Engine stresses in maintaining the data.  Any fields setup before the blocking will continue to function after the block is installed, but no more will be added. 
by
Use CMS005 to tie to a grid in M3
0 votes
by
It seems that in some cases, you may need to add the join in CMS010 for the view.
M3 and Related Technology

A place for me to remember the answers to questions I had to dig around to find. Please feel free to add questions and answers for anything related to Infor, M3, ION, and it's sprawling family.
...