Having some trouble creating a transaction Saved S...
# general
k
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
c
At a line level amount = amount of the line If you want returned amounts per line: Applying transaction...fields 'amount'. Gross sales = net sales at the line level Gross sales - applying transaction amount = net