How do you extract VAT amount on purchase order and sales order lines? Can't find one field even showing gross amount in transactionline or transactionaccountingline table. Using Legacy Tax. I haven't found a way through my "research", but you never know...

I am in similar situation We are using Netsuite2.com schema for most of the data pulls, but Netsuite.com for tax tables Now I have a list of fields from transaction_tax_detail table I need to find equivalents for in Netsuite2.com So far I have found this : https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/article_0822031101.html There is link to Excel there, which shows some fields mapped, but not all.

Yes.. thank you! Not even the taxline in the transaction line table is something you can trust... if a line is closed for instance, the taxline amount is including that line. And in some cases, on POs, it disappears completely if you close 1 of two lines.

spoke to Support and they told me I should install SuiteTax as the tax lines will not be present in legacy netsuite.com schema

okey! and by doing that, does that force you to leave legacy tax and start using suitetax? sounds like a bit of a project

indeed, and I am not looking forward to implementing SuiteTax We use our own custom tax solution (basically a big script) that calculates VAT based on : subsidiary, Item`s GL, Billing country and few other variables .... all due to the vertical my company operates in.