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

The Consolidated Financial Report does not display any data for a Company if that company name has a comma ',' character in the name

Entry Type: Program Issue

Product: SMI Report Designer

Application: SMI Report Manager (Consolidations) 

Version Reported: 7.30 / 1.00.0073 

Status:

This issue is being researched by Engineering.

Subject:

The Consolidated Financial Report does not display any data for a Company if that company name has a comma ',' character in the name.

Steps to Duplicate:

In [SOA] company:

**Connector Module must be activated to run Consolidated Reports in Sage MAS Intelligence**

1. Expand System Manager, Maintenance, Maintain Companies.
2. Enter COA in the 'Company' field. Edit the 'Name' to say "Consultants Of America, LLC." Save and close.
3. Open Company SOA.
4. Expand MAS Intelligence, Tools, Double-Click Report Manager (Consolidations).
5. Expand the Financials Folder. Highlight the 'Consol. Financial Reports 2-0 (MAS 500)' Report and Click on the Run button.
6. Enter the Report Parameters: 'Company Name' = Consultants of America, LLC. and Systems of America. 'Financial Year' = 2008. 'Budget Set' = 2 Current Budget. Click OK.
7. In Excel, Right-Click any Worksheet tab and Un hide Sheet 1. Note: Only the Systems of America Data displays on the Data Sheet.
8. Click on Sheet2. Expand the "D" column. Note:   'Consultants Of America',' LLC.','Systems of America'  is used as the Company Name Parameter. SMI treats the LLC as a separate Company Entity.

Expected Behavior:

Sage MAS Intelligence should be able to run Consolidated Reports for companies that have a comma ',' in the Company Name.

Possible Workaround:

1. Expand System Manager, Maintenance, Maintain Companies.
2. Enter COA in the 'Company' field. Edit the 'Name' to say "Consultants Of America LLC." Save and close.
3. After running the Consolidated Reports change back the company name as needed.