Can’t find Inventory Detail/Inventory Status through Suite Analytics Connect
Using Suite Analytics Connect ODBC and we cannot find the Inventory Detail/Inventory Status in the data tables or schema. We can find the Inventory Status values but we need it in the Inventory Detail to give us some insight into transactions with the Inventory Status that the item has at that time. Does anybody know where to find this?
Regards
MikeR
If you are unable to find Inventory Detail/Inventory Status in the data tables or schema while using Suite Analytics Connect ODBC, it is possible that this information is not included in the standard NetSuite data tables.
However, you may be able to obtain this information by creating a custom search in NetSuite that includes the fields you need, such as Inventory Status and Inventory Detail. Once you have created the search, you can use SuiteAnalytics Connect ODBC to connect to NetSuite and retrieve the data using the custom search.
To create a custom search in NetSuite, you can follow these steps:
-
- Navigate to Lists > Search > Saved Searches > New.
-
- Select the record type for which you want to create the search (e.g., Inventory Detail).
-
- Add the fields you need to the search criteria and results sections (e.g., Inventory Status, Inventory Detail).
-
- Save the search with a descriptive name.
Once you have created the search, you can use it in SuiteAnalytics Connect ODBC to retrieve the data. To do this, you will need to set up a connection to NetSuite using the ODBC driver and then create a query that includes the search you created.
I hope this helps! If you have any further questions, please let me know.
Best,
TROY OLTMANNS
NETSUITE TECHNICAL ARCHITECT
(p) 949.238.6900
(f) 949.271.4635
Check out our open opportunities at: Trevera Opportunities
Hi Troy,Great, thanks. We will give your solution a try. Appreciate you taking the time to answer 🙂 Regards Mike Radford
