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

When running the Financial Report Designer's Actual vs. Budget Consolidated Income Statement, Budget Amounts are not retrieved for a GL Account if the Actual Amount for a particular period is 0.00

Entry Type: Program Issue

Product: Sage MAS Intelligence

Application: SMI Report Manager (Consolidations)

Version Reported: SMI 1.00.0073 - MAS 500 7.30

Status:

This issue is being researched by Engineering.

Subject:

When running the Financial Report Designer's Actual vs. Budget Consolidated Income Statement, Budget Amounts are not retrieved for a GL Account if the Actual Amount for a particular period is 0.00.

Steps to Duplicate:

In [SOA] company:

Expand General Ledger, Maintenance, Maintain Budgets.
Click the 'Account' navigator button and select GL Account Number = "7400-00-00-00".
Click the 'Columns' button. Select Actual = Base and Comparison = Current Budget.
Select 2008 from the 'Fiscal Year' dropdown. Note: Current Budget Amounts have been entered for each Period of 2008 but Actual Amounts have only been updated in some periods. There are multiple periods were the Actual Amount are 0.00 but a Budget for that period has been entered.
Expand the MAS Intelligence Task in MAS 500.
Open the Tools folder and Double-Click on Report Manager (Consolidations).
Expand the Designer Folder and highlight the report called "Consol. Financial Reports Designer 2-0 (MAS 500).
Click the Run button.
Select "Canadian Inc." and "Systems of America" in the 'Company Name' field. Enter 2008 for the 'Financial Year' and 2 - Current Budget for the 'Budget Set'.
Click 'OK'.
Click on the 'BI Tools' tab. Click on 'Quick Generate' and select 'IS-Actual vs Budget'.
Locate the Row for GL Account "7400000000" in the 'IS-Actual vs Budget' Worksheet.
Scroll to the right and note Periods 3, 4 through 12. Note: 0.00 displays in the Budget Column when the Actual Amount is Zero.

Expected Behavior:

The Budget Amounts should display on the Income Statement MAS Intelligence Consolidated Reports for each Period regardless of the Actual Amounts posted to that GL Account for that period.

Possible Workaround:

In FRx Report Designer:

Use FRx to create a Consolidated Company Report that will compare the Actual Book Code to the Current Budget Book Code.