AC20.1 - Life Only Budget
Use AC20.1 (Life Only Budget) to define and maintain a life only budget. The
life only budget designates the total budgeted amount for the duration of the
activity group, including the budget for all individual activities included in
the activity group. You can define a budget for amounts and units and
calculate values using a factor or rate. Budget amounts are stored in the
activity group base currency. You can define the budget by either activity
group, which includes all activities in the group; or by activity group,
specific activity, and account category.
You do not have to enter an amount, factor, rate, and units. If you define
only two values, the system calculates the third. For example, Amount = Rate
multiplied by (*) Units.
If you define the life only budget as active, that is the only budget you can
use. You define whether a budget is life only in the header forms. For
example, you can define a life only budget amount at the beginning of the
activity group for the total amount of the project. Do not make that the
active budget, but make an annual amount the active budget. Down the road you
can compare the annual amounts with the life only amount to make sure you are
on track.
You have the following options to define budgets. You can define budgets using
any method, but can only have one active budget.
* Define budgets for the entire duration of the activity group using AC20.1.
* Define budgets by year for an entire activity group or individual activity
annually using AC20.2
* Define budgets by period for an entire activity group or individual activity
using AC20.3
* Define budgets for individual activities using AC20.4. This form lets you
define budgets for activities by period and year.
* Define budgets for all activities included in an account category using
AC20.5. This form lets you define budgets by period and year.
*
Updated Files
ACACTGRP - Updates this file with the active budget for the activity
group.
ACBUDDTL - This is one of the primary files maintained by this program.
Maintains annual budget and previous years budget balances for
activity and activity group
budgets.
ACBUDHDR - This is one of the primary files maintained by this program.
Maintains budget header information and total budget balance
for the activity or activity
group budget.
ACCHGORDER - Deletes budget change order records on a Delete action.
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCONSOL - References this file to validate last year's actuals on file
for the activity group for budget action code Copy Last Year's
Actuals.
ACCONSOLX - References this file to validate last year's actuals on file
for the activity group for budget action code Copy Last Year's
Actuals.
ACCUAMT - This file is accessed by a common routine used by this
program.
ACCUAMTX - This file is accessed by a common routine used by this
program.
RATOTALS - This file is accessed by a common routine used by this
program.
ULTOTALS - This file is accessed by a common routine used by this
program.
Referenced Files
ACACCTCAT - References this file to validate the account category.
ACACCTCATX - References this file to validate that the account category is
assigned to the activity group or activity.
ACACTIVITY - Validates the activity and identifies the active budget.
ACBILL -
ACBUDDTLX - This is one of the primary files maintained by this program.
Maintains period budget balances for the activity or activity
group budget. Maintained by account category for activity
budgets.
ACCATGRP -
ACCATGRPX -
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCMPPARAM -
ACCNTRACT -
ACCOLGRP -
ACCOLGRPX -
ACCOMMIT - This file is accessed by a common routine used by this
program.
ACCOMMITX - This file is accessed by a common routine used by this
program.
ACGLCONSL -
ACGLCONSLX -
ACGLMAST -
ACGLMASTX -
ACLEVEL - This file is accessed by a common routine used by this
program.
ACMASTER - This file is accessed by a common routine used by this
program.
ACMASTERX - This file is accessed by a common routine used by this
program.
ACPERCCMPL - This file is accessed by a common routine used by this
program.
ACPOOLHDR -
ACRANGEDTL -
ACRETAIN -
ACSTATUS - Validates that the activity allows budgeting
ACTOTALS -
CMPUTE - References this file to validate that the compute exists in
the Lawson Report Writer system.
CUCONV - This file is accessed by a common routine used by this
program.
CURELAT - This file is accessed by a common routine used by this
program.
FBFACTOR - References this file to validate the factor code.
GLCGCPY - References this file to validate that the company group exists
in the Lawson General Ledger system.
GLCHARTDTL - This file is accessed by a common routine used by this
program.
GLCHARTSUM - This file is accessed by a common routine used by this
program.
GLCPYGRP - This file is accessed by a common routine used by this
program.
GLMASTER - References this file to validate last year's actuals on file
for the account for budget action code Copy Last Year's
Actuals.
GLNAMES - References this file to validate the accounting unit in the
Lawson General ledger system.
GLSYSTEM - References this file to validate that the company exists in
the Lawson General Ledger system.
MLCALMAP -
MLCOLEDGER -
MXLISTHDR - References this file to validate the list.
MXLISTMBR - References this file to validate list members.
RWGRPDET - References this file to validate that the account group exists
in the Lawson General Ledger system.
RWROWDET - References this file to validate that the account group exists
in the Lawson General Ledger system.
ULPOST - This file is accessed by a common routine used by this
program.
AC20.2 - Annual Budget
Use AC20.2 (Annual Budget) to define and maintain budgets annually. You can
define annual budgets for an entire activity group, including all activities;
or for an activity group, specific activity, and account category. You must
define at least one amount, factor, rate, or unit for each year.
You can define as many budgets as necessary, but can only have one active
budget.
***The budget must be within the activity group or activity date range. For
example, if the group is only for 1999, you can't define a budget for 2000. If
project runs long, must first change year in group then define budget.
Updated Files
ACACTGRP - This file holds the total of the active amount (not unit)
budgets for all activities within the activity group.
ACBUDDTL - This is one of the primary files maintained by this program.
Maintains annual budget and future years budget balances for
activity budgets.
ACBUDDTLX - This is one of the primary files maintained by this program.
Maintains period budget amounts for the activity budget.
ACBUDHDR - This is one of the primary files maintained by this program.
Maintains budget header information and total budget balance
for the activity budget.
ACCHGORDER - Deletes budget change order records on a Delete action.
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCONSOL - This is one of the primary files maintained by this program.
Maintains annual budget and future years' budget consolidation
balances for activity budgets.
ACCONSOLX - This is one of the primary files maintained by this program.
Maintains period budget consolidation balances for the activity
or activity group budget. Maintained by account category for
activity budgets.
ACCUAMT - This file is maintained by this program for budgets with a
non-base currency. Maintains annual budget and future years
budget balances for activity and activity group budgets.
ACCUAMTX - This file is maintained by this program for budgets with a
non-base currency. Maintains period budget balances for the
activity or activity group budget. Maintained by account
category for activity budgets.
RATOTALS - This file is accessed by a common routine used by this
program.
ULTOTALS - This file is accessed by a common routine used by this
program.
Referenced Files
ACACCTCAT - References this file to validate the account category.
ACACCTCATX - References this file to validate that the account category is
assigned to the activity group or activity.
ACACTIVITY - References this file to validate the activity and identify the
active budget.
ACBILL -
ACCATGRP -
ACCATGRPX -
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCMPPARAM -
ACCNTRACT -
ACCOLGRP -
ACCOLGRPX -
ACCOMMIT - This file is accessed by a common routine used by this
program.
ACCOMMITX - This file is accessed by a common routine used by this
program.
ACGLCONSL -
ACGLCONSLX -
ACGLMAST -
ACGLMASTX -
ACLEVEL - References this file to determine if the activity is summary
level or posting.
ACMASTER - References this file to validate last year's actuals on file
for the activity for budget action code Copy Last Year's
Actuals.
ACMASTERX - References this file to validate last year's actuals on file
for the activity for budget action code Copy Last Year's
Actuals.
ACPERCCMPL - This file is accessed by a common routine used by this
program.
ACPOOLHDR -
ACRANGEDTL -
ACRETAIN -
ACSPREAD - References this file to validate the spread code and compute
the spread amounts.
ACSPREADX - References this file to calculate the spread code period
amounts.
ACSTATUS - Validates that the activity allows budgeting
ACTOTALS -
CMPUTE - References this file to validate that the compute exists in
the Lawson Report Writer system.
CUCONV - This file is accessed by a common routine used by this
program.
CURELAT - This file is accessed by a common routine used by this
program.
FBFACTOR - References this file to validate the factor code.
GLCGCPY - References this file to validate that the company group exists
in the Lawson General Ledger system.
GLCHARTDTL - This file is accessed by a common routine used by this
program.
GLCHARTSUM - This file is accessed by a common routine used by this
program.
GLCPYGRP - This file is accessed by a common routine used by this
program.
GLMASTER - References this file to validate last year's actuals on file
for the account for budget action code Copy Last Year's
Actuals.
GLNAMES - References this file to validate the accounting unit in the
Lawson General Ledger system.
GLSYSTEM - References this file to validate that the company exists in
the Lawson General Ledger system.
MLCALMAP -
MLCOLEDGER -
MXLISTHDR - References this file to validate the list.
MXLISTMBR - References this file to validate the accounting unit list.
RWGRPDET - References this file to validate that the account group exists
in the Lawson General Ledger system.
RWROWDET - References this file to validate that the account group exists
in the Lawson General Ledger system.
ULPOST - This file is accessed by a common routine used by this
program.
AC20.3 - Period Budget
Updated Files
ACACTGRP - Maintains the budget balance of all of the activity group's
active activity amount budgets.
ACBUDDTL - This is one of the primary files maintained by this program.
Maintains annual budget and previous years budget balances for
an activity.
ACBUDDTLX - This is one of the primary files maintained by this program.
Maintains period budget balances for the activity budget.
Maintained by account category for activity budgets.
ACBUDHDR - This is one of the primary files maintained by this program.
Maintains budget header information and total budget balance
for the activity.
ACCHGORDER - Deletes budget change order records on a Delete action.
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCONSOL - This is one of the primary files maintained by this program.
Maintains annual budget and future years' budget consolidation
balances for an activity.
ACCONSOLX - This is one of the primary files maintained by this program.
Maintains period budget consolidation balances for the
activity. Maintained by account category for activity budgets.
ACCUAMT - This file is maintained by this program for budgets with a
non-base currency. Maintains annual budget and previous years
budget balances for the activity.
ACCUAMTX - This file is maintained by this program for budgets with a
non-base currency. Maintains period budget balances for the
activity. Maintained by account category for activity budgets.
RATOTALS - This file is accessed by a common routine used by this
program.
ULTOTALS - This file is accessed by a common routine used by this
program.
Referenced Files
ACACCTCAT - References this file to validate the account category.
ACACCTCATX - References this file to validate account category assignment
for the activity.
ACACTIVITY - References this file to validate the activity.
ACBILL -
ACCATGRP -
ACCATGRPX -
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCMPPARAM -
ACCNTRACT -
ACCOLGRP -
ACCOLGRPX -
ACCOMMIT - This file is accessed by a common routine used by this
program.
ACCOMMITX - This file is accessed by a common routine used by this
program.
ACGLCONSL -
ACGLCONSLX -
ACGLMAST -
ACGLMASTX -
ACLEVEL - References this file to determine if the activity is summary
level or posting.
ACMASTER - This file is accessed by a common routine used by this
program.
ACMASTERX - This file is accessed by a common routine used by this
program.
ACPERCCMPL - This file is accessed by a common routine used by this
program.
ACPOOLHDR -
ACRANGEDTL -
ACRETAIN -
ACSPREAD - References this file to validate the spread code.
ACSPREADX - References this file to retrieve the spread code percents.
ACSTATUS - References this file to validate that the status is valid for
budgeting.
ACTOTALS -
CMPUTE - References this file to validate the compute.
CUCONV - This file is accessed by a common routine used by this
program.
CURELAT - This file is accessed by a common routine used by this
program.
FBFACTOR - References this file to validate the factor code.
GLCGCPY - This file is accessed by a common routine used by this
program.
GLCHARTDTL - This file is accessed by a common routine used by this
program.
GLCHARTSUM - This file is accessed by a common routine used by this
program.
GLCPYGRP - This file is accessed by a common routine used by this
program.
GLMASTER - This file is accessed by a common routine used by this
program.
GLNAMES - This file is accessed by a common routine used by this
program.
GLSYSTEM - This file is accessed by a common routine used by this
program.
MLCALMAP -
MLCOLEDGER -
MXLISTHDR - References this file to validate the list.
MXLISTMBR - References this file to validate the list detail.
RWGRPDET - This file is accessed by a common routine used by this
program.
RWROWDET - This file is accessed by a common routine used by this
program.
ULPOST - This file is accessed by a common routine used by this
program.
AC20.4 - Activity Budgets By Activity
Use AC20.4 (Activity Budgets By Activity) to define and maintain activity
budgets by activity. For each account category of the activity, you can add,
change, or delete the budget amount, factor, rate, or units. You can define a
budget with amount values only, unit values only, or amount, rate, and units.
If the Budget line has two values, the program calculates the third using the
formula:
Amount = Rate * Units.
If the budget has all three values, the program recalculates the amount as
Rate * Units and rounds the amount and units.
In the Budget field, you can select Attachments and define URL links or
comments.
Updated Files
ACACTGRP - The budget balance is maintained on this file for all of the
activity group's active activity amount budgets.
ACBUDDTL - This is one of the primary files maintained by this program.
Maintains annual budget and previous years budget balances for
activity budgets.
ACBUDDTLX - This is one of the primary files maintained by this program.
Maintains period budget balances for the activity budget.
Maintained by account category for activity budgets.
ACBUDHDR - This is one of the primary files maintained by this program.
Maintains header information and total budget balance for the
activity budget.
ACCHGORDER - Deletes budget change order records on a Delete action.
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCONSOL - This is one of the primary files maintained by this program.
Maintains annual budget and future years' budget consolidation
balances for activity budgets.
ACCONSOLX - This is one of the primary files maintained by this program.
Maintains period budget consolidation balances for the activity
budget. Maintained by account category for activity budgets.
ACCUAMT - This file is maintained by this program for budgets with a
non-base currency. Maintains annual budget and previous years
budget balances for activity.
ACCUAMTX - This file is maintained by this program for budgets with a
non-base currency. Maintains period budget balances for the
activity. Maintained by account category for activity budgets.
RATOTALS - This file is accessed by a common routine used by this
program.
ULTOTALS - This file is accessed by a common routine used by this
program.
Referenced Files
ACACCTCAT - References this file to validate the account category.
ACACCTCATX - References this file to validate that the account category is
assigned to the activity.
ACACTIVITY - References this file to validate the activity.
ACBILL -
ACCATGRP -
ACCATGRPX -
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCMPPARAM -
ACCNTRACT -
ACCOLGRP -
ACCOLGRPX -
ACCOMMIT - This file is accessed by a common routine used by this
program.
ACCOMMITX - This file is accessed by a common routine used by this
program.
ACGLCONSL -
ACGLCONSLX -
ACGLMAST -
ACGLMASTX -
ACLEVEL - References this file to validate if the activity is posting or
summary.
ACMASTER - This file is accessed by a common routine used by this
program.
ACMASTERX - This file is accessed by a common routine used by this
program.
ACPERCCMPL - This file is accessed by a common routine used by this
program.
ACPOOLHDR -
ACRANGEDTL -
ACRETAIN -
ACSPREAD - References this file to validate the spread code.
ACSPREADX - References this file to retrieve the percents for each period.
ACSTATUS - References this file to determine if the activity is in a
budget status.
ACTOTALS -
CMPUTE - References this file to validate the compute.
CUCONV - This file is accessed by a common routine used by this
program.
CURELAT - This file is accessed by a common routine used by this
program.
FBFACTOR - References this file to validate the factor code.
GLCGCPY - This file is accessed by a common routine used by this
program.
GLCHARTDTL - This file is accessed by a common routine used by this
program.
GLCHARTSUM - This file is accessed by a common routine used by this
program.
GLCPYGRP - This file is accessed by a common routine used by this
program.
GLMASTER - This file is accessed by a common routine used by this
program.
GLNAMES - This file is accessed by a common routine used by this
program.
GLSYSTEM - This file is accessed by a common routine used by this
program.
MLCALMAP -
MLCOLEDGER -
MXLISTHDR - This file is accessed by a common routine used by this
program.
MXLISTMBR - This file is accessed by a common routine used by this
program.
RWGRPDET - This file is accessed by a common routine used by this
program.
RWROWDET - This file is accessed by a common routine used by this
program.
ULPOST - This file is accessed by a common routine used by this
program.
AC20.5 - Activity Budgets By Account Category
Use AC20.5 (Activity Budgets By Account Category) to define and maintain
activity budgets by account category. For each account category you select,
you can add, change, or delete the activity budget amount, factor, rate, or
units. You can define a budget with amount values only, unit values only, or
amount, rate, and units.
If the Budget line has two values, the program calculates the third using the
formula: Amount = Rate * Units.
If the budget has all three values, the program recalculates the amount as
Rate * Units and rounds the amount and units.
In the Budget field, you can select Attachments and define URL links or
comments.
Updated Files
ACACTGRP - This file is accessed by a common routine used by this
program.
ACBUDDTL - Deletes annual budget records on a Delete action.
ACBUDDTLX - Deletes period budget amounts on a Delete action.
ACBUDHDR - This is the primary file maintained by this program. Maintains
budget header information.
ACCHGORDER - Deletes budget change order records on a Delete action.
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCONSOL - Deletes annual budget consolidation records on a Delete
action.
ACCONSOLX - Deletes period budget consolidation files on a Delete
action.
ACCUAMT - Deletes the non-base currency annual budget records on a
Delete action.
ACCUAMTX - Deletes the non-base currency period budget records on a
Delete action.
RATOTALS -
ULTOTALS -
Referenced Files
ACACCTCAT - References this file to validate the account category.
ACACCTCATX -
ACACTIVITY - Updates this file with the active budget for the activity.
ACBILL -
ACCATGRP -
ACCATGRPX -
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCMPPARAM -
ACCNTRACT -
ACCOLGRP -
ACCOLGRPX -
ACCOMMIT -
ACCOMMITX -
ACGLCONSL -
ACGLCONSLX -
ACGLMAST -
ACGLMASTX -
ACLEVEL - References this file to determine if the activity is summary
level or posting.
ACMASTER -
ACMASTERX -
ACPERCCMPL -
ACPOOLHDR -
ACRANGEDTL -
ACRETAIN -
ACSPREAD -
ACSPREADX -
ACSTATUS - References this file to validate that the status is valid for
budgeting.
ACTOTALS -
CMPUTE -
CUCONV -
CURELAT -
FBFACTOR -
GLCGCPY -
GLCHARTDTL -
GLCHARTSUM -
GLCPYGRP -
GLMASTER -
GLNAMES -
GLSYSTEM -
MLCALMAP -
MLCOLEDGER -
MXLISTHDR -
MXLISTMBR -
RWGRPDET -
RWROWDET -
ULPOST -
AC20.6 - Activity Group Budget Header
Use AC20.6 (Activity Group Budget Header) to define an activity group budget
header. You can define as many budgets as necessary, but each activity group
can only have one active budget. For example, if costs change you can define a
new active budget by copying the old one and keeping the old budget for
reference while making the new budget active.
The active activity group budget displays on the Budget form tab in AC00.1
(Activity Group).
Use AC21 (Budget Change Orders) to change a budget and provide an audit trail
of your changes.
Updated Files
ACACTGRP - Updates this file with the active budget for the activity
group.
ACBUDDTL - Deletes the annual budget files on a Delete
action.
ACBUDDTLX - Deletes the period budget amounts on a Delete
action.
ACBUDHDR - This is the primary file maintained by this program. Maintains
budget header information.
ACCHGORDER - Deletes budget change order records on a Delete action.
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCUAMT - This file is maintained by this program for budgets with a
non-base currency. Maintains annual budget and previous years
budget balances for activity.
ACCUAMTX - This file is maintained by this program for budgets with a
non-base currency. Maintains period budget balances for the
activity. Maintained by account category for activity budgets.
Referenced Files
ACBUDDTL - Deletes the annual budget files on a Delete
action.
ACBUDDTLX - Deletes the period budget amounts on a Delete
action.
ACCHGORDER - Deletes budget change order records on a Delete action.
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCUAMT - This file is maintained by this program for budgets with a
non-base currency. Maintains annual budget and previous years
budget balances for activity.
ACCUAMTX - This file is maintained by this program for budgets with a
non-base currency. Maintains period budget balances for the
activity. Maintained by account category for activity budgets.
CUCONV -
CURELAT -
GLSYSTEM -
AC20.7 - Activity Budget Header
Use AC20.7 (Activity Budget Header) to define an activity budget header. You
can define as many budgets as necessary, but each activity can only have one
activity budget. For example, if the cost of materials increases, you can
define a new active budget by copying the old budget and keeping it for
reference while making changes to the new active budget.
The header defines the budget number and description, budget date range,
currency and exchange rate information, amount and unit round types, whether
it is a life only budget, and whether it is the active budget. You must add
the budget header before you can add budget amounts and units.
The activity budget displays on AC10.1 (Activity).
Use AC20.8 (Budget Lock) to unlock the budget. Use AC21 (Budget Change Orders)
to change the budget and provide an audit trail of your changes.
Updated Files
ACACTGRP - This file holds the total of the active amount (not unit)
budgets for all activities within the activity group.
ACACTIVITY - References this file to validate the activity and identify the
active budget.
ACBUDDTL - This is one of the primary files maintained by this program.
Maintains annual budget and previous years budget balances for
activity budgets.
ACBUDDTLX - This is one of the primary files maintained by this program.
Maintains period budget balances for the activity. Maintained
by account category for activity budgets.
ACBUDHDR - This is one of the primary files maintained by this program.
Maintains budget header information and total budget balance
for the activity budget.
ACCHGORDER - Deletes budget change order records on a Delete action.
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACCONSOL - This is one of the primary files maintained by this program.
Maintains annual budget and future years' budget consolidation
balances for activity budgets.
ACCONSOLX - This is one of the primary files maintained by this program.
Maintains period budget consolidation balances for the activity
budget. Maintained by account category for activity budgets.
ACCUAMT - This file is maintained by this program for budgets with a
non-base currency. Maintains annual budget and previous years
budget balances for activity budgets.
ACCUAMTX - This file is maintained by this program for budgets with a
non-base currency. Maintains period budget balances for the
activity budget. Maintained by account category for activity
budgets.
ACTOTBAL -
ACTOTBALX -
Referenced Files
ACACCTCAT - References this file to validate the account category.
ACCHGORDER - Deletes budget change order records on a Delete action.
ACCHGORDX - Deletes budget change order detail records on a Delete action.
ACLEVEL - References this file to determine if the activity is summary
level or posting.
ACSTATUS - References this file to validate whether the activity status
code allows projections.
CUCONV -
CURELAT -
GLSYSTEM - References this file to validate that the company exists in
the Lawson General Ledger system.
AC20.8 - Budget Lock
Use AC20.8 (Budget Lock) to lock or unlock a budget. Locking prevents
deletion of the budget or changes to it. Use AC21 (Budget Change Orders) to
change budgets and provide an audit trail of your changes.
In the Budget field, you can select Attachments and define URL links or
comments.
Updated Files
ACBUDHDR - This is one of the primary files maintained by this program.
Maintains budget header information and total budget balance
for the activity or activity
group budget.
Referenced Files
ACACTGRP - Updates this file with the active budget for the activity
group.
ACACTIVITY - References this file to validate the activity.
INVOKED Programs
ACCL
GLAC
GLBL
IFUP
GLRV
IFCU
IFSG
MLRV
|
