Hi there fellow SuiteQL folks. I am trying to get the transaction lines from an Advanced Intercompany Journal transaction. What I however don't get is that whenever a tax rate has been applied it is handled as a separate transaction line and I can't find a way to map these additional VAT lines to the corresponding non VAT lines. In the following screenshot I had queried the

transactionaccountingline

so that you can easily see what I mean. On all lines where the amounts are 75 a tax rate has been applied. These are then show as separate lines (15.75) and I cannot see any keys that would reference these vat lines to the corresponding non vat lines. Additionally the non vat lines does not indicate which tax rate / code has been applied to, so I can't use that way to calculate the tax amounts myself as a work around.