My Oracle Support Banner

The Cash Discount On Receipts Is Being Calculated Incorrectly (Doc ID 2989019.1)

Last updated on NOVEMBER 23, 2023

Applies to:

Oracle Receivables - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Discounts are wrongly calculates when transaction is created with installments, and the following profile options are setup:

a. Profile options:
“eBTax: Inventory Item for Freight" as Freight
"eBTax: Invoice Freight as Revenue" as No.


Results: Discounts are wrongly calculated

b. . Profile options:
“eBTax: Inventory Item for Freight" as Freight
"eBTax: Invoice Freight as Revenue" as Yes.


Results: Discounts are wrongly calculated

c. . Profile options:
“eBTax: Inventory Item for Freight" as Null
"eBTax: Invoice Freight as Revenue" as Yes.


Results: Discounts are wrongly calculated

In the above cases, the discount is calculated for the whole amount of the transaction, instead of the partial amount.

If profile id setup like this:
“eBTax: Inventory Item for Freight" as Null
"eBTax: Invoice Freight as Revenue" as No.

Then the discounts are correctly calculated.


Steps to Reproduce:

1.

Responsibility: System Administrator
Navigation: Profile > System

  1. Setup profile option "eBTax: Inventory Item for Freight" as 'Freight Charge'.
  2. Setup profile option "eBTax: Invoice Freight as Revenue" as 'No'.

 

2.

Responsibility: Receivables Manager
Navigation: Setup > Transactions > Payment Terms

Create a payment term with 3 installments, with 'Allow Discounts on Partial Payments' check, and discounts for each installment.

 

3.

Responsibility: Receivables Manager
Navigation: Transactions > Transactions

Create an invoice using above payment term.

 

4.

Responsibility: Receivables Manager
Navigation: Receipts > Receipts

  1. Create a receipt.
  2. Apply receipt to first installment of the transaction created on step 3.
  3. Save. The discount is calculated for the full amount of the invoice instead of the amount of the installment.




Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.