CB191 - Bank Statement Close

After you enter and release all transactions associated with a bank
statement, run CB191 (Bank Statement Close) to close the bank statement. This
is required for cash codes that have Yes selected in the Reconciliation
Statement Required field in CB00.2 (Cash Code).

The program evaluates cash ledger transactions associated with a specific bank
statement number. If the total transaction amount is correct for the beginning
and ending balances defined for the bank statement in CB06.1 (Bank Statement),
the program updates the transaction records with a Statement Closed status and
updates the statement record with a Closed status.



Updated Files

    ACCOMMIT   - Contains commitments not yet posted to the general ledger.

    ACCOMMITX  - Contains commitments posted to the general ledger, but not yet
                 posted to the Activity management system.


    APMONITOR  - Contains job completion status records.

    APPAYMENT  - Contains all multiple (split invoice) payment records in the
                 Lawson Accounts Payable system.


    ARAPPLIED  - Contains application records which serve as linking or audit
                 records for each application made.


    ARCUSTOMER - Maintains and validates customer information.

    ARCUSTPER  - Contains period end totals for a customer.

    ARDISTRIB  - contains distribution records for every transaction that will
                 be posted to the General Ledger system through the Lawson
                 Accounts Receivable system.


    ARPAYMENT  - Contains the detail payment records entered for a given batch.

    ARPYMNTHDR - Contains the batch header information for payments entered
                 into the system.


    ARSUMMARY  - Contains totals by process level of accounts receivable
                 activity.


    ARUDISTRIB - Updates user analysis information.

    ARUPMNTHDR - Updates user analysis information.

    CBBANKENT  - Validates that a bank record exists.

    CBBANKINST - Validates that a transaction code exists.

    CBCASHCODE - Validates cash code and updates used flag.

    CBCHECK    - Contains all accounts payable cash payment records for a cash
                 code (bank account).


    CBCPYCASH  - Validates the relationship between a company and a cash code
                 and updates the used flag.


    CBDISTRIB  - Creates cash ledger distribution records.

    CBSTATEMNT - Validates a cash ledger statement exists.

    CBTRANS    - Creates cash ledger transaction records.

    CKPOINT    - Used to store restart information.

    CUSTDESC   - Contains customer master records.

    NATBALANCE - Contains summary information for a national account customer.

    TXCODEMAST - contains tax codes, descriptions, and the tax types that
                 define how the tax code is to be used.


    TXCOMPANY  - Validates Tax companies.

    TXTAXCODE  - Validates tax codes.

    TXTAXTABLE - Contains tax table records.

    TXTAXTRAN  - Contains all tax transaction records created for the Lawson
                 Tax system by the Accounts Payable, Accounts Receivable,
                 Billing, Cash Ledger, and Employee Advance and Expense systems.



Referenced Files

    ACACCTCAT  - Contains information on account categories.

    ACACTGRP   - Contains activity group information.

    ACACTIVITY - Contains activity setup and definition information.

    ACCAL      - Contains activity calendar header information.

    ACCALX     - Contains activity calendar detail information.

    APACCRCODE - Contains invoice accrual codes.

    APCOMPANY  - Validates AP company information.

    APCPYVND   - Contains default vendor codes at the company level.

    APHLDINV   - Contains records of vendors, invoices, and payments that are
                 on hold.


    APVENCLASS - Contains all vendor class records for a vendor group.

    APVENGROUP - Contains all vendor group records in the Accounts Payable
                 system.


    APVENMAST  - Contains vendor records, including one-time vendors defined
                 during invoice entry.


    ARCODE     - Validates AR codes.

    ARCOMP     - Contains the Accounts Receivable company records.

    AROIHDR    - Contains the header record for all invoices and debit memos in
                 the Accounts Receivable system.


    AROITEMS   - Maintains open item records.

    ARSADJUST  - Contains adjustment information for open items that have been
                 selected for cash application, but not yet processed into
                 adjustment records.


    ARSAPPLIED - Contains the cash application select records that have been
                 selected but not yet processed into application records.


    CBADJUST   - Used to determine if any cash ledger adjustment records exist.


    CBBALANCE  - Validates that an account balance records exists.

    CBSTMTDTL  - Maintains detail records for bank transactions entered on the
                 bank statement.


    CBUSER     - Validates user can access cash code.

    CBUSRCLASS - Validates all users for cash code.

    CUCONV     - Maintains exchange rate information.

    CURELAT    - Validates currency relationship.

    CUSTORDER  - Maintains a record for every order entered in the Lawson Order
                 Entry system.


    GLADDRESS  - Referenced by general ledger common routines.

    GLCHART    - Referenced by general ledger common routines.

    GLCODES    - Referenced by general ledger common routines.

    GLSYSTEM   - Referenced by general ledger common routines.

    NATACCT    - Contains national account records that identify payment
                 relationships between customers.


    OECOMPANY  - Stores the companies set up in the Lawson Billing system and
                 used in the Lawson Billing and Order Entry systems.


    SYSTEMCODE - Validates the system code updating the general ledger and
                 updates the object ID.


    TXTAXRATE  - Stores tax rates in effect for a specific tax code.

    WFSETUP    -


INVOKED Programs

    IFAC
    ACAC
    IFCR
    IFSG
    IFCU
    IFAU
    SLSE
    SLSU
    IFCC
    IFOB
    IFRS
    IFSC