Hey Everyone, I work on the NetSuite Platform tea...
# general
m
Hey Everyone, I work on the NetSuite Platform team looking to better understand how community members leverage AI/LLM capabilities to help with NetSuite-related tasks. I'd love to learn more about how you're using generative AI / tools to improve how you're working with NetSuite and/or if there are tips & tricks, preferred tech stack / concepts you're following. My goal is to refine my own skills and help promote AI/ML ideas within the org. 🕺 🪩
🙌 1
n
One idea I keep thinking about: how helpful would it be if a NetSuite instance came with an AI-powered chatbot that was 'aware' of your specific environment—scripts, configurations, settings, and all? You could ask it about features, architectural decisions, or even troubleshooting, and it would provide account-specific guidance. I think this could really streamline development and problem-solving. Curious to hear what others think!
thisline 2
👍 1
b
“Hey AI - where is this field used?”
👍 1
k
I use a vectorized version of the NetSuite documentation to power my own internal chatbot. It can answer questions about how to do just about anything using Retrieval Augmented Generation
💡 1
I'd love to partner with NetSuite if you guys want help building your own version.
I've also experimented with giving a generative AI access to a restlet to query the NetSuite schema directly using SuiteQL but have found it less useful at least the last time I tried.
🤔 1
Something that runs natively within NetSuite might be more useful for that use case
thisline 1
👍 1
r
Also #C05DWU284G1
@Mohammed Kassem one example I have done is an ai text summary on the sales order. It’s the last AI example on this blog I wrote: https://collectivemindtechnologies.com/blog/netsuite-ai-artificial-intelligence-for-erp/ Happy to discuss
🙌 1
I have a few other ideas as well. But also this is concerning: https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1737917252695849
👀 1
k
ooooh
N/llm
looks cool, definitely playing with that tonight after work. 😄
👍 1
Nevermind, it's pay as you go. Can't do any kind of serious development with this. 😞
👀 1
m
@Nadav Julius + @Ben Barnett your ideas are similar. I agree with them too. Curious to see how you imagine this will look / feel? A chatbot? or.. @Kristopher Wood - did you use embeds of the documentation in your RAG? Was this in PDF, XML, or markdown? Just curious, I've been thinking about doing something similar myself for experimentation purposes
r
@Mohammed Kassem sounds good. Thanks for passing it on. I would love to see how the N/LLM is the advantage in using vs integrating chatgpt or another LLM. I would also love to see a comprehensive article stating every field, feature, etc where NetSuite has added AI. I saw 2024.2 added AI to 200 fields but no list of those anywhere.
k
@Mohammed Kassem My RAG database is generated from the plain text of the publicly available documentation website. Whenever I read an article in the documentation I convert it to markdown and vectorize it. Then my AI uses graphql to search the vectors when generating answers.
Giving GPT access to SuiteQL was less useful for two reasons. 1. GPT is not fully agentic yet, so does not consistently use queries. SuiteAnalytics workbooks are more user-friendly and always accurate. 2. I am a consultant and do not have my own NetSuite account. I cannot ethically give GPT access to a client's business system. Therefore I have only been able to connect it to the MyLearn databases. These are not true business environments so aren't very useful. If I had a use case / reason to do more, I could, and maybe it would be more useful. I don't have one at the moment.
n
This is one of the big reasons I think a built in chatbot would be much better. The security wall you need to get over is much harder to get passed when its external VS opting into something internal.
👍 1
k
While there is a free option for
N/llm
, I assure you I'd blow through the monthly allotment. I did every time when building my GPT until they came out with the business version which is unlimited. I didn't get it to the point where I could make anything useful for my business until then.
r
One question I have had is, is it “really” internal or is it just pushing the info to Cohere and bringing back in?
k
That's exactly it. A public endpoint for an API I cannot control scares me.
It's "really" internal to Oracle's database cloud.
r
When I use the test chatbot in NetSuite, It’s not accessing any NetSuite data.
k
it says so in the documentation at least
r
Interested to hear more about it. This is what the chatbot says, so I’m not sure.
“You Can you get any data from my NetSuite account? ChatBot I’m unable to directly access your NetSuite account or any external systems due to security and privacy reasons. As an AI chatbot, I’m designed to respect the confidentiality and integrity of your personal and sensitive information. Any connection to external applications or databases requires a secure and authorized integration, which is typically set up at the infrastructure level. If you require specific data from your NetSuite account to assist you with particular tasks or answers, you can consider using the NetSuite API or integrating it with authorized third-party applications. That way, any exchange of data between NetSuite and an AI assistant like me would be handled securely, adhering to the necessary privacy and security protocols.”
n
@Kristopher Wood I mean your whole NetSuite instance is
"really" internal to Oracle's database cloud
right?
k
@Nadav Julius in a sense yes, though NetSuite is its own company, and Oracle Cloud Infrastructure is a separate one.
n
Yeah but NetSuite runs on OCI right?
k
No idea.
r
All NetSuite accounts are on OCI from what I have heard
thisline 1
I think they moved them all over last year
👍 1
“all NetSuite partners and customers are now officially running on OCI, a transition that was started in 2022.”
n
Exactly, so I'm just saying nobody's NetSuite's instance is local so were all trusting NetSuite with our data and by extension were trusting Oracle and OCI... so anything else in that ecosystem would be much easier to trust with the same data then anything external to the ecosystem.
👍 1
k
As far as giving it access to real data, it's an abstraction layer. You have to script the ability for it to "search" if you want it to be "aware".
My GPT isn't actually "aware" of its database. It's just slight of hand. It translates my requests to GraphQL and makes a query behind the scenes, then generates a new response based on the results which it sends back to me.
So you'd give N/llm a prompt which explains how to respond, how to get your script to do a query instead of sending the response to the user, how to use the query result to generate a user response. You'd have it add a prefix before its response if it "wants" to do a query, so if the response string begins with /query then pass everything after /query to N/query and send the result to the model to be interpreted and paraphrased to the user.
n
For sure... but if it was integrated into your NetSuite instance it could train itself on real time data giving it a much stronger context upfront
k
yeah, it doesn't look like the technology is there yet