APPX Software Library

5Graphs and Spreadsheets

Option 2Budgets by Quarter

This function creates a print file of net quarterly budget balances for an account/fiscal year and a budget type that is readable by graphics utility software. The following processing steps accomplish this job.

  1. Step 1This function allows you to enter an account number, a fiscal year, and a Budget Type as parameters for the Budgets by Quarter graph.

The screen shown below allows you to enter parameters needed for the Budgets by Quarter graph.

Budgets by Quarter screen

The Budget Analysis Budgets by Quarter Screen
Figure 24

Data items for the preceding screen are described below:

Budget Type

Alphanumeric, up to 12 characters Required Scan available

Identify the budget type of the budget record to be graphed. The budget type must be on file in the Types file.

Account

Upper case, up to 12 characters Required Scan available

Identify the single account, summary account balance, or account number of the budget amount to be graphed. The account must be on file in the Chart of Accounts.

Fiscal Year

Positive number, up to 2 digits

Supply the fiscal year of the account balance or budget amount to be graphed. The combination of account number and fiscal year must be in the Account Balances file, or the combination of Budget Type, account number, and fiscal year must be in the Budget Amounts file.

The entered data is validated. During validation, including access to other files, conditions may be found which cause messages to be displayed. Errors (E), Warnings (W), and Messages (M) that may result are shown below:

  • EBudget Type/Account/Fiscal Year Not on File

Press ENTER to display system-supplied information and then press ENTER again to save the information on this screen.

  1. Step 2This disposition is used for all graphics output functions.
  2. Step 3In order to print the Budgets by Quarter graph, this step formats the necessary parameters. The following data items are shown: Account, Description, Budget Type, Fiscal Year, Fiscal Quarter, and Amount.

A sample output is shown below.

Account 4110000000
Travel and Entertainment
Type FY89 Budget   Fisc Year 89

                       Net:

1Q89              60840.63
2Q89              57107.06
3Q89              53011.50
4Q89              54158.70