Time for the obligatory AI-related post!
One of the things I’ve always wanted in NetSuite is a central “dashboard” related to inventory lots (and to a lesser extent serialized inventory).
What lots are due to expire soon? In 30 days? In 90? What’s the value of that expiring inventory? How many units is that?
I’ve tried a lot of things to see what I could do within this domain, but never came up with anything I felt had promise.
A few months ago, I was experimenting with the NetSuite MCP SuiteApp and asked it what it could do to help me with lot management. It gave me this in about 5 minutes.
Review by item or location. Grouped expiration window with expandable tiles to show specific lots in each expiration bucket, with cost. Outside the screen shot is a full table of lot information.
I could have had the AI convert it to something like a Suitelet so it could be run from inside NetSuite itself. But I didn’t take it that far due to time and other priorities.
Since then we’ve gotten NetSuite Next, with its embedded Ask Oracle functionality. And after another quick test this morning in a NetSuite Next demo account, I can confirm you can do basically the same thing (though the output's appearance will be quite different).
So if you’re looking for lot inventory analysis, experiment with NetSuite Next or the MCP tools. It looks very promising.
I’m not providing the prompts I used because in both cases I single-shotted them and did not give the AI a lot of information. In other words, I went quick and dirty just to see what I'd get. You’ll want to work out a prompt that’s got a lot more detail.