You create a down payment and then uses the down payment for clearing multiple invoices. In the clearing of the last invoice, error 'Absolute value of assigned amount too high' occurs. You followed the steps below. The amounts mentioned below are examples.
You create sales order AAA(3300 JPY) with 3 line items and then created down payment request BBB(3000 JPY).
Then, you create the first invoice CCC(1100 JPY - refer to line item 10) before processing down payment DDD. After that, you manually cleared invoice CCC and down payment DDD in receivables.
You create the second invoice EEE(1100 JPY - refer to line item 20) , and the system automatically cleared it with down payment DDD.
You create the third invoice FFF(1100 JPY - refer to line item 30), and the system proposed clearing GGG with error 'Absolute value of assigned amount too high'.
SAP Business ByDesign
Reproducing the Issue
- Go to Receivables work center.
- Go to Customer Accounts view.
- Find the relevant account, then click on View.
- Find the third invoice FFF and click on Clearing ID GGG.
- Click on View All.
- You get an error message 'Absolute value of assigned amount too high'.
There are 3 scenarios for the Down Payment Process:
- The Down Payment was created from a source document e.g. a Sales Order by selecting the Sales Order and clicking on the Create Down Payment button.
- In this case the Down Payment cannot be assigned manually to an invoice request. Instead it is automatically assigned to the first available Invoice Request (no manual assignment is possible).
- The Down Payment was created manually from the Customer Invoicing work center without reference to any sales document. And there are then 2 options on how the customer can handle this.
- The Down Payment was assigned manually to the Invoice Request during Invoicing
- The Down Payment was NOT assigned manually to the Invoice Request. The invoice was cleared against the down payment in receivables.
The process is as follows. First a Down Payment Request is created, this Down Payment Request is then Invoiced and this invoiced version of the Down Payment Request is cleared with the payment in the receivables. Only the can the Down Payment be assigned
- automatically to the invoice request if scenario 1.a applies
- manually assigned in an Invoice Request in the Assigned Down Payments section during Invoicing if scenario 2.a applies
- manually cleared against an invoice in the receivables if scenario 2.b applies
In your case you used scenario 1.a. but at the time of invoicing the first Invoice the down payment DDD was actually not cleared with the payment and hence was not automatically assigned to the invoice request for Invoice CCC.
Instead, after down payment DDD was paid, and manually cleared with invoice CCC.
Then invoice EEE and Invoice FFF were created and the down payment was automatically assigned since scenario 2a applies and the DP was Payed.
In your case the error occurs because Invoice CCC was manually cleared with Down Payment DDD in receivables. Since any assignment of the Down Payment performed manually on the accounting side is not communicated back to invoicing an “over” assignment is possible and the error 'Absolute value of assigned amount too high' occurs.
Therefore, in the last clearing, the remaining amount in the down payment is 800 JPY (actual amount in receivables side) but in customer invoicing side the balance in the down payment is 1100 JPY as the down payment was not included in the first invoice.
And hence, the amount in the clearing needs to be manually corrected.
You can manually correct the amount in clearing GGG.
- Unselect Down Payment DDD and invoice FFF.
- Select Down Payment DDD and invoice FFF again.
- Change the Applied Net Amount of invoice FFF to 800.
- Click on Clear.
Or, you can process the down payment first and then create the first invoice to ensure that the first invoice is associated with the down payment.
Clearing; Down Payment; Customer Invoice , KBA , AP-CI-CI , Customer Invoice , Problem