You are creating an incoming payment in order to clear a customer invoice. The payment amount is less than the invoice invoice. Nevertheless, an error that the given amount exceeds the payment amount is raised.
Reproducing the Issue
- Go to Receivables work center.
- Go to Customer Accounts view.
- Open the customer account monitor of the related customer account.
- Highlight the invoice to be paid.
- Click Pay Manually By -> e.g. Incoming Check.
- In the screen that opens, mark the check box Set Payment Amount Manually
- Give the payment amount, which is less than the invoice amount.
The following error message is raised: '<invoice amount> assigned to partner <partner ID> exceed payment amount <incoming check payment>'
Incoming check: 12.000,00 USD
Invoice Amount: 17.000,00 USD
You expect that the payment is cleared and the invoice remains partially cleared.
In order to ilustrate this scenario, please consider invoice and payment amount as described in above section.
The incoming check amount has been manually set to -12.000,00 USD, while the matched invoice has amount of 17.000,00 USD. The error message for this case is correct, since the amount in the check is less than the invoice amount and there would be a remaining balance of 5.000,00 USD for the Check Payment due to Applied Net Amount.
Note that there is a differece between the scenarios where the invoice is partially cleared by the payment and where the payment is partially cleared by the invoice. Generally speaking, you may refer to the Remaining Balance amount. The remaining balance is assigned to the Payment line - in this case - meaning that the invoice was trying to partially clear the payment, which is not possible due to the amounts set, where the invoice amount exceeds the payment amount, hence the error. However, when you adjust the applied net amount of the invoice the remaining balance is assigned to the invoice line and hence the invoice is partially cleared by the payment.
In order to partially clear the invoice with this check, you need to change the Applied Net Amount in the invoice line to match with the open amount of the check, i.e. 12,000.00 USD. With this approach, the check is cleared and the invoice is Partially Cleared with remaining open balance of 5.000,00 USD (invoice).
KBA , SRD-FIN-ACR , Receivables , How To