when using a NetSuite formula in a dataset, when I try to access location.timezone i get an error: "Your formula contains a reference to an inaccessible field" But I can access other fields on the location. What is going on?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like the issue you're experiencing is due to the fact that not all fields on the location record are accessible in a NetSuite formula. This is likely because some fields, such as

location.timezone

, are not stored values and therefore cannot be referenced in a formula. In NetSuite, a stored value is a value that is saved in the database and can be referenced in searches and formulas. If a field is not a stored value, it cannot be referenced in a formula. This is likely the case with the

location.timezone

field. If you need to access the timezone information, you might need to create a custom field that stores this value and then reference that custom field in your formula. However, please note that this might not be the best solution depending on your specific use case and requirements. Remember to always check the "Store Value" option when creating custom fields if you plan to use them in formulas or searches. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******