Integration of HR-FI issues

[Former Member]

Hi All,

We require help in the following HR-FI integration areas.

1. Loans & Advances

We have the following types of advances

Staff Advance - Recoverable

Staff advance - Furniture

Staff advance - Routine Expens

Staff Advance - Adjustable

Staff Advance LTA

Vehicle Loan Recoverable

Car Deposit

How will we handle Employee advances and loans. How will the entry flow from

HR to FI in case of any advance.

Will the same be affected at the time of payrol posting or do we have to

pass FI entries for the same(Its been learnt that we can run the off-cycle payroll run of the same).

We have create special GL for all these loans and advances to employees. In

case HR is being implemented, then do we need all these special GL codes.

Is it possible to post directly to special GL by means of development or

user exit, as SAP didnt gave the provision to post to Spl. GL

-

---

2. Bank Transfer: How will we take care of salary processing in case of bank

transfer, cash payments and cheques to employees. How the system identifies the kind of payment to the employee(I hope it comes through the Bank details from HR master) and the bifurcation of the payment type and their detail note.

These are the major issues for which I wish to have the solution.

Thanks and regards,

Srn

[Former Member · Accepted solution]

hi,

1. Posting Loans can be to a vendor account using account type as 'KF'(Posting to fixed vendor accounts)

2. Posting of advances can be to acct type "Q"( Posting to Bance sheet with Employee numbers)

3. For any bank payment generation if the employee netpay is to be posted to the bank account , the /559 WT is been posted with as the vendor account to respective Employee bank account numbers after exiting the payroll and after FI posting

or using DME SAP Std for bank deposits.The payment method as Cash Payment & Cheques & Bank depends on the IT0009 records and accordingly the WT /557,/558 & /559 is created in RT

Regards

Hemant V. Mahale

[sikindar_a]

Generally.....

say if u have Housing loan

u have to take two wage types which are custom one is for

Houseing loan payment from /LOP

another is Loan repayent form /LRP

and seaparate GL account based on loan payment is necesary in order to know the exact result

Regarding bank result

check

/557 cheque payment

/558 Cash Payment

/559 Bank tranfer

this wage types will get triggres based on the selection u have given in It0009

Edited by: Sikindar on Jul 22, 2009 11:03 AM

[Former Member]

Hi Sikindar,

Thank you so much for the instant reply.

I would like to explain my query in detail.

Ex: I am giving the loan/Advance to employee of Rs. 10000 for a period of 1 year with 12% interest.

What should be the business process in SAP?

I would like to map the below scenario:

Firstly, the advance request will be given by the accounts department to the HR and HR maintains the loan deduction for the employee in the HR master?

My Requirement is u2026 Then in FI, the advances are normally to be treated as Spl., GL, by which they post to the employee, and it will clear the advance balance as and when the loan is deducted through payroll, for the same the deduction amount has to hit the spl. Gl account and the auto clearing of the debt by employee has to be done.

But in SAP, I believe there is no provision for spl. Gl to hit through payroll

This is the big question, as to how I could find the solution for the same

My question involves process as well as treatment for the above scenario.

Kindly help me out in this regard in detail.

Thanks and regards,

Srn

[sikindar_a]

Firstly, the advance request will be given by the accounts department to the HR and HR maintains the loan deduction for the employee in the HR master?

My Requirement is u2026 Then in FI, the advances are normally to be treated as Spl., GL, by which they post to the employee, and it will clear the advance balance as and when the loan is deducted through payroll, for the same the deduction amount has to hit the spl. Gl account and the auto clearing of the debt by employee has to be done.

But in SAP, I believe there is no provision for spl. Gl to hit through payroll

This is the big question, as to how I could find the solution for the same

Maintain the Loan subtype with proper interset rate and modify the PCR in the sub schema i think u are aware of that

later.... in the standrad Laon functionlity in payment tab

we have lot of option like Payment thru External payment if we use this option

the payment will not be displayed in the pay slip

but the Repayment will get displayed if the repay,ent starts in the same month

if the payment type is thru the pay roll both the payment and repayment will get displayed in the pay lsip

And regarding the GL account if the FI is giveing advace than he shd enter the amount for respective GL from CO side

and repay,ent will hit the GL accoutn for Loan Repayment as per the standrad one

and when there is advace given thru PY then loan payment will get hir the GL account given by the CO people

here why do u want SP GL account ??

only in one scenario we shd check that is wht in the case when the laon advace has been given to the employee form the FICO side ???

[Former Member]

Hi Sikindar,

Many a Thanks agian.

Your knocked the right chord.

My query is with respect to the advance given from the FI Side and hence I was looking for the Spl. Gl.

Here an advance amount is posted to the Employee vendor as a spl gl, and the details of that advance is sent to the HR and in HR we maintain the said process by you.

Fi will give the GL account to which the repayment has to be posted through payroll. Here in order to make the advance auto knockoff, FI has to give the spl gl account no for the Recovery symbolic account, so the respective debit and credit is posted and the advance is cleared by the end of due date. But, system is not allowing to assign this gl account as it is a reconciliation account and cannot be posted directly.

For the above said reason, what are the solutions to find the amount of loan/advance pending for the employee (any report) and reconciliation of the same to match the balances.

Thanks and regards,

Srn

[sikindar_a]

yes

Reconcillation account cannot be posted directly as there is some settings hs to be done from FICO

for the repayment why do u want the spl GL account

suppose wht in case if the Loan is porcessed thru PY department than also it shd hit the GL right

if yes why cannot we assign the same GL account to the Repayment As the nature wise both are same

the only differece is if the laon is paid thru FICO it wont get displayed so for this the CO user has to update the GL once the loan is granted

we shd check this one

and regarding the report

check the tcode

PC00_M40_LON1

or

PC00_M99_CLOF ................