Hello, i've created a Saved Search to monitor serialized assembly items that we loan to people. What I want is for the item(s) to come off the search when it has been returned to us (via a Return Authorization).
So far we are handling loans like Sales Orders, so I simply created a custom Sales Order "Loan" form with a couple of custom fields pertaining to the loan (Loan Return Date, etc). This way we can fulfill/pick/pack/ship etc, we are just not taking their money. When an item is returned, we do a Return Authorization.
Here is the Saved Search ive setup so far:
Transaction Search
Type is Sales Order
Loan Return Date is not empty
Tax/Shipping/COGS/Main Line is false
Item is none of (2 items we dont want to see)
Item : Name does not start with (a certain item group we want to omit)
A fairly simple search that correctly shows me the items, but what its not doing is accounting for when something is returned. My thought is to remove the item from the search if it has been returned via a RA in the system, but I can not get it to work. Ive tried using several of the bottom "field" selections, like "Applying Transaction fields" (are none of Return Authorization), etc but thats not working.
NS Support is working on this offline (cue laughter) so I thought I would try here. If anyone has any thoughts on how this could be done, whether its using the current search or starting over from scratch, im all ears. Thanks in advance!