Error: Local Menu Lines Limitation in Sage X3

By | September 16, 2024

We know that local menu in Sage X3 is nothing but the list of options provided to the user to select any one from them. For example, if there is a field which requires numerous options to be listed then you may come across an error regarding line limitation while entering values for local menu in Sage X3. Refer below screenshot.

Error
Fig01: Error

By default, Sage X3 allows to enter 123 options for local menu/dropdown list. In case, you need to enter more than 123 values for a particular dropdown, you need to follow below steps.

  1. Navigate to: Development > Data and Parameters > Tables > Tables
  2. Enter table name as “APLSTD”.
  3. Modify the Length for the field “LANMES” from 123 to the required number of options. However, you can not increase the length beyond 250 being it is of datatype Alphanumeric.
  4. Save the changes and Validate the table with “Forced validation” button.

Refer below screenshot for better understanding.

Message
Fig02: Message

Now, when you will enter new option or value in local menu standard will not show any error regarding line limitation and you will be able to enter values up to defined limit.

local menu values
Fig03: Local menu values

Thus, we can increase number of options for any local menu or dropdown up to 250.