How to get Inventory Adjustments records through SuiteAnalytics connect service?

AI generated answer (using internal Slack threads):

To get Inventory Adjustments records through SuiteAnalytics connect service, you can use the

transaction

table in your SQL query. The

transaction

table contains all the transactions in NetSuite, including Inventory Adjustments. Here is a sample SQL query that you can use to get the Inventory Adjustments records:

sql
SELECT * FROM transaction WHERE type = 'Inventory Adjustment'

This query will return all the fields from the

transaction

table where the type of the transaction is 'Inventory Adjustment'. You can replace the '*' with the specific fields that you want to retrieve. Please note that the actual field names in the

transaction

table might be different depending on your NetSuite setup. You can use the

SHOW COLUMNS FROM transaction

SQL command to get a list of all the field names in the

transaction

table. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******