Why do items on Cash Refund transactions display with multiple lines in saved search results?

I have created a saved search to identify items on Cash Refund transactions that do not have the Bin field populated in the inventory detail.  Looking at a Cash Refund transaction record, each item is listed once on a single line with a positive quantity value, but in the saved search results there are additional lines showing a negative quantity value.  Where is this negative quantity value coming from and how can I filter it out?

I have already tried using the criteria “quantity is greater than or equal to 1” but that did not work to filter out these extra lines.

I’m stuck and hoping somebody here can lead me in the right direction.

Thanks in advance for any helpful information you can share!

Rookie Asked on November 27, 2020 in Saved Searches.
Add Comment
1 Answer(s)
Best answer

Hello Emma,

If I have understood this correctly, this could have to do with an account, tax line, shipping line etc. that is on the cash refund transaction as well that is then cause this. If you add an account column to your results and see which accounts are causing the negative you can exclude these.

Trust this makes sense and helps.

Rookie Answered on November 27, 2020.

Thank you so much, this worked perfectly!

on November 27, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor