on 07-10-2009 9:34 PM
Dear experts,
I need your help on the following challenging issue with respect to payroll posting to accounting.
Is it possible for a payroll that runs in one company code for all employees, to post to FI and CO for multiple CoCds?
Example:
WT 1234 exists in HR CoCd 1000 (assume an amount of u20AC 100 in the payroll results)
G/L ABC exists in FI CoCd 1000
G/L DEF exists in FI CoCd 2000
CCtr xyz exists in CO CoCd 1000 (which is the employee's master cost centre)
CCtr uvw exists in CO CoCd 2000
The wage type should be mapped as follows:
+ 100 to G/L ABC and CCtr xyz (this is no problem, is realized with standard mapping)
- 100 to G/L DEF and CCtr uvw
The challenge is in the fact that the credit amount should go to another company code than the debit amount.
How can I realize this?
Thanks in advance for your feedback!
Jeroen
Check exits:
Program: RPCIPE00:
EXIT_RPCIPE00_001 Modify Symbolic Account
EXIT_RPCIPE00_002 Fill Out Assignment Number and Document Item Text
EXIT_RPCIPE00_003 Fill New Temporary Wage Types in RT (for Old Payroll
EXIT_RPCIPE00_004 Determines Account for Tax Wage Types
PCP0 txn badi's:
BADI SMOD_PCPO0001
Classes:
CL_HRPAY99_POSTING_ENGINE
IF_EX_HRPAY00_PCP0
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi there,
we are facing the same business process requirements. Please advice how it was solved through the SAP standard, without the need of creating a custom program.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We are facing a similar situation please see below, we would like an SAP standard approach as well.
My company is in the process of implementing SAP Payroll; we are currently trying to find a configuration change within SAP Payroll that will allow us to post the payroll to different company codes. We know that SAP FI is able to accept the data in whatever method we send to it. Also, the SAP Payroll and SAP FI modules that we are using are in two separate instances of SAP, each on separate hardware. Additionally, we are using ALE technology and IDocs to move data between the 2 environments.
If it is possible, the configuration change that we are looking for would allow us to post employer expenses and accruals (Gross wages, FICA, Unemployment, etc.) to the company code and cost center to which the employees belong, while having certain liabilities (Federal and State withholding, FICA, Net Pay, etc.) post to liability accounts that are under a different company code.
Any assistance you are able to provide will be much appreciated.
This is from SAP documentation:
Cross-company code transactions are characterized by the fact that payables are assigned to a company code other than the one in which the corresponding expenses arose. This results in receivables and payables between company codes.
If you want to post these receivables and payables to company code clearing accounts, you must make the settings in several steps, as outlined in the following.
Note that in the case of separate HR/AC systems, posting to company code clearing accounts can only be implemented if the AC system is in Release 4.5A or higher.
For more information on cross-company code transactions and business considerations, refer to the SAP Library under Payroll -> country -> Subsequent Activities -> Posting to Accounting -> Special Business Requirements for Posting -> Cross-Company Code Transactions.
Settings for Posting to Company Code Clearing Accounts
1. In the step Define Symbolic Accounts, you must assign an account determination type to each symbolic account in Human Resources. For specific postings to balance sheet accounts, the account assign types FL and FO are used. From a technical viewpoint, these account assignments are defined as follows:
Wage types that are assigned to a symbolic account with account assignment type FL are posted in accordance with the information from the last period in the WPBP table (Work Center Basic Pay) for the current original result.
Wage types that are assigned to a symbolic account with account assignment type FO are only used for posting in the evaluation of a current original result.
2. In the step Define Posting Characteristics of Wage Types, you must assign the symbolic accounts with the account assignment types FL and FO to the corresponding wage types:
You assign the symbolic accounts with account assignment type FL to wage types that, in the case of retroactive accounting, contain the difference between old and new payment amounts. In countries that use the principle of origin, this usually involves wage types /551 Recalculation difference and /552 Subsequent clearing from previous month.
You assign symbolic accounts with the account assignment type FO to wage types that contain payments to employees and whose amounts do not change in the case of retroactive accounting. This usually involves wage types /557 Cash payment, /558 Payment of balance, /559 Transfer and other, country-specific wage types.
3. In the step Create Posting Variants, you must set the Post to company-code clearing account indicator for the variants that you use. Otherwise, payables and receivables between company codes are not posted to company code clearing accounts, and remain as the balance on the document split account for the company codes affected.
Hi,
Jeroen,
As per your requirement you have to maintain the PPMOD feature and have to take Company code as decesion operation.
this activity will come in posing payroll results to accounting under Activities in HR. after that same wage type u can transfer to different GL
Regards,
Kapil Kaushal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Gr8... its a new learning.... we can post to two different company codes !!
Dear Joen,
not sure,, after chekin thz requirement,,, i was goin trhu User Exit...EXIT_RPCIPE00_001 which is importing All Wt;s and FICO Line items...
So, depending on Posting Key, we can change symblolic Accoutn and also GL Account i guess.. (ofcz Co.Code) also i guess
Please check it !!! Im not sure... bt ... help me in understandin thz...does it work ?
Regards
...Sadhu
You Use Cost distribution to post to different company code. It can happen with fixed amount or percenatege of amount. I am not sure about only credit amounts to be posted to Different company code. YOu still check infotype 0027.
Afrasyab
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the quick reply guys!
@ Sadhu; I don't know if this is a (SAP) standard practice, but I do know that SAP FI is configured in such a way.
@ Afrasyan; cost distribution is not an option, the situation is only applicable for particular wage types that are calculated during the payroll
I agree that some sort of cost distribution or reassignment is needed, the only thing is... should (can) it be configured in HR or in FI/CO (and if possible, where)?
Thanks!
Hello Nitin,
apologies, I do not have access to this information anymore. All I could find is that we created a custom program to change the line items of the posting document after RPCIPE00 has run. The custom program replaced company code and cost center information in the HR Posting document (table PPDIT). When transferring the posting to FI, clearance-postings were created automatically by standard SAP-FI functionality.
Please do check if your requirements need such custom solution, or that standard SAP functionality for intercompany posting or cost distributino can suffice.
Is this a Standard Finance Practice ??
So, Expenses are showed in one Co. Code and Profits in other Co. Code ???
And more over, GL Mapping will happen to the Co. Codes exists in IT1, so there is no chance of mapping to two different Co. Codes.
Regards
...Sadhu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.