My Oracle Support Banner

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 JUNE 14, 2020

Applies to:

Oracle Payables - Version 12.0.0 and later
Information 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


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