When running the Aggregated Financial Reports Designer 2-0, 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 Designer 

Version Reported: 7.30 

Status:

Resolved for Version 7.30 with hot fix PER 112347 / Dev 47237, and resolved for Version 7.40 with hot fix PER 11237 / Dev 47283.

Subject:

When running the Aggregated Financial Reports Designer 2-0, 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:

  1. Expand General Ledger, Maintenance, Maintain Budgets.
  2. Click the 'Account' navigator button and select GL Account Number = "1010-00-00-00".
  3. Click the 'Columns' button. Select Actual = Base and Comparison = Current Budget.
  4. Select 2008 from the 'Fiscal Year' drop down. 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.
  5. Expand the MAS Intelligence Task in MAS 500.
  6. Open the Tools folder and Double-Click on Report Manager.
  7. Expand the Aggregated Folder and highlight the Aggregated Financial Reports Designer 2-0 (MAS 500).
  8. Click the Run button.
  9. Select the following and click OK:
    • Financial Year = 2008
    • Budget Set = 2-SOA Current Budget
  11. Click 'OK'.
  12. In Excel, Unhide Sheet 1.
  13. Locate the Row for GLAcctNo = 1010-00.

Note the column "Per08BudgetAmount" through "Per13BudgetAmount" displays 0.00 when actual Budget amounts for these periods exist.

Expected Behavior:

Budget amounts should display for each period on the Income Statement in SMI reports even if the actual amounts are zero for that period.

Possible Workaround: