Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CB500


CB500 - Bank Transaction Interface

Run CB500 (Bank Transaction Interface) to interface or convert bank
transactions from a non-Lawson system to the Lawson Cash Ledger system. After
you load the appropriate bank transaction information into the Bank
Transaction Conversion file, you can run this program to edit the information
for completeness and accuracy. If the information passes all edits, new bank
transaction records will be created in the Lawson Cash Ledger system and the
corresponding records will be purged from the conversion file.

If this is your initial conversion, be sure to perform the following steps
after you successfully convert your non-Lawson bank transactions to the Lawson
Cash Ledger system.

1. Use CB99.1 (Bank Account Balance Update) to adjust the open and reconciled
balances of each bank account to include transactions not converted in the
current balances.

2. Run CB190 (Bank Period Close) for each bank account to update converted
bank transactions to a bank period and calculate new bank account balances.
Use the date of your last bank period.

3. Use CB99.2 (Bank Period Balance Update) to adjust the period ending
balance of each bank account to include transactions not converted and exclude
transactions converted for past periods. Use the period ending date you typed
in CB190.

Note: You must set up the following codes and information as valid records if
this information is to be converted as part of the bank transaction records:
cash codes in CB00.2 (Cash Code); process levels, vendors, and alternate
locations in the Lawson Accounts Payable system; and currency codes in the
Lawson Currency system.

Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    ADDRDATA   -

    CBBANKENT  - Used to validate bank and update used flag.

    CBBANKINST - Used to validate bank transaction code and update used flag.

    CBCASHCODE - Used to validate cash code and update used flag.

    CBCHECK    - Creates payment records.

    CBCPYCASH  - Used to validate company-cash code relationship and update
                 used flag.

    CBCTRANS   - Primary conversion file. Records are deleted from this file
                 after successful conversion or interface.

    CBDISTRIB  - Creates distribution records.

    CBSEGBLOCK -

    CBTRANS    - Creates bank transaction records.

    CKPOINT    - Used to store restart information.

    GLCOMMIT   -

    GLCOMMITX  -

    JBOOKHDR   -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  - Used to validate tax code and update last tax transaction
                 identification number.

    TXTAXTABLE - Used for tax calculations.

    TXTAXTRAN  - Creates tax transactions.


Referenced Files

    ACACCTCAT  -

    ACACCTCATX -

    ACACTGRP   -

    ACACTIVITY -

    ACBUDHDR   -

    ACCAL      -

    ACCATGRP   -

    ACCATGRPX  -

    ACCATSUM   -

    ACCATSUMX  -

    ACTRANS    -

    APACCRCODE -

    APCOMPANY  - Referenced by accounts payable common routine.

    APPAYGROUP -

    APVENGROUP - Referenced by accounts payable common routine.

    CBADJUST   - Referenced by bank transaction common routine.

    CBBALANCE  - Referenced by bank transaction object.

    CBCCGRP    -

    CBCTRANS   - Primary conversion file. Records are deleted from this file
                 after successful conversion or interface.

    CBGRPCC    -

    CBSTATEMNT -

    CBSTMTDTL  -

    CBUSER     - Validates user can access cash code.

    CBUSRCLASS - Validates all users for cash code.

    CUCONV     - Referenced by general ledger common routines.

    CURELAT    - Referenced by general ledger common routines.

    FBDETAIL   -

    FBFUNDAMT  -

    FBFUNDDTL  -

    FBHEADER   -

    GLADDRESS  - Referenced by general ledger common routines.

    GLAMOUNTS  -

    GLCHART    - Referenced by general ledger common routines.

    GLCHARTDTL - Referenced by general ledger common routines.

    GLCHARTSUM -

    GLCODES    - Referenced by general ledger common routines.

    GLMASTER   - Referenced by general ledger common routines.

    GLNAMES    - Referenced by general ledger common routines.

    GLSYSTEM   - Referenced by general ledger common routines.

    GLTRANS    -

    INSTCTRYCD -

    JBKACCT    -

    JBKOPCODE  -

    JBKSYSCODE -

    MXLISTMBR  -

    SYSTEMCODE -

    TXTAXRATE  - Used for tax calculations.

    WFSETUP    -


INVOKED Programs

    ACCL
    ACTA
    API4
    ACAC
    IFCU
    IFAC
    IFAU
    IFOB
    IFSG
    SLSE
    SLSU
    IFLU
    IFRS