How to Calculate Payroll Cumulative Results in the Future

[Former Member]

I need to calculate the cumulative year end total for a wage type while running payroll for the current period. Is there a function module or another way to do it?

RGDIR only has results up to 4/2016, so I cannot use PYXX_READ_PAYROLL_RESULT

Example:

The current period is 5/2016 and I am running payroll. Within a user exit during payroll run, I will calculate a wage type that is dependent on cumulative year end totals so that I can stay within a year end limit.

Requirement:

I need to calculate the cumulative Year End total for a wage type at 12/2016 (while I am running payroll for 5/2016 (within a user exit)).

How can this be achieved?

Thanks!

[former_member193210 · Accepted solution]

I'm not familiar with US Payroll and 401K requirements, but you could set-up a set of Constants, one for each Payroll Period in a year (eg. 1 to 26 for bi-weekly pays), and create a pcr that would query the Current Pay's number.  Depending on the return value, you would multiply the value of the WT by the appropriate constant to establlish the Future Value of the Employee's pre-tax 401K Contributions, and the result would be transfered into an Information WT.  Note that you may need a second Information WT to hold the Future Value of the Employer Contribution Match.

In the Current Pay's Calculation, you should be able to read the past contributions from the CRT Table and add the projected Future contributions in order to establish the margin available for the after tax contribution.

[SaiKrishna2024]

Hi,

Could you please let me know what is the purpose you want Cumulative results

Thanks,

Sai Krishna

[Former Member]

It is to determine how much we can set an after tax contribution wage type to.

The requirement is: pre-tax 401K contribution + employer match + after tax contribution cannot exceed $53,000.

They want the pre-tax 401K and employer match to take priority over the after tax contribution, so I must calculate end of year values of the pre-tax 401K and employer match wage types to take into account for the calculation.

I plan to calculate the pre-tax 401K and employer match to year end (12/2016). They will take priority over the after tax contribution, so the end of year (future) values must be in the calculation and it will calculate what is left of the $53,000 based on year end values of the pre-tax 401K and employer match.

[SteveBogner]

Why not use the deduction priority settings in v_t51p6 for that? Set the pre-tax wagetypes with a higher priority than the after-tax wagetypes.

If you really must forecast the amount to the end of the year, that would have to be included in custom ABAP code, in either a custom payroll function or operation.