AP136 – Invoice Accrual Reconciliation
- System
- Accounts Payable (AP)
- Type
- Batch program
- Updates
- 6 tables
- References
- 19 tables
AP136 (Invoice Accrual Reconciliation) is a Lawson Accounts Payable batch program. It updates ADDRDATA, APAPIHIST, APINVOICE, APRECON, CBBANKINST and CKPOINT and references APACCRCODE, APAPDHIST, APAPPHIST, APCOMPANY, APDISCACC, APDISTRIB, APDRAFTS, APDRFTDIST and 11 more.
About AP136
Run Invoice Accrual Reconciliation (AP136) to print a report of invoice transactions that make up your invoice accrual account balance as of the date you specify. The report shows the difference between what has been paid and updated through Payment Closing (AP170) or Bill of Exchange Cashing Update (AP180), and what has been expensed through Invoice Distribution Closing (AP175) for each invoice accrual account. Each time you run AP170, AP175, or AP190, you should rerun AP136. The report includes the amount paid, amount distributed, and the difference for each invoice listed. The difference should equal the general ledger invoice accrual account balance as long as no adjustments have been made to the invoice accrual account through the General Ledger application and no transactions have been interfaced to the general ledger from other subsystems for the invoice accrual account specified. This form lists transactions in theAccounts Payable application only. ***Processing Effect To save time when this report is run, the invoice accrual code is included in the index that is used in AP136. The invoice transactions that are listed are those included in the accrual account as of the run date. *** More Information Amounts for the AP accrual code and retainage accrual code are reported separately. For AP Accrual Code (distributions for the invoice accrued amount), the reportincludes related payments that do not have the retainage flag set to "Yes". If the non-retainage payments equal the invoice amount less retainage, then the invoice portion accrued to the AP accrual code is considered paid and is not reported for the AP accrual code. For Retainage accrual code (distributions for the retainage accrual code), thereport includes related payments with retainage flag set to "Yes". Once the invoice is fully paid -- including full payment of the retained portion - Invoice Accrual Reconciliation (AP136) marks the invoice record withreconciliation date.
Updated files (6)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| APAPIHIST | Vendor Invoice History | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APRECON | Invoice Accrual Reconciliation | AP |
| CBBANKINST | Bank Transaction Code | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
Referenced files (19)
| Table | Description | System |
|---|---|---|
| APACCRCODE | Invoice Accrual Code | AP |
| APAPDHIST | No description in the Lawson data dictionary | AP |
| APAPPHIST | AP Payment History | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APDISCACC | Discount | AP |
| APDISTRIB | Invoice Distribution | AP |
| APDRAFTS | AP Bill of Exchange | AP |
| APDRFTDIST | Bill of Exchange Distribution | AP |
| APDSKHIST | No description in the Lawson data dictionary | AP |
| APPAYGROUP | Pay Group | AP |
| APPAYMENT | Invoice Payment | AP |
| APVENMAST | Vendor Master Record | AP |
| GLADDRESS | General Ledger Company Address | IF |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MACOMPANY | Matching Company | MA |
Program calls
Invoked programs (11)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU