Financial Accounting Systems

Auto Reconciliation (AM18840 - Revision)

Overview

AM18840 is part of the Online Financial Information System (OFIS). This batch program updates the TRANS-SUMMARY dataset with summary financial data used when accessing the on-line budget activity information. It is one of a series of programs executed within the JAMOFIS jobstream which normally run each time the nightly FAS batch process runs.

Objective of Revisions

The purpose of this revision is to extract control data which will be used in the daily reconciliation of the OFIS subsystem to the main Financial Accounting System.

The data extracted from this program will be used to verify that the total for each of these activity types: encumbrance, and actual, reported as posted to the TRANS-DETAIL dataset equals the same totals reported by the main financial accounting system's reporting process.

Encumb = AM18009-134 Encumbrances

Actual = AM18009-132 Revenue + AM18009-134 Expenditures

Note: Actuals are the sum of both expenditures and revenues.

Modifications

Add additional logic to the section which writes out the control report to create the following one line output-file:

LOCATION FIELD PICTURE VALUE SOURCE
         
001-003 File-Code x(03) "OS1"  
004-011 Process-Date x(08)   parameter
012-013 Month-Number x(02)   parameter
014-016 Run-Number x(03)   parameter
017-020 Filler x(04) spaces  
021-037 Filler x(17) spaces  
038-040 Filler x(03) spaces  
041-057 Enumb-Amt s9(15)v99   FAS-ENCUMB-HASH
058-060 Filler x(03) spaces  
061-077 Actual-Amt s9(15)v99   FAS-ACTUAL-HASH
078-090 Filler x(13) spaces