SFSD Revenue and Expense Generator

This Add-On Module for MyFUNDamentals is used to generate defined revenue and/or expenditure records based on the summary of any linked revenue or expenditure sub accounts. The formula used for record generation consists of a user defined operator, a user defined rate (depending on the operator), and one or more selected revenue or expenditure sub accounts. This utility is useful for the following situations:

For example, Annual Salary and Wages may have been converted from 12 months to 10 months using a special utility. All Employee Benefits sub accounts have a clear relationship, or rate, tied to Salary and Wages. This utility can apply a user defined operator and rate to use in the target record generation.

Valid operators are:

The utility may be run for a single month, or all months consecutively.

Main Screen


Step by Step:
  1. Select the option to generate revenues and/or expenditures for All Months, or select a single Month from the drop box.
  2. Click the Start button.

Setup Part 1:

Setup Screen Part 1


Step by Step:
  1. Select a Target Sub Account from the drop down selection box in the first column
  2. Select an Operator from the drop down selection box in the Operator column
  3. Enter a Rate (numerical only) (up to 4 decimal places) note: no rate is needed for the Deferred Allocation operator.

Setup Part 2:

Setup Screen Part 2


Step by Step:
  1. Select a Generated Sub Account from the drop down selection box
  2. Enter a Selection Filter if required. The Selection Filter should contain a valid SQL Where Clause. Please consult with Visual Solutions for more details on this setting.
  3. Select a Target Site from the drop down selection box. The default option is 'Originating Site' which effectively includes any school or administrative center having source records. If the operation is specific to a single cost center, then that cost center would be selected.
  4. The next step depends on the Operator used for the currently selected Generated Sub Account
  5. Click Update to Save any changes.