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

Add Accounts on the Report Tools menu does not allow the Addition of new GL Accounts to Customized Reports

Entry Type: Program Issue

Product: Sage MAS Intelligence

Application: Report Manager 

Version Reported: 7.30 

Status:

This issue is being researched by Engineering.

Subject:

Add Accounts on the Report Tools menu does not allow the Addition of new GL Accounts to Customized Reports.

Steps to Duplicate:

In [SOA] company:

  1. Expand MAS Intelligence, Tools, Open Report Manager. Create a new Folder.
  2. Open the Designer Folder. Copy the Financial Reports Designer 2-0 Report and paste in the new folder.
  3. Highlight the copied report and click Run. Enter 2008 for the Financial Year and select the Current Budget Set for SOA. Click OK.
  4. In Excel, click on the BI Tools tab. Select Quick Generate, Balance Sheet.
  5. Click on the BI Tools tab. Select Quick Edit, Balance Sheet.
  6. Remove all columns except for Period 1 Columns. Click on Generate Layout.
  7. Create and Link the modified template.
  8. In MAS 500, Expand General Ledger, Maintenance, Maintain Natural Accounts.
  9. Enter 1010 in the 'Natural Account' field. Click on 'Create Accounts'. Create GL account 1010-00-00-SW. Save.
  10. Expand General Ledger, Activities, Process Journal Transactions.
  11. Create a new Batch. Select Standard for 'Entry Type'. Select the 01/01/2008 for the Post Date. Click on Enter Transactions.
  12. Select JE for the 'Journal'. Create a new 'Entry Number'. Click on the 'Detail' tab.
  13. Credit the new GL Account 1010-00-00-SW for $10.00. Credit an existing GL Account 1100-00-00-00 for $10.00. Post the GL Entry.
  14. Expand MAS Intelligence, Tools, Open Report Manager.
  15. Highlight the copied report and click Run. Enter 2008 for the Financial Year and select the Current Budget Set for SOA. Click OK.
  16. Click on the Modified Balance Sheet tab in Excel. Expand the Current Assets Section.
  17. Highlight the row containing GL Account 1010-00-00-00.
  18. Click on the Add-Ins Excel tab. Click on Report Tools. Select Add Accounts.
  19. Select the Modified Worksheet. Click Next.
  20. Note: The GL Account created in MAS 500 is not available for selection in the Balance Sheet.
  21. Click on the original Balance Sheet Excel tab.
  22. Highlight the row containing GL Account 1010-00-00-00.
  23. Click on the Add-Ins Excel tab. Click on Report Tools. Select Add Accounts.
  24. Select the Modified Worksheet. Click Next.
  25. Note: the GL Account 1010-00-00-SW is allowed to be added to the non-customized report.

Expected Behavior:

 The Add Accounts functionality should work the same regardless of whether the SMI Report was modified or not.

Possible Workaround:

None.