Auto clearing of customer RTGS Upload items

[Former Member]

My client want automatic customer payment for RTGS related items,

is there a way in SAP to clear the customer open items automatically for the below scenario

I want the system to clear the above mentioned line items based on certain pre-defined parameter and for the difference

As-Is Process:

1. 1.Posting of advance payment received from customers manually via F-28 or CM via FB01

    Dr Bank  1000  Dr Promo  500

  Cr Cust  1000  Cr Cust  500

1. 2.Customer Invoice posted in the system

  Dr Cust  1000

  Cr Sales  1000

1. 3.Customer Clearing via F-32

  Dr Cust  200  -> Balance as of 26.02.2014

  Dr Cust  1500  -> Adv payment and CM

  Cr Cust  1000  -> Customer Invoice

  Cr Cust  700  -> Balance as of 27.02.2014

Please suggest if you have solution other than manual clearing F-32

Please help me as this development is urgent

Best regards

Nitin Kumar

[Former Member]

HI Nitin

There are Two ways You can do Automatic Clearing

1. Through F.13 which is Automatic Clearing Transaction for this You need make Customisation settings

Go To  IMG -   Financial Accounting  - General Ledger Accounting - Business Transactions - Open Item Clearing -  Prepare Automatic Clearing. or T Code OB74

fill these details Chat A/c/Acct Type/ From Acct/Criterion 1 /Criterion 2 /Criterion 3 /Criterion 4

Fill all account types(D,K,S and A) with specified criterion 1.

Note

If you Maintain a Criterion 1 as ZUONR(assignment), the system will pick up the documents(which needs to be cleared)automatically based on this assignment field.

For the documents to be cleared should have the same assignment field if not the system will not pick  the documents for clearing .

2. You can use the Transaction F-30 while Posting itself you can select the items and you can clear, This is the transaction for Post with Clearing

if Client requires f.13 transaction also via automatic then you can schedule a Job by giving all the Parameters so that no need to go and execute daily F.13 Transaction.

Hope this is helpful,.

Mahesh

[Former Member]

Thanks for the answer with explanation Lal.

So you mean to say that i need to develop the program for auto clearing which will collect all the open items from f.13 tcode and call the F-32 t-code for clearing.

Or

Please let me know how we can Automate so that all the open items can be cleared of the multiple customers which are related to RTGS payaments.

As f-32 t-code is possible for individual customers only, my client needs for multiple customers clearing.

Which will clear the line items according the advance payments and invoices done by the customers using FIFO method.

Exp

1.Customer Clearing via F-32

  Dr Cust  200  -> Balance as of 26.02.2014

  Dr Cust  1500  -> Adv payment and CM

  Cr Cust  1000  -> Customer Invoice

  Cr Cust  700  -> Balance as of 27.02.2014

[Former Member]

HI Nithin

For Automating F.13 Transaction No need to develop Any Programme as I said before Schedule a Job for this standard Programme SAPF124 with all relevant Parameters which will capture in the Variant. Variant You can Create like below

Assignment Field Plays a key role like Assignment field is a reference field in payment Transaction.

so what ever the transactions you want automatic clearing you can mention the same in Assignment field so that it will only those specific transactions (Like RTGS Transactions)

[Former Member]

I understand Lal sir, but it is not happening in this scenario 

[Former Member]

Hi Nithin,

Can you Please Explain the Issue clearly. Like as per the Screenshot what i understood Test run Executed Successfully. If you are following any reference while doing payment you can mention same as assignment field so that it will clear those items.

It will be good if you explain the issue clearly so that you can solve your requirement,

Mahesh

[Former Member]

Hi Sir

Process flow for RTGS in india is as follows,

So now my client need a customized program for automate the clearing open items, (Last block which is marked need to be automated).

Like as F-32 is used to clear open items for individual customers, my client needs a program to be for multiple customers, before clearing the open items they need a overview for all the customers and they need the program which will clear items which are related to only RTGS payments but not Cheques, that is main actually.

Here we need to take the advance payments F-29 and payments done like F-28 and invoice document posted for cutsomer F-22, which will be shown in F-32 for clearing open items.

Hope u got this. Please let me know on this.

[Former Member]

Client requires a  customized program for automatic the clearing  for customers,

Please help me on this as soon as possible.

[former_member184878]

Hello,

Yes, see my answer avbove:

Use function F. 13 and do customizing which field/information is relvant for reconciliation.

you also can implement SAP EBS (electronic banking)

all the best Erwin

[former_member184878]

Hello

take a look on function f.13

you can do customizing on which field automatic reconciliation should be done

br erwin