emp vendor line item wise posting

[Former Member]

Hi Experts,

Client requirement is to do personnel vendor account posting for employees whose loan is running instead of expense accounts.

I have configured the steps to meet the requirement in CDV for testing: working on SAP ECC 6.0

1. Define Symbolic account  (V_T52EK😞 set Acc asign type ="K "

2. Define Posting Characteristics of Wage Types

3. Assign Vendor Accounts

     9052  *0002 *0002

Payroll is run for the employee whose vendor account is created, then posted to FI. However, when an employee has 2 or 3 loans then system is posting cumulative amount in employee vendor account.

For example : Employee id :10100001

Loan 1 deduction: 10000

Loan 2 deduction:   5000

Loan 3 deduction:   2000

Vendor account posting is  10100001 : 17000

how can i fix  to post line item wise employee's loan deductions.

waiting for reply.

[Former Member · Accepted solution]

HI,

  You may use special G/L indicator. against loan types.

1. You have to segregate loan deduction if all loan installments are getting added in /LRP   You are needed to split them by writing a PCR. Query Loan type in the rule and create separate wagetypes for separate loan type installment. 

2. Create 3 symbolic accounts and assign it to 3 loan installment wage types.

3. Create 3 special G/L indicator if you have 3 loan types.

4. Assign this special G/L indicator with symbolic account. This can not be done by config. You have to take help of ABAP.

Regards

Anirban

[Former Member · Accepted solution]

Hi Anirban,

Thanks a lot for your reply Please check our configuration for wagetypes.

currently we have below condition As is  :

Wage type		Symbolic Account		G/L account
9VLI	Vehicle Loan Interest	9055	Vehicle Loan Int	33300020	Interest-Staff Loan
9VLP	Vehicle Loan Principal	9054	Vehicle Loan P	23430070	Vehicle Loan
9HLI	Housing Loan Interest	9053	Housing loan Int	33300020	Interest-Staff Loan
9HLP	Housing Loan Principal	9052	Housing loan P	23430060	Housing Loan

and posting is done under above mentioned G/L account. check in image1 and image 2.

now the client requirement is to to post line item wise employee's loan deductions. that is also done

I have done config for the same in CDV as per below:

    

Wage type		Symbolic Account
9VLI	Vehicle Loan Interest	9055	Vehicle Loan Int
9VLP	Vehicle Loan Principal	9054	Vehicle Loan P
9HLI	Housing Loan Interest	9053	Housing loan Int
9HLP	Housing Loan Principal	9052	Housing loan P

all symbolic accounts assigned to vendor account *0002

till this everything is fine, now when employee is having more than 1 loan than system is taking cumulative amount in his vendor code.

please check this posting also in image 3 and image 4.

We also want to assign special G/L indicator to the loan type, but i am not aware about this. if needed BADI than please throw some light on BADI also.

Thanks

[Former Member · Accepted solution]

Hi,

   There are three steps in it. You will be required to use two BADI.

Step 1:

BADI 1: SMOD_PCPO0001 method EXIT_RPCIPE00_00.

             In this method an unused field (ZUONR)  in FI Line item can be filled with value corresponding to special G/L indicator. This BADI is triggered during payroll posting documnet creation.

        Let us say you need 4 different line items in case all these types are available.

Write this within the first BADI,

ZUONR value is populated on the basis of symbolic account (ITEM-KOMOK).

  IF ITEM-KOMOK = '9052'.
ZUoNR = '1'.
ELSEIF ITEM-KOMOK = '9053'.
ZUoNR = '2'.
ELSEIF ITEM-KOMOK = '9054'.
ZUoNR = '3'.
ELSEIF ITEM-KOMOK = '9055'.
ZUoNR = '4'.
ENDIF.

Step 2:

   Create 4 special G/L indicator. 1, 2, 3, 4.

  1 (for 9HLP wagetype).

  2  (for 9HLI wagetype).

  3 (for 9VLP wagetype).

  4 (for 9VLI wagetype).

  Please take help from FI configurator as this would require few other necessary settings.

Step 3:

BADI 2: This is triggered during FI posting document creation.

The Badi AC_DOCUMENT~CHANGE_INITIAL is used. In this BADI via substitution, sp. G/L indicator gets its value in the FI line item on the basis of assignment number field (field ZUONR) value.

Please take help of an ABAP.

Hope this helps.

Regards

Anirban

[Former Member · Accepted solution]

Hi Anirban,

I forgot to attach images in earlier email. you can check it now, attached only image 3 and 4.

Thanks a lot for detail reply with steps.

I'll coordinate with ABAP and FI people then let you know.

Again thanks a lot.

[Former Member · Accepted solution]

Hi Anirban,

Thanks a lot for your guidance to map this requirement, however, we have completed the step 1 only , where in the FI people has created special G/L indicator and it is written into code as per step 1, but how to  Assign this special G/L indicator with symbolic account? how to achieve step 2 and 3.

ABAPer has no idea on this?

Kindly throw some light on it.

Waiting for reply.

[Former Member · Accepted solution]

Hi Experts,

Looking for help to fix this issue.

[Former Member · Accepted solution]

Dear Experts,

Waiting for valuable inputs.

[Former Member · Accepted solution]

Dear Experts,

Waiting for valuable guidance.

[Former Member · Accepted solution]

Dear Experts,

Please share any expert suggestion, as i am looking for the solution.

I am unable to fix this issue, Please let me know whether is it possible by HR configuration? or what are the next steps to fix it.

[Prashant4 · Accepted solution]

Dear Anirban Shankar,

Thanks for this valuable information, but i'm unable to achieve step 3.

I want different Loan line while creating FI Posting Document with corresponds to Special G/L Indicator.

Regards,

Prashant Sharma.

[shinas_rh]

Hi,

Have solved this issue....??

Please share ur solution....

I am also facing same Problem here....

Please, Thanks in advance

Shinas