PAM Reconciliation Processor

The PAM Reconciliation Processor compares the output of the Payroll Labor Distribution Consolidation (the payroll accounting tables) against the Advantage Financial Payroll Reconciliation (PYRLAR) table, which contains accounting line details for Payroll Expenditure Correction (PREXC)/Payroll Expenditure (PREXP) transactions that have been submitted to Final.  PAM Reconciliation can be run in two modes:

Adjustment ModeAdjustment Mode

The purpose of the PAM Reconciliation - Adjustment Mode is to update the Advantage HRM Payroll and Fringe Expense Journals with any corrections originated by a PREXC transaction in Advantage Financial. Because the PREXC transaction originated in Advantage Financial, there is no record PREXC transaction in HRM. PAM Reconciliation updates the HRM Payroll Accounting tables with the PREXC transaction details and creates LCRR transactions to make the PREXC transaction updates in the Payroll and/or Fringe Expense Journals.

Payroll ModePayroll Mode

The purpose of the PAM Reconciliation - Payroll Mode is to process PREXP/PREXC transactions that originated in Advantage HRM either through payroll or by a Labor Cost Redistribution Request (LCRR) transaction. The PAM Reconciliation - Payroll Mode has three steps:

  • Step 1: Process all matching records between Advantage Financial’s Payroll Reconciliation (PYRLAR) table and Advantage HRM’s payroll accounting table. For these matching records, Payroll Reconciliation updates the Journal Status Indicator to R (Reconciled) on the Payroll and Fringe Expense Journal.

  • Step 2: Process all records between Advantage Financial’s Payroll Reconciliation (PYRLAR) table and Advantage HRM’s payroll accounting table where the amounts have not changed. This scenario covers situations where there is some kind of Chart of Accounts (COA) Inference on the PREXP/PREXC transaction in Advantage Financial. The PREXP/PREXC transaction accounting line amount has not changed but the COA values have changed.

In step 2 there is an option to have Payroll Reconciliation directly update the Payroll and Fringe Expense Journals or create LCRR Transactions to update the Payroll and Fringe Expense Journals with the new COA values from Advantage Financial. If you want to create LCRR transactions in step 2, please set the Payroll Reconciliation Audit Parameter Flag to Y. An important consideration with the Payroll Reconciliation Audit Parameter Flag set to Y is the LCRR transaction can provide you with a transaction audit trail but will increase the number of records in the Payroll and Fringe Expense Journals.

  • Step 3: Process all records between Advantage Financial’s Payroll Reconciliation (PYRLAR) table and Advantage HRM’s payroll accounting table where the amounts have changed. This is a scenario where a user goes into the PREXP/PREXC transaction and changes the accounting line amount(s). Advantage Financial allows users to change PREXP/PREXC accounting line amounts but the transaction total must remain the same. PREXP/PREXC accounting line amounts are summarized amounts that include several employee’s expenses rolled into a single accounting line. Employee specific adjustments cannot be made in the PREXP/PREXC transactions. Any PREXP/PREXC accounting line amount changes are prorated across all impacted employees.

In Step 3, PAM Reconciliation does not do direct Payroll and Fringe Expense Journal table updates to record any changes made in Advantage Financial. Step 3 creates LCRR transactions to update the Payroll and Fringe Expense Journal tables.