PROGRAM ISSUE ** THIS INFORMATION HAS NOT BEEN VERIFIED **

"The Lookup retrieval returned no data", occurs in Sage MAS Intelligence.

Entry Type: Program Issue

Product: Sage MAS Intelligence

Application: SMI Report Manager

Version Reported: 4.40

Status:

This issue is being researched by Engineering.

Subject:

"The lookup retrieval returned no data", occurs when clicking the Lookup Value button in the Optional Default for Parameters window in SMI Report Manager.

Steps to Duplicate:

In ABC company:

1. Open SMI Report Manager
2. Right click on any folder and select Add Report
3. Select Standard Report and click Ok
4. Enter Report Name and click Ok
5. Select Data Container Financial Report 2-0(MAS) Parent Connection: Sage MAS (Auto Connect) and click Ok
6. Select the following Column Fields and click Ok:
• Account
• AccountDesc
• ActivityPeriod01
• ActivityPeriod02
• ActivityPeriod03
• ActivityPeriod04
• ActivityPeriod05
7. In Object List, select the new report created above.
8. On the Parameters tab, click on the Add button
9. Choose the following Filter Fields:
• GL_FiscalYear Comparison Method: Equal To, Click Ok
10. Click on the Lookup Value (...) button, in the Optional Default for the Parameters window
11. Error "The Lookup retrieval returned no data."
12. Note: Same results occur when selecting the following filter fields
• GL_Company Code
• Account_Type
• Type

Expected Behavior:

Possible Workaround:

None