Symptom
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.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Receivables work center.
- Go to Customer Accounts view.
- Open the concerned customer account monitor.
You'll see that the advice created via web service remains as an open item.
Cause
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.
Resolution
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.
Keywords
ManageBankAdviceIn; bank credit advice , KBA , AP-PAY-ADV , Payment Advice , How To