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. ACCUSTOMER - References this file to validate the activity customer. ACLEVEL - References this file to determine if the activity is summary level or posting. ACRPTGRP - References this file to validate the account category group. ACRPTGRPX - References this file to validate the account categories in the account category group. 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. INVOKED Programs ACAC IFCR IFSG IFCU HRFN IFAC IFAU SLSE SLSU IFCC IFOB |