APPX Software Library

5Graphs and Spreadsheets

Option 1Budgets by Month - Net

This function creates a print file of net monthly budgets for an account/fiscal year and 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 Month - Net graph.

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

Budget By Month - Net screen

The Budget Analysis Budget By Month - Net Screen
Figure 23

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 Month - Net graph, this step formats the necessary parameters. The following data items are shown: Account, Description, Budget Type, Fiscal Year, Month Descriptor, and Budget Amount.

A sample output is shown below.

Account 4080000000
Salaries Expense
Type FY89 Budget   Fisc Year 89

             Net:

Jun     20898.15
Jul     23985.69
Aug     25001.27
Sep     25634.82
Oct     25625.19
Nov     14879.11
Dec     27967.87
Jan     25629.32
Feb     25814.03
Mar     25906.24
Apr     26326.65
May     15896.32