EX175 – Company Expense Posting

System
General Ledger Setup (IF)
Type
Batch program
Updates
23 tables
References
24 tables

EX175 (Company Expense Posting) is a Lawson General Ledger Setup batch program. It updates ACCOMMIT, ACCOMMITX, ACTRANS, ADDRDATA, CKPOINT, EEEXPDTL, EEEXPHDR, FBDETAIL and 15 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, APACCRCODE and 16 more.

About EX175

If you use Lawson Travel Expense Management, run Company Expense Posting (EX175) to transfer company-paid expenses to General Ledger. IMPORTANT You will use this program only if you use Lawson Travel Expense Management (EXPM) with Lawson Enterprise applications (General Ledger, Accounts Payable, Payroll). When run with the Update field set to Yes, EX175 creates General Ledger Transaction (GLTRANS) records. You will need to run Transaction Interface (GL165) to create General Ledger transaction records from the interface records created by EX175. All expense data is maintained within Infor10 Expense Management. When you areready to generate the following reports, you will move the expense data from XM to Lawson: -expense report reimbursements, -cash advance requestreimbursements, -payment request reimbursements, and -post company-paid expenses to Lawson General Ledger.

Updated files (23)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ACTRANSActivity TransactionAC
ADDRDATAAddress CodeIF
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
SUBCKPOINTSubledger Check PointIF
SYSTEMCODESystem CodeIF
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX

Referenced files (24)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACCTCATXAccount Category DetailAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACCALActivity CalendarAC
ACCALXActivity Calendar DetailAC
ACCATSUMXAccount Category Summ DetailAC
APACCRCODEInvoice Accrual CodeAP
APCOMPANYAccounts Payable CompanyAP
APVENMASTVendor Master RecordAP
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
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
TXTAXRATETax RateTX
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (21)

ACAC, ACTA, API4, GLCC, IFAC, IFAU, IFCU, IFFC, IFGT, IFJR, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, SLFD, SLSB, SLSE, SLSS, SLSU