SAP Business One: Query to Show Customers Without Sales Employees Assigned

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

2019-01-16T11:44:19+00:00 February 11th, 2009|SAP Business One|Comments Off on SAP Business One: Query to Show Customers Without Sales Employees Assigned