Electronic bank statement

[Former Member]

We are getting some documents through third party software and they issue cheque directly and when they send following type document through Idoc

Discount/billback  Debit

Customer  Credit

They mention the cheque number in XBELNR field of credit memo. Then we do payment run (F110) but without generating any output or cheque assignment.

Customer Dr

Sub-bank account Cr

As above entries doesn't have any check assigned in SAP, it won't have entry in PAYR table. In BAI file transaction is 475 and algorithm assigned in 011. But it's not clearing those entries after BAI file posting as it didn't find any record in PAYR table.

Is there any way to recognize BAI file check number with the original credit memo XBELNR field to clear the associated entries? Please help me to find out the solution.

[Former Member]

Hi Pooja,

Can you please answer few questions to help me analyze and understand  your problem better: In BAI file, which field contains the check number? Are you providing number range as variant in FF_5? Do you see system even picking up the check number in posting log? Are there any errors you see in posting log?

[Former Member]

Hi Neeru

BAI file contain the check number in 16 notes to payee external transaction 475. Right now i am not using number range as variant in FF_5. But for testing pupose sometime i am using XBLNR range as zzzzzzz. In posting log i am getting error amount is too large to process.

Now the problem is i tried with algorithm 021. It's working if reference number is unique in customer line item. But problem is we will have more than 1 line item with same reference number.

And one more thing i noticed when we run F110 with payment method X which doesn't generate any check or any payment medium, it put together all line item and create only one line item in bank sub account.

I hope you understand my problem. Right now what's happening, third party software is paying to our customer for their credit memos. And whatever check they issue, they send the data through IDoc with check as reference number. And there can be 3 customer document paid through same check number..

I tried by implementing the note 213551 but when we run F110, system don't consider the reference number and create one line item for all the line items of customer credit memos which are due.

So now trying to understand what can be good option in this scenarion.

[Former Member]

Hi Taro

How we can configure customer in posting rules so that instead doing F110 when we are getting BAI file, it should clear customer and post the amount in main bank account.

Thanks

Pooja

[former_member251898]

Hi Pooja,

With regards to OSS213551, a reference document number unique in all cleared items is transferred to the payment document, so in your case, if running F110 is necessary,  you may need to configure payment grouping with XBLNR.

In terms of configuring posting rule with customer subleder, I would normally use posting area 1 and 2 posting in the following manner

Posting Area 1 - posting type 1

Dr  Bank Subaccount Clearing  Cr Bank Main Account

Posting Area 2 - Posting type 7 clear debit subledger

Dr Customer (no entry in Account Symbol/Posting key)  Cr  Bank Subaccount Clearing 

The reason for putting 2 posting areas is to ensure your bank main account, hence cash position is always updated even if the system fails to clear the customer items.

Hope that this helps

cheers

taro

[Former Member]

Any help?

[former_member251898]

Hi Pooja,

If I have understood your question correctly, I can think of 2 possible solutions.

The first one would be not to run F110 first and get BAI bank statement upload to clear the customer open item. Obviously as you do not have the cheque number info in PAYR, you must use a different algorithm (i.e. 001 to search XBLNR).

The second one is where you really need to run F110, firstly implement OSS note 213551 so that those open payment documents in bank sub accounts have the XBLNR info from the credit meno and use a different algorithm (i.e.001) to get the system to search the reference document number to clear against.

Hope that this will help you a bit.

Cheers

Taro

[Former Member]

I didn't try Second option but first option is not working. How you think 1st option should work? I mean on which logic it should try to find out the document and clear that one.

[former_member251898]

Hi

The way I would try to make it work would be to set the posting rule with the relevant processing type to clear Subledger (i.e. 8 or 9) mapped against the external transaction code with algorithm (i.e. 001) for XBLNR. I may use posting area 2 for that, though.

And then once FF_5 is performed, first check the posting log if the system searches for the cheque number in XBLNR.

Let me know how it worked for you.

Cheers

taro

[Former Member]

I tried by implementing note 213351 but it's not working with algorithm 001 or 029 or 019 and couple more..Customer credit memo posted with document type RV.

I tested a scenario where i posted document within Financial accounting e.g. doc type DA and assigned algorithm 029 and it was clearing the document without doing any other change.

But now when the doc type is RV i tried different combination and also the combination suggested by you but nothing is working...I don't know what's logic behind this.

[former_member251898]

Hi

That is a strange case.

Firstly you need to identify the cause as to why FF_5 program does not match the reference number in your RV document. In my option, the document type configuration setting would not be the one that cause this issue, but I suspect that it may be to do with how the reference field information is kept in FBKP, for example, leading zero's.  Could you try to manually type the cheque number over RV document and run FF_5 to see the system clears the document?

Best regards

Taro

[Former Member]

FBKP table doesn't exist..Please tell me correct table name so that i can see how the data is coming in that table

[suma_mani]

Hi Pooja,

Check REGUH and REGUP table where F110 Payment data has been saved.

Regards

Mani Kumar

[Former Member]

In those table we have reference number same which is coming in BAI file.

[former_member251898]

Hi Pooja,

Apology

I meant to say BKPF - accounting header table - that the cheque number is maintained in the reference field (XBLNR) by 213551 note.

best regards

taro

[Marssel700]

Hi Pooja,

Have you defined FCHI properly?

You can also verify other algorithms in the link below

http://help.sap.com/saphelp_46c/helpdata/en/43/0bd56743de11d1896f0000e8322d00/content.htm

regards

[Former Member]

We are using payment method X which will not generate any check number. Because we are paying check through third party system. And whenever third party send us the credit memo document through idoc, they mention the check number in reference field

[Marssel700]

You need enter a search refference in your document paid by check. Use algorithm 015 and enter the check in Assignment field.