2589692 - Automatic Clearing Between Bank Advice Created via Web Service and Invoice is Not Working

You are creating a Bank Credit Advice via web service, using the Invoice ABC as reference, however you noticed that the system is not automatically clearing the items.

ABC means the Invoice ID.

SAP Business ByDesign

1. Go to the Receivables Work Center.
2. Go to the Customer Accounts subview.
3. Select the row of Account ID DEF (DEF means the Account ID) and click View.
4. Under Trade Receivables tab --> Invoices / Payments subtab, select Open Items list.
5. Notice that the Automatic Clearing did not occur.

The issue is occurring due one or more of the following root causes:

• XML not correctly formatted.
• Clearing Strategy configuration not correctly maintained.
• Invoice isn't correctly referenced in the Bank Advice.
• You are using the Business Partner as reference instead of using the Invoice.

First of all, you need to check if your XML is well formatted accordingly with the instructions in the Help Document Inbound Service ManageBankAdviceIn. You can use the example given in the Help Document. Also, you need to make sure that the XML has the invoice, which you are trying to clear with the Bank Advice as reference.

I.e. <PaymentTransactionDestinatedInvoiceReference>
 <ID>AB</ID>
 </PaymentTransactionDestinatedInvoiceReference>

If you are using the Business Partner as reference, system will try to search in the Open Items of this Business Partner for an Open Item based on amount, with range of +- 5% of the Payment amount. In case there is a single Open Item found, them it will select that invoice, and in case of multiple it will not pick any Open Item.

If your XML is well formatted, or after correct your XML, you need to check if the clearing strategy is correctly configured in the system.

Also, under the Clearing Strategy you can flag the function "Allow Automatic clearing if No or Incorrect ref Number" if items not found using reference numbers are to be cleared automatically. This configuration means that in case of an unique found based only on amount then post the Allocation automatically or not. This configuration specifies that if no item can be found using a reference number, the system tries to identify an item using amounts specified in the memo line. If no amounts are specified in the memo line and the payment can be cleared with only one item, the payment amount is to be used for the search.

Help Documents:

• Inbound Service ManageBankAdviceIn
• Configuration: Clearing Strategies
• 2490272 - Automatic Clearing of Bank Advices via Web Service and Open Invoices

ManageBankAdviceIn, Web-Service, Bank Credit Advice, XML, Customer Account, Receivables, Invoice, Business Partner, Automatic Clearing, Clearing Strategies. , KBA , managebankadvicein , receivables , automatic clearing , xml , invoice , bank credit advice , customer account , business partner , clearing strategie , web-service , SRD-FIN-ACR , Receivables , How To