R12: APXINWKB Wrong Discount Amount Calculated On Invoice Using Folders With Invoice Amount Before Currency Code
(Doc ID 1503647.1)
Last updated on APRIL 20, 2023
Applies to:
Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]Information in this document applies to any platform.
Wrong Discount Amount Calculated On Invoice Using Folders With Invoice Amount Before Currency Code
Or
If Invoice Created Using Copy Invoice Above Invoice Amount Changed
Symptoms
Users may experience some of these symptoms:
- The calculated discount amount is wrong on Payables invoice workbench form
- Discount Amount Remaining in the Scheduled Payments tab is doubled
- Issue occurs when using folders or moving columns in APXINWKB.
- If invoice currency code is before the invoice amount then the discounts are calculated correctly, otherwise discount is doubled.
- Prompt Payment Discount Doubles when using folders or moving columns in APXINWKB
- Discountable amount keeps growing when changing invoice amount from a invoice header created from "copy previous record" in APXINWKB
1. Create only the invoice header with the any custom folder that has got the amount field before the currency code.
Save the record and query the record in sql.
SQL> SELECT invoice_amount,amount_applicable_to_discount FROM AP_INVOICES_ALL
WHERE invoice_num = 'Put your invoice number here'
The amount_applicable_to_discount will be more than the invoice_amount.
2. Open up the same custom folder and place the invoice amount field after invoice currency code.
Save the record and query the record in sql.
SQL> SELECT invoice_amount,amount_applicable_to_discount FROM AP_INVOICES_ALL
WHERE invoice_num = 'Put your invoice number here'
The amount_applicable_to_discount will be equal to the invoice_amount.
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 |
| References |