We use a macro to print sales docs. The macro hits the transactions button - Print Sales Docs. Sets the type to Order, checks Document, and tells it to print the range 0000000000 to 9999999999, not reprinting any.
Now as would be expected it also prints any Sales Trx that have 0 items shipped. We do not want this.
So being a newb to this program I play around with it, and discover the retrictions part of the report. I setup a restriction like the following:
SUMMATION( SOP_LINE_WORK.QTY To Invoice ) > 0
Now from my understanding, this would make sure that the quantity to invoice (number shipped on report) would be summed up for that report and only if it is greater than 0 it would allow it through, that is printed.
This doesn't seem to be the case, however, as I can still print a batch a Sales Trx that have only backorders and have every single one printed.
Does anyone have any ideas why the above restriction isn't working (i.e. I did it wrong), or know of any way to get it to do what I need it to do?
Now as would be expected it also prints any Sales Trx that have 0 items shipped. We do not want this.
So being a newb to this program I play around with it, and discover the retrictions part of the report. I setup a restriction like the following:
SUMMATION( SOP_LINE_WORK.QTY To Invoice ) > 0
Now from my understanding, this would make sure that the quantity to invoice (number shipped on report) would be summed up for that report and only if it is greater than 0 it would allow it through, that is printed.
This doesn't seem to be the case, however, as I can still print a batch a Sales Trx that have only backorders and have every single one printed.
Does anyone have any ideas why the above restriction isn't working (i.e. I did it wrong), or know of any way to get it to do what I need it to do?