Created on 10-24-2019 | Last modified on 12-04-2020

Summary

Cannot Select a field in UDT Selection task window (opened from Custom Office, User-Defined Table Maintenance) for Sage 100

UDT field, even if it is a Key field for the User-Defined Table, is somehow not available as a Select Field to filter by an Operand

Disclaimer

Backup Warning

Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

Support

Sage Customer Support does not provide assistance for issues related to third party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please contact your Sage business partner, network administrator, or accountant for assistance. Please review this document for additional information on the scope of Sage Customer Support Services.

Cause

There may be have been a problem that occurred during the creation of the User-Defined Table (UDT), or the User-Defined Field (UDF)

Resolution

Try adding the following Note to the User-Defined Field Element in the Data Dictionary.

  1. From the Sage 100 Desktop, open File, Run, and then type the following command and press the Enter key to open a ProvideX command prompt: SYZCON
  2. At the ProvideX command prompt, type the following command and press the Enter key to open Data Dictionary Maintenance: DD
  3. In Data Dictionary Maintenance, click the Query Table View (binoculars icon) button to access the User-Defined Table (UDT)
    • Note: The name will be in the format of M/M_UDT_Name, where “M/M” is the module code
  4. Click “2. Data Elements” to access that tab’s options.
  5. In the Data Elements grid, Double-click on the User-Defined Table (UDF) of interest to open the Element Description window.
  6. In the Element Description window, enter the following string into the Notes grid: udfRPTSEL$=”Y”
    • Note: If udfRPTSEL$=”N” already exists, don’t add the string. Change the “N” value to “Y” instead
    • Note: If the Notes grid already has another (different) string, you may append to the last with a comma.
    • Example: If the Notes section has the following string: udfCTLTYP=”M” then append so it looks like this: udfCTLTYP=”M”, udfRPTSEL$=”Y”
  7. Click “OK” to close out of the Element Description window.
  8. Click “Exit” to close out of the Data Dictionary Maintenance window.
  9. To exit the ProvideX prompt window, type the following command and press the Enter key: BYE