SAP Knowledge Base Article - Public

2490272 - Automatic Clearing of Bank Advices via Web Service and Open Invoices


You are creating bank credit advices via web service ManageBankAdviceIn with reference to existing invoice in the system, however the automatic clearing between invoice and bank advice does not happen. Instead, the advice becomes an open item in the customer account monitor.


SAP Business ByDesign

Reproducing the Issue

  1. Go to Receivables work center.
  2. Go to Customer Accounts view.
  3. Open the concerned customer account monitor.

You'll see that the advice created via web service remains as an open item.


One of the reasons why the automatic clearing does not happen is that the request XML has been made with the Initiator Invoice Request tag (<PaymentTransactionInitiatorInvoiceReference>) for the invoice, which refers to Invoice ID field in the bank advice screen, being an external reference ID. Hence, the automatic clearing does not happen.

The Invoice ID field can be seen in the References section in the bank advice.


In order for the automatic clearing to be possible, you need to create the bank advice with the Document ID filled as reference. In the XML request, add the <PaymentTransactionDestinatedInvoiceReference> being the internal reference for the invoice you wish to clear, which is the Document ID.

The resulting payload file shall have both the <PaymentTransactionInitiatorInvoiceReference> and <PaymentTransactionDestinatedInvoiceReference> with the corresponding external reference ID and document ID.


ManageBankAdviceIn; bank credit advice , KBA , AP-PAY-ADV , Payment Advice , How To


SAP Business ByDesign all versions