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)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ACTRANSActivity TransactionAC
ADDRDATAAddress CodeIF
APHLDINVHoldAP
APPAYMENTInvoice PaymentAP
CKPOINTNo description in the Lawson data dictionary
EEEXPDTLNo description in the Lawson data dictionaryAP
EEEXPHDRNo description in the Lawson data dictionaryAP
FBDETAILBudget DetailGL
FBFUNDAMTBudget Fund BalanceGL
FBTRANSBudget TransactionsGL
FBYETRNo description in the Lawson data dictionaryGL
GLCOMMITGL CommitmentsGL
GLCOMMITXGL commitment DetailGL
GLHISCOMBLNo description in the Lawson data dictionaryGL
GLHISCOMXNo description in the Lawson data dictionaryGL
JBKSEQNBRJournal Book Sequence NumberGL
JBOOKHDRJournal Book HeaderIF
PRSYSTEMHR Company and Process LevelsHR
SUBCKPOINTSubledger Check PointIF
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX

Referenced files (29)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACCTCATXAccount Category DetailAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACBRDNTRANThe Burden Transactions file is updated by the Activity Posting (AC190) program.AC
ACCALActivity CalendarAC
ACCALXActivity Calendar DetailAC
ACCATSUMXAccount Category Summ DetailAC
ACCNTRACTActivity ContractBR
APACCRCODEInvoice Accrual CodeAP
APCOMPANYAccounts Payable CompanyAP
APVENGROUPVendor GroupAP
CTXMMCRNo description in the Lawson data dictionaryAP
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
EEADVAPPNo description in the Lawson data dictionaryAP
EMPLOYEEEmployeeHR
FBFUNDDTLBudget Fund DetailGL
GLADDRESSGeneral Ledger Company AddressIF
GLCHARTGeneral Ledger ChartIF
GLCODESGeneral Ledger CodesIF
GLNAMESGeneral Ledger NamesIF
GLSYSTEMGeneral Ledger CompanyIF
INSTCTRYCDIntrastat Country CodesTX
JBKOPCODEJournal Book Operator CodeIF
JBKSYSCODEJournal Book SystemIF
SYSTEMCODESystem CodeIF
TXTAXRATETax RateTX
WFSETUPNo description in the Lawson data dictionaryWF

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