SFSD Expense Generator

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

An alternate record source for the desired expense sub account is either not available or not reliable and a clear relationship exists between the source(s) and result accounts.
The source(s) of the record generation have been generated or derived from a custom module, excluding a financial import.

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 + (plus), - (minus), *(multiplication), and /(division)"

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

Expense Generator Main Screen

Step by Step:

Select the option to generate expenditures for either All Months, or select a single Month from the drop box.
Click the Start button.

Setup:

Expense Generator Setup Screen

Step by Step:

Select a Target Expense Type from the drop down selection box in the first column
Select an Operator from the drop down selection box in the Operator column
Enter a Rate (numerical only) (up to 4 decimail places)
Select one or more Source Expenditure Sub Account(s) from the Source Expenditure Sub Accounts list box at the bottom of the screen.
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.