by ehiatt » Wed Oct 18, 2017 3:07 pm
This should give you what you want for sales in Report Generator:
Query LIST PDA.PARTS WITH CLOSED GE "%" AND WITH CLOSED LE "%" AND WITH SO EQ "%" BY PART-NO BY REFER PART-NO DESC CLOSED QTY SLSMN EMPNAME SO REFER ID-SUPP
Selection WITH CLOSED GE "%" AND WITH CLOSED LE "%" AND WITH SO EQ "%"
Sorting BY PART-NO BY REFER
This is by date and source. If you want all sales in all sources by date, just take out: AND WITH SO EQ "%"
Hope that helps.