Remittance Advice from customer for EBS settlement

[mateusz_wrobel]

Hello All,

One of the biggest our customers is going to send us remittance advices along with payments. When processing EBS we should take infromation from this remittance advice and clear position (one incoming payment for multiple invoices) with open invoices. I couldn't find any information but is there solution that will read incoming (customers) remittance advices and help settle bank statements? Any IDocs or so?

Thanks & regards,

M.

[Bohdan]

Hi mateusz.wrobel,

It is possible to enhance the processing / clearing of customer's (and vendor's) open items with the help of the payment advices in SAP. If the payment advice is reasonably small, you can create it manually via transaction FBE1. But if the payment advice is big (i.e. several pages), you might want to look for some automation. The options:

- If you customer supports EDI and is willing to exchange the data electronically, you can try leveraging the IDOCs (type REMADV). In this regard, I'd recommend to check out OSS note 513071 - Automatic item clearing with REMADV IDoc.

- If your company has any OCR tools, you can leverage them to scan / parse the PDF-files and create the advices in the system automatically. Here the options heavily depend on the solution provider and their automation approach. SAP offers its own service called DOX, which is a combination of OCR & RPA - OCR is used to parse the PDF-files and RPA tools are leveraging VBA scripts to post payment advices in online mode (similarly like via GUI scripts). This is fully workable solution, but tends to experience performance problems with really big advices (if they have more than 30-40 pages). Plus, there are some other limitations / issues, but let's consider it project specific stuff.

Anyway, there are options worth exploring. But before you go on, I'd recommend this excellent post by Techlorean about the basics of the payment advices in SAP. When I started actively working with payment advices, I've found this post very useful.

Regards,

Bohdan