UPCALC - NEGATIVE NET PAYS#

Overview#

In UPCALC, when net pay is negative, it can cause negative deposits. PC Usage 9 is available so the negative net pay amount can be stored in another PC and then change the general net pay PC to zero.

UPCALC – Negative Net Pay Scenario#

When an employee’s pay is calculated and the results are as follows:

PC 0010 Gross Pay = 0.00
PC 0020 Total Ded = 275.93
PC 0030 Net Pay = -275.93

This situation may be a result of an addition User Calc in the ‘Final Pay Point’ that generates addition deductions after the Insufficient Earnings logic, or if there is programming errors or database errors in creating Sundry arrears lines. The UPCALC will generate the ‘Negative Net Pay’ amounts according to this formula:
Net Pay = Gross – Deductions

For example:

If Gross = 0, Total Deduction = 275.93, then

when Deductions are not being processed by Arrears or Advance, then Net Pay would be negative. Net Pay = Gross – Deductions Net Pay = 0 – 275.93 Net Pay = – 275.93

When Net Pay is not zero, UPCALC Net Pay Split process will distribute the Net Pay amount according to IPPM Payment Split Method into Deposit pay component or Check pay component, this process is necessary in order to balance the pay

The Negative Deposit amount will be rejected by the bank and therefore UPCALC should capture this scenario before the disbursement

Below is the UPCALC processing logic to handle this Negative Net Pay scenario, which may cause

Setup#

On the IPPC form, must setup a Pay Component for PC Usage 9 Negative Net Pay in order to capture the negative net pay amount.

Negative Net Pay Logic#

Negative Net Pay – when IPPC is NOT set up#

In UPCALC ‘Final Pay Point’ Net Pay Split logic, when Net Pay pay component (Usage 3) is negative, UPCALC will move the Net Pay amount to Negative Net Pay pay component (Usage 9), then change Net Pay PC (Usage 3) to zero and issue exception message:
  • PR#-00619 - *** Net Pay #1 is negative, PC #2 net pay is changed to 0

If a pay component for PC Usage 9 has not been setup, then the ‘Negative Net Pay’ amount will be moved back to Net Pay PC, this allows the Pay to be balanced and RPREGC Pay Register report to show the negative net pay for user to locate the employee with negative net amount, UPCALC will issue this exception message:

  • PR#-00621 - *** Warning: Pay Component is not set up for PC Usage 9 Negative Net Pay, #1 goes back to Net Pay PC. Please set up PC for Usage 9 to store Negative Net Pay amount. Employee should not have negative net pay, please fix the problem and re-run this pay.

Negative Net Pay – when IPPC is NOT set up#

In UPCALC ‘Final Pay Point’ Net Pay Split logic, when Net Pay pay component (Usage 3) is negative, UPCALC will move the Net Pay amount to Negative Net Pay pay component (Usage 9), then change Net Pay PC (Usage 3) to zero and issue exception message
  • PR#-00619 - *** Net Pay #1 is negative, PC #2 net pay is changed to 0

If a pay component for PC Usage 9 has been setup, then the ‘Negative Net Pay’ pay component will store the negative Net Pay amount, this allows the Pay to be balanced and the RPREGC Pay Register report to show the negative net pay for user to locate the employee with negative net pay, UPCALC will issue exception message:

  • PR#-00620 - *** PC #1 is stored with #2. Employee should not have negative net pay, please fix the problem and re-run this pay
When Net pay = 0, there will be no split for Deposit or Check amount

From RPREGC report, users must audit the Totals page at the end of report, if there are amounts in the Negative Net Pay pay component (Usage 9), users must locate the employee and review the problems that caused this negative net pay, fix the problem and then re-run the pay for the employee

When users are auditing a pay or Payrun totals on RPREGC, the Net Pay formula should be: Net Pay = Gross – Deduction

Please note that Net Pay should include Pay components from Usage 3 (Net Pay) and Usage 9 (Negative Net Pay).


Notes #

Click to create a new notes page