Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing Sales Doc Restrictions

Status
Not open for further replies.

Borvik

Programmer
Jan 2, 2002
1,392
0
0
US
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?
 
I found the answer.

Setup Sales. Choose Sales Order Proc.
Choose ther Order button at the bottom, and Select the ORDER ID at the top of the next screen.
Finally Uncheck the checkbox 'Allow all Back Ordered Items to Print on Invoice'

Hope that helps anyone else looking for the answer.
 
Ok so I was a little presumptuous. It worked while printing to the screen, but when actuall printing came to.. it failed to work. Back Orders still came off of the printer.

Any ideas as to what's causing this?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top