Trx F-28

[Former Member]

Hi.....

When we receive payments from a customer we use Trx F-28 to reconcile invoices and payments .

We are trying to find a way to simplify this on mass.

Is there a Trx in R3 that allows us to link automatically payments and sales invoices from a file (e.g. an MS Excel file) that contains all the required data?

Thanks in advance.....

[Former Member]

Hi

you can explore Electronic Bank Statement (EBS) functionality in order to try to clear the customer invoice when receive the payment. The EBS can find the open item and clear them in the AR ledger. I tell you in advance that standard algothims are not "amazing", I mean that they are based on XBLNR or BELNR information in order to match invoices with payments received at bank's account, an other option is to develop a user exit for that. Do not expect too much of EBS anyway, you will need probably to continue matching payments and customer's invoices manually.

Cheers

Rafa