This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I have a saved search that fetches an item that s updated after a specific time . but i get duplicate results for a single item.

looks like you added a column which uses data from a join (location available)

you should get one search result for each inventory location you chose in your location filter

criteria contain filters, results contain columns

i added another column named Location and that shows that there are two results for same location

for your purposes, you can use the filter and column literally named Inventory Location

out of curiosity, why do you have a custom last updated

I want to have a field that saves the date and time when an item is updated

the difference to the last modified being?

yes, it has the date/time the record was last modified

I am a beginner actually .. The developer previously working on netsuite used this field in many scripts .. I am just continuing that

similarly, the last quantity available change has the date/time the quantity available changed

understand the difference between quantity available and quantity on hand before using that column

a minor warning: kits dont have inventory numbers stored in their columns

and in general beware unit types when doing quantity, the quantity shown may not be in the units you want

Will the saved search work for kit as well

I want it to work against both kit and inventory items

and im not sure if you can do it if your inventory items use units type

for kits, you would need to setup filters and columns using the member item join to calculate inventory

I have noticed that the filter inventory location doesnt work in case of "Kit"

ok .. I may have to change my script then to use another saved search specifically for kit

ask on <https://netsuiteprofessionals.com/> if you need help making that search