AP161 – Electronic Payment File Creation
- System
- Accounts Payable (AP)
- Type
- Batch program
- Updates
- 15 tables
- References
- 45 tables
AP161 (Electronic Payment File Creation) is a Lawson Accounts Payable batch program. It updates ADDRDATA, APELECTID, APMONITOR, APPAYGROUP, APPAYMENT, APPROCLEV, CBBANKENT, CBBANKINST and 7 more and references APCOMMENTS, APCOMPANY, APCONTACT, APDRAFTS, APINUSRFLD, APINVOICE, APPMTBOD, APPROCGRP and 37 more.
About AP161
Run Electronic Payment File Creation (AP161) to create an electronic payment transfer file to pay scheduled invoices for vendors defined to be paid by electronic payment. The form creates a flat file that contains payment data and remittance information. - For the Electronic, SWIFT, and ETEBAC file formats, you can map the flat file data to the electronic payment standard you use. - For country-specific formats (for example, Germany's DTAUS and DTAZV formats), the flat file is created in the applicable format. Select a process group if you want to process payments concurrently. This allows you to balance the load. You can run the form multiple times. Enter a different file name on the File Name tab to avoid overwriting the first file. Run AP161 for each cash code processed by Cash Requirements (AP150). Lawson EDI for Supply Chain Management can be used to translate the AP161 output to EDI X12 820 format. AP161 does create the tape file in the EDI 820 format.
Updated files (15)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| APELECTID | Electronic Transfer ID | AP |
| APMONITOR | Accounts Payable Monitor | AP |
| APPAYGROUP | Pay Group | AP |
| APPAYMENT | Invoice Payment | AP |
| APPROCLEV | Accounts Payable Process Level | AP |
| CBBANKENT | Bank | CB |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCASHFORM | Cash Payment Format | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBPAYMENT | Cash Payment | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
Referenced files (45)
| Table | Description | System |
|---|---|---|
| APCOMMENTS | Comments | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APDRAFTS | AP Bill of Exchange | AP |
| APINUSRFLD | AP Invoice User Fields | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APPMTBOD | No description in the Lawson data dictionary | AP |
| APPROCGRP | Process Group | AP |
| APPROCLEV | Accounts Payable Process Level | AP |
| APUSER | Pay Group User | AP |
| APUSRCLASS | Pay Group User Class | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCLASS | Vendor Class | AP |
| APVENLCBOD | No description in the Lawson data dictionary | AP |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| CBCCGRP | Cash Code Group | CB |
| CBCCTRNJB | Cash Code Journal Book | CB |
| CBCPYCASH | Company-Cash Code Relationship | CB |
| CBGRPCC | Cash Code Group Cash Codes | CB |
| CBMXVALUE | Cash Code Attribute Value | CB |
| CBPMTCAT | No description in the Lawson data dictionary | CB |
| CBRECPTHDR | Cash Receipt Deposit | CB |
| CBTRANS | Bank Transaction | CB |
| CBTRANSBOD | No description in the Lawson data dictionary | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| CUCODES | Currency Codes | IF |
| EEADVANCE | Employee Advance | AP |
| EEEXPENSE | Employee Expense | AP |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCODES | General Ledger Codes | IF |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MAREASONCD | Matching Reason Code | MA |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| TXCOMPANY | Tax Company | TX |
| VBABOD | No description in the Lawson data dictionary | AP |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (12)
ACAC, ACTA, API3, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU