EX545 – Advance Payback Creation
- System
- General Ledger Setup (IF)
- Type
- Batch program
- Updates
- 10 tables
- References
- 43 tables
EX545 (Advance Payback Creation) is a Lawson General Ledger Setup batch program. It updates ACCOMMIT, ACTRANS, ADDRDATA, APHLDINV, APPAYMENT, CKPOINT, EEEXPHDR, JBKSEQNBR and 2 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 35 more.
About EX545
If you use Lawson Travel Expense Management, run Advance Payback Creation(EX545) to create expense request reimbursement records for Payroll or Accounts Payable expense requests. IMPORTANT You will use this program only if you use Lawson Travel ExpenseManagement (EXPM) with Lawson S3 Enterprise applications (Accounts Payable, Payroll) and your organization uses expense requests with advance amounts. When run with the Update Option field set to Update, EX545 can create: - In Payroll, pay code records. - In Project Accounting (AC) and Accounts Payable (AP), commitments foradvances. - In AP, employee advance-type invoices. EX545 creates invoice (APINVOICE)records with an invoice type of A (Advance) with no distributions. - In AP, employee advance-credit invoices. AP170 creates invoice (APINVOICE)records with an invoice type of M (Employee Advance Credit Memo) on hold with no distributions.
Updated files (10)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACTRANS | Activity Transaction | AC |
| ADDRDATA | Address Code | IF |
| APHLDINV | Hold | AP |
| APPAYMENT | Invoice Payment | AP |
| CKPOINT | No description in the Lawson data dictionary | — |
| EEEXPHDR | No description in the Lawson data dictionary | AP |
| JBKSEQNBR | Journal Book Sequence Number | GL |
| JBOOKHDR | Journal Book Header | IF |
| PRSYSTEM | HR Company and Process Levels | HR |
Referenced files (43)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBUDHDR | Activity Budget Header | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCOMMIT | Activity Commitments | AC |
| ACCONSOL | Activity Consolidation | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACTRANS | Activity Transaction | AC |
| APACCRCODE | Invoice Accrual Code | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APVENGROUP | Vendor Group | AP |
| EMPLOYEE | Employee | HR |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBHEADER | Budget Header | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCODES | General Ledger Codes | IF |
| GLCOMMIT | GL Commitments | GL |
| GLINTCO | General Ledger Intercompany | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| GMFNDACT | Grant Eligible Activities | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JBKOPCODE | Journal Book Operator Code | IF |
| JBKSYSCODE | Journal Book System | IF |
| SYSTEMCODE | System Code | IF |
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