Customer Automatic Clearing - F.13 and F-32 Manual

[sureshtcs]

Dear All,

My client requirement is to perform automatic clearing for Bulk Customers on every week. They are performing only cash related Business and they do not use Credit. Their activities are,

• Customer Down payment post - F-29
• Invoice creation - DR or RV invoice
• Credit memo
• Payment done in F-29 only not in F-28
• Clearing in F-32

So instead of clearing for each customer by selecting invoice and other items, they want to perform bulk clearing. I tried in F.13 But that does not capture the down payment clearing functionality. Kindly help me on this.

1. Are we able to perform enhancement in F-32 selection screen to input customer number range to clear the customers?

2. Even if we perform z report for this, only F.13 program will be captured?

[giova10ni · Accepted solution]

Dear Suresh,

Down Payments are cleared in F-39 manually.

In automatic clearing (F.13), you need to create rules in OB74. You want to create bulk clearing but the system does not know with what criteria you want to perform clearing. You do that in OB74. So you create a new entry there, you enter your customer accounts and select criterion Special G/L Indicator, (field UMSKZ).

Try that and see if clearing is performed.

Regards

[sureshtcs · Accepted solution]

Dear giova10ni

Could you pls help me what kind of fields do we need to change in OB74?. I think this is standard and correct. I tried F.13 earlier without making any changes in this below screen. But i received error only when i execute by selecting the special GL , given indicator as A to W. The error was "No customer record is found". Please let me know what are the pre-requisites for this. Will the F.13 accept the down payment clearing?

[sureshtcs]

Dear Gerogios,

Thanks for your help. I able to perform clearing the customer. Could you please help me whether i able to clear credit memo also. If yes means, what will be the settings in OB74. Please clarify

[giova10ni]

Dear Suresh,

Yes, the process is the same. In OB74, assignment should be the criterion, and all your documents should have the same assignment field. It doesn't matter whether you clear invoices, credit memos or payments as long as they all balance to zero.

Thanks

[sureshtcs]

Dear Georgios,

I tried again by giving common assignment number for all the documents. But when i tried to run the automatic clearing F.13. Still iam getting error that "No records found" . Is there any way than this to clear bulk customers such as Bapi or function module help to clear customers?

[giova10ni]

Dear Suresh,

Have you selected all invoices and payment documents and entered them in Document number field in F.13?

Enter Assignment text as well in Assignment field and check.

Also if this does not work, check select customers checkbox, enter all you customer accounts you want to clear making sure the debit and credit line for invoice and payment in each customer balance to zero

Regards

[sureshtcs]

Dear Georgios,

Actually i want to clear bulk customers, even if they post down payment and credit memo transactions. As you addressed in the above comment,

• I posted a down payment for 4,000 USD.
• raised invoice for same 4,000 USD.
• Down payment clearing is done in F-39 for 4,000 USD.
• I given assignment number as 0101 in all the documents.

But when i trying to clear the customer in F.13, still same error shows that "No records found" .

Kindly advise that whether is it right way to perform this clearing?

[giova10ni]

Dear Suresh,

1.In OB74 enter ZUONR (Assigment) as criterion 1 for customer account types.

2.All down payments must become normal payments.

3.Make sure the balance of all the documents you want to clear is zero. You can enter all the documents you want to clear in FBL5N (dynamic selections, document number) select all of them, and using Mass Change function enter a common assignment for all.

4.In F.13 enter all your document numbers in Document Number. In Posting parameters, select Test run and if the Test run is ok, then deselect Test run and execute a productive run. In output control select all checkboxes.

Regards,

[sureshtcs]

Dear All,

Can you pls suggest me an idea that how to clear bulk customers. If standard report F.13 is not supporting, which option will help me to do? Please advise. In F-32, even if we create customer code by performing the enhancement in front screen, will it clear bulk customers? .

[giova10ni]

Dear Suresh,

Could you please make clear what exactly you want to clear. A downpayment must become a normal payment in F-39 once the invoice is posted. Then you can mass clear invoices with payments in F.13 using a criterion in OB74. For example, if you want to clear 50 invoices with 50 payments using assignment as a criterion, first you enter the same assignment text in those 100 documents. This can be easily done using the mass-change functionality. The total balance of those 100 documents with the same assignment field must be zero before so that they can be cleared in F.13. This is how mass clearing is performed.

Regards

[JonathanEemans]

Hi,

Check out the documentation of the automatic clearing program.

Best regards,

Jonathan Eemans

[sureshtcs]

Dear Jonathan,

1. I posted Down payment in F-29 for Rs 1,000
2. I raised customer invoice for Rs 1,000
3. Posted down payment clearing document in F-39
4. now the amount transferred from Down payment to Normal recon account of Customer

I checked in OB74, assignment field is maintained and the same i maintaining in down payment documents also. Now when i tried to execute F.13, i am getting no records. Can you please give me some brief idea what are the fields i need to go through.

Even without flagging the special GL transaction and A indicator, i executed. still no records.

[JonathanEemans]

It's mentioned in the documentation...

The following items are not cleared:
...
Down payments, unless down payment clearing for the same amount has been posted