Process Pay Audit Log - Transaction could not be split

Payroll | Process Pay | Audit log

Summary

This topic explains how to manually split transactions when the following type of warning appears in the process pay audit log:

"Transaction (101) with amount (1384.64) could not be split"

Problem

PayGlobal lets allowances have their cost centres determined automatically using proportional costing. One method is to set up an allowance group for the allowances that are used to assign cost centres when they are present in the pay.

For example, if the allowance group contains allowances 100 and 200, and allowance 666 is set to cost proportionately using this allowance group. Allowances 100 and 200 are included in a pay and they are assigned to cost centres ABC and EFG respectively. If allowance 666 is then added to the pay, it is split between cost centres ABC and EFG depending on the total amount of each of those cost centres.

The splitting problem occurs when negative transactions from the ‘source’ allowances are included in the pay.

Allowance code	$ Amount	Cost Centre
200	80	XYZ
200	-79.99	ABC
Total of allowance group	0.01
Total of Cost Centre XYZ	80
Total of Cost Centre ABC	-79.99
666	100	Calculated

Cost Centre XYZ = 100 x 80 / 0.01 = $800,000

Cost Centre ABC = 100 x 79.99 / 0.01 = $-799,900

This process gives a Nett result of Allowance code 666, cost centre ABC, amount $100, which is mathematically correct, but causes large total amounts and cost centre totals. This problem not only occurs when the values are a few cents, it also occurs with larger amounts.

Additionally, when these values are very large, PayGlobal cannot handle them so process pay crashes and generates errors.

Solution

You need to change the transactions in your pay if you want your proportionally costed allowance transactions to split correctly.

Your options are:

Do nothing. No split will occur and the default cost centre will be used.
Create separate pays for positive and negative transactions. Then enter the proportionally costed allowance into the appropriate pay sequence.

For example:

Pay sequence 1500 has only negative transactions (reversing the original incorrect transactions) and any ‘adjustment’ transactions should be deleted (-79.99).

Pay sequence 1501 has only positive, adjustment transactions that show the correct values (80.00).

Enter the proportionally costed transaction in the appropriate pay sequence. We recommend adding it to the pay sequence with positive transactions because they are correct and will result in the correct split.