"This report yielded no data" when generating a report with Account Type in the row format in FRx

Entry Type: Program Issue

Product: FRx

Application: FRx

Version Reported: 6.7.9111

Status:

This issue is being researched by Engineering.

Subject:

"This report yielded no data" appears when generating a report with Account Type in the row format in FRx for Sage MAS 90 and 200.

Steps to Duplicate:

In FRx for Sage MAS 90 and 200 ERP:

Note: Sage Customer Support cannot duplicate this issue with demo data. The following steps are based on a reported case.

1. On the File menu, point to New, and click Row.
2. Click the Link to General Ledger drop-down menu.
3. Click Account Type.
4. Click the Account Type drop-down menu, and select 01 Cash. Click OK.
5. On the File menu, click Save. Enter a name and description, and then click OK. Close the row format.
6. On the File menu, point to New, and click Column.
7. In column A, select DESC from the Type (GL, Calc, etc.) drop-down menu.
8. In column B, select GL from the Type (GL, Calc, etc.) drop-down menu.
9. In column C, select GL from the Type (GL, Calc, etc.) drop-down menu. 
10. In the Current Per/YTD field, enter YTD.
11. On the File menu, click Save. Enter a name and description, and then click OK.
12. On the File menu, point to New, and click Catalog.
13. Enter a new catalog ID, and select the row and column created above. Click Save.
14. Click Generate Report. Note that "This report yielded no data" appears.

Expected Behavior:

The report should generate without error.

Possible Workaround:

Use the full account number in the row format.