High Quantity on a Sales Order

Use this query to check for high order quantities on a Sales Orders.

If you make an alert out of this query, then you can be notified when potential keying errors occur.

/* Shows all sales orders where the qty ordered is greater */
/* than or equal to the amount within the WHERE Clause below */

Select 
DocNum as 'Order#'
,itemcode as 'Item#'
,dscription as 'Description'
,Quantity
,Gtotal 'Line Total'
,cardcode as 'BP'
,cardname as 'BP Name'

FROM rdr1 dtl
INNER JOIN ordr hdr on dtl.docentry = hdr.docentry

WHERE
Linestatus = 'O'
and Quantity>=100

Order By DocNum, LineNum
FOR BROWSE