SAP Knowledge Base Article - Public

3269389 - Error on the Sales Order: "Sum of Dates' Amounts Exceeds the Item's Amount"


You have created a sales order and maintained invoice schedule with 100% for the lines, system reports the below error hence you are not able to release it.

Error: Sum of dates' amounts XXX exceeds the item's amount YYY. (XXX, YYY represent the values of the amounts)


SAP Business ByDesign

Reproducing the Issue

  1. Go to the Sales Orders work center.
  2. Go to the Sales Orders view.
  3. Open the order ABC. (ABC represents the ID of sales order).
  4. You can see the errors at the bottom. 


The error is due to the sum of the invoice schedule amount of the dates exceeds the item total amount.

For example, the line 10 has item total amount as 329,899.70 EUR.

There are 2 invoice dates created for the line 10 in Invoice Scheduling tab.

Date 1, percentage=95%, amount=313,404.72 EUR.

Date 2, percentage=5%, amount=16,494.99 EUR.

So the sum of dates= 313,404.72 + 16,494.99=329,899.71. This sum amount exceeds the item total 329,899.70 by 0.01.

And this difference is caused due to rounding when calculating the date amount by percentage.


You can manually adjust the date amount in the Invoice Schedule.

For example, manually change 313,404.72 into 313,404.71. The percentage remains as 95%, invoice total changes to 329,899.70 and the error is then removed.


Sum of Dates' Amounts Exceeds the Item's Amount; invoice schedule; sales order. , KBA , SRD-CRM-ORD , Orders & Contracts , Problem


SAP Business ByDesign all versions