Tax Line Not Being Interfaced to AP from PN (Doc ID 978414.1)

Last updated on MARCH 24, 2016

Applies to:

Oracle Property Manager - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

 Tax setup has been done at the term template level in the Property Manager module. The tax code is set up with 'tax inclusive' as 'No' and 7% VAT tax.

The term template is attached in the payments tab to an expense lease. After it is authorised and exported to AP, the tax amount does not flow to AP. When the invoice is queried in AP, it first displays only the invoice amount, but after clicking on the tax details button and then going back to the general tab, the tax info is then displayed. However, the tax amount is added as an extra line amount, so after that, the header and line amounts are not in synch which causes an invoice hold.

If the following flags are updated in the ap_invoices_interface table, the invoice appears correctly in AP:
CALC_TAX_DURING_IMPORT_FLAG to Y
ADD_TAX_TO_INV_AMT_FLAG = Y

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms