General Ledger Batch Processes

The following diagram illustrates the basic nightly batch processes.

GL Batch Processing.png

Following is a list and short explanation of the batch processes available in the General Ledger. Batches are scheduled and/or unscheduled. Scheduled batches will run nightly and unscheduled jobs must be manually scheduled or run. All jobs have unscheduled versions so they can be run on demand during testing or when needed. Unless noted, all jobs are scheduled.

 

GL Batch Processes

Job Name

Description

balanceForwardJob

This unscheduled year end job creates a file that contains the next years beginning balances. Run this job after nominalActivityClosingJob has been run and entries posted. The file is placed in the staging/gl/OriginEntry directory and can be viewed via the Batch File and loaded for processing via the General Ledger Correction Process.

clearPendingEntriesJob

This job clears the general ledger pending entries from the documents that are in an approved or processed state when this job is run. This job is run after the Poster job.

collectorJob

This job validates and converts the xml and flat file collector files that are in the staging/gl/collector (xml and flat) file directories to the General Ledger file format and places them in the staging/gl/originEntry directory for processing.

detectMissingEntriesJob

This job compares the entries in the General Ledger to approved Kuali Financials documents and notifies specified individuals if entries are missing for the document.

encumbranceForwardJob

This unscheduled year end job creates a file to roll forward specified encumbrances to the following year.  This job can be run on the same day that nominalActivityClostingJob is run. The file is placed in the staging/gl/OriginEntry directory and can be viewed via the Batch File and loaded for processing via the General Ledger Correction Process.

enterpriseFeedJob

This job processes files dropped in the staging/gl/enterpriseFeed directory and places them into the staging/gl/originEntry directory. Format of the file is described below in the Enterprise Feed Upload.

manualPurgeJob

This unscheduled job purges data from the General Ledger Account Balances, ID Billing Detail, Encumbrances, Entry and Sufficient Funds Balances tables prior to the year listed in parameters PRIOR_TO_YEAR; namespace code  is KFS-GL.

nightlyOutJob

This job collects entries from the General Ledger Pending Entry table that have an approved or processed status at the time the job is run. A file is created in the General Ledger format and placed in the staging/gl/originEntry directory for processing.

nominalActivityClosingJob

This unscheduled yearend job creates a file to close revenues and expenses to fund balance. It should be run before balanceForwardJob is run. The file is placed in the staging/gl/OriginEntry directory and can be viewed via the Batch File and loaded for processing via the General Ledger Correction Process.

organizationReversionCurrentYearAccountJob

This unscheduled yearend job runs against the current year account table to create organization reversion and carry forward entries. The file is placed in the staging/gl/OriginEntry directory and can be viewed via the Batch File and loaded for processing via the General Ledger Correction Process. Typically run prior to fiscal year end.

organizationReversionPriorYearAccountJob

This unscheduled yearend job runs against the prior year account table to create organization reversion and carry forward entries. The file is placed in the staging/gl/OriginEntry directory and can be viewed via the Batch File and loaded for processing via the General Ledger Correction Process. Typically run after fiscal year end.

posterBalancingHistorySyncJob

This unscheduled job rebuilds the history tables based on current entries and balances and create as new starting place for future comparisons in the event that errors discovered by the posterBalancingJob require a refresh.

posterBalancingJob

This job builds a series of entry and balance tables that are synched with the General Ledger. Thereafter, the process uses these history tables, adding transactions from each nightly batch cycle.

posterJob

This job performs a final validation, updates the balance tables and posts the transactions to the General Ledger. Reversing, ICR actuals and encumbrance, and bank offset entries are created and posted. Invalid transactions are demerged and are available for correcting via the General Ledger Correction Process.

scrubberJob

This job does an initial validation, posts entries to continuation accounts, generates offsets, creates capitalization, plant indebtedness, cost share transfers actuals and encumbrances. Invalid transactions are demerged and are available for correcting via the General Ledger Correction Process.

sufficientFundsAccountUpdateJob

This job updates the sufficient funds balance table.

Set parameter FISCAL_YEAR (Component SufficientFundsAccountUpdateStep) to the current Fiscal Year.

sufficientFundsFullRebuildJob

This is an unscheduled job and when run, empties the sufficient funds balances table and repopulates the tables. This job is run when the sufficient funds balance table needs to be reset.

More:

balanceForwardJob

collectorJob

detectMissingEntriesJob

encumbranceForwardJob

enterpriseFeedJob

nightlyOutJob

nominalActivityClosingJob

organizationReversionJobs

posterBalancingJob

posterJob

scrubberJob

sufficientFundsAccountUpdateJob

sufficientFundsFullRebuildJob