SAP Business One: High Quantity on a Sales Order

By Mark Chinsky • February 11th, 2009

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

Thanks to Ed Monk of SBONotes.com

  • Share/Bookmark

This website uses IntenseDebate comments, but they are not currently loaded because either your browser doesn't support JavaScript, or they didn't load fast enough.

 

Leave a Comment

You must be logged in to post a comment.

« | Home | »