Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Link between subledger lines and invoice lines — Cloud Customer Connect
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
38
Views
1
Comments
edited Jul 30, 2020 1:10PM in Subledger Accounting & Accounting Hub 1 comment

Summary

I need to link XLA_DISTRIBUTION_LINKS with ap_invoice_lines_all

Content

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.

Register

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