|
|
CB500 - Bank Transaction Interface
**Form Purpose
Run Bank Transaction Interface (CB500) to import 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.
**Processing Effect
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.
**More Information
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 -
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 -
ACACTGRP -
ACACTIVITY -
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 -
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 -
JBKACCT -
JBKOPCODE -
JBKSYSCODE -
MXLISTMBR -
SYSTEMCODE -
TXTAXRATE - Used for tax calculations.
WFSETUP -
INVOKED Programs
ACCL
API4
ACAC
IFCU
IFSG
IFAC
SLSE
SLSU
IFOB
IFRS
|
