SAP Knowledge Base Article - Public

3671063 - How To Configure Decimal Places In Discount Calculations

Symptom

Rounding differences in discount calculations result in incorrect discount amounts. The system rounds discount percentages to three decimal places, causing discrepancies in the expected discount amount.

  • Example: For a total amount of 22,500,000 and a required discount of 14,000, the system calculates the discount as -95.173% (resulting in -14,001) or -95.172% (resulting in -13,998), neither of which achieves the required discount of 14,000.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Navigate to Work Center Customer Invoicing.
  2. Go to Invoice Documents view and select Invoice ABC (ABC represents ID of Invoice Document).
  3. Create a manual credit memo notification with a specific discount amount.
  4. Enter the total amount and desired discount percentage.
  5. Observe that the system rounds the discount percentage to only three decimal places. If manually enter a percentage with more than 3 decimal places, system raises error "Item XX has too many decimals; only 3 decimals permitted".

Cause

Discounts can only be maintained as percentages on product level, and the fine-tuning option does not support changing the decimal places of these discounts.

 

Resolution

It is the designed system behavior.

If adjustments to the display decimals or calculation formula are required, submit a system change request through the Customer Influence Portal for SAP Business.

Refer to the Customer Influence Portal SAP Customer Influence Portal for further system customization requests to modify the display decimals or calculation formula. 

Keywords

rounding difference, discount calculation, discount percentage, discount rounding, net value, total list price discount, calculation discrepancy, display decimals, customer invoice processing, too many decimals; only 3 decimals permitted. , KBA , AP-CI , Customer Invoice Processing , Problem

Product

SAP Business ByDesign all versions