R12: AP: APXIIMPT: Credit Memo & PO Match: AMOUNT_REMAINING,GROSS_AMOUNT ISSUE When ADD_TAX_TO_INV_AMT_FLAG=Y
(Doc ID 2592826.1)
Last updated on SEPTEMBER 04, 2024
Applies to:
Oracle Payables - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
PROBLEM DESCRIPTION
===================
APXIIMPT: Payables Open Interface Import: CREDIT memo and PO matching issue:
When ADD_TAX_TO_INV_AMT_FLAG=Y,
AMOUNT_REMAINING and GROSS_AMOUNT are wrong value.
The RTS was not used .
( Inserts into AP_INVOICES_INTERFACE , AP_INVOICE_LINES_INTERFACE with PO values ,
and submit Payables Open Interface Import.)
Steps:
1.Create COMPLEX PO
2.Submit"Pay On Receipt AutoInvoice" .
APXIIMPT:Payables Open Interface Import is submitted.
Standard Invoice was importted to AP.
3.Return PO.
(The RTS was not used .)
4.Insert to AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE.
Example:
1)AP_INVOICES_INTERFACE
INVOICE_TYPE_LOOKUP_CODE=CREDIT
Invoice_Amount=-10000
CALC_TAX_DURING_IMPORT_FLAG=Y
ADD_TAX_TO_INV_AMT_FLAG=Y
2)AP_INVOICE_LINES_INTERFACE
LINE_TYPE_LOOKUP_CODE = ITEM
AMOUNT = -10000
PO_HEADER_ID=XXXX
PO_NUMBER=XXXXX
PO_LINE_ID=XXXXXX
PO_LINE_NUMBER=X
PO_LINE_LOCATION_ID=XXX
RCV_TRANSACTION_ID=XXXX
TAX_CLASSIFICATION_CODE=XX
5.Submit Payables Open Interface Import.
AP_INVOICES_ALL
INVOICE_TYPE_LOOKUP_CODE = CREDIT
INVOICE_AMOUNT = -10800
AP_INVOICE_LINES_ALL
ITEM -10000
TAX -800
AP_PAYMENT_SCHEDULES
AMOUNT_REMAINING = -10000 <--It should be -10800
GROSS_AMOUNT = -10000 <--It should be -10800
The CREDIT memo and the DEBIT memo are reproduced the issue .
The Standard Invoice and Prepayment are not reproduced.
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 |