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

When running the Financial Reports 2-0 (MAS 500) 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 ERP MAS 500

Application: Sage MAS Intelligence

Version Reported: SMI 1.00.0073 - MAS 500 7.30

Status:

This issue is being researched by Engineering.

Subject:

When running the Financial Reports 2-0 (MAS 500) 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 = "7400-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 Financials Folder and highlight the report called "Financial Reports 2-0(MAS 500).
  8. Click the Run button.
  9. Enter 2008 for the 'Financial Year' and 2-SOA Current Budget for the 'Budget Set'.
  10. Click 'OK'.
  11. From Excel click on the 'Catagories' sheet
  12. Assign GLCatCode 20 Current Assets for all Account Group Codes
  13. From Excel click on the 'MENU' sheet
  14. Locate "Actual 1-12/ Budget 1-12 & YTD Annual Budget" and click  "Income Statement" button
  15. Click "OK" at New Sheet Name
  16. Locate the Row for GL Account "7400000000" in the New Sheet Created
  17. 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 Reports for each Period regardless of the Actual Amounts posted to that GL Account for that period

Possible Workaround:

None