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!
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.
Thank you so much, this worked perfectly!