Financial Accounting Systems

Auto Reconciliation (AM18009 - Revision)

Summary

  • Objective for Revision
  • Modification Details and Criteria
  • Data File Layout- AUTOREC11200
  • Entry Type

    Objective for Revision

    The daily reconciliation process relies heavily on the summarized report (AM18009TOTAL) created by the AM18009 program. This program will therefore be our focus today for data extraction to a flat file. The data extract should be specific to manual worksheet criteria, and complete. Every detail obtained from AM18009TOTAL to balance the reconciliation worksheet should be extracted to the datafile. Go to Modification Details & Criteria

    Modification Details & Criteria

  • Output File(AUTOREC/AM18009)
    The output file should be created as VALUE "AUTOREC18009"
    The FD NAME = AUTOREC-REPORT.
    The record name = AUTOREC-OUT.

  • Specific Coding for All reports Every detail record posted into the AM18009 should have an entry-type value unique to it's own report group. For example Rpt 111 should only have one "TOTAL-LIQ" and etc. Determine entry-type value for each detail record posted according to the entry-type table.

  • Focus Loop (#####-END-R##) The Sum-Total-Report(AM18009TOTAL) is primarily processed in the #####-END-R## loop (eg: Rpt 110 = 61059-END-R10. Adding a perform loop in the #####-END-R## should allow us to accumulate the data neccessary for auto reconciliation.

    Focus Loops in AM18009
    Report #Specific Coding Detail
    RPT 11061059-END-R10
    RPT 11161181-END-R11
    RPT 11261274-END-R12
    RPT 11361390-END-R13
    RPT 11461490-END-R14
    RPT 11561559-END-R15
    RPT 11661690-END-R16
    RPT 11761790-END-R17
    RPT 11861890-END-R18 -- NO GO TO
    RPT 11961990-END-R19
    RPT 12062090-END-R20
    RPT 12162181-END-R21
    RPT 12262281-END-R22
    RPT 12462490-END-R24
    RPT 12562581-END-R25
    RPT 13263290-END-R32
    RPT 13363390-END-R33
    RPT 13463490-END-R34
    RPT 13863890-END-R38
    RPT 13963990-END-R39
    RPT 14064090-END-R40
    RPT 14164190-END-R41
    RPT 14264290-END-R42
    RPT 14664690-END-R46
    RPT 14864890-END-R48

    File Layout - AM18009/AUTOREC

    HEADER RECORD
    Data ElementPosition Value
    File Code001-003 "RP0"
    Filler004-005 spaces
    Process Date006-011yymmdd-from control parameter
    Accounting Month012-013from control parameter
    File Present Flag014-014 "1" or "0"
    Accrual Ind015-015from control parameter
    Filler016-end spaces

    DETAIL RECORD
    Data ElementPosition Value
    File Code001-003"RP1"
    Report Number004-006Spaces
    Fund Number007-009Spaces
    Entry Type010-030Spaces
    Autorec-Amount031-043from control parameter
    Filler044-044Spaces

    HASH RECORD
    Data ElementPosition Value
    File Code001-003"RP9"
    Total Records004-010Zero
    Filler011-040Spaces

    Entry Type

    Go to Entry Type Table