on 05-05-2010 8:10 PM
Is there a way I can set electronic bank statement to do cross company code posting.
We have lot of cross company code money transfers, When I upload EBS file, I want to credit the master cash account in one company and debit deposit clearing account in another company.
If that can't be done any advice on best way to handle this will be appreciated.
Thanks
Paul
Hi Shaun,
We actually do the same with your .But we have a issue , do you run into this issue before ? If you have run into the issue in point 3 . would you please share the solution if you have solution .
1, WE CAN SEARCH THE OPEN ITEM COSS COMPANY CODE BY DEVELOP USER EXIT FEB00001 .
2, WE can make the cross company code posting by use badi feb_badi .
3, There is no user exit to change table avip . When update avip, the program will always get the document according to FEPKO-BUKRS , this will cause issue in FEBA for clearing document .
Jacky Liu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks
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 this same issue in our SAP deployment. We are currently considering two options:
1) Customize the EBS posting program to read a custom table. In the custom table, we would define the company code of the subledger posting.
First Posting - Based on EBS Configuration - Company Code of the Bank
40 BANK ACCOUNT
50 INTERCOMPANY CLEARING
Second Posting - Based on Custom Table - Company Code of the Receivables
50 INTERCOMPANY CLEARING
15 CUSTOMER
2) Post the same EBS file twice. In the first, we would post all of the bank postings (A/P, Fees, Funding, etc). In the second, we would post all of the A/R subledger postings. We would have to customize the 2nd file to read it as an "A/R" House Bank, so that it would post to the company code of the Receivables. We would most likely do this customization by substituting a bank account number in the file when a copy of the file is made.
Can anyone offer any advice on the best approach? Or, can anyone share what they have done in the past to resolve this issue?
Thanks in advance for any guidance you can provide.
Shaun Styles
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Paul,
Can't you use netting for cross company code adjustment.
Regards,
Anand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We are also doing cross company code money transfers. The bank sends separate electronic bank statements for the sending account and for the receiving account. Each bank statement is posted under the right company code (program RFEBKA00). We have no problem with this.
The cross company booking is done at transfer time (transaction FRFT_B), not when booking the bank statement.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Henry,
Just curious what accounting entry electronic bank statement make when you get a cross company code bank transfer. In our current world of manual process we credit the bank g/l account in one company and debit the bank g/l account in other company. But from the above postings I understand cross company code postings are not possible using EBS.
Paul
Hi,
FRFT_B create postings in both companies on clearing accounts. Obviously, we don't receive one bank statement, but two: one bank statement in the sending company and one bank statement in the receiving company. In each company the bank statement generates a clearing with the respective open item on bank clearing account.
Hi Paul,
Check SAP notes 124655.
Thanks
Aravind
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
as standard this cannot be done.
There is a basic premise that a EBS relates to a house bank, and that a house bank is for a single company code.
I am sure there COULD be a way of bespoking this but you would need to carefully plan it, and consider the impact this would have on future changes and upgrades.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.