AP180 – Bill of Exchange Cashing Update
- System
- Accounts Payable (AP)
- Type
- Batch program
- Updates
- 45 tables
- References
- 42 tables
AP180 (Bill of Exchange Cashing Update) is a Lawson Accounts Payable batch program. It updates ADDRDATA, APAPDHIST, APAPIHIST, APAPPHIST, APAPSHIST, APASTDTL, APCRMEMO, APCRMHIST and 37 more and references APACCRCODE, APCOMPANY, APCONTACT, APDRFTCDES, APHLDINV, APPAYGROUP, APPMTBOD, APPROCLEV and 34 more.
About AP180
Run Bill of Exchange Cashing Update (AP180) to create general ledger distribution records for bill of exchange activity that has occurred since the last running of AP180. This includes bills of exchange that have been cashed or dishonored. The form creates a listing of bills of exchange that have been cashed or dishonored. **Processing Effect If you select Yes in the Online Selection Only field, AP180 updates only bills of exchange marked as Cashed or Dishonored in AP80.1 (Bill ofExchange Cashing Selection). If you select No in the Online Selection Only field, AP180 automatically cashes bills of exchange that have a due date on or before the Due Date less the Margin Days you define. It also updates bills of exchange that you marked as Cashed or Dishonored in AP80.1 (Bill of Exchange Cashing Selection) as long as the bill of exchange due date falls on or before the Due Date less the Margin Days you define. When AP180 processes a cashed bill of exchange, it changes the status of the invoices paid by the bill of exchange to historical.
Updated files (45)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| APAPDHIST | No description in the Lawson data dictionary | AP |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPHIST | AP Payment History | AP |
| APAPSHIST | No description in the Lawson data dictionary | AP |
| APASTDTL | Asset Detail | AP |
| APCRMEMO | Credit Memo Application | AP |
| APCRMHIST | No description in the Lawson data dictionary | AP |
| APDFLHIST | No description in the Lawson data dictionary | 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 |
| APDSUSRFLD | Accounts Payable User Fields | AP |
| APHLDINV | Hold | AP |
| APINUSRFLD | AP Invoice User Fields | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APISRHIST | No description in the Lawson data dictionary | AP |
| APPAYMENT | Invoice Payment | AP |
| APUAVAL | No description in the Lawson data dictionary | AP |
| APUAVHIST | No description in the Lawson data dictionary | AP |
| APVENBAL | Vendor Balance | AP |
| 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 |
| CBTRANS | Bank Transaction | CB |
| CBTRANSAUD | No description in the Lawson data dictionary | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| MAAOCDTL | Invoice Add On Cost Detail | MA |
| MAAOIHIST | No description in the Lawson data dictionary | MA |
| MAINVDTL | Invoice Line Detail | MA |
| MAMAAHIST | No description in the Lawson data dictionary | MA |
| MAMADHIST | No description in the Lawson data dictionary | MA |
| MAPOINV | Multiple PO Invoice | MA |
| POAOCSPRD | Add On Cost Spread | PO |
| POPSPHIST | No description in the Lawson data dictionary | PO |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
| TXTAXTRAN | Tax Transaction | TX |
Referenced files (42)
| Table | Description | System |
|---|---|---|
| APACCRCODE | Invoice Accrual Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APDRFTCDES | Bill of Exchange Accrual Code | AP |
| APHLDINV | Hold | AP |
| APPAYGROUP | Pay Group | AP |
| APPMTBOD | No description in the Lawson data dictionary | AP |
| APPROCLEV | Accounts Payable Process Level | AP |
| APUSER | Pay Group User | AP |
| APUSRCLASS | Pay Group User Class | 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 |
| APVENMAST | Vendor Master Record | 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 |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBPAYMENT | Cash Payment | 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 |
| 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 |
| 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 (12)
ACAC, ACTA, APH1, API4, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU