AC196 - Activity Time Reconciliation
Use AC196 (Activity Time Reconciliation) 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. 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
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.
ACAMCODE - References this file to validate activity asset.
ACASSIGN - References this file to validate resources assigned to an
activity.
ACCATGRP -
ACCATGRPX -
ACCOLGRP -
ACCOLGRPX -
ACCUSTOMER - References this file to validate the activity customer.
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
IFCU
IFSG
ACSR
HRFN
IFAC
IFAU
SLSE
SLSU
IFOB
|