Lawson Insight Technical Documentation

PR85.1 - Bank Account Reconciliation

Use PR85.1 (Bank Account Reconciliation) to reconcile and void payments
closed by running PR197 (Payroll Close). You can reconcile individual payments
or a range of payments. You can also void partial payments. Direct deposit
payments are automatically assigned a reconciled status when you run PR197.

If the bank provides account activity on magnetic tape, run PR165 (Bank
Reconciliation Tape Processing) to update PR85.1 with all bank activity that
occurred during a specific period of time.

To void a payment, select line action Void next to the appropriate payment.
You can type a date for the void, or allow the system date to default. The
system updates payroll history files based on the void date. The system also
uses the void date when creating reversing general ledger entries for a voided
payment or partial voided payment. To void a partial payment, select P in the
Type field. Choose the direct deposit void button (asterisk) to indicate the
general ledger offset accounts.

If you enter No in the Create Distributions field on the company or process
level record, or if payroll history is purged, the system creates general
ledger distributions based on current distribution information.

Run PR197 (Payroll Close) in report mode to produce a listing of distribution
transactions.

To update history files for the voided payment, run PR197. If you do not run
PR197 specifically to close voided payments, the voided payments are updated
when you run PR197 for the next payroll cycle.

Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    ATTENDHIST - Referenced by the employee object only.

    EMDEDMASTR - Used to update the employee's deduction balance.

    EMPACHDIST - Used to validate employee ACH distributions and update
                 distribution information.

    PAYDEDUCTN - Maintained by this program.

    PAYMASTR   - Maintained by this program. Used to verify if an Employee
                 Payment Distribution file record exists for a payment, and to
                 validate the payment status.

    PBBLDEDUCT -

    PBJOBCDTRN -

    PBTIME     -

    PBTIMEREC  -

    PBTRANS    -

    PR1099RHST -

    PR1099RSLH -

    PRCHECK    - Maintained by this program. Used to validate the payment
                 number and the payment status.

    PRDEDDTL   -

    PRDISTRIB  - Maintained by this program. Used to validate distributions.

    PREMDEDHST - Referenced by the employee object only.

    PRGARNHIST -

    PRPAYCODE  - Used to update the pay code on void payments.

    PRSYSTEM   - Updates the company with payment information.

    PRTIME     - Used to update time record information.

    QUARTDED   - Used to update quarterly deduction information.

    QUARTWAGE  - Used to update quarterly wage information.

    TIMERECORD - Used to create reversal time records.

    TIPPAY     - Used to create tip pay reversals.

    TPPARAM    - Used to validate tip parameters.

    TRSGBLCK   -


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    ATTENDCODE - Referenced by the employee object only.

    BANKACCT   - Maintained by this program. Used to update last payment ID,
                 and to validate the entered bank account.

    BANKFILE   - Used to validate the bank code.

    CUCONV     -

    CURELAT    -

    DEDCODE    - Used to retrieve deduction information for validation.

    EMDISTMAST - Used to retrieve distribution percent information.

    EMPLOYEE   - Maintained by this program. Used to update the employee's last
                 distribution sequence when you void a payment.

    EMSTATUS   -

    EMTAMASTR  - Used to verify period end dates when you void a payment.

    GLADDRESS  -

    GLCHART    -

    GLSYSTEM   -

    HRSECLEV   - Used to validate the employee's data item security level.

    PAYSUMGRP  - Used to retrieve the pay summary group and tip pay type, and
                 to update tip pay information.

    PBBILL     -

    PBBLJOBCD  -

    PBBLJOBCDX -

    PBBLSUIDTL -

    PBBLWCHDR  -

    PBCLIENT   -

    PBDCTGRPX  -

    PBFEE      -

    PBFEEGRPX  -

    PGEMPLOYEE -

    PRFUNDSRC  -

    PROTACCTS  -

    PRPENFSRC  -

    PRPENHIST  -

    PRPENPAY   -

    PRSHIFTTBL -

    PSGRELATE  -

    SYSTEMCODE -


PR85.2 - Bank Account Totals

The Bank Account Totals subform displays payment totals for the account and
parameters selected in PR85.1 (Bank Account Reconciliation).

From the subform, you can select other account payment totals to view. You
can also select parameters, to display totals for a specific date range, a
specific payment type, or both.

Updated Files

    None.


Referenced Files

    EMPACHDIST - Used to display ACH totals.

    PRCHECK    - Used to display payment totals.

    PRSYSTEM   - Used to validate the company.


INVOKED Programs

    ACCL
    HRFN
    IFAC
    ACAC
    IFCU
    IFSG
    IFAU
    SLSE
    SLSU
    IFOB
    IFRS
    PBFE
    PBWC
    PREN