Skip to Content

Payroll Posting to Vendor Account

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    May 13, 2012 at 08:37 AM

    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.


    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    May 10, 2013 at 11:50 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 10, 2013 at 05:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 10, 2013 at 10:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Shinas Hamsa

      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