Alternate quantity percentages

By default, the formula’s Quantity Percent (i.e., MATERIAL_PERCENT) column is used to sort ingredients in an ingredient statement.

The Alternate Quantity% list, in the Ingredient Statement form, can be used to select another column for sorting.

System administrators must complete these setup tasks:

1. Create the C_ALTQTYPCT Enumerated List.
2. Configure the ATTRIBUTE1 - ATTRIBUTE25 column values so that they are shown in the Alternate Quantity% list.

For the Enumerated List Custom Value field:

• Use the database column name, as defined in the DB_FIELD_NAME column of the FsValidationField table, for the G.FORMINGRED validation code.
• In the database, change these columns from strings to double precision floating point numeric values.
• In the Validation form, change these column definitions to TYPE_DATA 5.

  

System performance can be affected by the Alternate Quantity % feature. Therefore, do not create the C_ALTQTYPCT enumerated list unless you plan to use this feature.