CB82.1 – Statement Reconciliation
- System
- Cash Ledger (CB)
- Type
- Online screen — form 82
- Updates
- 26 tables
- References
- 22 tables
CB82.1 (Statement Reconciliation) is a Lawson Cash Ledger online screen (form 82, subform 1). It updates ACCOMMIT, ACCOMMITX, ADDRDATA, APMONITOR, CBADJUST, CBBANKENT, CBBANKINST, CBCASHCODE and 18 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, APCOMPANY, CBAUTONBR and 14 more.
About CB82.1
Use Statement Reconciliation (CB82.1) to manually apply (reconcile) the bankrecords in the CBTRANS file to records in the CBSTMTREC file. **Process at a Glance When accessing Statement Reconciliation (CB82.1), the screen will be split.The header is a reconciliation statement line that needs to be reconciled to CBTRANS records. The detail portion of the screen are the actual CBTRANS records. Select the CBTRANS records to be reconciled to the statement line by entering an "A" for Applied on the FC line. Then, perform a change to reconcile the CBTRANS records to the statement line. The application changes the status of the CBTRANS record to the function of the statement line (reconcile, void, or stop pay). Information from the statement line is then stored on the CBTRANS record to link it back to the statement record.
Updated files (26)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ADDRDATA | Address Code | IF |
| APMONITOR | Accounts Payable Monitor | AP |
| CBADJUST | Reconciliation Adjustment | CB |
| CBBANKENT | Bank | CB |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBCONSOL | This file is updated by a batch program that consolidated CBTRANS amounts by Cash Code/Bank Inst Code/Company. | CB |
| CBCPYCASH | Company-Cash Code Relationship | CB |
| CBDISTRIB | Transaction Distribution | CB |
| CBSTATEMNT | Reconciliation Statement | CB |
| CBSTMTDTL | Cash Staement Detail | CB |
| CBSTMTREC | No description in the Lawson data dictionary | CB |
| CBTRANS | Bank Transaction | CB |
| CBTRANSAUD | No description in the Lawson data dictionary | CB |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| SUBCKPOINT | Subledger Check Point | IF |
Referenced files (22)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| APCOMPANY | Accounts Payable Company | AP |
| CBAUTONBR | No description in the Lawson data dictionary | CB |
| CBBALANCE | Bank Account Balance | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| FBFUNDDTL | Budget Fund Detail | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCODES | General Ledger Codes | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| SYSTEMCODE | System Code | IF |
Program calls
Invoked programs (12)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, SLSE, SLSU