Hi everyone! Is there a way to extract from suiteql the tax item or the gross amount connected to a specific line as I see in the front-end? For example if I have 2 tax codes in a SO, in the extraction I can see the two distinct lines one for each tax code but I cannot understand which inventory item has which tax code. Today I am only able to extract net amount and then a line (the tax line indeed) with the total tax amount, but I need to have the information in the line of the inventory item I'm considering. Thank you for your kind support

Have you tried looking at the transactionlines?

If they are using suitetax, there is a transactionTaxDetail table you can join on from the transactionLine. If they are not, I don’t believe there is anyway to have a relationship between the tax line and non-tax line

That looks like you're not on SuiteTax. After going back and forth with support for a while, they told me legacy tax fields (aka not SuiteTax) are not available in the new schema that SuiteQL runs off of. As it turned out, we weren't really using those fields, so we lucked out, but I don't know what you're supposed to do if you are using them.