You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Link between subledger lines and invoice lines

Received Response
edited Jul 30, 2020 1:10PM in Subledger Accounting & Accounting Hub 1 comment


I need to link XLA_DISTRIBUTION_LINKS with ap_invoice_lines_all


I need to link XLA_DISTRIBUTION_LINKS with ap_invoice_lines_all, basically to link the tax rate code with sub ledger accounting tables.

i have tried going through AP_INVOICE_DISTRIBUTIONS_ALL using invoice_distribution_id = source_distribution_id_num_1 and applied_to_source_id_num_1 = invoice_id, but this doesn't work for all of the invoices, unfortunately. I think this is because i need the tax rate code to go onto the 'item' rows instead of the tax rows which the report doesn't pick up  in the form of extra rows such as in the ap_invoice_lines_all table.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!