SAP Knowledge Base Article - Public

2836203 - Cash Discount on invoice is showing wrong decimals

Symptom

You have posted a customer invoice but the Maximum Cash Discount is showing the calculation incorrectly

Environment

SAP Business Bydesign

Reproducing the Issue

  1. Go to the Receivables work center.
  2. Click on Customer Accounts > Select the Customer and click on view.
  3. In the Customer Account  Monitor > select the customer invoice line which is in Open Status.
  4. Under Payment Terms / Due Dates tab.
  5. Maximum Cash Discount is updated with unexpected value or the discount amount picked during the payment of the invoice is showing unexpected value.

Cause

In the customer account monitor when you select this customer invoice the discount amount may look something like this

Maximum Cash Discount: -18.000,01

Normal Cash Discount: -6.000,01

The system calculates a proportion as follows: 660000 / 600000 = 0.90

Resolution

Maximum or Normal Cash Discount calculation

Total Invoice Amount / Tax Base Amount

Total Invoice Amount is Total Item Net Value + Taxes

Tax Amount is Tax Base Amount * Tax Rate

Example:  660000 / 600000 = 0.90

Maximum Cash Discount Amount = -1 * proportion * Transaction Amount * Maximum Cash Discount "Percentage"  / 100.
= -1 * 0.909091 * 660000 * 3 / 100
= 18,000.01

Keywords

 Maximum Cash Discount calculation, normal cash discount calculation taking extra decimals , KBA , AP-PAY-ADV , Payment Advice , Problem

Product

SAP Business ByDesign all versions