Wiki: UPAUDT

AUDIT PAYROLL TRANSACTIONS#

Processing Information#

All batches and transactions (Pay Detail and Sundry) must be audited before UPCALC will process them.

The audit process will prepare the pays by creating lines for any attendance or benefit lines for the period, organizes the transactions by pay point, picks up sundry lines for this period and calculates per period premiums.

The Audit Payroll Transactions (UPAUDT) allows you to mass update more than one batch at a time, which will produce a detailed report of the transactions.

After the transactions have been generated or entered into IPPH (Pay Header) they must be audited through UPAUDT (Audit payroll transactions).

The audit process prepares pays for calculations by performing the following tasks:

Set Toggles
- Evaluate the period and then set the First Pay in Month toggle
- Evaluate the period and then set the First Pay in Period toggle
Checks for both a Work Jurisdiction and Home Jurisdiction on each pay header
- If any pay headers are missing one or both of these Jurisdictions they will be listed in the report output and the batch will not be Balanced
Pick up all Sundries
- Create pay lines for all qualified sundry transactions
- Create pay lines for all qualified arrears. (e.g. pick up areas from prior pays)
- One Time Sundry Items are created as pay lines and removed from the sundry table
- Declining balances are reduced for sundries with NO element
Premiums
- All ‘Per Period’ premiums are calculated and attached.
Process Pay Points
- Insert pay lines for all tasks on the associated pay point set of the pay header.
- Pay lines are connected to the appropriate pay point set as determined by the pay category on the pay header.
Establish FLSA Tasks
- Create a pay line for each FLSA period ending in the pay period.
Insert ‘UserCalc’ Pay Lines
- Insert an additional pay line for any transaction that invokes a UserCalc.
Insert Begin and End Pay Lines for UPCALC
- These two are not from the Pay Point Set and must be inserted separately.
Expire Sundry for Termination Pays
- Expire all remaining sundry lines for a termination pay.
Batch Balancing
- Compute the totals from all pay lines of a batch and a balance to the element amount in the Control tab of IPBE, if provided.
Physically Remove ‘Cancelled’ Pays
- UPAUDT will physically remove ‘cancelled’ pay headers, pay lines, pay line details that are marked for deletion.

If this process is completed, the Audited and Balanced toggles in IPBE will be turned on. In addition, the system marks the pay headers (IPPH) in that batch so that the Stage field displays “Audit’ and that both the Audit and Preparation toggles are ON.

Before marking a batch as 'Balanced', UPAUDT ensures that there are no pays in the batch for employees with Unaudited Cancelled pays in other batches. In this situation, the UPAUDT process will NOT mark the batch as 'Balanced', and issue will an exception messages for the Audit Report.

This edit ensures that there are no cancelled pays for an employee during UPCALC.

This is required since these cancelled pays may have associated leave lines that MUST be removed before the employee can be calculated.

Report Parameters & Filters#

Report Parameters
Entity	Mandatory, LOV available
Payroll	Mandatory, LOV available
As of Date	Mandatory, Date, LOV available
Batch Eligible	Optional, LOV available Not Eligible or Eligible or Both
Sort Employees by	Optional, LOV Available
Report Heading	Optional Descriptive Field
Print Pay Headers	Optional, LOV Available
Print Pay Lines	Optional, LOV Available
Include Changes ONLY	Optional, LOV Available
Print Transaction G/L	Optional, LOV Available
Print Total Page	Optional, LOV Available
Include EE Changes	Optional, LOV Available
Run ADP Garn	Optional, LOV Available Yes/No - Default is No If Yes, will do ADP GARN validation
Exception Level	Mandatory, LOV available ‘0 – 0’ available

Report Filters
User Name	Optional, Multiple selections, LOV available
Batch Number	Optional, Multiple selections, LOV available

Notes #

Click to create a new notes page