hey guys
I am after SQL query to pull a tax code, tax amount at line level for specific invoice using ODBC
My ODBC config is using
Netsuite2.com schema
Netsuite`s suiteanswer suggests :
SELECT
*
FROM
transaction_tax_detail td
left join transactions tr on td.transaction_id = tr.transaction_id
WHERE
transaction_id = '123456'
Also connect schema is listing transaction_tax_detail as available table, yet ODBC giving me an error this table was not found