cancel
Showing results for 
Search instead for 
Did you mean: 

FEBA Postings

Former Member
0 Kudos

Hi,

Hope someone can give me some  help or suggestions.

One of my companies business lines, makes many, many payments to vendors. Due to certain business requirements, each invoice entered into SAP is paid with a separate payment.

Many of the invoices are for the same amount. For instance, we could have 25 payments for $100.00 in one day on the same bank account.

We are using electronic bank statement for this account.  I have the algorithm 019 set as the bank is passing back the SAP document number in the reference field.

When the bank statement is loaded, the first payment in the file, for example for $100 posts completely. DR to the clearing account and CR to the cash account. The item is removed from the clearing account.  All is fine.

However additional amounts for $100 only are posting on account. DR to the clearing account, CR to the cash account, but the item is still shown open in the clearing account.  I then have to click on each on acct posted item and using

Line item> post> find the open item and clear it.  Sometimes there could be 40 or 50 $100 payments in the clearing account waiting to be cleared. So you have to search for the item. Or of course you can enter the document number you want to clear, but that does take extra time. I can search for the item just as quickly as I can enter the document number. Sometimes on a large bank statement, this process can take almost all day to finish.

This results in a zero item transaction but it removes the item from the clearing account reducing the balance in the account.

Does anyone have any suggestions on what we could do to get all the items to post automatically? It seems if the algorithm is telling the system to look for document number in the reference field, it should be able to find the item.

We know we can use algorithm 001 and a user exit but the user exit suggested to us by SAP is used for AR and not AP.

Help!!

Thanks

Alicia    

Accepted Solutions (1)

Accepted Solutions (1)

former_member190954
Participant
0 Kudos

Hi, the algorithm 019 (as e.g. 001) is used for XBLNR field. But from what you wrote, you are looking for the BELNR field (document number). Try the algorithm 020.

Regards,

Ondrej

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks to both of you who have made suggestions.

I have already tried using 020 algorithm but with no better results than with 019. Results are almost identical.

former_member197737
Contributor
0 Kudos

Hi Alicia,

What bank statement format are you using? Does the document number comes in Note to payee field?Can you share with us the line from statement that works fine and another one with issues?

Interpretation algorithm 019 should be used with DME reference number (REGUT-RENUM). If you are sending this number as reference in payment file, then it's ok, if not, won't work.

In your case, it seems you are using accounting document number (REGUH-BELNR). For this case you should be using algorithms 001 or 020. In both cases be aware to populate algorithm fields BELNR in transaction FF_5 when uploading bank statement.

Clearing information is stored in table FEBCL, You can compare entries to identify any difference. Field FEBCL-SELFD for these cases should be populated with text 'BELNR', and FEBCL-SELVON should be populated with the accounting document number concatenated with fiscal year (Eg 20000000012015)

Best regards!

Mgitur

former_member194797
Active Contributor
0 Kudos

Hi Alicia,

are you using the right document number range when launching program RFEBKA00 ? The 'BELNR number interval' should contain the right range for selecting payment document numbers present in REGUH-VBLNR.

former_member194797
Active Contributor
0 Kudos

Hi,

we have no problem using algorithm 020 and not 019. The reference you put in the payment file is the payment document number, so when this reference appears in EBS the program must search for a open item having this reference as document number, not as reference. The search by document number is done via algorithm 020: Document number search.