|
|
AC196 - Activity Time Reconciliation
**Form Purpose
Run Activity Time Reconciliation (AC196) to reconcile time posted to the
Activity Management system with the time record history in the Payroll system.
You can reconcile Payroll amounts and hours with amounts and hours posted to
the Activity Management system.
**Processing Effect
The reconciliation is accomplished by comparing the ACTRANS (Activity
Transaction) file with the PRTIME (Employee Pay/Hours History) file using the
object identifier as the key. The program produces activity journal entries to
correct any variance between Payroll time history and Activity Management
estimates.
Transactions created in AC196 are not billable; however, since the PRTIME
file does not have all the fields required for billing. The journal entries
are edited to ensure that the activity, account category, and account are
valid for the activity you are creating the journal entry for. If changes are
required to the time records, you can make the changes in Payroll or, if the
changes affect Activity Management only, you can make them in AC40.1 (Journal
Entry).
Updated Files
ACMONITOR -
ACTRANS - This is the primary filed maintained by this program. Creates
activity transactions for any variance between the payroll time
history and the activity transaction file.
CKPOINT - Used for restart capability.
MXLISTHDR - Updates the Last Build Time and Last Build Date fields on this
file.
MXLISTMBR - Updates the Last Build Time and Last Build Date fields on this
file.
PRTIME - Updates the reconciled field on this file from blank to yes.
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. Also, references
this file to validate billing
parameters.
ACACTGRP - References this file to validate the activity group.
ACACTIVITY - References this file to validate the activity.
ACACTMXVAL - References this file to validate activity attributes and
values.
ACADDLCNTR -
ACAMCODE - References this file to validate activity asset.
ACASSIGN - References this file to validate resources assigned to an
activity.
ACBILL -
ACBILLX -
ACCATGRP -
ACCATGRPX -
ACCNTRACT -
ACCOLGRP -
ACCOLGRPX -
ACIFACTV -
ACLEVEL - References this file to determine if the activity is summary
level or posting.
ACSTATUS - References this file to validate the activity's status.
EMPLOYEE - References this file to validate the employee resource.
GLADDRESS - This file is used by a common routine that is used by this
program.
GLCHART - This file is used by a common routine that is used by this
program.
GLSYSTEM - References this file to validate that the company exists in
the Lawson General Ledger system.
HRSECLEV - References this file to validate the Human Resources security
level.
MXCATDEF - This file is used by a common routine that is used by this
program.
MXELEMENT - This file is used by a common routine that is used by this
program.
MXLISTDTL - References this file to validate list parameters.
MXOBJCAT - This file is used by a common routine that is used by this
program.
PRSYSTEM - References this file to validate that the company exists in
the Lawson Human Resource system.
WFSETUP -
INVOKED Programs
ACAC
ACCL
API4
IFAC
IFCU
IFSG
SLSE
SLSU
ACSR
IFAU
IFOB
|
