AC121 – Budget Calculation
- System
- Activity Management (AC)
- Type
- Batch program
- Updates
- 18 tables
- References
- 60 tables
AC121 (Budget Calculation) is a Lawson Activity Management batch program. It updates ACACTGRP, ACASNROLE, ACBUDDTL, ACBUDHDR, ACCONSOL, ACCUAMT, ACGLCONSL, ACGLMAST and 10 more and references ACACCTCAT, ACACCTCATX, ACACTIVITY, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE, ACASSIGN and 52 more.
About AC121
Run Budget Calculation (AC121) to calculate budgets using compute statements for activity groups and activities. AC121 includes fields for saving oroverriding compute statements assigned to the budgets. You can define compute statements in RW50.1 (Compute Statements). **Processing Effect When a budget uses a compute statement, the computed amount is a base currency amount. If the budget has a currency other than base, the currency amount is calculated as base currency and converted using translation data assigned in the budget header. NOTE Existing budget data cannot be computed, modified or deleted when areleased change order exists or while the budget is locked.
Updated files (18)
| Table | Description | System |
|---|---|---|
| ACACTGRP | Activity Group | AC |
| ACASNROLE | The Assignment Role file will store the roles associated with a resource assignment. | AC |
| ACBUDDTL | Activity Budget | AC |
| ACBUDHDR | Activity Budget Header | AC |
| ACCONSOL | Activity Consolidation | AC |
| ACCUAMT | Activity Currency Amount | AC |
| ACGLCONSL | AC GL Acct Unit Consolidation | AC |
| ACGLMAST | AC GL Acct Unit Master | AC |
| ACMASTER | Activity Balances | AC |
| ACSUMBAL | No description in the Lawson data dictionary | AC |
| ACTOTBAL | No description in the Lawson data dictionary | AC |
| ACTRANS | Activity Transaction | AC |
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| RATOTALS | Ratio Totals | GL |
| ULTOTALS | No description in the Lawson data dictionary | GL |
Referenced files (60)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | 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 |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | 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 |
| ACCHGORDER | Activity Change Order | AC |
| ACCMPPARAM | Activity Compute Parameters | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCOMMIT | Activity Commitments | AC |
| ACCTRCATGX | Contract Category Group Dtl | BR |
| ACGRPMXVAL | The ACGRPMXVAL file is the primary file updated by AC13. | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACPERCCMPL | Activity Percent Complete | AC |
| ACPOOLHDR | Allocation Pool Header | AC |
| ACRANGEDTL | Activity Total Range Detail | AC |
| ACRETAIN | No description in the Lawson data dictionary | BR |
| ACROLE | The Activity Management Role file stores resource roles and descriptions. | AC |
| ACSPREADX | Activity Spread Code Detail | AC |
| ACSTATUS | Activity Status | AC |
| ACTOTALS | Activity Total Names | AC |
| ACTRANS | Activity Transaction | AC |
| CMPUTE | Compute Statements | GL |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| GMAWARD | Grant Management Award | GM |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MLCALMAP | Multi-Book Ledger Calendar Map | ML |
| MLCOLEDGER | Multi Book Ledger Co Ledger | ML |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| RWGRPDET | Report Writer Group Detail | GL |
| RWROWDET | RW Row File Detail | GL |
| STRUCTURE | Category Structure | AC |
| SYSTEMCODE | System Code | IF |
| ULPOST | This file is used to store the last posting date and time. | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (16)
ACAC, ACSR, ACTA, API4, GLAC, GLBL, GLRV, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, MLRV, SLSE, SLSU