<@UDEBTKW4A> not silly - seen this needed from man...
# inventory
a
@Tyler not silly - seen this needed from many clients; one approach was to build a saved search that calculated this number and place it as a custom sublist on an item form
t
Thanks a bunch @al3xicon! Mind if I ask some follow-up questions on that? 1.) What would that type of saved search look like? Would it just be looking at the quantity of each individual component and then essentially return the lowest component quantity? 2.) How often would that saved search have to run in order for it to remain consistent and accurate across an entire inventory list? Would there be any concern of significant lag time with this? Again, thank you for taking the time to help out. I really appreciate it
a
yep, you just need to calculate each member item's available (or on hand, depends on how you define it) qty , multiple by the qty needed in your build, and return the "minimum" of that so to speak
the approach to take depends somewhat on what you want to DO with the data, though
if read-only suffices on an item record, then a custom sublist or summary search into custom field are two real-time approaches, and don't require any manual running of the search itself
t
Well I am essentially looking to search for an Item and then return a quantity number of how many physical units we have on hand, plus the amount of items we can create. It would be read-only
a
if you need to store the value of the data, however, in order to report on it further / include in your own saved searches, then a different approach will be needed - i think there isn't a way to do this without a script, really - and that could run every 15 minutes to be maximally up-to-date
ok, then a single saved search with a filter on the item should do the trick
just requires some fancy formula-ing
t
For sure. I will take a look at it and see what I come up with. Thanks again!
a
you bet