Hello, how I can identify the tax rate/amount of each item in a transaction? For example if there is an invoice with 4 items ( 1st with tax rate 21%, second with tax rate 0%, third one with 9% and last one again with 21%) In trasnactionline table there are 8 rows: 1 for main line, 4 for items with netamounts ( one row per item) and 3 rows for each tax rate with summarized information( one row per each tax rate : 21%, 9%, 0%) . However, I need to have information like item1 -> 21% tax rate, item2 -> 0% tax rate, item3 -> 9%, item4 -> 21% tax rate. How I can achieve this? Is there another table I can use or the only way is to apply some calculations...

Hi I have tried before in SuiteQL without any results.. https://timdietrich.me/blog/netsuite-suiteql-sales-tax/ that is not a proof though. You can find it in a saved search with "tax item"

@mesper, thank you very much 🙂