3513496 - Following Error Occurs when Adding an Item or Changing the Quantity in a Sales Order: Item XX: Could not calculate result; result exceeds defined value range

Following Error Occurs when adding an item or changing the quantity of an item in Sales Order ABC: Item XX: Could not calculate result; result exceeds defined value range (ABC represents the Sales Order ID and XX represents the Line Item Number).

SAP Business ByDesign

1. Go to the Sales Orders work center.
2. Select the Sales Orders view.
3. Open Sales Order ABC.
4. Navigate to the Items tab.
5. Select Line Item XX
6. Change the quantity to 10 (10 is used as an example).
7. The following error occurs: Item XX: Could not calculate result; result exceeds defined value range

This error occurs because an extension field with type Decimal is set up in the system as a calculated field and the result of the calculated value exceeds the length for which it is set up for.

In our example when changing the quantity of Line Item XX to 10 the error "Item XX: Could not calculate result; result exceeds defined value range" is caused by the  extension field XYZ (XYZ represents the ESR Name of the extension field).

This error occurs because extension field XYZ is a calculated field and with type Decimal in your system that is set up for a totally length of 5 (this includes the number of decimals) and decimals of 2 but the value in this field if, you select the quantity 10 for line item XX, is determined as 1151.04 which has a length of 6 and therefore exceeds the length 5.

Since the length of an extension field cannot be changed the solution is:

- either ensure that no value that has a greater length of 5 is passed.

- or you need to remove the extension field and create a new extension field with a greater length as per the customers requirement.

KUT; Extension Field; PDI; Decimal; Calculated Field; Calculation; Length; greater than; exceeds , KBA , AP-SLO-SO , Sales Order , Problem