hey guys, i am trying to get the internal id "quantityonhand" and "newquantity" exposed on a saved search using the "formula (text)" as the result and getting "error:invalid expression" as the result. Since i am a n00b at this, anyone have ideas?

what are you using for the formula

{quantityonhand} -- that's it. I am just trying to display the values in the field, not trying to get anyhting done to that field. The field is unavailable via the drop down in the search.

what type of search

Is this an inventory adjustment search?

yes! using the type "transaction"

You need to join from the item or inventory fields

unfortunately, those fields are not available in the drop down, so can i use a join in the formula field?

You’re not going to get “new quantity” though, I bet.

dang

they are the fields with ... at the end

right i cna get to that table..but within that table in the search, i can't get the fields "quantityonhand"... i guess maybe they are just called "quantity". lemme run that

though like @mattdahse I dont recognize new quantity

What you really want is “what did I have before this adjustment line?” and “What do I have after this adjustment line?” and those values are probably not going to be available in a search.

new quantity can be calculated using a formula field of taking quanitty on hand + adjustment quantity

Yes, but the problem is that if the adjustment happened yesterday, your “on hand” from today isn’t what you want.

yup, it is almost like I need an inventory balance at a point in time

anyway, to get on hand in your search formula, add the formula(text) column, then for the actual formula, select

Item Fields...

and then

On Hand

to see how joins should look like

ohhhh, i didn't know i could do that!!!! THANK YOu!

But again, that will give you what’s on hand at the moment the search is run. Not what was on hand before the adjustment happened.

yup, saved search si going to be live data. which means i need to focus on the inventory detail report.

my general advice is to avoid trying to calculate historical inventory

ohh wow....didn't think that would even an option