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

Last updated on MAY 20, 2024

Applies to:

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

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