11i: AP: How To Perform A Mass Update Of Null Income Tax Types For Federally Reportable Suppliers (Doc ID 987031.1)

Last updated on JULY 31, 2023

Applies to:

Goal

Many Invoices are not being reported in the 1099s. The Invoice Exception report shows that these invoices are listed in the section "Invoice Distribution Lines for 1099 Suppliers with No Income Tax Type". 

Further research indicates that the field Income Tax Type in the distributions window, which maps to the column AP_INVOICE_DISTRIBUTIONS_ALL.Type_1099, are blank.

Is there some way to populate these distributions with the default defined in the Supplier record without having to query each invoice and distribution separately?

Solution

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