R12: MAX TOTAL AMOUNT Hold Incorrectly Applied To Receipt Matched Invoice
(Doc ID 1548333.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Payables - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
- Matched Invoices in foreign currency are getting 'Max Total Amount' hold applied at validation
- Invoices are matched to Receipt
- Receipt and Invoice have same exchange rate so hold should not be applied
- If invoice was matched to PO then hold should be applied as rate different on PO
- Hold reason: 'Sum of invoice and exchange rate variances exceeds limit'
- Not allowing further process the invoices.
Steps to Reproduce:
Payables > Setup > Invoice > Tolerance
Example:
Total Amount = 50 and enabled
PO:
Qty :17
Unit Price 60600 JPY
Exch Rate Date: 04 APR 2012
Exch Rate: .012153163893922
Qty :17
Unit Price 60600 JPY
Exch Rate Date: 04 APR 2012
Exch Rate: .012153163893922
Total base amount billed on PO:
= SUM((NVL(PD.quantity_ordered, 0) - NVL(PD.quantity_cancelled, 0)) * p_po_price * DECODE(p_inv_curr_code, p_base_curr_code,1, PD.rate))
= 12520.18944
= SUM((NVL(PD.quantity_ordered, 0) - NVL(PD.quantity_cancelled, 0)) * p_po_price * DECODE(p_inv_curr_code, p_base_curr_code,1, PD.rate))
= 12520.18944
Receipt:
Exch Rate : .0126190672086472
Exch Rate Date: 29 Aug 2012
Invoice:
Exch Rate : .0126190672086472
Exch Rate Date: 29 Aug 2012
Total base amount invoiced on invoice:
= SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),nvl(D.base_amount,(D.amount * DECODE(I.exchange_rate, null, PD.rate, I.exchange_rate)))))
= 13000.16 (d.base_amount value)
= SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),nvl(D.base_amount,(D.amount * DECODE(I.exchange_rate, null, PD.rate, I.exchange_rate)))))
= 13000.16 (d.base_amount value)
ship_base_amt_var = 13000.16 - 12520.18944
= 463.8111
= 463.8111
which is greater than tolerance amount 50
In terms of base amounts Amount Billed exceeds Amount ordered and this is out of tolerance. So hold is valid for PO matched invoice.
In terms of base amounts Amount Billed exceeds Amount ordered and this is out of tolerance. So hold is valid for PO matched invoice.
However, for receipt matched invoice, the invoice and receipt use the same exchange rate so should have no hold applied.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |