PROGRAM ISSUE ** THIS INFORMATION HAS NOT BEEN VERIFIED **

Unable to map new Account Groups in Sage MAS Intelligence

Entry Type: Program Issue

Product: Sage MAS Intelligence

Application: Report Manager

Version Reported: 4.40

Status:

This issue is being researched by Engineering.

Subject:

Unable to map new Account Groups in Sage MAS Intelligence  The prompt "There are MAS Account Groups that need to be mapped to Reporting Groups..." prompt displays continuously and numerous blank lines exist when new account groups to map are added to the categories tab in SMI Report Manager.

Steps to Duplicate:

In ABC company:

  1. Log into SMI Report Manager for ABC company.
  2. Close Report Manager.
  3. Log into SMI Report Manager for ABX company.(using the same user).
  4. Expand Financials subject folder, highlight Consol Acc Group Code 2-0(MAS).
  5. On the Properties tab, in the Database Consolidation List, click lookup and check the boxes for ABC & ABX company codes and click Ok.
  6. Expand Financials subject folder, highlight Consol Financial Reports Sub 2-0(MAS).
  7. On the Properties tab, in the Database Consolidation List, click lookup and check the boxes for ABC & ABX company codes and click Ok.
  8. Expand Financials object folder, highlight Consol Financials Reports 2-0(MAS), click Run
  9. Report Parameters, select the following:
    • Fiscal Year=2010
    • Budget Code=Original
  11. In Excel, click on the Categories tab, map all the account groups then click Menu tab and minimize Excel.
  12. In Report Manager, highlight Consol Financials Reports 2-0(MAS) and right click and select Create and Link Template.
  13. Select the template and click Ok.
  14. Click Yes at the prompt, "This report has an option to place parameters on the second worksheet set.....Is this Okay?".
  15. In the specify template name window, add "1" after Reports, click Ok
  16. Click Ok at the prompt, "The template was created successfully and linked to the report".
  17. Close Report Manager
  18. Log into SMI Report Manager for EEC company.
  19. Expand Financials subject folder, highlight Consol Acc Group Code 2-0(MAS).
  20. On the Properties tab, in the Database Consolidation List, click lookup and check the box for EEC company code and click Ok.
  21. Expand Financials subject folder, highlight Consol Financial Reports Sub 2-0(MAS).
  22. On the Properties tab, in the Database Consolidation List, click lookup and check the box for EEC company code and click Ok.
  23. Report Parameters, select the following:
    • Fiscal Year=2010
    • Budget Code=Original
  25. Click Yes, at both Trial Balance Add-Ins window.
  26. Click Yes, at the prompt, "There are MAS account groups that need to be mapped to Reporting Groups before auto generating any layouts from the MENU sheet....".
  27. Click Ok, at the prompt, "Please map your MAS account groups by click on the red shaded cell...."

    Note: you will need to repeat the 2 steps above.

  28. Notice in Excel, on the Categories tab, you must scroll down to Line 1318 to see the new account groups that need to be mapped.

Expected Behavior:

There should not be 1300+ blank lines between the existing mapped account groups and the new account groups that need to be mapped.

Possible Workaround:

Scroll to the bottom of the Categories tab and map the new Account Groups