Row account group displays incorrect or no information

Entry Type: Program Issue

Product: FRx

Application: FRx Desktop

Version Reported: 6.5, 6.7

Status:

For current information on this issue, please click the 'Engineering Status' link above. To record the occurrence of this issue, please respond "Yes" to the question, "Did this answer help you?"

Subject:

Row account group displays incorrect or no information. The frl_acct_code table is not updated when changes are made to Setup Account Groups in Sage MAS 500 ERP.

Steps to Duplicate:

FRx for Sage MAS 500

In SOA company:

  1. In FRx, open File / New / Row.
  2. Click the 'Link to General Ledger' button, and click 'Account Type'.
  3. Select "REVENUE" as the account type.
  4. Click the 'OK' and 'Save' buttons.
  5. Create a new catalog, and attach the row from the previous step to any column.
  6. Generate the report for period 6, year 2004.
  7. Drill down to the account level, and note the information for account 4000-00-00-00.
  8. Close FRx.
  9. From Sage MAS 500, open General Ledger / Maintenance / Maintain GL Accounts / Maintain Natural Accounts.
  10. Select account "4000-00-00-00", and change the account group to "COGS" and the account type to "Cost of Goods Sold".
  11. In FRx, rebuild the GL index. For more information, see How to delete and rebuild FRx indexes.
  12. In FRx, open the catalog and row.
  13. Click the 'Link to General Ledger' column, and change the account type to "COGS".
  14. Save the row, and generate the report.
  15. Drill down to the account level, and note that account 4000-00-00-00 is not included on the report.

Expected Behavior:

Row account groups should display all account types.

Possible Workaround:

Contact Sage MAS 500 Customer Support for the following SQL script: FRXAcctGroup_MAS500.sql

Note: The following procedures assume certain knowledge of Microsoft SQL Server and/or Transact SQL. Contact an authorized Business Partner or database administrator for assistance.

Sage Software Support is not responsible for assisting with these procedures and cannot be responsible for errors that may occur when changes are made directly to the SQL Server. Be sure to back up all system and application databases before making changes to any tables.

Run the SQL script against the database after changing account groups in Sage MAS 500, or use the account sets option instead of row account groups in FRx. For more information, see How to create account sets.