Utility to replace the Advanced Lookup Engine (ALE) query files for Sage 100 ERP when:
• Lookup columns are misaligned
• Lookup missing data
• Field values do not belong to the column (e.g. Customer Zip Code displays under Terms Code)
• F2 lookup data is incorrect
instead of having to run the PRINT %SYS_SS'CreateTable("table","COMPANY:xxx") instruction one by one.
by: Jose J. R. | over a year ago | General Enhancements
Comments
Advanced Lookup Engine (ALE) lookups are pervasive throughout Sage 100 ERP, and critical to the efficient operation of the software. They are the primary way of accessing data, and the customers depend heavily on them. The current remedy provided by Sage Support to solve this issue is insufficient, inefficient, and impractical. Building a utility seems totally justified, and not to difficult to code.