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.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the tax item or gross amount connected to a specific line in SuiteQL cannot be directly extracted as seen in the front-end. However, there are a few things you can check or do: 1. Ensure that the "Enable Tax Lookup on Sales Transactions" and "Per-Line Taxes on Transactions" options are checked. You can find these options by navigating to Setup > Accounting > Set Up Taxes. 2. Check if you have created a Tax Schedule and if the particular item (or all of your items) is assigned a Tax Schedule. 3. On the Customer Record, ensure that the Taxable Box is checked with the Tax Item Assigned. 4. If the Sales Order is using the old form prior to enabling Advanced Taxes, then the Tax Item should live under the Accounting Subtab on the Older Sales Orders. 5. Tax is calculated during the submit process (probably before submit) of the Sales Order. It is not calculated/reflected as each item is added. Once you save the sales order, it populates the standard taxtotal field only then. 6. If the tax code rate is 0%, then the tax amount will be 0 also. Remember, the tax item field on the customer comes from the record of type

taxcode

and on the sales order, the field of the line item

tax code

comes from the record

tax group

, so the IDs are different. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******