A client has an alert (based on a query) that runs once a week to email open PO's for a certain customer..
this alert is emailed and messaged internally.
what they've noticed recently is that not all the data shows in the email.
when you run the query the results are about 123 lines...but in the email there is only about 73 lines.
what could be the issue?