What to do about Accounts that won’t show up in FRx

by Jan Harrigan CPA

Got a new account that won’t appear on a report?


You’ve added it to your chart of accounts, and to your FRx row format. You know you have data posted to it. But it just won’t show up on the report no matter what you try.

Same thing for new budget book codes.

Here’s what to try first: rebuild the index. In the catalog, drop the report date box down, check the box to “Rebuild FRx GL indexes”, and run the report. That should do it. That forces FRx to go take a brand new snapshot of your GL chart of accounts.

If that doesn’t work, you can delete or rename the .g32 file (that’s the index file) in the sysdata directory in the FRx install. (It will start with the first few letters of the FRx company name plus some random numbers, followed by a .g32.) All users should log out of that company in FRx first.

The .g32 file rebuilds once a day the first time someone logs in to the company. It’s a picture of your chart of accounts. That’s why you might add an account one day and it won’t show up, but when you run the report the next day, it appears. And that’s why the above steps work: they reshoot the picture of the newer chart. So now you know. Cheers—Jan

Be Sociable, Share!

    { 4 comments… read them below or add one }

    Guy Trudeau April 18, 2011 at 11:36 am

    Jan, Tried this but it does not work for us. We are trying to bring in an account from another company. no joy.

    Jennifer Gates December 20, 2011 at 12:49 pm

    Does not work for us either.

    Santy June 20, 2014 at 9:30 am


    I try to insert a new row but, i see the system only have 78767 files

    how i can create more files??


    Jan Harrigan CPA July 15, 2014 at 1:39 pm

    Hi Santy…I don’t recall the limit, but you’ve probably reached it. That’s an awful lot of rows, though…I would rethink the design with drilldown capability in mind, using less detail and more grouping if possible. The most extreme example would be a one-row trial balance with all accounts that you’d drill down on, vs. a billion-line trial balance that is impossible to keep in balance. Good luck…Jan

    Leave a Comment

    Previous post:

    Next post: