Hi there, can see that transactionaccountingline is not incremental. Is there a way to get the same results without using transactionaccountingline table? Can transactionline be used to get the amount and account or does another table exist?

You can use the transaction line expense account column and the transaction line amount field is in the transaction currency where transaction accounting line is in the subsidiary currency, so those may have different values