Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PR05


PR05.1 - Deduction

**Form Purpose
Use Deduction (PR05.1) to define deductions, and how the system calculates
the deduction amount. You can define deductions for items subtracted from an
employee's pay such as federal tax, state or province taxes, insurance,
pension plans, and so on.

You can also define deductions for company-paid items and the company's
portion of insurance.

**Processing Effect
Deductions that affect an employee's gross pay and, optionally, company-paid
deductions appear on payments and direct deposit receipts created by PR160
(Payment Print). All deductions, employee and company-paid, print on PR140
(Earnings and Deductions Calculation).




Updated Files

    ADDRDATA   -

    APAPPROVAL -

    APAUDIT    -

    APCOMMENTS -

    APCONTACT  -

    APCPYVND   -

    APHLDINV   -

    APVENADDR  -

    APVENBAL   -

    APVENCERT  -

    APVENGROUP -

    APVENLOC   -

    APVENMAST  -

    APVENPAY   -

    CBBANKINST -

    CBCASHCODE -

    CUSTDESC   -

    DEDCODE    - The primary file maintained by the program. If you change a
                 deduction, a flag is set so that the Employee Deduction file is
                 updated the next time you run PR140 (Earnings and Deductions
                 Calculation). You cannot delete a deduction that is attached to
                 a tax authority, benefit plan, employee, or one-time deduction.

    MXLISTHDR  -

    MXLISTMBR  -

    POVENDLOC  -

    POVENDOR   -

    PRDEDACCTS -

    TAXIDEXMP  - When you delete a deduction with a tax status of Exempt, the
                 corresponding Pay or Deduction Exemption Code file records are
                 deleted.

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -


Referenced Files

    ACACCTCAT  -

    APACCRCODE -

    APAPPROVAL -

    APAUTHOR   -

    APCOMMENTS -

    APCOMPANY  -

    APCONTACT  -

    APCPYVND   -

    APDISCCODE -

    APDISTHDR  -

    APHLDINV   -

    APHOLDCODE -

    APINCCODE  -

    APINVOICE  -

    APPAYMENT  -

    APPROCGRP  -

    APUSRFLDEF -

    APVENBAL   -

    APVENCERT  -

    APVENCLASS -

    APVNMXVAL  -

    ARCUSTGRP  -

    CBUSER     -

    CBUSRCLASS -

    CUCONV     -

    CURELAT    -

    DCCLASS    - Used to retrieve the payment description if a description is
                 not entered on the screen. Also used to verify the deduction
                 class entered.

    EEADVANCE  -

    EEAPPROVAL -

    EEEXPENSE  -

    EMDEDMASTR - Used to verify a tie to employees. You cannot delete a
                 deduction if a tie to an employee exists.

    GLADDRESS  -

    GLCHART    - Used to validate the general ledger chart name.

    GLINTCO    -

    GLSYSTEM   - Used to validate the general ledger company.

    INSTCTRYCD -

    INSTREGN   -

    MAINVHAND  -

    MAMATCHTBL -

    MAMSGTOL   -

    MAMTCHRULE -

    MAPOOLCNT  -

    MXCATDEF   -

    MXELEMENT  -

    MXLISTDTL  -

    MXOBJCAT   -

    ONETMDED   - Used to validate a tie to a one-time deduction. You cannot
                 delete a deduction if a tie exists to a one-time deduction.

    PAYCLASS   - Used to validate the existence of a pay class.

    POAOCDTL   -

    POVAGRMTHD -

    PRDEDACCTS -

    PREMDEDHST - Used to edit for employee deduction history.

    PREMPGARN  -

    PRGARNRULE -

    PROCUREGRP -

    PRONWAGES  -

    PRREGPARM  -

    PRSYSTEM   - Used to validate the company and process level.

    PRTAXAUTH  - Used to validate the tax authority.

    PRTAXCAT   - Used to validate tax categories.

    PRTIME     - Used to validate that employee pay or hours history does not
                 exist for the tax category or tax authority.

    PURCHORDER -

    REQCODE    - Used to determine required deduction criteria.

    TIMERECORD - Used to validate the existence of time records.

    TXTAXRATE  -


PR05.2 - Taxable Wages Table

**Form Purpose
Use Taxable Wages Table (PR05.2) to reduce taxable wages by the amount of a
specified deduction. The deduction must have a tax status of X (Exempt) in
PR05.1 (Deduction).

**Processing Effect
The system determines taxable wages for deductions with the calculation type
Tax.




Updated Files

    TAXIDEXMP  - The detail file maintained by this program


Referenced Files

    DEDCODE    - Used to validate the deduction.

    PRSYSTEM   - Used to validate the company and process level.


PR05.3 - Additional Vendors

**Form Purpose
Use Additional Vendors (PR05.3) to select vendors by process level for this
deduction.




Updated Files

    ADDRDATA   -

    APAPPROVAL -

    APAUDIT    -

    APCOMMENTS -

    APCONTACT  -

    APCPYVND   -

    APHLDINV   -

    APVENADDR  -

    APVENBAL   -

    APVENCERT  -

    APVENGROUP -

    APVENLOC   -

    APVENMAST  -

    APVENPAY   -

    CBBANKINST -

    CBCASHCODE -

    CUSTDESC   -

    MXLISTHDR  -

    MXLISTMBR  -

    POVENDLOC  -

    POVENDOR   -

    PRVENDOR   -

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -


Referenced Files

    APACCRCODE -

    APAPPROVAL -

    APAUTHOR   -

    APCOMMENTS -

    APCOMPANY  -

    APCONTACT  -

    APCPYVND   -

    APDISCCODE -

    APDISTHDR  -

    APHLDINV   -

    APHOLDCODE -

    APINCCODE  -

    APINVOICE  -

    APPAYMENT  -

    APPROCGRP  -

    APUSRFLDEF -

    APVENBAL   -

    APVENCERT  -

    APVENCLASS -

    APVNMXVAL  -

    ARCUSTGRP  -

    CBUSER     -

    CBUSRCLASS -

    CUCONV     -

    CURELAT    -

    DEDCODE    - Used to validate the deduction.

    EEADVANCE  -

    EEAPPROVAL -

    EEEXPENSE  -

    GLADDRESS  -

    GLCHART    -

    GLSYSTEM   - The GLSYSTEM file is used to validate general ledger company
                 if distribution  summary types are used.

    INSTCTRYCD -

    INSTREGN   -

    MAINVHAND  -

    MAMATCHTBL -

    MAMSGTOL   -

    MAMTCHRULE -

    MAPOOLCNT  -

    MXCATDEF   -

    MXELEMENT  -

    MXLISTDTL  -

    MXOBJCAT   -

    POAOCDTL   -

    POVAGRMTHD -

    PROCUREGRP -

    PRSYSTEM   -

    PURCHORDER -

    TXTAXRATE  -


PR05.4 - Employment Health Tax Wages

**Form Purpose
Use EHT Wages (PR05.4) to view or enter the wages used to calculate employer
health tax deductions. You can enter historical information by hand, if
needed; however, when you run Employee Wages for EHT (PR125), the Payroll
application updates this form.

**Process at a Glance

1. Define EHT deductions on Deduction (PR05.1)

2. Enter historical wages for EHT on this form or run PR125 to update EHT
wages.

3. Process Payroll

4. View wages updated by PR125 on this form.

**Processing Effect
The Payroll application uses the wages on this form to calculate the employer
health tax deductions.




Updated Files

    PRONWAGES  -


Referenced Files

    DEDCODE    - Used to validate the deduction.

    PRBUSGRP   -

    PRPROVINCE -

    PRSYSTEM   -

    PRTAXAUTH  -


PR05.5 - Employment Health Tax Exemptions

**Form Purpose
Use EHT Exemptions (PR05.5) to enter employer health tax (EHT) exemption
amounts. You can enter the exemptions by report entity or by process level.


Warning Although you can update year-to-date wages on this form, this should
do so only for first-time conversions.

Note If you have employer health tax deductions for provinces that have
exemption amounts you will need to indicate how the exemption amounts should
be applied on EHT Exemptions (PR05.5) each year based on how your employer
health tax account numbers are assigned to their Lawson process levels.

**Process at a Glance

1. Define EHT deductions on Deduction (PR05.1).

2. (Optional) Enter historical wages for EHT on EHT Wages (PR05.4).

3. (Optional) Enter exemptions on this form.

4. Run PR125 to update EHT wages.

5. Process Payroll

6. View wages updated by PR125 on this PR05.4.

**Processing Effect
If you do not enter exemption amounts, BSI will use the default exemption
amount for the tax authority. Exemption amounts/percents and applicable
indicator should only be entered for a process level or report entity that has
an associated EHT account number.




Updated Files

    PRREGPARM  -


Referenced Files

    DEDCODE    -

    PRPROVINCE -

    PRSYSTEM   -

    PRTAXAUTH  -

    TAXGROUP   -


PR05.6 - Process Level Accrual Accounts

Updated Files

    PRDEDACCTS -


Referenced Files

    DEDCODE    -

    GLINTCO    -

    GLSYSTEM   -

    PRSYSTEM   -


PR05.7 - Process Level Expense Accounts

Updated Files

    PRDEDACCTS -


Referenced Files

    ACACCTCAT  -

    DEDCODE    -

    GLINTCO    -

    GLSYSTEM   -

    PRSYSTEM   -


INVOKED Programs

    ACAC
    ACCL
    ACTA
    API4
    IFAC
    IFAU
    IFCU
    IFOB
    IFSG
    SLSE
    SLSU
    IFLU