CB185 – Bank Tape Mass Reconciliation
- System
- Cash Ledger (CB)
- Type
- Batch program
- Updates
- 15 tables
- References
- 15 tables
CB185 (Bank Tape Mass Reconciliation) is a Lawson Cash Ledger batch program. It updates ADDRDATA, CBADJUST, CBBANKENT, CBBANKINST, CBCASHCODE, CBCONSOL, CBCPYCASH, CBDISTRIB and 7 more and references CBAUTONBR, CBBALANCE, CBCCGRP, CBGRPCC, CBUSER, CBUSRCLASS, CUCONV, CURELAT and 7 more.
About CB185
Run Bank Tape Mass Reconciliation (CB185) to reconcile or void banktransactions. Select from the following run options: - TAPE. Use this option to read records in the Tape file you load from a bank tape. The program reconciles or voids transactions loaded from the tape, and creates a listing of reconciled or voided transactions and an error report listing transactions that were not reconciled or voided. - MASS. Use this run option to reconcile or void all transactions within the transaction number range you define. All records are reconciled at the issued amount. - DATA INPUT. Use this option to reconcile all reconciled transactions you enter from a bank statement on Manual Reconciliation Entry (CB25.1). The program creates a listing of reconciled transactions and an error reportlisting transactions that were not reconciled. This program will not reconcile transactions that have a reconciled amount that is different from the issued amount beyond the reconciletolerances defined for the cash code on Company-Cash Code Relationships (CB00.3). Use Reconciliation Variance Adjustment (CB30.1) to create and release transaction adjustment distributions for the amount of the difference. Run Invoice Reinstatement (AP190) to reinstate accounts payable invoices associated with transactions you void in AP185.
Updated files (15)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| CBADJUST | Reconciliation Adjustment | CB |
| CBBANKENT | Bank | CB |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | 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 |
| CBRECON | Manual Reconciliation Entry | 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 |
| CKPOINT | No description in the Lawson data dictionary | — |
Referenced files (15)
| Table | Description | System |
|---|---|---|
| CBAUTONBR | No description in the Lawson data dictionary | CB |
| CBBALANCE | Bank Account Balance | CB |
| CBCCGRP | Cash Code Group | CB |
| CBGRPCC | Cash Code Group Cash Codes | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCODES | General Ledger Codes | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (11)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU