AP170 – Payment Closing
- System
- Accounts Payable (AP)
- Type
- Batch program
- Updates
- 52 tables
- References
- 76 tables
AP170 (Payment Closing) is a Lawson Accounts Payable batch program. It updates ACCOMMIT, ACCOMMITX, ACTRANS, ADDRDATA, AMCONTROL, AMINTER, AMINTERAU, AMRPRINTER and 44 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 68 more.
About AP170
Run Payment Closing (AP170) to complete a cash payment cycle for a pay group. This is the last form in the payment cycle. Make sure you are satisfied with your cash payment run before you close the payment cycle. Once you close the cash payment cycle, you cannot reprint bad payment forms or recreate a payment tape or electronic payment file. AP170 creates a summary payment listing, a listing of recurring invoices, and a summary of general ledger transactions. **Processing Effect AP170 creates general ledger entries for cash, discount, reportable income withholding, currency gain and loss, and payment accrual transactions. If a recurring invoice was processed in the payment cycle, AP170 creates the next recurrence. If a prepayment or employee advance was processed, AP170 creates the offsetting credit memo. AP170 removes temporary hold codes from vendors and invoices, updates vendor balances to reflect payments made, and changes paid invoices to historical status making them unavailable for further maintenance. AP170 also creates offsetting tax recovery entries, if applicable.
Updated files (52)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ACTRANS | Activity Transaction | AC |
| ADDRDATA | Address Code | IF |
| AMCONTROL | Asset Internal Control | AM |
| AMINTER | Asset Interface | AM |
| AMINTERAU | Asset Interface Audit | AM |
| AMRPRINTER | Asset Repair Interface | AM |
| APASTDTL | Asset Detail | AP |
| APBATCH | Batch | AP |
| APDISTRIB | Invoice Distribution | AP |
| APDSUSRFLD | Accounts Payable User Fields | AP |
| APFRIEXP | No description in the Lawson data dictionary | AP |
| APHLDINV | Hold | AP |
| APINUSRFLD | AP Invoice User Fields | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APMONITOR | Accounts Payable Monitor | AP |
| APPAYMENT | Invoice Payment | AP |
| APRPTBLINC | No description in the Lawson data dictionary | AP |
| APUAVAL | No description in the Lawson data dictionary | AP |
| APVENBAL | Vendor Balance | AP |
| APVENMAST | Vendor Master Record | AP |
| 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 |
| CBPAYMENT | Cash Payment | CB |
| CBTRANS | Bank Transaction | CB |
| CBTRANSAUD | No description in the Lawson data dictionary | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| 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 |
| ICLOCATION | Company Location | IC |
| INRPTTBL | No description in the Lawson data dictionary | TX |
| JBKSEQNBR | Journal Book Sequence Number | GL |
| PWEXPENSE | No description in the Lawson data dictionary | PW |
| SUBCKPOINT | Subledger Check Point | IF |
| SYSTEMCODE | System Code | IF |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
| TXTAXTRAN | Tax Transaction | TX |
Referenced files (76)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBUDHDR | Activity Budget Header | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCONSOL | Activity Consolidation | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACTRANS | Activity Transaction | AC |
| AMTEMPLATE | Asset Template | AM |
| APACCRCODE | Invoice Accrual Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APDISCCODE | Discount Code | AP |
| APDRAFTS | AP Bill of Exchange | AP |
| APHOLDCODE | Hold Code | AP |
| APPAYCOREL | Pay Group-Company Relationship | AP |
| APPAYGROUP | Pay Group | AP |
| APPMTBOD | No description in the Lawson data dictionary | AP |
| APPROCGRP | Process Group | AP |
| APPROCLEV | Accounts Payable Process Level | AP |
| APSECWTH | No description in the Lawson data dictionary | AP |
| APUSER | Pay Group User | AP |
| APUSRCLASS | Pay Group User Class | AP |
| APUSRFLDEF | AP User Field Definition | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENCLASS | Vendor Class | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLCBOD | No description in the Lawson data dictionary | AP |
| APVENLOC | Vendor Location | AP |
| APWTHCODE | Income Withholding Code | AP |
| CBADJUST | Reconciliation Adjustment | CB |
| CBAUTONBR | No description in the Lawson data dictionary | CB |
| CBBALANCE | Bank Account Balance | CB |
| CBCASHFORM | Cash Payment Format | CB |
| CBCCTRNJB | Cash Code Journal Book | CB |
| CBRECPTHDR | Cash Receipt Deposit | CB |
| CBSTATEMNT | Reconciliation Statement | CB |
| CBSTMTDTL | Cash Staement Detail | CB |
| CBTRANSBOD | No description in the Lawson data dictionary | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| CUACCT | Currency Gain and Loss Account | IF |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| ETEMPVEN | No description in the Lawson data dictionary | ET |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBHEADER | Budget Header | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCODES | General Ledger Codes | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| GMFNDACT | Grant Eligible Activities | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MACOMPANY | Matching Company | MA |
| MAFRXREF | No description in the Lawson data dictionary | MA |
| PODOCREF | Document Reference | PO |
| PURCHORDER | Purchase Order Master | PO |
| TXTAXRATE | Tax Rate | TX |
| VBABOD | No description in the Lawson data dictionary | AP |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (21)
ACAC, ACTA, API4, GLCC, IFAC, IFAU, IFCU, IFFC, IFGT, IFJR, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, SLFD, SLSB, SLSE, SLSS, SLSU