PF calculation working wrong in RT table

[Former Member]

Hi

Kindly check below calculation for PF in RT table.

My question is /3F6 is 60000 (/3F5(5000)*12), but system is showing 59,000. Did I missed any config ????

/3F1 Ee PF contribution 01 01 5,000.00

/3F3 Er PF contribution 01 01 4,459.00

/3F4 Er Pension contribution 01 01 541.00

/3F5 Ee Mon PF contribution 5,000.00

/3F6 Ee Ann PF contribution 59,000.00

/3F9 PF adm chrgs * 1,00,000 01 01 45,833,700.00

/3FA PF basis for Ee contrib 01 01 41,667.00

/3FB PF Basis for Er Contrib 01 01 41,667.00

/3FC Pension Basis for Er cont 01 01 6,500.00

/3FE Interest accrued on total 365.00

/3FJ VPF basis for Ee contrib 01 01 41,667.00

/432 Agg of Chapter VI 59,000.00

I think /432 is 6000(5000*12), why system is calculating 59000,

did I missed any configuration ????????

Please guide me ..

Thanking you

Regards

Nandhini

[Former Member]

/3F6 calculation formula is as follows -

/3F5 = /3F5 YTD (year till date it will come from last month CRT) + /3F5 current month + /3F5 current month * projection factor.

Here YTD value is the one which is creating problem or rather you say because of it, it is coming less.

Try checking /3F5 in CRT table of last months one by one, you will get the month where it had been reduced.

[Former Member]

Thanks Rem and praveen , Now its working fine ......

Regards

Nandhini

[former_member193210]

I'm not familiar with WT /3F6, but try doing a Payroll Simulation for one employee, with the LOG turned ON.

Expand the resulting log and search for all occurrences of WT /3F6 to identify where the value 59000,00 is created (and whether the value 60000,00 exists at one point in your schema).

Once you have located the point where the value is created (or modified), you should have more elements to idenfity the source of the discrepancy.