PR140 – Earnings and Deductions Calculation
- System
- Payroll (PR)
- Type
- Batch program
- Updates
- 42 tables
- References
- 71 tables
PR140 (Earnings and Deductions Calculation) is a Lawson Payroll batch program. It updates ACCOMMIT, ACCOMMITX, ADDRDATA, C6EMPADDRT, C6EMPINV, C6EXEMPT, C6HOUSERNT, C6NETWAGE and 34 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, BANKACCT, BANKFILE and 63 more.
About PR140
Run Earnings and Deductions Calc (PR140) to calculate and report employee deductions, company deductions, and net pay for all employees with Current status time records. The system creates Earnings and Deduction Calculation report every time you run PR140. For each employee, this report lists: - Wage detail - Employee paid deductions - Company paid deductions The system creates the Garnishment report every time you run PR140. For employee who has garnishments, this report lists: - Gross pay - Disposable income - Wages exempt from garnishment - Deduction amounts. When you run PR140, the Payroll system can also create three additional reports: - Error report - Warning report - Error Time Record Deleted report The system creates the Error report if there are time records that the system cannot process because of an error. It lists the time records that are in error. The system creates the Warning report if there are BSI tax warnings. This report lists the employee the warning applies to and the warning itself. If you do not want to create a Warning report, select No in the Tax Warning Messages field on PR140. The system creates the Error Time Records Deleted report if you chose to delete error time records when you ran PR140. This report lists the deleted time records. If you chose to delete error time records, you must re-enter the time records listed on this report before you can process them. IMPORTANT If you have made changes to PR26.1 (Employee Garnishments), you need to run PR115 (Garnishment Update) before you run PR140. If you re-run PR140, the application will change the Prenotify Status fieldon Direct Deposit Distribution (PR12.1) from Prenotified back to Not Prenotified. The program resets this field automatically for employees who were in a prenotified status for the current cycle, so that the rerunning of PR140 will not advance the Direct Deposit record into an Accepted status prematurely. To recreate the prenote file, run PR160 for Prenote Also or PrenotificaionOnly. If a processed time record is deleted for an employee who has been prenotified in the current payroll, then Time Record Entry (PR36.1) will change the Prenotify Status from P back to N.
Updated files (42)
| Table | Description | System |
|---|---|---|
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ADDRDATA | Address Code | IF |
| C6EMPADDRT | No description in the Lawson data dictionary | C6 |
| C6EMPINV | No description in the Lawson data dictionary | C6 |
| C6EXEMPT | No description in the Lawson data dictionary | C6 |
| C6HOUSERNT | No description in the Lawson data dictionary | C6 |
| C6NETWAGE | No description in the Lawson data dictionary | C6 |
| C6PRDDTL | No description in the Lawson data dictionary | C6 |
| C6PREVEMP | No description in the Lawson data dictionary | C6 |
| C6PROJECTN | No description in the Lawson data dictionary | C6 |
| CKPOINT | No description in the Lawson data dictionary | — |
| EMACHDEPST | Employee ACH Account | PR |
| EMDEDMASTR | Employee Deduction | PR |
| EMPACHDIST | Employee ACH Distribution | PR |
| EMTAMASTR | Employee Time Accrual Master | TA |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| HRHISTORY | HR History | HR |
| LPPENDREQ | No description in the Lawson data dictionary | LP |
| ONETMDED | Payroll One-time Deduction | PR |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| PAYMASTR | Employee Payment Master | PR |
| PRCHECK | Employee Payment | PR |
| PRDEDDTL | No description in the Lawson data dictionary | PR |
| PREMPBANK | No description in the Lawson data dictionary | PR |
| PRGARNHIST | Contains the history for a particular garnishment (case number and file number). | PR |
| PRMONITOR | No description in the Lawson data dictionary | PR |
| PRPENFSRCH | No description in the Lawson data dictionary | PR |
| PRPENHIST | No description in the Lawson data dictionary | PR |
| PRSYSTEM | HR Company and Process Levels | HR |
| PRTIME | Employee Pay/Hours History | PR |
| PRTRDADJ | No description in the Lawson data dictionary | PR |
| SUBCKPOINT | Subledger Check Point | IF |
| TAEMPSERV | Employee LP Service Record | LP |
| TIMERECORD | Employee Time Records | PR |
Referenced files (71)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| BANKACCT | Bank Account | PR |
| BANKFILE | Bank Code | PR |
| BNLIMITS | Benefit Limits | HR |
| C6BANKM | No description in the Lawson data dictionary | C6 |
| C6EMDDMSTR | No description in the Lawson data dictionary | C6 |
| C6EMPADDRT | No description in the Lawson data dictionary | C6 |
| C6INPF | No description in the Lawson data dictionary | C6 |
| C6INVEST | No description in the Lawson data dictionary | C6 |
| C6NETWAGE | No description in the Lawson data dictionary | C6 |
| C6PRDDEF | No description in the Lawson data dictionary | C6 |
| C6PRDDTL | No description in the Lawson data dictionary | C6 |
| C6TAXGRP | No description in the Lawson data dictionary | C6 |
| COMPHIST | Employee Compensation History | BN |
| DEDCODE | Deduction | PR |
| DEPTCODE | Department | HR |
| EMDEPEND | Employee Dependent | HR |
| EMPLOYEE | Employee | HR |
| EMSTATUS | Employee/Applicant Status | HR |
| FBFUNDDTL | Budget Fund Detail | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| HRHISTORY | HR History | HR |
| HRSECLEV | Employee Security Level | HR |
| INEMPLOYEE | No description in the Lawson data dictionary | C6 |
| INSTCTRYCD | Intrastat Country Codes | TX |
| JOBCODE | Job Code Parameters | HR |
| PAEMPLOYEE | Employee Personnel Information | HR |
| PASCRTY | Data Item Attribute Parameters | HR |
| PAYSUMGRP | Pay Summary Groups | PR |
| PCODES | Human Resource Code | HR |
| PCODESDTL | Contains contact information detail (address and phone number) for specific types of PCODES. | HR |
| PLAN | PL Group Detail | BN |
| PRBUSGRP | No description in the Lawson data dictionary | PR |
| PREMDEDHST | Employee Deduction History | PR |
| PREMPGARN | Used to store information to identify a particular garnishment per employee per company. | PR |
| PRGARNRULE | The Garnishment Rules files contains garnishment rules by governing tax authority and category for wage formulas… | PR |
| PRGARNRULX | No description in the Lawson data dictionary | PR |
| PRGARNTYPE | Contains the type of garnishments and categories to which they are linked. | PR |
| PRMINWAGE | Minimum Wage | PR |
| PRONWAGES | No description in the Lawson data dictionary | PR |
| PROTPAYPRD | Overtime Pay Periods | PR |
| PROVERTIME | Overtime Pay Plan | PR |
| PRPAYCODE | Pay Code | PR |
| PRPENFSRC | No description in the Lawson data dictionary | PR |
| PRPENFSRCH | No description in the Lawson data dictionary | PR |
| PRPENPAY | No description in the Lawson data dictionary | PR |
| PRPROCGRP | Payroll Process Group | HR |
| PRREGPARM | No description in the Lawson data dictionary | PR |
| PRSAGDTL | Step & Grade Schedule Detail | HR |
| PRTAXAUTH | Tax Authority | PR |
| PRTAXLEVY | Payroll Tax Levy | PR |
| PRTAXLOC | No description in the Lawson data dictionary | PR |
| PRTIME | Employee Pay/Hours History | PR |
| PSGRELATE | Pay Class/Pay Sum Grp Relation | HR |
| PSGTAXES | Pay Summary Group Taxes | PR |
| QUARTDED | Quarterly Deduction | PR |
| SYSTEMCODE | System Code | IF |
| TAXGROUP | Payroll Tax Reporting Group | PR |
| TAXIDEXMP | Pay/Deduction Exemption Code | PR |
| WCCLASS | Work Comp Class Detail | PR |
| WCCLASSHDR | Work Comp Class Header | PR |
| WCCLASSOVR | No description in the Lawson data dictionary | PR |
| WCPOLICY | Workers Compensation Policy | PR |
Program calls
Invoked programs (17)
ACAC, ACTA, API4, HRLO, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, PRAN, PRBA, PRBN, PREN, SLSE, SLSU