FEBA Postings

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