Hi all,

We do most of our customer reports based off the GL_DetailPostings table.

I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to display the ItemCodes from the sales invoices on the report.

I see no way to link the GL_DetailPosting records back the AR_InvoiceHistoryDetail table (???)

I can link back to the invoice header record easily but there is no lineno or sequenceno field that can tie back to the invoice details table, unless I'm missing something? 

Thanks in advance for any help you can offer!