hey guys I am after SQL query to pull a tax code, ...
# suiteanalytics
m
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
c
Are you using legacy tax or suitetax?