We have some custom Order reports that print in our warehouse.
Previously, I was given the task reducing the amount of paper that was being used - by restricting the reports to print only those that had items to ship (ie. no orders with only backorders, dropships or a combination of the two).
It seemed to be working fine, until a couple of days ago. They came to me and showed me a completely blank report, well it had the Order information, but no details.
Currently I have this restriction in place:
I had figured that this would work - if a record exists with a Qty To Invoice above 0 (not backordered) AND Drop Ship = 0 (that item isn't dropshipped) then print.
Apparently I am mistaken. I can take out the restriction and it will print the order, just fine - it has only drop ships. If I add a backordered item to the order - it will print and both of the items will print.
Any ideas?
Previously, I was given the task reducing the amount of paper that was being used - by restricting the reports to print only those that had items to ship (ie. no orders with only backorders, dropships or a combination of the two).
It seemed to be working fine, until a couple of days ago. They came to me and showed me a completely blank report, well it had the Order information, but no details.
Currently I have this restriction in place:
Code:
EXISTS(SOP_LINE_WORK.Qty To Invoice > 0 AND SOP_LINE_WORK.Drop Ship = 0)I had figured that this would work - if a record exists with a Qty To Invoice above 0 (not backordered) AND Drop Ship = 0 (that item isn't dropshipped) then print.
Apparently I am mistaken. I can take out the restriction and it will print the order, just fine - it has only drop ships. If I add a backordered item to the order - it will print and both of the items will print.
Any ideas?