Cannot Select a field in UDT Selection task window (opened from User-Defined Table Maintenance) in Sage 100
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.
- 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
- At the ProvideX command prompt, type the following command and press the Enter key to open Data Dictionary Maintenance: DD
- 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
- Click “2. Data Elements” to access that tab’s options.
- In the Data Elements grid, Double-click on the User-Defined Table (UDF) of interest to open the Element Description window.
- 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”
- Click “OK” to close out of the Element Description window.
- Click “Exit” to close out of the Data Dictionary Maintenance window.
- To exit the ProvideX prompt window, type the following command and press the Enter key: BYE