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)

TableDescriptionSystem
ACCOMMITActivity CommitmentsAC
ACCOMMITXActivity Commitments DetailAC
ADDRDATAAddress CodeIF
C6EMPADDRTNo description in the Lawson data dictionaryC6
C6EMPINVNo description in the Lawson data dictionaryC6
C6EXEMPTNo description in the Lawson data dictionaryC6
C6HOUSERNTNo description in the Lawson data dictionaryC6
C6NETWAGENo description in the Lawson data dictionaryC6
C6PREVEMPNo description in the Lawson data dictionaryC6
C6PROJECTNNo description in the Lawson data dictionaryC6
EMACHDEPSTEmployee ACH AccountPR
EMDEDMASTREmployee DeductionPR
EMPACHDISTEmployee ACH DistributionPR
EMTAMASTREmployee Time Accrual MasterTA
FBDETAILBudget DetailGL
FBFUNDAMTBudget Fund BalanceGL
FBTRANSBudget TransactionsGL
FBYETRNo description in the Lawson data dictionaryGL
GLCOMMITGL CommitmentsGL
GLCOMMITXGL commitment DetailGL
GLHISCOMBLNo description in the Lawson data dictionaryGL
GLHISCOMXNo description in the Lawson data dictionaryGL
HRHISTORYHR HistoryHR
LPPENDREQNo description in the Lawson data dictionaryLP
ONETMDEDPayroll One-time DeductionPR
PAYDEDUCTNEmployee Payment DeductionsPR
PAYMASTREmployee Payment MasterPR
PRCHECKEmployee PaymentPR
PRDEDDTLNo description in the Lawson data dictionaryPR
PREMPBANKNo description in the Lawson data dictionaryPR
PRGARNHISTContains the history for a particular garnishment (case number and file number).PR
PRMONITORNo description in the Lawson data dictionaryPR
PRPENFSRCHNo description in the Lawson data dictionaryPR
PRPENHISTNo description in the Lawson data dictionaryPR
PRSYSTEMHR Company and Process LevelsHR
PRTIMEEmployee Pay/Hours HistoryPR
PRTRDADJNo description in the Lawson data dictionaryPR
SUBCKPOINTSubledger Check PointIF
TAEMPSERVEmployee LP Service RecordLP
TIMERECORDEmployee Time RecordsPR

Referenced files (72)

TableDescriptionSystem
ACACCTCATActivity Account CategoriesAC
ACACTGRPActivity GroupAC
ACACTIVITYActivityAC
ACCALActivity CalendarAC
ACCALXActivity Calendar DetailAC
ACCATSUMXAccount Category Summ DetailAC
BANKACCTBank AccountPR
BANKFILEBank CodePR
BNLIMITSBenefit LimitsHR
C6BANKMNo description in the Lawson data dictionaryC6
C6EMDDMSTRNo description in the Lawson data dictionaryC6
C6EMPADDRTNo description in the Lawson data dictionaryC6
C6INPFNo description in the Lawson data dictionaryC6
C6INVESTNo description in the Lawson data dictionaryC6
C6NETWAGENo description in the Lawson data dictionaryC6
C6PRDDEFNo description in the Lawson data dictionaryC6
C6PRDDTLNo description in the Lawson data dictionaryC6
C6TAXGRPNo description in the Lawson data dictionaryC6
COMPHISTEmployee Compensation HistoryBN
DEDCODEDeductionPR
EMDEPENDEmployee DependentHR
EMPLOYEEEmployeeHR
EMSTATUSEmployee/Applicant StatusHR
FBFUNDDTLBudget Fund DetailGL
GLADDRESSGeneral Ledger Company AddressIF
GLCHARTGeneral Ledger ChartIF
GLNAMESGeneral Ledger NamesIF
GLSYSTEMGeneral Ledger CompanyIF
HRHISTORYHR HistoryHR
HRSECLEVEmployee Security LevelHR
INEMPLOYEENo description in the Lawson data dictionaryC6
INSTCTRYCDIntrastat Country CodesTX
JOBCODEJob Code ParametersHR
PAEMPLOYEEEmployee Personnel InformationHR
PASCRTYData Item Attribute ParametersHR
PAYSUMGRPPay Summary GroupsPR
PCODESHuman Resource CodeHR
PCODESDTLContains contact information detail (address and phone number) for specific types of PCODES.HR
PLANPL Group DetailBN
PRBUSGRPNo description in the Lawson data dictionaryPR
PREMDEDHSTEmployee Deduction HistoryPR
PREMPGARNUsed to store information to identify a particular garnishment per employee per company.PR
PRGARNRULEThe Garnishment Rules files contains garnishment rules by governing tax authority and category for wage formulas…PR
PRGARNRULXNo description in the Lawson data dictionaryPR
PRGARNTYPEContains the type of garnishments and categories to which they are linked.PR
PRMINWAGEMinimum WagePR
PRONWAGESNo description in the Lawson data dictionaryPR
PROTPAYPRDOvertime Pay PeriodsPR
PROVERTIMEOvertime Pay PlanPR
PRPAYCODEPay CodePR
PRPENFSRCNo description in the Lawson data dictionaryPR
PRPENFSRCHNo description in the Lawson data dictionaryPR
PRPENPAYNo description in the Lawson data dictionaryPR
PRPROCGRPPayroll Process GroupHR
PRREGPARMNo description in the Lawson data dictionaryPR
PRSAGDTLStep & Grade Schedule DetailHR
PRSAGHEADStep & Grade Schedule HeaderHR
PRSTATEStatesPR
PRTAXAUTHTax AuthorityPR
PRTAXLEVYPayroll Tax LevyPR
PRTAXLOCNo description in the Lawson data dictionaryPR
PRTIMEEmployee Pay/Hours HistoryPR
PSGRELATEPay Class/Pay Sum Grp RelationHR
PSGTAXESPay Summary Group TaxesPR
QUARTDEDQuarterly DeductionPR
SYSTEMCODESystem CodeIF
TAXGROUPPayroll Tax Reporting GroupPR
TAXIDEXMPPay/Deduction Exemption CodePR
WCCLASSWork Comp Class DetailPR
WCCLASSHDRWork Comp Class HeaderPR
WCCLASSOVRNo description in the Lawson data dictionaryPR
WCPOLICYWorkers Compensation PolicyPR

Program calls

Invoked programs (17)

ACAC, ACTA, API4, HRLO, IFAC, IFCU, IFLU, IFOB, IFRS, IFSG, IFUP, PRAN, PRBA, PRBN, PREN, SLSE, SLSU