EX542 – Expense Creation
- System
- General Ledger Setup (IF)
- Type
- Batch program
- Updates
- 25 tables
- References
- 29 tables
EX542 (Expense Creation) is a Lawson General Ledger Setup batch program. It updates ACCOMMIT, ACCOMMITX, ACTRANS, ADDRDATA, APHLDINV, APPAYMENT, CKPOINT, EEEXPDTL and 17 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBRDNTRAN, ACCAL, ACCALX, ACCATSUMX and 21 more.
About EX542
If you use Lawson Travel Expense Management, run Expense Creation (EX542) to create expense report reimbursement records for Payroll or Accounts Payable expenses. IMPORTANT You will use this program only if you use Lawson Travel Expense Management (EXPM) with Lawson Enterprise applications (Accounts Payable, Payroll). When run with the Update Option field set to Update, EX542 creates: - Unreleased time records with a non-earning pay code for the employee expenses in Payroll. EX542 creates Payroll time (TIMERECORD) records. In orderto generate a payment, Payroll processing must complete in the Payroll (PR) system code. - Approved employee expense-type invoices in Accounts Payable. EX542 creates invoice (APINVOICE) records with invoice type E (Employee Expense) and distribution (APDISTRIB) records. Troubleshooting: Error message: Handling code must represent Expense type invoice. The default invoice handling code in Accounts Payable represents a non-expensetype invoice. Make sure that the Invoice Handling Code on Vendor (AP10) or Vendor Class (AP00.3) is an expense type code. Handling codes are defined on MA05.1. All fields must be set to No in order to be an expense-type invoice.
Updated files (25)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ACTRANS | Activity Transaction | AC |
| ADDRDATA | Address Code | IF |
| APHLDINV | Hold | AP |
| APPAYMENT | Invoice Payment | AP |
| CKPOINT | No description in the Lawson data dictionary | — |
| EEEXPDTL | No description in the Lawson data dictionary | AP |
| EEEXPHDR | No description in the Lawson data dictionary | AP |
| 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 |
| JBKSEQNBR | Journal Book Sequence Number | GL |
| JBOOKHDR | Journal Book Header | IF |
| PRSYSTEM | HR Company and Process Levels | HR |
| SUBCKPOINT | Subledger Check Point | IF |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (29)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACBRDNTRAN | The Burden Transactions file is updated by the Activity Posting (AC190) program. | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| APACCRCODE | Invoice Accrual Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APVENGROUP | Vendor Group | AP |
| CTXMMCR | No description in the Lawson data dictionary | AP |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| EEADVAPP | No description in the Lawson data dictionary | AP |
| EMPLOYEE | Employee | HR |
| FBFUNDDTL | Budget Fund Detail | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCODES | General Ledger Codes | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JBKOPCODE | Journal Book Operator Code | IF |
| JBKSYSCODE | Journal Book System | IF |
| SYSTEMCODE | System Code | IF |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (61)
ACAC, ACSB, ACTA, AMCO, APCP, APDS, API1, API2, API3, API4, API5, EXI2, EXI3, EXI4, GLCC, HRHI, HRLO, HRST, ICCP, ICI1, ICI9, ICIT, ICLC, IFAC, IFAU, IFCU, IFFC, IFGT, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, MAI1, MAPL, MARC, POBL, POCP, POED, POI1, POI3, POI4, POI6, POI7, POI9, POIA, POIF, POIG, POIH, POII, POIJ, POIL, POIM, POIX, PREN, SLFD, SLSB, SLSE, SLSS, SLSU