Query in UDO fields

[former_member614281]

Hi all,

Im trying to populate a UDO field, with a query, but it can't seem to work, i have an error when updating UDV on the field.

What do you guys think is the probleme. udo.jpg

[ANKIT_CHAUHAN]

Hi ssabir,

If there is no data, you can delete/unregister the UDO and create the UDO again with a shorter UDO Code.

If there is data, you still need to delete/unregister the UDO and import the data into the newly created UDO. You can use DTW or DI API for the import.

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[ANKIT_CHAUHAN · Accepted solution]

Hi ssabir,

It appears that you are having the same scenario as mentioned in SAP Note 2356033.

Workaround:

The maximum length of the FormID field in table CSHS and the Code field in table OUDO is 20. The FormID field in table CSHS is combined by the prefix string UDO_FT_ (string having 7 characters) and the UDO code (string having 13 characters from the UDO Unique ID).

Note: If you want the UDO to be supported by the formatted search, the length of the UDO code should be fewer than 14 characters.

The maximum length of the FormID field in table CSHS and the Code field in table OUDO was extended to 100 in SAP Business One 10.0.

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[former_member614281 · Accepted solution]

Hi,

Thank you for your reply, i got it, but i'm having trouble with how to change the length of UDO code, is it possible ? how can i do so ?