Loan infotype 45 - updating error

[Former Member]

Hi Guru's

Whenever i am trying to update loan infotype(45) iam getting the error "The Employee 00040029 is not eligibile for the loan 9025 on 01.06.2009" Is there any relationship between salary advance recovery wage type and loan infotype 45, if there is link then where we need to give the link.

Regards,

Ravi

[Former Member · Accepted solution]

The Loan Eligibility is set in that manner :-

just check the Loan configuration Table , Particularly table V_T7INJ3

SPRO > Payroll >country > Company Loans

[Former Member · Accepted solution]

Hi,

I have maintained V_T7INJ3 table, but still iam getting the same error.

Regards,

Ravi

[Former Member · Accepted solution]

Also check ALOAN feature

[Former Member · Accepted solution]

Hi Archana,

I have checked the feature ALOAN. it only has Germany under Molga with some written values.

Regards,

Ravi

[Former Member · Accepted solution]

If u r doing for India payroll, maintain 40 (Molga)

[Former Member · Accepted solution]

No friends Molga 40 is not working, the same error is repeating.

Regards,

Ravi

[Former Member · Accepted solution]

check features , ALOAN, 40LGR, table T506C, V_T7INJ3

[Former Member · Accepted solution]

Hi,

Thanks i have maintained data in the feature 40LGR, so now iam not getting the error.

But loan data is not displayed in Payslip. May i known the model wage type for loan and loan payment. how many wagetypes i need to maintain and where they are appeared (payments, deductions or Additional payments)

Ex:- My client wants to give 200000 loan to an employee, for which the repayment is for 20000 / Month. The loan is recovered in 10 months with out any interest.

Regards,

Ravi

[Former Member · Accepted solution]

/LLB Loan balance

/LOE External loan payment

/LOP Loan payment - payroll

/LRP Regular repayment

There would appear in payslip. Loan paymnent in the first month u will get /lop.

from repayment start date u will get /lrp and /llb

[sikindar_a · Accepted solution]

ravi check the below thread

for laons u have to modifiy the Schema XLOZ

and under that technical wage type u have to insert ur model wage and

> u have to Copy the customer wage types form /LRP loan repayment nad /LOP loan payment

Once u insert ur Cusomter wage type in PE51 form

they wil appear

dont do anything wiht technical wage type

Edited by: Sikindar on Jul 1, 2009 4:38 PM

[Former Member · Accepted solution]

I have copied /LPR and /LOP to customer wage (9025, 9024) and assigned 9025 to Recurring payments and deductions and 9025 to basic pay wage group, Is this the correct assignment? I have also maintained the PCR XLOZ with customer wagetypes.

But still i dont get the above wagetypes in remuneration statement. Should i do any changes in v_512w_d.

Please guide me.

Regards,

Ravi

Edited by: ravi Kumar on Jul 2, 2009 2:31 PM

[sikindar_a · Accepted solution]

try like this

say u r haveing two loan types

1 Houseing Loan

2. Personal Loan

for IT0045 create two sub types 9001 for Houseing Loan 9002 for Personal Loan

u can chec the same in the Configuration

now

for Houseing Loan copy two wage types

9021 from /Lop Loan payment

9022 form /LRP loan Repayment

do same for Personal Loan

now go to XLOZ rule in PE02

Copy it as ZLON

under the node /LOP that is loan payment

make

add L9001 this is ur subtype for Houseing loan

under that ADDWTE9021 as this is ur wage type for Loan Payment

the same logic applicable for /LRP here u have to keep 9022

This are loan related wage type payments fo u shd not include anything in IT0014 and IT0015 sitll have doubts let me know i will check it

[Former Member · Accepted solution]

Hi,

Its not coming, i didnt understand where we need to insert "add L9001 this is ur subtype" in the ZLON PCR.

Regards,

Ravi

[sikindar_a · Accepted solution]

Ravi

XLOZ

100 is ur subtype

under that u wil find ADDWTE1LRP right this is standrad

same like that

copy from XLOZ to ZLON

add ur loan subtype

9001 ex houseing loan

under that ADDWTE9022 this ur wage type for Loan Repayment

/LRP

****

9001 ur subtype

ADDWTE9022 ur wage type for loan Repayment

same for /LOP loan payment

/LOP

****

9001

ADDWTE9021 this is wage type for /LOP

>note u shd copy two wage types from /LRP /LOP

[Former Member · Accepted solution]

Hi Sikindar,

I did exactly same but still its not coming.

I have maintained IT 45,

Maintained all nodes in SPRO->Company Loan

Copied /LRP /Lop to customer wagetpes.

Maintained PCR XLOZ (same as u said) but still i could not get any items related to loan in remuneration statement. Apart from this is there any thing we need to do.

Regards,

Ravi

[sikindar_a · Accepted solution]

ok

now check with this

Add the cusomter wage type

in PE51 one add PAYment wage type in Additons in Cumulation ids

and Loan Repaymetns in the deductions side

now Check the log

if u expand the log it shd be like this

/LOP 1000

/LRP 100

here ur payment i have taken as 1000 and repayment i have taken 100

and under that technical wage type will be ur customer wage types

9022 1000 /LOP

9021 100 ./LRP

[Former Member · Accepted solution]

Not coming once again,

I have seen the payroll log, there is no amount.

I think the problem is with PCR.

Regards,

Ravi

[sikindar_a · Accepted solution]

send me the screen shot .........

of the PY LOG and the Loan PCR

[Former Member · Accepted solution]

sent screen shot, please check.

Regards,

Ravi

[sikindar_a · Accepted solution]

9025 is ur subtype right

do like this 9025 is ur subtype

9024 is Loan repayment

9026 is ur Loan Payment

note both of the wage type shd be copied form /LRP /LOP

Ur PCR is right if u follow the above method

and wht is the important is how u have maintained IT0045 wht u have check is check whetehre u have maintained all the threee tabs dont forget to maitain the Pyaments tab that is the thrid one

and ur PCR shd be in

XLON Sub Schema commet XLOZ

and insert ur PCRas lke this PRT ZLON NOAB Loans

and make sure u have added ur /LOP that is laon payment in additions and /LRP in Deductions note u have to add both techincal loan wage type and ur customer wage type in the pay silp

>had sent u the PCR of mine pls check

[Former Member · Accepted solution]

Hi,

First of all thanks for your valuable inputs.

Iam getting Loan payment(/LOP) in payments, but iam not getting loan repayment (/LRP) in deductions, though i have maintained 45 infotype.

Loan payment also iam getting 2 amounts

Loan payment payroll

Loan Payment.

Regards,

Ravi

[sikindar_a · Accepted solution]

send me the screen shot

hope u have maitained

IT0045 properly

first tab amount given second tab conditions third tab payment type

and ur PCR and make sur that u have inculded ur repaymnt in the Deduction side

[Former Member · Accepted solution]

Thanks a lot now it is working perfectly,

For double amount display i have deleted /lop and /lrp from pe51

now iam getting loan repayment wage type too, and its working perfectly.

Thanks once again.

Regards,

Ravi

[sikindar_a · Accepted solution]

Good

Now assing the symbolic account for the loan payment type and loan repayment type and assign it to ur GL account

in OBYE and OBYG

note > check whether the FICO wants same GL for all the loans or different GL as per the Loan types

All the best ravi

[sikindar_a]

Try

> to maitain udner Molga 40 (india)