Updating Invoice Header amount with exclusive tax automatically on expenses invoice
Summary:
When contingent worker (CWR) expense invoices are transferred to Payables, we calculate the exclusive tax using a third-party tax engine. Is there a method to update the header amount with the sum of the line and tax amounts to validate the invoice without any line variance holds?
These expenses are created as "Standard Invoice" and not "Payment Request" in AP by the interface from expenses to AP.
As the CWR expense does not go to the AP_INVOICES_INTERFACE table, where this can be achieved by setting the ADD_TAX_TO_INV_AMT_FLAG, I would like to know which tables are used to move the CWR expense from Expense to Payables. Additionally, is there a similar field available that can automatically update the header amount with the sum of the line and tax amounts when the CWR expense is moved to Payables?