Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

AC196


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