SAP Business One: 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
Thanks to Ed Monk of SBONotes.com
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.
« SAP Business One: Query to Show Customers Without Sales Employees Assigned | Home | SAP Business One Birthday List! (without the year) »
July 30, 2010
by: Wayne Schulz • Epicor, Publishers, Schulz Consulting
July 24, 2010
by: Wayne Schulz • 90minds
July 21, 2010
by: Wayne Schulz • FAQ, Sage MAS 200, Sage MAS 90, Schulz Consulting
July 20, 2010
by: Wayne Schulz • 90minds, Alnoor Cassim
July 19, 2010
by: Brett Zimmerman • Consultant, ERP, ERP Tools, FAQ, General Technology, MAS 200 Extended Enteprise Suite, Sage, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, Uncategorized, add ons
July 9, 2010
by: Beth Bowers • Beth Bowers, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, add ons, sage business insights intelligence
July 21, 2010
by: Wayne Schulz • FAQ, Sage MAS 200, Sage MAS 90, Schulz Consulting
July 19, 2010
by: Brett Zimmerman • Consultant, ERP, ERP Tools, FAQ, General Technology, MAS 200 Extended Enteprise Suite, Sage, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, Uncategorized, add ons
July 9, 2010
by: Beth Bowers • Beth Bowers, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, add ons, sage business insights intelligence
July 1, 2010
by: Wayne Schulz • 90minds, News, Sage, Sage MAS 90
June 24, 2010
by: Brett Zimmerman • Consultant, FAQ, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, Schulz Consulting, Uncategorized
June 14, 2010
by: Mark Chinsky • Clients First Business Solutions, Sage MAS 200, Sage MAS 90, Uncategorized
July 21, 2010
by: Wayne Schulz • FAQ, Sage MAS 200, Sage MAS 90, Schulz Consulting
July 19, 2010
by: Brett Zimmerman • Consultant, ERP, ERP Tools, FAQ, General Technology, MAS 200 Extended Enteprise Suite, Sage, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, Uncategorized, add ons
July 9, 2010
by: Beth Bowers • Beth Bowers, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, add ons, sage business insights intelligence
June 24, 2010
by: Brett Zimmerman • Consultant, FAQ, Sage MAS 200, Sage MAS 90, Sage MAS 90 Extended Enterprise Suite, Schulz Consulting, Uncategorized
June 14, 2010
by: Mark Chinsky • Clients First Business Solutions, Sage MAS 200, Sage MAS 90, Uncategorized
June 4, 2010
by: Mark Chinsky • Clients First Business Solutions, Sage MAS 200, Sage MAS 90, Uncategorized, jobops
Leave a Comment
You must be logged in to post a comment.