Hi All, I have my head a few projects atm so I can...
# inventory
s
Hi All, I have my head a few projects atm so I can't get my brain to work out how to create a search or report (pref a SS) to alert my sales people when an item which was 0 or less on hand, is now back in stock. (I'm not interested in stock we have just received, only the stock which was completely sold out). Thanks in advance!!
d
Not sure what you mean by your comment in parenthesis, but.. You could create a transaction search for "inbound" transactions (depending on your setup, could incl. receipts, adjustments, builds, etc) Then your criteria could be
On Hand - Quantity (on this transaction) less than/equal 0
To be a bit more robust you could do a summary search on inbound qty for today, summary criteria of
SUM quantity >= on hand
This is to account for the same item being receipted/coming in on two transactions at the same time/on the same day. All depends on your NS config and requirements
s
Thanks David. I'm unsure re the parenthesis (I had 2 comments in () ) .. essentially I just want to know which stock has been received today that previously had 0 or negative stock. I don't want to see the stock received today which already had a qty greater than 0 on hand. Its to alert our sales people that items which were previously out of stock, are now back in stock.