PR89.1 – Payment Modeling
- System
- Payroll (PR)
- Type
- Online screen — form 89
- Updates
- 40 tables
- References
- 72 tables
PR89.1 (Payment Modeling) is a Lawson Payroll online screen (form 89, subform 1). It updates ACCOMMIT, ACCOMMITX, ADDRDATA, C6EMPADDRT, C6EMPINV, C6EXEMPT, C6HOUSERNT, C6NETWAGE and 32 more and references ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, BANKACCT, BANKFILE and 64 more.
About PR89.1
Use Payment Modeling (PR89.1) to model payments or perform net-to-gross calculations. NOTE If you enter an amount in the Exempt field, the calculation is approximate and not an exact amount. **Processing Effect Current PR89 functionality has limitations when calculating based on selected tax deductions for employees set up with a tax filter of 1. In order for the local deduction to calculate in this scenario, you will need topopulate the local authority on the Taxes tab. Local resident authorities are only set up to automatically default to PR89.1 if: - The employee"@Ys tax filter is set to 2 (Locate Fed/State) or 3 (Locate Federal).- and - - The employee"@Ys tax filter is set to 2 (Locate Fed/State) or 3 (Locate Federal).- and - - The employee has Resident City populated on HR11.1 (Employee) or PR13.1 (Employee). PR89.1 will only default the resident city authority, not the work city authority. Alternatively, if you want to take only federal, state, and local taxes in the modeling tool, you can populate the PR89.1deduction cycle field (selecting a cycle that contains only taxes) instead of flagging each individual tax deduction. PR89.1 would then show city taxes as expected.
More information: When you inquire on a specific employee, values defined on the employee record default in the appropriate fields. You can enter a deduction cycle and a payment date to retrieve actual deduction information. You can override any field on the form to process "what if" scenarios for an employee. If you do not select an employee, you must enter the desired deduction amounts or percentages by deduction type, and select the applicable taxes to be included by entering X (Select) next to the desired tax in PR89.3(Payment Calculation). You can optionally enter other tax information in the TaxInformation subform. To process a net-to-gross calculation, leave the Gross Amount field blank and type an amount in the Net Amount field. When the calculation is complete, the form displays the gross amount the employee must be paid to achieve the net amount entered. Three options are available to determine the gross amount to be used in the calculation. - Type the total gross amount and hours for payment modeling. - Select the salary class and type the appropriate annual or hourly rate, and allow the system to calculate the gross. - For a calculation based on a step and grade schedule, select the appropriate schedule, step, and grade, and allow the system to calculate the gross. After you perform payment modeling, you can use the Xfer key to transfer to PR80 (Manual Payment). Select a reserved payment number, select a pay code, enter the calculated gross amount in the Amount field, select X (Calculate), and press OK, to create a payment.
Updated files (40)
| 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 |
| C6PREVEMP | No description in the Lawson data dictionary | C6 |
| C6PROJECTN | No description in the Lawson data dictionary | C6 |
| 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 (72)
| 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 |
| 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 |
| PRSAGHEAD | Step & Grade Schedule Header | HR |
| PRSTATE | States | PR |
| 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