Payroll Results posted to FI are in Lakhs

[Former Member]

Hello All,

When posting the results of the Payroll run for any employee (Payroll India), the results that are posted are in lakhs. This is mainly caused due to the following wage types

• /3F7 - EDLI contri * 1,00,000

• /3F8 - EDLI adm chrgs * 1,00,00

• /3F9 - PF adm chrgs * 1,00,000

I've looked through the older threads and it seems that I will have to modify a PCR. However, this is something I've never done before and I would like some help with this.

Can you confirm that modifying the PCR is the only way to go? Also, if it is necessary can you give me step-by-step instructions or point me to a guide for the same?

Thanks all,

Vivek

[Former Member · Accepted solution]

Hi Vivek,

you have to modify PCR INED

[Former Member]

Hi All,

We've managed to modify the PCR ourselves. I'm adding the solution here as a reference if anybody else needs it.

Basically, we created new wage types copies from the original /3F7, /3F8, /3F9 WTs. Then the PCR was modified somewhat as follows

(for /3F7 WT)

RPF1 <---- our PF Trust ID

└ AMT/100000

└ ADDWT 13F7 <-- 13F7 is our copy of the standard /3F7 WT

└ AMT*100000

└ ADDWT /3F7

The same logic is used for the remaining WTs.

It is the copied WTs (i.e. 13F7, 13F8 etc) that are posted to FI and not the originals. The originals need to keep their original value (in lakhs and crores) because the standard PF reports need them that way.

A screenshot of the modified PCR is available [here|http://img78.imageshack.us/img78/6960/zine.png]

Thanks for all the help and pointers that helped us arrive at this resolution.

Regards,

Vivek

Edited by: Vivek Thomas on May 2, 2009 10:55 AM

[Former Member]

Hi,

Copy the rule from INED rule to ZNED, then change the rule like this,

for /3F7

AMT/100000

ADDWT *

/3F8

AMT/100000

ADDWT *

/3F9

AMT/100000

ADDWT *

LET it be the trust there is no problem in that rule, if you have new trust, then change the trust name in rule, and chagne the amt/10 to amt/100000.

Then copy the sub schema INN1 to ZNN1, and insert the rule to after INED rule in ZNN1.

Good luck

Devi.

[former_member583520]

Hi,

If you want this functionality to be done, u have to write a small PCR for this. Because all PF related calculations will be done in INEPF, which is a standard function.

And the PCR will be

ZEDI Personnel Calculation Rule ZEDI

Insert the rule in INN1 Sub schema.

000360 PIT INPR * Addition of PF Basis

000370 INEPF Provident Fund calculations

000380 PIT ZEDI PCR for revised Calculation of EDLI

If you have any query's pls let meknow.

Thanks and Regards,

Revathi.

[Former Member]

Hello Revathi,

Thanks for your quick response!

This is what I've done so far. Please correct me if I've made any mistakes.

1 - Made a copy of PCR INED as ZINE and changed the division to 100000 ([Screenshot|http://img245.imageshack.us/img245/6960/zine.png])

2 - Made a copy of Sub-schema INN1 as ZIN1 and changed the reference to INED to ZINE ([Screenshot|http://img2.imageshack.us/img2/2456/zin1.png]), and

3 - Modified the IN00 schema as ZIN0 and changed the reference to INN1 to refer to ZIN1 ([Screenshot|http://img21.imageshack.us/img21/3430/zin0.png])

However, after running the payroll the WTs are still in the lakhs.

Please can you guide me as to where I went wrong and the necessary corrections?

Thanks and regards,

Vivek

[sikindar_a]

did u modified the PCR

AMT*100000

it shd be AMT/100000 in INED

Edited by: Sikindar on Apr 27, 2009 3:53 PM

[Former Member]

The purpose of PCR INED is for a different reason. You cannot use that for the issue you have given here. No need to mdify or create any rules for calculatinf EDLI and other changes.

Payroll function INEPF while calculating will divide the amount /100000 within the code itself.

If the out put of values from INEPF are very huge, (that means there is a problem in INEPF)then you have to debug and see or else raise a OSS note.

[Former Member]

Hello Sikindar/Revathi,

I have modified the PCR INED but I am still getting this problem. Any other suggestions to fix this?

Spaceship -

Please could you give some more details. I didn't exactly understand what you were trying to convey.

[Former Member]

hi vivek,

While modifying the PCr , have u put in the correct PF Trust Account for reference..........just check out once more....and while doing the processing check in the rt table what are edli amounts coming

[former_member583520]

HI,

Modifying the pcr is the way.

Thanks and Regards,

Revathi.

[Former Member]

Hi Revathi,

Thanks! I actually figured that I would have to modify the PCR based on your response in the thread [].

The thing is that I've never modified a PCR before and don't even know how to begin. Also, will have to make any other changes or modifications besides the PCR?

Thanks,

Vivek