Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Sage MAS Partner
LoriD
Posts: 88
Registered: 11-19-2008
0
Accepted Solution

FRx Engine failed to create GL Index

I am trying to setup reports for a new company in FRx and I get this message when trying to set company as default.  I am using MAS200 4.3.16; FRx  6.7.7032.

 

I have allow external access checked in company maintenance.

Reinitialezed GL_AccountHistory

Rebuilt GL keys and sorts.

Deleted .g32 file in sysdata.

 

Any other ideas would be greatly appreciated.

Lori
Super Contributor
rmikolainis
Posts: 1,252
Registered: 10-29-2008

Re: FRx Engine failed to create GL Index

After you reinitialize the GL_AccountHistory table, you need to Run the Recalculate Account Balances Utility in GL to repopulate that table.

(try this first)

 

If that doesn't work, check your file rights and permissions. Check out the ODBC data settings also and make sure all the info is correct. Test the connection too in ODBC.

 

Contributor
ChrisC
Posts: 21
Registered: 01-16-2009
0

Re: FRx Engine failed to create GL Index

I have the same issue.  FRx was working fine this morning, now not so good.  I did attempt to populate Budget Revision Entry via VI, but not successful.  Anyway, after doing suggestion to resolve my error, I'm still getting this error "Error 8900 A DirectLink error has occurred while populating book code information. (This error occurred while populating the frl_book_ctrl table in the GLX database).  Any suggestions???