Skip to Content
author's profile photo Former Member
Former Member

How to store Description Instead of Code from UDT ?

Hi,

I have use one UDT which is liked to one UDF on Purchase order Document.

When i select the any entry from UDT it will display the description in udf but when i add document it stores Code.

Is it possible to store the description instead of Code from UDT.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2013 at 06:41 PM

    Hi,

    This is system default. It is much more efficient to store code than name. What is the reason you need store description?

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 01, 2013 at 11:51 AM

    Linking a User Table to a User-Defined Field

    Instead of defining valid values for a field within the field definition, you can specify that the valid values are contained in a user-defined table.

    This can be helpful if you have several fields in different tables with the same valid values, or when you want to update the valid values dynamically. Note

    You can link a field to a user-defined table only.

    Prerequisite

    • You are adding a user-defined field, as described in Creating User-Defined Fields, and you have opened the Field Data window to define the new field.

    • The field type is Alphanumeric and its structure is Regular.

    • The Set Valid Values for Field and Set Default Value for Field checkboxes are not selected.

    Procedure

    ...

    1.In the Field Data window, select the Set Linked Table checkbox.

    A new field is displayed to the right.

    2.In the new field to the right, select the user table that contains the valid values for the current field.

    3. Fill out the rest of the form, and choose the Add button.

    Result

    When the field is displayed on the user interface, a dropdown list appears when you edit the field. The Code and Name fields are displayed, and the value of the field is the Code value of the selected item.

    It Is by System Default

    Hope Helpful

    Regards

    Kennedy

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.