Symptom
For customer account XYZ 4 open customer invoices exist over 61.20 EUR each.
These shall be cleared in a bank statement ABC where 4 transactions over 61.20 EUR each refer to these 4 invoices.
Customer XYZ is identified via a Rule for Analyzing Memo Lines, Rule Type: 4 - Customer.
The applicable Clearing Strategy implies the option to 'Allow Automatic Clearing If No or Incorrect Reference Number'.
Hence you expect that all 4 invoices totalling 244.80 EUR are automatically cleared against all 4 bank statement transactions over the same total of 244.8 EUR.
All bank statement transactions, however, remain in Postprocessing Status 'Required'. Candidate invoices are not cleared but merely 4 on-account clearings are posted.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Liquidity Management work center.
- Open the Bank Statements view.
- Navigate to the relevant bank statement ABC and Edit.
- Select relevant bank statement transactions.
- Follow the Postprocessing: 'Required' link to access the relevant on-account clearing.
Cause
The bank statement clearing run processes every bank statement transaction sequentially and individually.
Here we have the situation that 4 bank statement transactions ABC/1, ABC/2, ABC/3, ABC/4 over 61.20 EUR relate to one customer account XYZ.
Customer Account XYZ is identified via a rule of Rule Type:'4 - Customer' - and consequently 4 on-account payments are created.
On the other side 4 corresponding customer invoices exist which are not identified via unique identifier, for example External Reference.
The option to 'Allow Automatic Clearing If No or Incorrect Reference Number' - takes effect when we see a 1:1 relationship between to due-times, here payment and customer invoice.
If only one customer invoice over 61.20 EUR would exist - an automatic clearing would be created. Here, however, a single bank transaction over 61.20 would relate to 4 invoices over a total of 244.80 EUR.
Resolution
In the here present scenario 2 alternatives apply if your aim is an automatic clearing.
- Employ the 'Receivables - Clearing Run'. All 4 On-Account Payments from Bank Statement would clear against all 4 corresponding invoices of similar character and same amount. - Or:
- Provision of External Receivable Reference in each bank statement transaction and clearing via Rule for Analyzing Memo Lines (Rule Type: 13 - Open Receivable External Reference).
Keywords
Rules for Analyzing Memo Lines Invoice Clearing Clearing Strategies , KBA , SRD-FIN-MOP , Payment Management , Problem