Having some trouble creating a transaction Saved Search to show under results:
1. Gross Sales
2. Returns (in $ amount)
3. Net Sales
I can get the Net Sales but not the other 2. I currently have Shipping and Tax Line on NO which I'm assuming is causing the Gross Sales number to not be accurate. I tried Amount (Credit) for the Returns it wasn't accurate.
For Criteria, I have:
1. Main Line False
2. Type: Cash Refund, Invoice, Credit Memo (should I add item receipt?)
3. Shipping and Tax Line False