Use the query to show all of the customers that do not have sales employees assigned. You can use this as an alert as well.
SELECT CardCode as BP, CardName as ‘Customer Name’ FROM OCRD Where SLPCODE = -1 and CardType = ‘C’ FOR BROWSE
Thanks to Ed Monk of SBONotes.com
« SAP Business One Simplified Order Guides for Sales Orders | Home | SAP Business One: High Quantity on a Sales Order »
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.