Getting a value from a table for a formated search

[Former Member]

Hi,

I have a user defined field and I have related to it a formatted search. But the problem is that I would like to get the itemcode which is a field of a table and this table is in the form 139 and my field is in the -139

Thanks in advance,

vanesa

[barend_morkel2 · Accepted solution]

You can refer to fields in a screen template using the syntax, $[Table name.Field name]. The table name is the name of the table belonging to the screen template, for example, OINV for the invoice entry screen. (Using a query like "SELECT $[Table name.Field name]" - this will only work in SBO)

You can use the index at the end of this unit to define the syntax so that the query applies to all document entry screens. The syntax is then $[$Field index.Field column.NUMBER/CURRENCY/DATE/0]. The system is able to uniquely identify each field of a document via the field index and the field column.

- You use the NUMBER parameter if the field concerned contains an amount and a currency key, and you want to extract the amount only.

- You use the CURRENCY parameter if the field concerned contains an amount and a currency key, and you want to extract only the currency key.

- You use the DATE parameter if the field concerned is a date field and you want to use it for calculations.

Thus you would use $[$139.0.0]

(if the field's ID you are looking for is 139)