AC527 – AC to GL Budget Interface
- System
- Activity Management (AC)
- Type
- Batch program
- Updates
- 6 tables
- References
- 41 tables
AC527 (AC to GL Budget Interface) is a Lawson Activity Management batch program. It updates ACASNROLE, ADDRDATA, CKPOINT, FBUDGETREL, MXLISTHDR and MXLISTMBR and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE and 33 more.
About AC527
Use AC to GL Budget Interface (AC257) to interface activity budget information between Project Accounting and General Ledger.This program moves the budget detail from Project Accounting into the GL interface file, and then standard GL budget processes incorporate the interfaced budget detail. AC to GL Budget Interface (AC257) maps the posting activity in AC to the appropriate GL company and accounting unit either by using the default company and accounting unit for that activity, or by using an organization code set up on Organization Relationship (GL08.1) and an account code set upon Account Relationship (GL09.1). AC to GL Budget Interface (AC257) can be used with posting activity levelbudgets only. Activity and life only budgets are not interfaced using this program. Use the Activity tab to specify the activity, activity group, or activity list and account category combination for the budget(s) you want to interface. Use the Budget Options tab to set up specific interface options, such as period mapping and budget year adjustments.
Updated files (6)
| Table | Description | System |
|---|---|---|
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| FBUDGETREL | Budgeting Relationships | GL |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
Referenced files (41)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACACTMXVAL | Activity List Attribute Values | AC |
| ACADDLCNTR | Additional Contract Info | BR |
| ACAMCODE | Activity Asset | AC |
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ACASSIGN | Activity Resource Assignment | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBUDDTL | Activity Budget | AC |
| ACBUDHDR | Activity Budget Header | AC |
| ACCAL | Activity Calendar | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATMXVAL | No description in the Lawson data dictionary | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCTRCATGX | Contract Category Group Dtl | BR |
| ACCUAMT | Activity Currency Amount | AC |
| ACGRPMXVAL | The ACGRPMXVAL file is the primary file updated by AC13. | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACROLE | The Activity Management Role file stores resource roles and descriptions. | AC |
| ACSTATUS | Activity Status | AC |
| FBFACTOR | Budget Global Factors | IF |
| FBHEADER | Budget Header | GL |
| GLACCTREL | GL Account Relationships | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLCOMPREL | GL Organization Relationships | IF |
| GLSYSTEM | General Ledger Company | IF |
| GMAWARD | Grant Management Award | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| STRUCTURE | Category Structure | AC |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (13)
ACAC, ACSR, ACTA, API4, IFAC, IFAU, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU