So I'm trying to to add some data from the Invoicing Transactions Amounts Work table (INV_LINE_WORK - IVC10101) to the Invoice Posting Journal report.
In Report Customizer, if I go to Table drop down and choose IVC_HDR_WORK (Invoicing Transaction Work) / Relationships I see it has a relationship for Invoicing Transactions Amounts Work Table there.
I go to the Invoicing Posting Journal / table / relationships I see that Invoicing Transaction Work table but when I hit new I don't see a link to the Invoicing Transaction Amounts Work Table. I would have expected to see it there.
What am I missing to get to add the Invoicing Transactions Amounts Work table to the Invoice Posting Journal Report.