what field shows the subtotal of an invoice on a transaction dataset

AI generated answer (using internal Slack threads):

The field that shows the subtotal of an invoice on a transaction dataset in NetSuite is typically represented as

{amount}

. However, this field includes tax and shipping charges. If you want to exclude tax and shipping charges, you can use the formula

{amount} - NVL({shippingamount},0) - NVL({taxtotal},0)

. This will give you the subtotal of just the items on the invoice. Please note that

NVL

is a function that returns the first non-null value in the list of values provided. In this case, it's used to ensure that if the

shippingamount

or

taxtotal

fields are null, they will be treated as 0, preventing any errors in the calculation. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******