AP181 – Bill of Exchange Statement Update
- System
- Accounts Payable (AP)
- Type
- Batch program
- Updates
- 47 tables
- References
- 42 tables
AP181 (Bill of Exchange Statement Update) is a Lawson Accounts Payable batch program. It updates ADDRDATA, APAPDHIST, APAPIHIST, APAPPHIST, APAPSHIST, APASTDTL, APCRMEMO, APCRMHIST and 39 more and references APACCRCODE, APCOMPANY, APCONTACT, APDRFTCDES, APHLDINV, APPAYGROUP, APPMTBOD, APPROCLEV and 34 more.
About AP181
Run Bill of Exchange Statement Update (AP181) to - Update cashed and dishonored bills of exchange. - Create general ledger distribution records for bills of exchange that were cashed and dishonored. This will debit the bill of exchange acceptance account, credit the cash account, and create a cash ledger transaction for each new statement that was created by Bill of Exchange Cashing Statement (AP167) for this cash code since the last time AP181 was run. - Update vendor balances. **Process at a Glance When processing a cashed bill of exchange, AP181 changes the status of the invoices paid by the bill of exchange to historical. When processing a dishonored bill of exchange, AP181 reinstates the invoices associated with the dishonored bill of exchange. Depending on the reason the bill of exchange was dishonored, you can reschedule, maintain, or cancel the invoices. You can run AP181 only if you chose the Bill of Exchange Draft Statement option on the Options tab of Pay Group (AP01.1).
Updated files (47)
| 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 |
| APDFTSTMT | 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 | — |
| JBOOKHDR | Journal Book Header | IF |
| 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 |
| 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 |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JBKOPCODE | Journal Book Operator Code | IF |
| JBKSYSCODE | Journal Book System | IF |
| 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