Sage 100

 View Only
  • 1.  FRx - ""This report yielded no data"" when generatin

    Posted 09-19-2011 12:39
    FRx - ""This report yielded no data"" when generating a report in FRx Getting this message for an existing company. The KB article that it matches is off the mark (not helpful) I can run the same report in a different company and it works. This is for the client that I created a new company for then copied the new GL (blank) back to the old company. So I am wondering if there is yet another little adjustment that I need to make. Any thoughts are appreciated.


  • 2.  RE: FRx - ""This report yielded no data"" when generatin

    Posted 09-19-2011 12:55
    First thought is rebuild indexes in FRX


  • 3.  RE: FRx - ""This report yielded no data"" when generatin

    Posted 09-19-2011 13:27
    Good thought, but no cigar. Since this is the same company that I had all those crappy little issues with last week, I wonder if there is still one remaining....


  • 4.  RE: FRx - ""This report yielded no data"" when generatin

    Posted 09-19-2011 13:33
    Delete all of the G32 files in the Sysdata sub directory.


  • 5.  RE: FRx - ""This report yielded no data"" when generatin

    Posted 09-19-2011 13:53
    Good thought, but the desired results did not appear.


  • 6.  RE: FRx - ""This report yielded no data"" when generatin

    Posted 09-19-2011 14:07
    Is the Default Specification set pointing to an invalid path? Does the new company have a valid specification set defined?


  • 7.  RE: FRx - ""This report yielded no data"" when generatin

    Posted 09-19-2011 15:41
    can you create a simple report from scratch and get results? If so, try mixing and matching new rows & columns with the old ones and see if maybe one of those building blocks is causing the issue


  • 8.  RE: FRx - ""This report yielded no data"" when generatin

    Posted 09-19-2011 16:17
    Actually, the new company SGG is working fine. It is the TQF (old) company that I cleared out the GLTQF folder that is giving me fits now.


  • 9.  RE: FRx - ""This report yielded no data"" when generatin

    Posted 09-21-2011 10:03
    Epilogue - Ended up opening a case for client. Reinitialized the GL_AccountHistory table, rebuilt the GL sort keys, deleted the *.g32 FRx and ran the account balance program in GL Utilities. Thanks to all for the suggestiong