I want to know pull shippingtaxcode (field on the Invoice record) in the saved search but cant find.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the

ShippingTaxCode

field is not directly accessible in a saved search because it's not a column but a transaction line. However, you can potentially pull in tax information by grouping or using formulas to grab what you need for the column. Here's a general approach: 1. Run a saved search without any

Main Line

criteria. 2. Include

Item

and

Amount

in the results. 3. You'll 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. Remember, when you're writing a saved search, it's a GUI wrapper over a database query. 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. Please note that this is a general approach and might need adjustments based on your specific requirements. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******