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