**INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

Retained Income Current Year is incorrect on the Balance Sheet in SMI Report Manager.

Entry Type: Informational

Product: Sage ERP MAS Intelligence

Application: Report Manager

Version Reported: 4.50 EA

Determined this was not a program issue, it was data related. There were bad records in GL_AccountSegment.M4T file.

Status:

This issue is being researched by Engineering.

Subject:

Retained Income Current Year is incorrect on the Balance Sheet

Steps to Duplicate:

In TSG company:

1. Open General Ledger / Reports / Financial Reports
2. Select the Standard Balance Sheet and click Proceed
3. Select 2011, Period 1 ending 10/31/2010 and click Preview
4. Note the Retained Earnings-Current Year is 41,523.71
5. Close MAS
6. Open Report Manager
7. Log into TSG company
8. Highlight the Financial Reports 2-4 and click Run
9. Select Fiscal Year 2011 and ORIGINAL Budget Code and click OK
10. Once the Excel file is generated, click on the Categories tab and map as follows:

11. 0000	CURRENT ASSETS	20	Current Assets
    1000	CASH	20	Current Assets
    1100	RECEIVABLES	20	Current Assets
    1200	MATERIALS INVENTORY	20	Current Assets
    1300	WORK-IN-PROGRESS	20	Current Assets
    1400	OTHER CURRENT ASSETS	20	Current Assets
    1500	FIXED ASSETS	20	Current Assets
    1800	LONG TERM ASSETS	20	Current Assets
    1900	OTHER ASSETS	20	Current Assets
    2000	PAYABLES	28	Current Liabilities
    2100	PAYROLL TAXES PAYABLE	28	Current Liabilities
    2200	OTHER TAXES PAYABLE	28	Current Liabilities
    2500	LONG-TERM LIABILITIES	28	Current Liabilities
    2800	INTER-COMPANY	20	Current Assets
    3000	EQUITY	36	Equity
    4000	NET SALES	8	Revenue
    5000	COST OF SALES	9	Cost of Goods Sold
    6000	DIVISION EXPENSES	12	Cost and Expenses
    7000	SELLING, GENERAL & ADMINISTRATIVE	12	Cost and Expenses
    7100	LABOR BURDEN ACCOUNTS	12	Cost and Expenses
    7113	INDIRECT LABOR	12	Cost and Expenses
    7300	OCCUPANCY EXPENSE ACCOUNTS	12	Cost and Expenses
    7400	OFFICE EXPENSE ACCOUNTS	12	Cost and Expenses
    7407	QUALITY/SAFETY	12	Cost and Expenses
    7500	SELLING EXPENSE ACCOUNTS	12	Cost and Expenses
    7600	GENERAL EXPENSE ACCOUNTS	12	Cost and Expenses
    7700	FINANCIAL EXPENSE ACCOUNTS	12	Cost and Expenses
    7800	ENGINEERING	12	Cost and Expenses
    7900	PURCHASING	12	Cost and Expenses
    8000	OTHER INCOME AND EXPENSE	12	Cost and Expenses

    Click on the Menu tab and select the 2- Balance Sheet

12. Click ok to New Sheet Name and Ok to Layout Generated Successfully

13. Expand the Equity section and note that the Retained Income Current Year is 19495.82 for Period 1

Expected Behavior:

Retained Income Current Year should match the Retained Earnings Current Year in MAS 90

Possible Workaround:

Look for bad records in GL_AccountSegment