AP150 – Cash Requirements
- System
- Accounts Payable (AP)
- Type
- Batch program
- Updates
- 34 tables
- References
- 70 tables
AP150 (Cash Requirements) is a Lawson Accounts Payable batch program. It updates ADDRDATA, APAPPROVAL, APAUDIT, APCOMMENTS, APCONTACT, APCPYVND, APHLDINV, APINVOICE and 26 more and references APACCRCODE, APAPIHIST, APAPPROVAL, APAUTHOR, APCOMPANY, APCONTACT, APCPYVND, APDISCCODE and 62 more.
About AP150
Run Cash Requirements (AP150) to schedule released invoices for payment. Use the Main tab to define required parameters for the form. Use the Select Options tab to define options used to restrict which invoices are scheduled for payment. Use the Sort Options tab to define options used for sorting payments. When the quantity of invoices exceeds 9999 invoices, the program will create a new payment record. **Processing Effect AP150 uses the Pay Thru Date and Payment Date you define to schedule invoices for payment and determine whether invoice discounts are taken. It also uses the Payment Date to revalue non-base currency invoices. AP150 schedules all invoices that have a due date on or before the Pay Thru Date you define. Invoices marked for immediate payment are scheduled regardless of their due dates. The Payment Date you define determines whether the application takes invoice discounts. If you select the Take All Discounts option, AP150 takes the available discount on all invoices scheduled for payment regardless of their discount dates. If there are multiple invoices for a client, AP150 creates three payment records and three separate checks will be cut for the vendor. The form creates a listing of the number of payments scheduled, calculated gain and loss amounts to be transferred to the general ledger by AP170 (Payment Closing), and amount of discounts lost by vendor. The listing also indicates which individual payments are for pay vendors that share multiple invoiced vendors. **Troubleshooting If AP150 schedules invoices for payment that you do not want scheduled in the current payment cycle, you have several options to prevent the invoices from being selected. Make changes and rerun AP150 as many times as you need until the listing includes only the invoices you want scheduled for payment. - Change invoice due dates or discount dates in AP30.3 (Payment Schedule Adjustment). Re-run AP150. - Place selected invoices or vendors on hold in AP40 (Hold Selection).Re-run AP150. - Assign a user-defined invoice group to the invoices you want scheduled for payment in AP30.3 (Payment Schedule Adjustment). Run AP150 for the invoice group. - Assign a pay immediately indicator to the invoices you want scheduled for payment in AP30.3 (Payment Schedule Adjustment) or AP40.1 (Invoice Hold Selection). Run AP150 with Yes in the Pay Immediately Only field.
More information: After AP150 creates a satisfactory listing with Yes in the Update field, run AP155 (Payment Forms Creation), AP160 (Payment Tape Creation), or AP161 (Electronic Payment File Creation).
Updated files (34)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| APAPPROVAL | Invoice Approval | AP |
| APAUDIT | Vendor Invoice Audit | AP |
| APCOMMENTS | Comments | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APHLDINV | Hold | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APMONITOR | Accounts Payable Monitor | AP |
| APPAYMENT | Invoice Payment | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| APVENPAY | No description in the Lawson data dictionary | AP |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBCPYCASH | Company-Cash Code Relationship | CB |
| CBPAYMENT | Cash Payment | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUSTDESC | AR Group Customer | AR |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| JBKSEQNBR | Journal Book Sequence Number | GL |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| POPOVUF | No description in the Lawson data dictionary | PO |
| POVENDLOC | Vendor Location Master | PO |
| POVENDOR | PO Vendor Master | PO |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (70)
| Table | Description | System |
|---|---|---|
| APACCRCODE | Invoice Accrual Code | AP |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPROVAL | Invoice Approval | AP |
| APAUTHOR | Authority Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APDISCCODE | Discount Code | AP |
| APDISTHDR | Distribution Code Header | AP |
| APDRAFTS | AP Bill of Exchange | AP |
| APHOLDCODE | Hold Code | AP |
| APINCCODE | Income 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 |
| APSECWTHRT | 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 |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENCLASS | Vendor Class | AP |
| APVENLCBOD | No description in the Lawson data dictionary | AP |
| APVENLOC | Vendor Location | AP |
| APVNMXVAL | No description in the Lawson data dictionary | AP |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| CBBANKENT | Bank | CB |
| CBCASHFORM | Cash Payment Format | CB |
| CBCCGRP | Cash Code Group | CB |
| CBCCTRNJB | Cash Code Journal Book | CB |
| CBGRPCC | Cash Code Group Cash Codes | CB |
| CBMXVALUE | Cash Code Attribute Value | 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 |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| EEADVANCE | Employee Advance | AP |
| EEAPPROVAL | Expense Advance Approval Code | 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 |
| INSTREGN | Intrastat Region Code | TX |
| MAINVHAND | Invoice Handling Code | MA |
| MAMATCHTBL | Match Table | MA |
| MAMSGTOL | No description in the Lawson data dictionary | MA |
| MAMTCHRULE | Matching Rules | MA |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| POAOCDTL | Add On Cost Detail | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POVAGRMTHD | Vendor Agreement | PO |
| POVENDLOC | Vendor Location Master | PO |
| PROCUREGRP | Procurement Group | 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 (11)
ACAC, ACTA, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU