Hi Everyone,

Issue: After some investigation, we've identified that NetSuite doesn't support Formula Fields and sounds like also does not support Calculated Fields through the API (i.e. they are not extracted and loaded to the data warehouse or the lastmodifieddate is not updated when there are changes, in the case of Calculated Fields).

Feature Requested: Like Salesforce's Formula and Lookup Field dbt_package, it would be fantastic to have a NetSuite dbt_package that allows us to store the calculations and formulas in NetSuite and then build them in our data warehouse.

Please upvote if this is something you'd like! Please comment if you have more information about this use case.

Example use cases:

• A field that houses the row_number of a transaction_line
• A field that shows how many days until or after a certain date (time delta field)
• A field that multiplies two fields together

More Information:

Formula Fields are custom fields that are dynamic in the NetSuite application. They recalculate each time a page is loaded with the data available. As an example, you could create a formula field that is simply the row_number of a transaction line. Each time lines are deleted, created, or moved, this row_number formula field recalculates to reflect the display on the application page. 

It appears that you cannot actually "Store Value" of these custom Formula Fields (you can check the box when you are creating, but they will not be pulled into the data warehouse). See NetSuite's documentation for more details.

On top of not even storing the values, from talking with Fivetran, it sounds like there are other cases of calculated fields (such as subtracting two fields from each other) that can be stored and extracted, but updates to those fields do not trigger the lastmodifieddate to change, which means that the data is not updated by Fivetran. This is very similar to the Salesforce formula field situation and requires a dbt_package-type solution to fix.

As of now, I don't believe NetSuite offers a table that houses the formulas and calculations, but I could be wrong.