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

Non-Financial Accounts are included in the total Current Year Retained Earnings in Sage MAS Intelligence.

Entry Type: Program Issue

Product: Sage MAS Intelligence

Application: Report Designer

Version Reported: 4.40

Status:

This issue is being researched by Engineering.

Subject:

Non-Financial Accounts are included in the total Current Year Retained Earnings on the Balance Sheet in Sage MAS Intelligence.

Steps to Duplicate:

In ABC company:

1. In MAS, expand General Ledger, Reports and click Financial Reports select the Standard Balance Sheet and Standard Income Statement, preview for the Period Ending 5/31/2010.     Make note of the amounts of the Retained Earnings-Current Year and the YTD Net Income.
2. Expand General Ledger / Setup / Account Group Maintenance and add the following Account Group and click Accept:
• Account Group = 999
• Description = SMI NONFINANCIAL
• Category = Non-Financials
• Account Type = Non-Financial
3. Expand General Ledger / Main /Account Maintenance and create the following account and click Ok:
• Account No. = 999-00-00
• In Account Entry, click on value 999 then click on the Add  icon
• Description = SMI NON-FINANCIAL
4. Enter and update the following in General Journal entry:
• Source Journal = NF
• Entry Number = 000001
• Posting Date = 5/31/2010
• Account Number = 999-00-00
• Credit = 100,000.00
5. Preview the same Financial Reports from step 1 and note that the non-financial amount of 100,000 is not included in the Retained Earnings-Current Year.
6. Open SMI Report Manager
7. Expand Designer, and Run the Financial Reports Designer report.
• Fiscal Year = 2010
• Budget Code = Original
8. The Mapping Tool screen will open, the new account group appears in the left box (UnMapped System Categories).
9. In the Reporting Groups in right box, click NON FINANCIAL and Add the new account group (SMI NONFINANCIAL) to this reporting group.
10. Click OK to close the Map your System Categories into Reporting Groups screen.
11. Click OK to close the System Category Mapping message.
12. When Financial Report Designer opens, go to the BI Tools tab.
13. Click the Quick Generate dropdown and select Balance Sheet.
14. Note: Period 05 YTD RETINC amount includes the Non-Financial Account amount and does not agree with the Standard Balance Sheet in MAS 90. The Total Assets do not agree to the Total Equity and Liabilities.

Expected Behavior:

The non-financial accounts should not be included in the RETINC line on the Balance Sheet.

Possible Workaround:

1. In order to populate the Non Financial Account, Click on Quick Generate and select IS-Actual vs Budget 

2. Unhide Sheet1 and for account 999-00-00, change the Type from "I" to "N.