how to get tax code from transaction line table

AI generated answer (using internal Slack threads):

To get the tax code from the transaction line table, you can use a Saved Search or SuiteQL. For a Saved Search, you can follow these steps: 1. Run a saved search without any

Main Line

criteria. 2. Include

Item

and

Amount

in the results. 3. You will see the main line (denoted with the * if you add the “*” column) with some rolled up amounts, but then the non-main lines with the various items (inventory, shipping, tax) along with their amounts. 4. Depending on the overall structure of the search you could pull in tax info if you did some grouping/formulas to grab what you needed for the column. 5. The

Tax Item

might be what you’re looking for, but it’s not on the Main Line. For SuiteQL, you can write a query to get the Journal line details along with tax Code and Tax amount on the line. However, the exact query would depend on your specific database structure and the fields you have available. Please note that not every field you see on the transaction page is documented in the record browser, and not all are able to be added to a saved search the way it seems they should. This is because when you’re looking at a transaction in the system, you’re looking at a loaded record — which has some fields and values that are derived or pulled from the underlying transaction lines in the database to make it appear as a “field” on the transaction. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******