SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

Transferring payments between different systems

Former Member
0 Kudos

Our Client has SAP CR&B and Oracle Financials.

SAP CR&B and Oracle use different Bank Accounts.

How do other clients handle scenarios where they have move dollars between different systems?

For example:

A customer has a receivable of 100 dollars in SAP CR&B and another receivable of 900 dollars in Oracle A/R.

Customer sends a payment for 1000 dollars which gets posted in SAP and also funded in the bank account. There is a credit of 900 on the customer account in sap.

We need to move the 900 dollars from SAP to Oracle system. Client wants to reverse the 1000 dollar payment posting and make a new payment posting for 100 dollars in SAP system.

If we make this new posting of 100 dollars - the bank clearing a/c will be off balance because we cant make the corresponding funding posting to the bank a/c since the money is already realized in the bank.

1 ACCEPTED SOLUTION

AmlanBanerjee
Active Contributor
0 Kudos

Hi,

I dont know if any physical connection is possible b/w your two systems-SAP CR&B and Oracle Financials.

However, what you can do is, you can move the total amount of say $1000 to the payment clarification worklist in SAP.

Then from there you can allocate the amount pertaining to the customer in SAP, say $100 to the customer account.

The remaining $900 you can move to a suspense account., and then post a misc dr to offset the same using a particular set of main\sub pertaining to a GL a/c-Payments-Oracle Financials in SAP.

In oracle, you can post a misc cr against the same GL A/c of $900 and allocate it against the customer's account.

At the end of the day, when you reconcile, entries in GL A/c in SAP should exaclty offset the entries of the GL A/c in Oracle.

Hope it helps....

Thanks,

Amlan

View solution in original post

2 REPLIES 2

AmlanBanerjee
Active Contributor
0 Kudos

Hi,

I dont know if any physical connection is possible b/w your two systems-SAP CR&B and Oracle Financials.

However, what you can do is, you can move the total amount of say $1000 to the payment clarification worklist in SAP.

Then from there you can allocate the amount pertaining to the customer in SAP, say $100 to the customer account.

The remaining $900 you can move to a suspense account., and then post a misc dr to offset the same using a particular set of main\sub pertaining to a GL a/c-Payments-Oracle Financials in SAP.

In oracle, you can post a misc cr against the same GL A/c of $900 and allocate it against the customer's account.

At the end of the day, when you reconcile, entries in GL A/c in SAP should exaclty offset the entries of the GL A/c in Oracle.

Hope it helps....

Thanks,

Amlan

former_member213733
Active Contributor
0 Kudos

Hi ,

Create a new interim clearing account say ' clearing oracle a/c' and make the posting to that account ( B/S type a/c ).

To make the customer account have the perfect picture , configure new main and sub transactions to make the necessary entries for settling the balance as desired .

Regards ,

Dewang