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

Budget amounts are missing for G/L accounts in the Actual vs. Budget Income Statement in Financial Report Designer if the actual amount for a particular period is zero

Entry Type: Program Issue

Product: Sage MAS 500

Application: SMI Report Manager 

Version Reported: 7.30, SMI 1.0

Status:

This issue is being researched by Engineering.

Subject:

Budget amounts are missing for G/L accounts in the Actual vs. Budget Income Statement in Financial Report Designer if the actual amount for a particular period is zero

Steps to Duplicate:

In [SOA] company:

  1. Expand General Ledger and Maintenance. Double-click Maintain Budgets.
  2. Click the Account navigator button and select G/L account number 7400-00-00-00.
  3. Click the Columns button, and select the following:
    Note: Current budget amounts have been entered for each period of 2008 but actual amounts have been updated only in some periods. Multiple periods have an actual amount of 0.00 but still have a budget.
  4. Expand MAS Intelligence and Tools. Double-Click Report Manager.
  5. Expand the Designer folder and select one of the following reports:
  6. 18. Click the Run button.
  7. 19. Select the following and click OK:
  8. Click the BI Tools tab.
  9. Click Quick Generate and select IS-Actual vs. Budget.
  10. In the IS-Actual vs. Budget worksheet , locate the row for G/L Account "7400000000".
  11. Scroll to the right and in periods 3 and 4 through 12, note that 0.00 displays in the Budget column if the actual amount is zero

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 Workarounds:

In FRx Report Designer:

Use FRx to create a report that will compare the Actual Book Code to the Current Budget Book Code.

In Sage ERP MAS 500:

  1. Expand General Ledger, Maintenance, Maintain Financial Reports.
  2. Create a new Financial Report. Select Income Statement as the 'Report Type'. Select Income Stmnt - Actual, Budget and Varian as the 'Column Format'. Select FSFormat2.RPT as the 'Template.
  3. Select Current Budget for the Selection 'Budget Type'.
  4. In the Format Section, add a checkmark in Print Detail and Print GL Account Numbers.
  5. Save and Finish.
  6. To run report go to General Ledger, Insights, Report, Financial Reports.

Related Articles: