What I need is to pull up the sales orders for a specific item.
What is happening is that the search results always come out with multiple lines from the same sales order or cash sale. I have done this same type of search and keep getting the same results. Multiple lines from the same transaction. I have written another thread about this with no results and I had a slightly different goal for that search.:mad:
I have tried the main line = true and the others you will see below that are supposed to make it work with no luck.
My criteria:
Type is Cash Sale
Item is DVD-MR-Raiders
Date is within 1/1/2011 and 7/15/2011
Tax Line is false (This I read from another thread)
Shipping Line is false (This I read from another thread)
Main Line is true (This I read from another thread) But when it is true it shows up NO RESULTS
Results:
Date*****
Name*****
Customer : Address 1*****
Customer : City*****
Customer : State/Province*****
Customer : Zip Code*****
Customer : Phone*****
Customer : Email*****
Amount
Thanks
Abby