Symptom
You have uploaded a bank statement, which has an item corresponding to an Outgoing Check. The 'DME Reference' rule for analyzing memo line is working as expected and it derived the correct payment ID, however the payment allocation remains In Preparation.
If you try to create a proposal, an error message is also raised.
Environment
SAP Business ByDesign.
Reproducing the Issue
- Go to Payment Management work center.
- Go to Payment Allocation view.
- Open the concerned In Preparation payment allocation.
- Click Edit rules for analyzing memo lines.
- On the screen that opens, click Simulate.
- Paste the payment allocation's memo line and click Simulate.
You see that the DME Reference rule correctly determined a Document ID.
- Go back to the payment allocation and under Payment Confirmations/Returns tab.
You see the related Document ID not assigned to this payment allocation.
- Click Actions -> Create Proposal.
The system starts searching for outgoing checks, but returns the following error: 'No outgoing check found'
Cause
The DME rule for analyzing memo line is successfully reading the memo line and extracting the Document ID as a result. Nevertheless, the system logic is to set the result of the DME rule as an 'External ID' as one of the search parameters of the query in backend when looking for payment orders.
Therefore, the system is searching for an outgoing check with External Reference ID as the Document ID from the DME Reference rule result. Since this check with external reference doesn't exist, errors are raised and the allocation is not automatically posted.
This is generally not an issue for Outgoing Bank Transfer since Document ID is equal to External Document ID. Nonetheless, the External Document ID of an outgoing check concerns the Check Number, retrieved from a check lot.
Resolution
For the automatic allocation to work using a DME Reference rule and Outgoing Checks, the check's external reference ID needs to be given in the bank statement inbound file so that it populates the payment allocation memo line accordingly.
Alternatively, you may edit the payment allocation's memo line manually to change the Document ID to the concerned External Reference ID. After that, you may click Actions -> Create Proposal for the system to read the memo line, search for the payment and allocate it.
See Also
Keywords
Payment Allocation. Rules for Analyzing Memo Lines. DME Reference. Outgoing Check. Inbound File. , KBA , AP-ACC , Business ByDesign: Financial Accounting , AP-PAY-BS , Bank Statement , AP-PAY-PAL , Payment Allocation , How To