To cope with our 90 subsidiaries, we are exploring SuiteQL - which we have found to be great.
However the tax lines have NO account detail in the transactionline or transaction. So I figured we would link back to item table to get the account... or to the transactiontaxdetail table - but it does not seem to exist.
Any suggestions