Payroll Posting to Vendor Account

[waqas_rashid]

Hello Experts,

We have requirement to post few wage types to vendor account without summarizing them. When we post our monthly payroll (PC00_M99_CIPE), I have noticed that these wage types are summed and net is posted to vendor. Our FI users are unable to identify details of those posted entries.

Example:

Wage Type          Amount

---------------------------------------------

1111                     100

2222                     200

When posted to FI user only see 300 in posted documents line items. Which is correct, but without breakup.

How can I post above wage types as separate entries to FI?

Thanks,

Waqas Rashid

[Sujith_EM · Accepted solution]

Rashid,

Will you please try this report RPCIP_DOCUMENT_ANALYSE, in the first tab fill the run id in the field Number of Posting Runt  which you will get from PCP0.

In the second tab Additional selection choose Eval.Detail with Pers . No .

Execute it and filter according with your requirement( you can filter with Wage types, employee number, GL account, cost center, profit center etc)and download it to Excel.

[waqas_rashid · Accepted solution]

Dear Sujith, thanks for prompt reply. This report seems quite useful but there is a small issue. I couldn't find FI document number in this report which is very much required.

Secondly kindly let me know if it is possible to handle this issue through posting. Instead of generating report and exporting it to Excel etc.

Thanks,

Waqas Rashid

[Former Member]

Hi,

Please check the below steps to achieve your requirement.

1. set account type "K" for your symbolic account (where loan wagetype 1111 and 2222 are mapped) under  V_T52EK.

For example : symbolic account is 9001 and it is mapped with 1111, so please set account type "K" for 9001

2. check the symbolic account is mapped with respective wagetype  under V_T52EZ

3. enter *0002 in front of respective symbolic account for example : 9001 *0002 *0002 via t-code OBYU

4.Rerun the payroll with test case in CDV and do payroll posting for the PERNR.

System will automatically do PERNR wise posting where employee is created as vendor.

It will fix your issue.

Thanks.

[shinas_rh]

Hi,

these settings are already and  done i have run test run and verified.

issue is Total amount is coming a one line Item in the Vendor.

Waiting for this Month Payroll, let see any Issues..

Thanks

Shinu

[Former Member]

Hi

You can check with the BAdI SMOD_PCPO0001 and Method EXIT_RPCIPE00_002.

It may serve your purpose.

Cheers

Anwii

[Former Member]

Dear Rashid,

This might be a one of the option to look in to.

Like Mr.Sujith suggested,

RPCIP_DOCUMENT_ANALYSE:This is the only the report available to analyse at G/L and Vendor level.

If it is required to have the additional filed like FI Document Number for that please refer the table BKPF and With the help of ABAP,it will be required to create Z-Development in which are the components against Net Payable,against that Particular employee.This will resolve your query.

There is no standard  T.Code in FICO.

OR

1.Post all the Expenses like Basic,DA HRA,and Conveyance other expenses to the Expense Account

2.Post all the Deductions PF,ESI,LWF and TDS in to Balance Sheet or P&L Accounts

3.Post your (/560) Net Pay and Claim (/561) to the Vendor Accounts

Hence while posting it will generate two document numbers

Document 1:All the Expenses and Deductions

Document 2: Net Pay or Claim

Bifurcation of the Expenses,Deductions and net pay will displayed as line items for FICO as well.

Sincerly

Govardhan Reddy

[shinas_rh]

Hi ,

I have done all the changes based on My Little Knowledge is HCM Module and Posting is fine.

Only The issue is for Deduction like Salary Advance and medical Advances which is getting deducted from The Regular Payroll is getting reflected as a Cumulative amount in Employee vendor.

if this is happening as a Two line Items in the employee Vendor , then it is easy for FI users to adjust the amounts.

Also, i have 2 more Doubts;

1. What is this technical Wage type, I just know that it is selecting Clearing GL that i assigned.

2. Also, is there any option in Off Cycle Payroll to get the Narration in the GL line item. i mean When we run OffCye Transaction Payroll, posting is happening to Employee vendor, But there is Detail of the transaction.Only amount is coming. i have tried ASSIGNMENT filed in The off cycle , But is is not updating anywhere in The GL.

Thanks In advance

Shinu

[Former Member]

Dear Shinas,

1.What is this technical Wage type, (Are you asking about technical wage type in HR.Please provide clear information on this query?

2.Narration of GL in Line item.

Set Up Line Item Text

Create Posting Variants

FBL1N

FBL3N

Sincerely

Govardhan Reddy

[shinas_rh]

Yes Sir,

I am asking about the Technical wage Type in HR.

/561

/562 etc.

and what is the T-code to maintain

Set Up Line Item Text.

Thanks in advance

Shinas

[Former Member]

Dear Shinas,

Technical Wage Types

http://scn.sap.com/thread/1018745

Set Up Line Item Text.

SPRO->IMG->Payroll->Payroll India->Reporting for Posting Payroll Results to Accounting->Activities in Accounting System->Set Up Line item Text.

Govardhan Reddy

[shinas_rh]

Can we do this for Item wise,

Like For LTC one text.

for Leave encashment another.

For alary payable another one..

But, thanks soo much for ur response Sir.

Thanks

[Former Member]

Dear Shinas,

It is not possible in the standard.However as Anwesha suggested,you may check with the BAdi.

Govardhan Reddy

[shinas_rh]

Dear Sir,

I will Explain my present Issue n detail (I am FICO FM Consultant)

I configured LTC and Leave encasement as Vendor Posting.

I am Running Offcycle payroll and It is getting Posted to Vendor and expenses Account Properly.

Also, I have Noticed is Calling wage Type /559.

Now when i tried my regular payroll , test run, net pay is going to Vendor Account cause that is also calling Same technical wage type.

Actually net pay should be Posting to Salary payable GL.

this is why i asked about technical wage type in my previous Query Sir.

how we can solve this issue...

Wage types i i have found in HCM config are;

Can you help me On this.

for regular payroll i need Still Salary Payable GL a net pay that have been happening from the Day first Golive.

Now i have changed LTC and Leave Encasement as Offcylce vendor Posting, but due to this Changes , net pay is also Going to vendor A/C.

Hope My explanation is giving clear picture related to my Issue.

[Former Member]

Dear Shinas,

All the Payables are stored in /559=Bank transfer.Every employee will be maintained IT0009=Bank Data(Bank Transfer/Cash Payment/Cheque Payment).

Either it is Off-Cycle or Regular Payroll,the same wage type is linked to Symbolic Account,and the symbolic account is linked G/L.Hence it will go to same vendor account.

In the standard it not possible.

Govardhan Reddy

[shinas_rh]

Assalamu Alikum,

I am also facing the Same issue Brother.

I am also getting Summarized Amount for Salary Advance, medical Advance etc to vendor Account.

Could you please explain how you have solve this Issue.

Shinas