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 */
DocNum as ‘Order#’
,itemcode as ‘Item#’
,dscription as ‘Description’
,Gtotal ‘Line Total’
,cardcode as ‘BP’
,cardname as ‘BP Name’

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

Linestatus = ‘O’
and Quantity>=100

Order By DocNum, LineNum

Thanks to Ed Monk of