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’
Order By DocNum, LineNum
Thanks to Ed Monk of SBONotes.com